32 bit to 64 bit on 10.2.0.2 - RAC

Reference: Note: 62290.1

I read the above note and tested in my lab server.

I encountered errors when I used this note.

The note 62290.1 is suggesting doing the following:

1.startup upgarde
2. run catalog.sql
SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql
Check the validity of the DBMS_STANDARD package:

3. SQL> select status from dba_objects
where object_name='DBMS_STANDARD'
and object_type='PACKAGE'
and owner='SYS';
If the package is invalid, recompile it:

SQL> alter package dbms_standard compile;

4. Run the following script

5. @$ORACLE_HOME/rdbms/admin/utlirp.sql
6. @$ORACLE_HOME/rdbms/admin/utlrp.sql

I found a problem during step 1, which is missing informaion on RAC.

When I execute the catalog.sql then it results in
BEGIN
*
ERROR at line 1:
ORA-06553: PLS-801: internal error [56319]

Here is what I did:

1. Create pfile='/tmp/init.ora' from spfile;
2. Modify pfile.
Disable the cluster specific parameters.

(We cannot do startup upgrade in case the cluster specific parameters are enabled)

ORA-39701: database must be mounted EXCLUSIVE for UPGRADE or DOWNGRADE
Error 39701 happened during db open, shutting down database
USER: terminating instance due to error 39701

3. startup upgarde pfile='/tmp/init.ora'
4. @$ORACLE_HOME/rdbms/admin/utlirp.sql
5. @$ORACLE_HOME/rdbms/admin/catupgrd.sql
6. @$ORACLE_HOME/rdbms/admin/utlrp.sql
7. select * from dba_registry;
8.shutdown immediate
9. startup

SQL> select COMP_ID,status from dba_registry;

COMP_ID STATUS
------------------------------ -----------
ORDIM VALID
XDB VALID
EXF VALID
RUL VALID
OWM VALID
CATALOG VALID
CATPROC VALID
JAVAVM VALID
XML VALID
CATJAVA VALID
RAC VALID

 

Download the toolbar and Stay connected with Live DBA