Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: How login as sysdba with sqlnet.authentication=none
Solaris64 Bit 10gRel2
$ cat sqlnet.ora
#SQLNET.ORA Network Configuration File
SQLNET.AUTHENTICATION_SERVICES=(NONE)
$ sqlplus /nolog
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Mar 12 17:49:20 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
SQL> connect / as sysdba
ERROR:
ORA-01031: insufficient privileges
SQL> quit
$ sqlplus "sys as sysdba"
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Mar 13 11:17:02 2007
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit
Production
With the Partitioning, OLAP and Data Mining options
SQL>
RMAN scripts connect since they connect using user/passwd using tns.
HTH
GovindanK
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 16 2007 - 13:45:23 CDT
![]() |
![]() |