ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init]

 Below document explains the issue faced after the upgrade, troubleshooting  and need for timezone files.

Application or sql-developer may see below error while performing the operations in database.

SQL> select count(*) from employee.details ;

ERROR at line 1:
ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [],
[], [], [], [], [], [], [], [], []

SYMPTOMS

There might be database upgrade or patch activity recently happened at the database end and the required Timezone files are missing.

 

Solution

Check the missing timezone files and copy it from old Home to the current Oracle Home and restart the database.

 

SQL> SELECT tz_version FROM registry$database;

TZ_VERSION
----------
        31

oracle@db-host: PROD1DB:zoneinfo > pwd
/u01/app/oracle/product/11.2.0.2/old_home/oracore/zoneinfo

oracle@db-host: PROD1DB:zoneinfo > ls- ltr |wc -l

38

oracle@db-host: PROD1DB:zoneinfo > ls- ltr *_31*

-rw-r--r--. 1 oracle oinstall 340892 Nov 20  2020 timezone_31.dat
-rw-r--r--. 1 oracle oinstall 786708 Nov 20  2020 timezlrg_31.dat


oracle@db-host: PROD1DB:zoneinfo > cp timezone_31.dat /u01/app/oracle/product/11.2.0.4/home_new/oracore/zoneinfo
oracle@db-host: PROD1DB:zoneinfo > cp timezlrg_31.dat /u01/app/oracle/product/11.2.0.4/home_new/oracore/zoneinfo

oracle@db-host: PROD1DB:zoneinfo > ls -ltr |wc -l
38

 

oracle@db-host: PROD1DB:zoneinfo > srvctl stop database -d PROD1DB
oracle@db-host: PROD1DB:zoneinfo > srvctl start database -d PROD1DB

oracle@db-host: PROD1DB:zoneinfo > pwd
/u01/app/oracle/product/11.2.0.4/home_new/oracore/zoneinfo


 

 

 Found this post interesting? Subscribe us  😊😉