Re: 8i on RH Linux: new user cannot sign on SQL*Plus

Assuming we are talking UNIX host.

Could be an environment problem as well. New user must have same environment (assuming Unix host) as user 'oracle'. Pay special attention to following env vars:
ORACLE_HOME
ORACLE_SID
PATH
LD_LIBRARY_PATH
TWO_TASK User account should also be a member of dba or user groups in /etc/group

Normally, the installer, orainst, creates a script, root.sh that populates a shared library directory (e.g. /usr/local/bin) and grants permissions for all members of dba/user groups, but users still need an Oracle environment.

Todd Ryder
tryder2_at_home.com

Kevin O'Gorman <kevin_at_ayuda.com> wrote in message news:3802A534.9EAC36C5_at_ayuda.com...
> I'm all alone with my new Oracle 8i EE (nobody else here knows anything
> about it either).
>
> I've been in and out of 'sqlplus' and 'svrmgrl' a number of times as
> user 'oracle'. I just did
> a CREATE USER to create a new user, and granted him the CONNECT and
> RESOURCE
> roles. Now I try to connect using 'sqlplus' and I get an error about
> loading of a shared library.
> No soap. User 'oracle' continues to work.
>
> I'm assuming this is a permissions problem, even though as near as I can
> tell, I have permissions
> according to the docs. All the /u01/app..... directories are 771, all
> the shared libraries are 751, and
> I'm logged into Linux as a user from an 'other' group. However, even
> changing the library to
> 777 doesn't make the message go away.
>
> Help?
>
> --
> Kevin O'Gorman (805) 650-6274 kevin_at_ayuda.com
> At school: kogorman_at_cs.ucsb.edu
> Permanent e-mail forwarder: Kevin.O'Gorman.64_at_Alum.Dartmouth.org
>
>
>
Received on Sun Nov 07 1999 - 00:00:00 CET