RE: How login as sysdba with sqlnet.authentication=none

It's 'connect "sys as sysdba"'


........................................................................
............................................................. 
Kanbay
Richard J. Goulet, Senior Oracle DBA 
45 Bartlett ST | Marlborough, MA 01752 USA
Tel: 508.573.1978 | Fax: 508.229.2019 | Cell: 508.742.5795
rgoulet@xxxxxxxxxx
........................................................................
............................................................. 



-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of GovindanK
Sent: Monday, April 16, 2007 2:45 PM
To: cemail_219@xxxxxxxxxxx; oracle-l@xxxxxxxxxxxxx
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-l


Other related posts: