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

From: J. G. Dutcher <DutcherJG_at_navair.navy.mil>
Date: Thu, 14 Oct 1999 09:36:03 -0700
Message-ID: <DutcherJG-1410990936030001@clhrd7.chinalake.navy.mil>

Did you grant create session?

In article <3802A534.9EAC36C5_at_ayuda.com>, Kevin O'Gorman <kevin_at_ayuda.com> wrote:

> 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

TIA Received on Thu Oct 14 1999 - 11:36:03 CDT