QUESTION POSED ON: 17 May 2006 I need to upgrade a RAC 9.0.X database to RAC 9.2.X. The 9.2 upgrade guide doesn't seem to have the info I need for using the Database Upgrade Assistant for RAC databases. When I start DBUA and select the db to be upgraded, I get an "ORA-01034: Oracle not available" error. The RAC db is up and running and the /etc/oratab seems to be in order. I think it's looking for the ORACLE_SID value in oratab instead of the RAC db name. I could cheat and put the instance names in oratab but I'm not sure how that would mess up DBUA.
>
Starting with Oracle 9.2, the DBUA should support the upgrading of RAC databases. I am curious to know whether you get the same message if you start the DBUA on one of the other nodes of your RAC database. If you are able to start the DBUA on another node, review the permissions of the oracle executable between the nodes. There is a documented problem with the permissions for this executable not getting propagated to the remote node when RAC is first configured. This problem, however, seems to apply specifically to Oracle 10g on Linux but it may assist with your problem.
Search and Browse the Expert Answer Center Search and browse more than 25,000 question and
answer pairs from more than 250 TechTarget industry experts.
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.