SP2-1503: Unable to initialize Oracle call interface

[Robin Geary]

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

[Peter Godron]

Robin,
is you NLS_LANG set ?

[Robin Geary]

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

NLSLANG=AMERICAN_AMERICA.UTF8

[Peter Godron]

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]

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]

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

[Yogeeraj_1]

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

[Robin Geary]

Thanks,

I installed the latest patch earlier this morning.

[Robin Geary]

I have the sqlplus working now.

Thanks for all your help.

[Peter Godron]

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

[Robin Geary]

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