SP2-1503: Unable to initialize Oracle call interface
                                                 Last update (2012-01-03 20:25:15)
                                                                                                                   Date added (2011-12-30 21:53:24)

Summary
After upgrade from Oracle 10g, or Oracle 11gR1 to Oracle 11g R2 you may get at the
$>sqlplus "/ as sysdba"

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

This problem is related to the $ORA_TZFILE environment variable in Oracle 11GR2 which is no longer needed.

The workaround is to unset the variable and then call sqlplus again
$unset ORA_TZFILE
$sqlplus "/ as sysdba"
sql>
If you use Oracle E-Business Suite 11i or R12 then you have to remove the environment variable ORA_TZFILE also from the database environment file.

At the end of $ORACLE_DATABASE_HOME/SID_host.env there is an entry

######################
# Timezone Specification file
ORA_TZFILE="$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat
export ORA_TZFILE
######################
you must remove it. It shows a file(timezlrg.dat) that no longer exists!

You must also remove the ORA_TZFILE and from $ORACLE_DATABASE_HOME/appsutil/template/ad8idbux.env
Reviews
Filters
Search