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]
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]
Comments
-Vinish
You're welcome :-)