Re: ORA-01031 while connecting as SYS
- From: "Prabhu, K" <prabhu_adam@xxxxxxxxxxx>
- To: lindens@xxxxxxxxxx
- Date: Wed, 09 Nov 2005 16:05:33 +0000
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.
From: Stu Lindenmayer <lindens@xxxxxxxxxx> To: prabhu_adam@xxxxxxxxxxx CC: oracle-l@xxxxxxxxxxxxx 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@db_name as sysdba"
Stu Lindenmayer <lindens@xxxxxxxxxx>
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