After fresh Installation of 18.104.22.168 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]
Oracle Apps DBA
- Syed Zaheer
- 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)