Issue# 16:
After moving DB to new ORACLE_HOME on Linux 64-bit, using RMAN convert, we got the following error:
@@ ?/rdbms/admin/utlirp.sql
…
…
…
ERROR at line 1:
ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [],
[], [], [], [], [], [], [], [], []
Solution:
R12.2 RAC Conversion Faile With ERROR At Line 1:ORA-00600: Internal Error Code, Arguments: [qcisSetPlsqlCtx:tzi Init], [], [], When Converting Via Rconfig (Doc ID 2050964.1)
Missing DST files in the new ORACLE_HOME:
Old ORACLE_HOME;
[ordpro@dbmig ~]$ cd $ORACLE_HOME/oracore/zoneinfo
[ordpro@dbmig zoneinfo]$ ls
big timezlrg_10.dat timezlrg_14.dat timezlrg_4.dat timezlrg_8.dat timezone_12.dat timezone_2.dat timezone_6.dat
little timezlrg_11.dat timezlrg_1.dat timezlrg_5.dat timezlrg_9.dat timezone_13.dat timezone_3.dat timezone_7.dat
readme.txt timezlrg_12.dat timezlrg_2.dat timezlrg_6.dat timezone_10.dat timezone_14.dat timezone_4.dat timezone_8.dat
timezdif.csv timezlrg_13.dat timezlrg_3.dat timezlrg_7.dat timezone_11.dat timezone_1.dat timezone_5.dat timezone_9.dat
[ordpro@dbmig zoneinfo]$ ls |wc -l
32
[ordpro@dbmig zoneinfo]$
New ORACLE_HOME
[ordpro@r12upgdb zoneinfo]$ ls
big timezdif.csv timezlrg_1.dat timezlrg_4.dat timezlrg_7.dat timezone_10.dat timezone_2.dat timezone_5.dat timezone_8.dat
little timezlrg_10.dat timezlrg_2.dat timezlrg_5.dat timezlrg_8.dat timezone_11.dat timezone_3.dat timezone_6.dat timezone_9.dat
readme.txt timezlrg_11.dat timezlrg_3.dat timezlrg_6.dat timezlrg_9.dat timezone_1.dat timezone_4.dat timezone_7.dat
[ordpro@r12upgdb zoneinfo]$
Transfer the missing files to the new Home:
[ordpro@dbmig zoneinfo]$ scp *_13.dat *_14.dat *_12.dat ordpro@172.10.10.210:/oracle/dpro/db/tech_st/11.2.0.4/oracore/zoneinfo
ordpro@172.10.10.210's password:
timezlrg_13.dat 100% 764KB 764.1KB/s 00:00
timezone_13.dat 100% 336KB 336.4KB/s 00:00
timezlrg_14.dat 100% 773KB 772.9KB/s 00:00
timezone_14.dat 100% 336KB 336.4KB/s 00:00
timezlrg_12.dat 100% 767KB 767.2KB/s 00:00
timezone_12.dat 100% 337KB 336.9KB/s 00:00
[ordpro@dbmig zoneinfo]$
- Restart the DB and run the script again:
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade pfile='/tmp/pfile_new.ora';
ORACLE instance started.
Total System Global Area 6413680640 bytes
Fixed Size 2213776 bytes
Variable Size 1342179440 bytes
Database Buffers 5033164800 bytes
Redo Buffers 36122624 bytes
Database mounted.
Database opened.
SQL> @@ ?/rdbms/admin/utlirp.sql
…
…
…
DOC>#######################################################################
DOC>#######################################################################
DOC> utlirp.sql completed successfully. All PL/SQL objects in the
DOC> database have been invalidated.
DOC>
DOC> Shut down and restart the database in normal mode and run utlrp.sql to
DOC> recompile invalid objects.
DOC>#######################################################################
DOC>#######################################################################
DOC>#
SQL>
No comments:
Post a Comment