RE: How login as sysdba with sqlnet.authentication=none
- From: "Richard J. Goulet" <rgoulet@xxxxxxxxxx>
- To: <gkatteri@xxxxxxxxxxx>, <cemail_219@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 16 Apr 2007 15:11:07 -0400
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
