Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: How login as sysdba with sqlnet.authentication=none

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

From: GovindanK <gkatteri_at_fastmail.fm>
Date: Mon, 16 Apr 2007 11:45:23 -0700
Message-Id: <1176749123.14797.1184898735@webmail.messagingengine.com>


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
Received on Mon Apr 16 2007 - 13:45:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US