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
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
No comments:
Post a Comment