Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to run STARTUP UPGRADE in 11g-RAC env

IamHariKrishnaJun 3 2013 — edited Jun 3 2013
11.2.0.3.5
RHEL-7
2 NODE RAC

issue : XDB component is INVALID and oracle support suggested below steps. But, in RAC env, can we do this on both nodes or only on one node. If we are doing in node1 and do we need DOWN node2 ?

{
SQL> spool xdbreload.log
SQL> connect / as sysdba
SQL> set echo on;
SQL> shutdown immediate;
SQL> startup upgrade;
SQL> @?/rdbms/admin/xdbrelod.sql
SQL> shutdown immediate;
SQL> startup;
SQL> @?/rdbms/admin/utlrp.sql
SQL> spool off
}

Could you please help me on how to run UPGRADE in rac env ?

Thanks,
Hari
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 1 2013
Added on Jun 3 2013
1 comment
3,940 views