Fwd: urgent connect '/ as sysdba' insufficient privs

think this was supposed to go to the group.

• Forwarded message ---------- From: Lou Fangxin <anysql_at_gmail.com> Date: Wed, 30 Mar 2005 07:59:33 +0800 Subject: Re: urgent connect '/ as sysdba' insufficient privs To: shrekdba_at_gmail.com

1, make sure that your account are under dba group

    $id
    ......

2, make sure you set the ORACLE_SID variable

   echo $ORACLE_SID

3, check the sqlnet.ora file, make sure you use the OS authorization.

On Tue, 29 Mar 2005 17:54:14 -0600, Shrek <shrekdba_at_gmail.com> wrote:
> > suggestions would be most welcome
> >
> > have deleted password file and recreated password file
> > oracle user is a member of the dba group
> > relinked sqlplus
> > what are we missing?
>
> as far as i remember "/ as sysdba" doesn't use the password file, but
> i could be wrong. is the set sui bit on the binary set? are the
> permissions on the log directories set correctly? how about the audit
> file being created OK? got permissions on /tmp OK?
>
> --
> --
> Bill "Shrek" Thater ORACLE DBA
> shrekdba_at_gmail.com
> ------------------------------------------------------------------------
> I am my beloved's, and my beloved is mine (Song of
> Solomon 6:3)
> --
> http://www.freelists.org/webpage/oracle-l
>

--
Welcome, http://www.anysql.net


-- 
--
Bill "Shrek" Thater     ORACLE DBA     
       shrekdba_at_gmail.com 
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--
http://www.freelists.org/webpage/oracle-l