Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Depending on the timezone differences ORA-00600 error can be occured when opening the database. The argument for this error is [qcisSetPlsqlCtx: tzi init], which causes the database not to open.
The error is due to timezone differences. If the patch has been applied to the restored backup, but this patch is not available for the restored ORACLE_HOME, the error will be occured and the database will not be opened.
Errors that occur when opening the database:
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 | RMAN> sql 'alter database open'; sql statement: alter database open RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of sql command on default channel at 12/22/2016 17:42:58 RMAN-11003: failure during parse/execution of SQL statement: alter database open ORA-00600: internal error code, arguments: [opiodr: call 2], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [], [], [], [], [], [], [], [], [], [] RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== ORA-03114: not connected to ORACLE RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of sql command on default channel at 12/22/2016 17:42:58 RMAN-11003: failure during parse/execution of SQL statement: alter database open ORA-00600: internal error code, arguments: [opiodr: call 2], [], [], [], [], [], [], [], [], [], [], [] ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [], [], [], [], [], [], [], [], [], [] |
In this case, make sure that the timezone files in the following directory in the new ORACLE_HOME are the same as before. Apply all time zone patches applied to the old database to the new one.
1 2 3 | $ORACLE_HOME/oracore/zoneinfo $ORACLE_HOME/oracore/zoneinfo/little $ORACLE_HOME/oracore/zoneinfo/big |
You can also copy the required timezone files manually. Then the database will open succesfully.
