SP2-1503: Unable to initialize Oracle call interface

SP2-1503: Unable to initialize Oracle call interface

Solution:

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