When we were trying to connect to our upgraded 18.104.22.168 database, below error was thrown and we were not able to connect.
$ sqlplus as sysdba
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
Done intial checking :
>> user oracle was in the correct database admin group (/etc/group)
>> No tnsnames issues as TNS_ADMIN variable is poiting to correct directories and all files( tnsnames.ora, sqlnet.ora, listener.ora) in it have valid entries.
>> $PATH variable was pointing to correct $ORACLE_HOME/bin
On checking the environment variable closely, it was found that one of the variable ORA_TZFILE was pointing to non-existent file.
ls -ltr /u01/oracle/dev/db/tech_st/11.2.0/oracore/zoneinfo/timezlrg.dat
ls: /u01/oracle/dev/db/tech_st/11.2.0/oracore/zoneinfo/timezlrg.dat: No such file or directory
This file timezlrg.dat was not present at the location, though there were other files with names like
-rw-r–r– 1 oradev dba 507957 Aug 18 2011 timezlrg_2.dat
-rw-r–r– 1 oradev dba 493675 Aug 18 2011 timezlrg_1.dat
-rw-r–r– 1 oradev dba 791430 Aug 18 2011 timezlrg_14.dat
-rw-r–r– 1 oradev dba 782475 Aug 18 2011 timezlrg_13.dat
-rw-r–r– 1 oradev dba 785621 Aug 18 2011 timezlrg_12.dat
-rw-r–r– 1 oradev dba 787272 Aug 18 2011 timezlrg_11.dat
-rw-r–r– 1 oradev dba 792894 Aug 18 2011 timezlrg_10.dat
Unsetting this variable solved our issue.
$ unset ORA_TZFILE
$ sqlplus / as sysdba
SQL*Plus: Release 22.214.171.124.0 Production on Tue Oct 16 11:45:08 2012
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Oracle Database 11g Enterprise Edition Release 126.96.36.199.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
We can also set and use the desired timezone file and if we do not set it then by default it will use maximum value of n.
[Post Views: 2683]
You can connect with me on LinkedIn.
Latest posts by Brijesh Gogia (see all)
- Performance Tuning Basics 16 : Using SQL Tuning Health-Check Script (SQLHC) - April 1, 2018
- Physical and Logical Block Corruption in Oracle Database - March 10, 2018
- Performance Tuning Basics 15 : AWR Report Analysis - February 6, 2018