Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: urgent connect '/ as sysdba' insufficient privs

Re: urgent connect '/ as sysdba' insufficient privs

From: Jared Still <jkstill_at_gmail.com>
Date: Wed, 30 Mar 2005 00:28:33 +0000
Message-ID: <bf463805032916282be3ab6d@mail.gmail.com>


As Bill stated, the password file is not necessary.

Ensure that your ORACLE_HOME, PATH and ORACLE_SID are all set as you expect them to be, as well as exported.

Make sure that the OS user you are logged in as is part of the DBA group.

Jared

On Tue, 29 Mar 2005 17:46:27 -0600, aj wells <awellsdba_at_gmail.com> wrote:
> 9i instance
> Linux
>
> Okay, we have an instance that we can log into connect sys/password as
> sysdba and it works fine
> however...
> if we try to log in '/ as sysdba' it complains about insufficient privs...
>
> 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?
>
> ajw
> --
> http://www.freelists.org/webpage/oracle-l
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
http://www.freelists.org/webpage/oracle-l
Received on Tue Mar 29 2005 - 19:32:22 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US