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

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

How login as sysdba with sqlnet.authentication=none

From: J. Dex <cemail_219_at_hotmail.com>
Date: Fri, 13 Apr 2007 11:46:32 -0400
Message-ID: <BAY140-F3120102BA06EB8838CE0D2A55D0@phx.gbl>


How can you login with sysdba when SQLNET.AUTHENTICATION is set to NONE?

We have a server that got put into a different domain. In order for users outside the domain to connect, we had to change SQLNET.AUTHENTICATION from {NTS} to {NONE}. With the authentication set to NONE, I can no longer connect as sysdba.

Logged into the server as Oracle or myself, I get ORA-01031: insufficient privileges when trying to login in with any of the following combinations:

SQL> connect /as sysdba
SQL> connect sys/sys_passwd as sysdba
SQL> connect sys /as sysdba

Now my RMAN scripts are failing as well.



Canít afford to quit your job? Ė Earn your AS, BS, or MS degree online in 1 year.
http://www.classesusa.com/clickcount.cfm?id=866145&goto=http%3A%2F%2Fwww.classesusa.com%2Ffeaturedschools%2Fonlinedegreesmp%2Fform-dyn1.html%3Fsplovr%3D866143
--
http://www.freelists.org/webpage/oracle-l
Received on Fri Apr 13 2007 - 10:46:32 CDT

Original text of this message

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