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"
Cheers,
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
>
>
> -- //www.freelists.org/webpage/oracle-l
