Fwd: urgent connect '/ as sysdba' insufficient privs

think this was supposed to go to the group.


---------- Forwarded message ----------
From: Lou Fangxin <anysql@xxxxxxxxx>
Date: Wed, 30 Mar 2005 07:59:33 +0800
Subject: Re: urgent connect '/ as sysdba' insufficient privs
To: shrekdba@xxxxxxxxx


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@xxxxxxxxx> 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@xxxxxxxxx
> ------------------------------------------------------------------------
> 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@xxxxxxxxx 
------------------------------------------------------------------------
I am my beloved's, and my beloved is mine (Song of
Solomon 6:3)
--
http://www.freelists.org/webpage/oracle-l

Other related posts: