Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

SP2-1503: Unable to initialize Oracle call interface

Robin Geary
Advisor

SP2-1503: Unable to initialize Oracle call interface

After all the help you guys have given me, im slowly getting there..

New errors when trying to start sqlplus

SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly.

Thanks in advance
10 REPLIES
Peter Godron
Honored Contributor

Re: SP2-1503: Unable to initialize Oracle call interface

Robin,
is you NLS_LANG set ?
Robin Geary
Advisor

Re: SP2-1503: Unable to initialize Oracle call interface

Yes Peter, however im not sure what it should be...

NLSLANG=AMERICAN_AMERICA.UTF8
Peter Godron
Honored Contributor

Re: SP2-1503: Unable to initialize Oracle call interface

Robin,
that looks fine.
After some more digging I also found:

We just installed Oracle 10.2.0.1 on HP-UX 11i. A non-oracle user is trying to
use sqlplus and gets following error.

$ sqlplus username/password
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

Looked up on the metalink and Oracle is saying it is a base bug 4516865.
Permissions at the OS level aren't set properly after the Oracle 10gR2 install.
One of the solution given is to do "chmod -R 755 $ORACLE_HOME", a recursive
permission command. Do you think this is a good solution from a security
perspective?

Metalink says, "There is a one-off patch for the base bug 4516865, but this
fixes the permissions problem only on the server side. Currently, there is still
no patch for the client side." They don't say what the one-off patch is :-(
Robin Geary
Advisor

Re: SP2-1503: Unable to initialize Oracle call interface

Its a server in the setup process so I did the chmod but it still gave the same error. I am in as the oracle user also. I shall check out the Metalink articles you mentioned.

Thanks.
Peter Godron
Honored Contributor

Re: SP2-1503: Unable to initialize Oracle call interface

Robin,
Note:335063.1 on Metalink is a good point to start. From there you can link to the bug description.
Yogeeraj_1
Honored Contributor

Re: SP2-1503: Unable to initialize Oracle call interface

hi robin,

i will also suggest that you install the latest available patch to 10.2.0.2 before trying anything...

I have just finished installing that at my site and works without any glitches.

good luck!

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Robin Geary
Advisor

Re: SP2-1503: Unable to initialize Oracle call interface

Thanks,

I installed the latest patch earlier this morning.
Robin Geary
Advisor

Re: SP2-1503: Unable to initialize Oracle call interface

I have the sqlplus working now.

Thanks for all your help.
Peter Godron
Honored Contributor

Re: SP2-1503: Unable to initialize Oracle call interface

Robin,
could you please identify/summarise the solution, so that other people, with the same problem, can use your experience.
Many Thanks.
Robin Geary
Advisor

Re: SP2-1503: Unable to initialize Oracle call interface

Hi,

Actually one of the othet IT guys here modified the .profile for the Oracle user with the following...

# export ORACLE_HOME=/u/oracle/product/10*/client*/
export ORACLE_HOME=/u/oracle/product/10.2.0/client_1/
export ORACLE_BASE=/u/oracle/product/10*/client*/
export TEMP=/prod/tmp
export TMPDIR=/prod/tmp
export LD_LIBRARY_PATH=/u/oracle/product/10*/client*/instantclient
export SHLIBPATH=ORACLE_HOME/lib32:$ORACLE_HOME/lib:$SHLIBPATH
export LD_LIBRARY_PATH=/u/oracle/product/10*/client*/instantclient