Browsed by
Category: Howto

The cloud is more than a portal: oracle-dbcs-cli

The cloud is more than a portal: oracle-dbcs-cli

A common misconception is that “The Cloud” is only accessible through the portal which is provided to you. In this post I will show that Oracle has some utilities ready for you to manage the cloud using the command line (cli). One way to do it, and which is very useful when you only use one-time commands, is Curl. The REST API is well documented with curl examples as well. This time we will focus on oracle-dbcs-cli utility and the…

Read More Read More

Compute node disk expansion resulted in mount.ocfs2: Bad magic number in superblock while opening device /dev/sda3

Compute node disk expansion resulted in mount.ocfs2: Bad magic number in superblock while opening device /dev/sda3

Before Christmas 2017 I had the honour to expand the compute node storage for a virtualised exadata. Better said, OVM on exadata. This can be done for several reasons. The most logic one, also the reason why this customer bought the disk expansion, is that you want to create more virtual machines and you have ran out of space on /EXAVMIMAGES. The preparation is actually pretty simple. It is documented completely in the Exadata Database Machine Maintenance Guide. And look,…

Read More Read More

Put the pedal to the metal: Oracle Bare metal cloud! The first impressions on networking

Put the pedal to the metal: Oracle Bare metal cloud! The first impressions on networking

The beginning In the beginning of this year (2017), I was doing a cloud project, despite all efforts, unfortunately not on the Oracle cloud. When we finally had to deliver, suddenly the license rules changes for non-Oracle other cloud environments and you might or might not remember all options were open again. At that point, I really needed to vent and I wrote the blogpost Why the sun shines for Oracle and it’s cloudy for others. I made some points…

Read More Read More

Tasting a different flavour; postgres done by an oracle dba

Tasting a different flavour; postgres done by an oracle dba

There are moments in life you put everything on a row and you want to taste a slight different flavour. Well, I had a week off and I had a play with the plain vanilla postgres. Basically I should try the EDB as it is a bit more “oracle-like”, but I had a spare solaris zone and didn’t feel like running linux, so … plain vanilla it is. First steps? Easy as … I would say anything. In my homelab…

Read More Read More

Can’t locate Term/ReadKey.pm in @INC during catcdb.sql in 12.1.0.2

Can’t locate Term/ReadKey.pm in @INC during catcdb.sql in 12.1.0.2

During some playing around with database creation on 12.1.0.2 using several methods, Geert De Paep (find him at @geertdepaep) and I discovered something funny. Creating the database using dbca, works as expected. But then it was time to create a container database using the create database statement. The best thing to do is follow the official oracle documentation. Find it here: http://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN13529 all steps are normal until running the catcdb.sql-script. When running it from a oel6.5 with a default (non-patched)…

Read More Read More

A more secure connection to a pdb with the Oracle Wallet

A more secure connection to a pdb with the Oracle Wallet

Wallets are cool! Since 9i oracle is pushing us towards services for connecting to a database. Since pdb’s have arrived, you get less and less choice to connect without a service. Recently I discovered passwords stored in environment variables in order to connect to the pdb. A short talk to the author of the script learned me that he just wants to connect to a pdb, so I offered the solution to store the password in the oracle wallet. Here is how…

Read More Read More

Memo to Self: Recap cellsrvstat

Memo to Self: Recap cellsrvstat

Sometimes I ask myself “how did that work again”, so I decided to document this every time I have this feeling. With some links to the documentation, easy commands,… you got the picture. First one today, new customer, new environment, to get some feeling with the cells, I used cellsrvstat. Documentation reference (here ). Cellsrvstat is also part of the exawatcher on the cells. A basic overview of the command. If you log on to the cells as root, it…

Read More Read More

Exadata add a new vm

Exadata add a new vm

Today a customer highlighted me a nice-to-know. If you add a new virtual machine to an exadata ovm cluster, he experienced something odd. It was tested on a “new installation”, so it worked good. Basic steps are: Run over OEDA and add the cluster move the xml-files to the dom0 on the same spot as the original one run install.sh with this config As this is a good customer he followed the advice of having all passwords changed. The bad thing…

Read More Read More

Python … no not the snake – my very first script

Python … no not the snake – my very first script

Do you know the feeling? “I should do <fill in something cool here>”. Well, I was facing this already a time by learning python. I knew that you could do some cool thing with it, but never pushed myself to do it. Until now! Otn appreciation day! Thanks to Mr Oracle Base  Tim Hall. Some time ago, he launched the idea of otn appreciation day and of course I added my entry as well. You can find it here. Tuesday…

Read More Read More

Acfs: it’s all about permissions

Acfs: it’s all about permissions

It all starts with creation of a database on a Database appliance which failed with the error

  One of the things … is it due to running on the ODA or is it a general cluster issue? It was easy to verify as this customer had another ODA on which everything just works smoothly. So we started to compare the environments. One tiny little thing appeared to be different: the ACL. On a working ODA:

  On…

Read More Read More

%d bloggers like this: