sqlplus works as root or oracle but not as other users
Posted on 2006-04-05
Similar scenario to previous post: Oracle client on Citrix terminal server, but did not see information there to resolve the issue.
Sunblade platform, solaris 8, oracle 10g r 2
I am seeing the same issue with sqlplus running fine when logged in as root or as user oracle but failing for other users.
The error I get when logged in to my personal account and type sqlplus is:
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly
I did not find any information in the Oracle 10g docs that was useful to resolve this; is this a security measure in 10g to restrict sqlplus access?
Any advice to resolve or pointers to additional info appreciated.