Browsed by
Category: Howto

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 Validation of server pool succeeded. Registering database with Oracle Restart PRCR-1006 : Failed to add resource ora.demodb.db for demodb PRCR-1071 : Failed to register or update resource ora.demodb.db CRS-2566: User ‘oracle’ does not have sufficient permissions to operate on resource ‘ora.redo.datastore.acfs’, which is part of the dependency specification. DBCA_PROGRESS : DBCA Operation failed.   One of the things … is it due to…

Read More Read More

Oracle secure backup. It DOES work on windows

Oracle secure backup. It DOES work on windows

A while ago I was asked to implement a filesystem backup on a windows server. How hard could it be and basically it’s not too difficult. Only one minor thing is not too well documented and I would like to highlight this here. In this particular setup the service was running under the local system account. Personally I would like to see it under a local user account. In order to be able to perform a succesfull filesystem backup, we…

Read More Read More

mac os x + 12c thin client

mac os x + 12c thin client

Sometimes it’s time to upgrade. So the I decided to add the oracle 12c thin client to my mac a couple of weeks ago. Yes I know, I was very happy with the oldy-but-goodie 10g version, but ok. The 12c instant client is very easy to install. I remember it took quite some time to install the 10g version, so happy about that. Unzipping the zipfiles, 2 symlinks and then a bit personal config in my .profile. So far so…

Read More Read More

Hello world!

Hello world!

Well that’s it guys. I moved from tumblr ( http://vanpupi.tumblr.com ) to wordpress to have some more flexibility, mostly for the code-tags actually. We’ll see where it will bring us.