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…
During some playing around with database creation on 22.214.171.124 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)…
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…
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…
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…
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…
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 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:
[grid@ODA_A-1 ~]$ crsctl status resource ora.redo.datastore.acfs -p |grep ACL
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…
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…
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.