Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Saturday, 16 October 2010

SP2-1503 SP2-0152 with new 11.2 installation

Hi,

After fresh Installation of 11.2.0.1 on Sun Solaris 10, sqlplus command was not working. When i am using sqlplus command after setting all valid environment variables getting error SP2-1503: Unable to Initialize oracle call interface. SP-0152: ORACLE may not be functioning properly.

This is a know issue and provided in tech note SP2-1503 SP2-0152 with new 11.2 installation.

Execute below steps:

-> creating softlinks for timezone files.

cd $ORACLE_HOME
pwd
/db/data/prod/11.2.0/oracore/zoneinfo
ln -s timezone_11.dat timezone.dat
ln -s timezlrg _11.dat timezlrg.dat

After creating the soft links with these files sqlplus command is working properly.

Tech Note: [ID 974515.1]

2 comments:

Anonymous said...

Vow!!! It really worked. Thanks :)

-Vinish

Syed Zaheer said...

Hi Vinish,

You're welcome :-)