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: ORA-01031 while connecting as SYS

Re: ORA-01031 while connecting as SYS

From: Prabhu, K <prabhu_adam_at_hotmail.com>
Date: Wed, 09 Nov 2005 16:05:33 +0000
Message-ID: <BAY23-F30A3BC09231A2C05DA528985670@phx.gbl>


Stu Lindenmayer,

Many Thanks for your help.

I'm trying to connect by using Oracle software owner login after setting ORACLE_SID in local system but still facing the problem.

Thanks
Prabhu

From: Stu Lindenmayer <lindens_at_tpg.com.au> To: prabhu_adam_at_hotmail.com
CC: oracle-l_at_freelists.org
Subject: Re: ORA-01031 while connecting as SYS Date: Wed, 09 Nov 2005 11:05:48 +1100
>Prabhu,
>If you're trying to use just basic OS authentication then all you need
>to do is login as the Oracle software owner, set ORACLE_SID and run:
>sqlplus "/ as sysdba"
>
>If you want to connect remotely as SYS over a network (I wouldn't really
>recommend it) then you'll need the password file you've already created.
>Also you need to set the database parameter REMOTE_LOGIN_PASSWORDFILE to
>either "exclusive" or "shared" (requires a DB restart). To verify the
>password file has been read and the parameter is valid, after the
>restart check "select * from v$pwfile_users;". This view should show SYS
>and also SYSTEM users from memory. Then from the command line run:
>sqlplus "sys/password_at_db_name as sysdba"
>
>Cheers,
>
>Stu Lindenmayer <lindens_at_tpg.com.au>
>
>On Tue, 2005-11-08 at 15:15 +0000, Prabhu, K wrote:
> > All,
> >
> > After installing Oracle 9IR2 on RH Linux 8.0, while trying to access
> > SQLPLUS as SYS user
> > we're getting error ORA-01031: insufficient privileges. We tried
> > connecting sqlplus from
> > the OS user which we installed the Oracle and have all the required OS
> > groups assigned to it.
> > Both connect / as sysdba and with passord created from the orapwd
> > utility have failed.
> > We also tried by connecting from OS user which has the same name as
> > ORACLE_SID, but still we're facing the problem.
> >
> > Your help in this regard is deeply appreciated.
> >
> > Thanks
> > Prabhu
> >
> >
> > -- http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Nov 09 2005 - 10:08:18 CST

Original text of this message

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