Friday, 21 January 2011

Oracle clusterware 11gR2 and database 10gR2

I've found many posts for oracle clusterware 11gr2 database 10gr2 but I've found also many problem that seems to be ignored or, better, are getting me mad!
Oracle say that when you have a database 10gR2 in a cluster running clusterware 11gR2 you have to add database with srvctl command from database 10gR2 oracle home. This work. But you are not be able to bring up or down database. If you check your resource configuration with command crsctl config res ora.YOURDB.db you find few strange, missing or misconfigured, entries, but with one that is quite curious:


ACTION_SCRIPT=/opt/oracle/crs/11.2.0.2/bin/racgwrap


Ok, why? Why with srvctl command from 10gR2 home you get, for a single instance database (neither RAC nor RAC One), a strange configuration calling a RAC wrapper in 11gR2 home?


I think, even if oracle is debugging this problem, I'll have to configure manually action script to get database up and down. This hoping clusterware is able to do it correctly because currently I've also found that not always resource dependencies and order is respected!

What's next?

Which news for 2011? Ok I've just completed the certification entitled "Oracle Database 11g Performance and Tuning expert". Exam was not really simple and, even if many times the answer was "increase shared pool" you need a good knowledge in oracle database and in operations environment to succeded in it. I'll start my university courses at Open University on 7th May. I'll write a dedicated post to my study path for MSc in Computing and ICT. Even if I'm currently working in Corner Bank I don't feel really good and I'm trying to find a new job. Based on current salary, coming back to Italy is impossible because, of course, I'm not so despaired to accept a new work with a lower salary. I'm voted to relocate myself outside Italy, better if in german Switzerland, or Germany of United Kingdom. To work in Germany of a in german language place you need a good level of german and today my level is A1...too low :D
Also, I want to start a certification path in IBM Db2. I think can be a really interesting thing for an Oracle database administrator and also for my curriculum can be a good step to leverage my addiction in database management. Also, a knowledge of Oracle competitors is appreciable in my opinion. I have to move with my legs because I don't find many possibility to increase my career and my experience in my actual place of work.
Other thing? mumble....I'll try to keep this post updated in future :D