How login as sysdba with sqlnet.authentication=none
- From: "J. Dex" <cemail_219@xxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Fri, 13 Apr 2007 11:46:32 -0400
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
