hello everybody in this forum.
I have a problem with my command line sql oracle 10g, sometime when i want to start my sqlplus it done, but sometime it didn't work i don't understand why?
please can you help me to solve that problem. this message is the message it often displays:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
But i have installed also Sql developper upon my computer but it works very well, that problem never happen on sql developper.
Did you install oracle client apart from oracle datase(server) software?let us know what oracle software and os you installed ?
Set ORACLE_HOME and PATH correctly and then try to execute.. post your ORACLE_HOME and PATH
Fallow the below steps:
> cd C:\Oracle\oracle10g\product\11.2.0\client\BIN -- > this path many be different in your case.
If you need to automate this than you need to set the env variables.