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


After fresh Installation of 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.

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]


Anonymous said...

Vow!!! It really worked. Thanks :)


Syed Zaheer said...

Hi Vinish,

You're welcome :-)