ORA-00600 qcisSetPlsqlCtx

 

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:

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.

You can also copy the required timezone files manually. Then the database will open succesfully.

dbtut
Author: dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

Your email address will not be published. Required fields are marked *