Re: Newbie screams for help

Check the exact error text:
eg: ora-00001
And look it up in the help.

My guess is either you lack:

create session
OR
connect

privilage.

Login as system
and
grant connect to oracle;
grant create session to oracle;

Same way you granted dba;
BTW: DBA is a role not a group.

In article <377B195E.A003351_at_cybertech.com.sg>,   Nobody <boris_at_cybertech.com.sg> wrote:
>
> I have Oracle8 server on a Linux box.
> After I login as 'oracle' ( group dba ) start sqlplus
> it prompts me for username/password and rejects oracle/oracle-passwd.
> If I start svrmgrl and try to 'startup' it says - insufficient
> privileges.
> All this in oracle's own account which is supposed to have all rights.
>
> What am I screwing up?
>
> Thanks
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Thu Jul 01 1999 - 04:29:33 CDT