| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: How login as sysdba with sqlnet.authentication=none
It's 'connect "sys as sysdba"'
........................................................................ .............................................................Kanbay
rgoulet_at_kanbay.com ........................................................................ .............................................................
-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of GovindanK
Sent: Monday, April 16, 2007 2:45 PM
To: cemail_219_at_hotmail.com; oracle-l_at_freelists.org
Subject: 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-l -- http://www.freelists.org/webpage/oracle-lReceived on Mon Apr 16 2007 - 14:11:07 CDT
 |
 |