Oracle error when executing sqlplus: "SP2-1503: Unable to initialize Oracle call interface"

Question

I'm struggling with the following error when starting up sqlplus as my regular user - say "scott".

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

Environment is:

• Oracle 11.2.0.2
• OpenSuse Linux 11.1 (64bit)

Misc other detail:

• Oracle installed and running on localhost
• No tnsnames issues as can run sqlplus as oracle admin user
• Database up and listener started (11.2.0.2 install).
• user scott in database admin group (/etc/group)
• user scott references correct 11.2.0.2 installation

This is most bizarre as I can happily run sqlplus as the oracle user (say "oraadmin") and user scott is registered in the oracle admin group. Additionally, I had no such problems with my previous Oracle install (10.2.0.7). My ~scott's $ORACLE_HOME references the 11.2.0.2 installation.

Comparing my 11.2.0.2 and 10.2.0.7 environments, I've noticed several libraries (including $ORACLE_HOME/lib/libsqlplus.so) have group read-only permissions (744) so have chmod'ded these.

Other than that, my $ORACLE_HOME/lib, $ORACLE_HOME/bin, $ORACLE_HOME/oracore and $ORACLE_HOME/rdbms all seem reasonable with sensible permissons.

N.B: There's a plethora of stuff on-line but, as is often the case, there's a lot of case-specific issues and mainly around different versions of Windows. Focusing mainly on comparing my envs. Besides, as far as I can tell, this question doesn't yet exist on SO so could be useful to start collating answers by environment. I'll report back any sensible findings.

Answer 1

If it is Windows 7, You can right click on SQL Plus or whatever software you using, I use Crystal Reports.

so to you would have to right click and Run as Administrator.

it fixed for me.