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@(protected)> To: prabhu_adam@(protected) CC: oracle-l@(protected) Subject: Re: ORA-01031 (See ORA-01031.ora-code.com) 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@(protected) as sysdba" > >Cheers, > >Stu Lindenmayer <lindens@(protected)> > >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 (See ORA-01031.ora-code.com): 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 > >
