Oracle disables operating system authentication and logon

1. How to log on to the database through operating system authentication

1) The most basic method is to use "sqlplus/as sysdba" to log on to the database.

Sqlplus/as sysdba

The slash "/" indicates the user name on the left and the password on the right. It indicates that the user name and password are not given and can be logged on to the database system.

2) log on to the database with the correct user name and password

Sqlplus sys/password as sysdba

Obviously, there is no problem with logon.

3) log on to the database with the wrong user name and password

Sqlplus wind/wind as sysdba

This type of operating system authentication allows you to log on to the database smoothly even if you use the wrong user name and password.

2. Disable operating system authentication to log on to the database

Edit Oracle_HOME/network/admin/sqlnet. ora

SQLNET. AUTHENTICATION_SERVICES = (NONE)

3. verify whether the verification takes effect

1) You must use the correct user name and password to log on to the system.

C: \> sqlplus sys/password as sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Wednesday February 16 13:41:14 2011

Copyright (c) 1982,201 0, Oracle. All rights reserved.

Connect:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0-64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>

2) use the correct user name and wrong password for Logon Testing

C: \ Users \ Administrator> sqlplus sys/wind as sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Wednesday February 16 13:40:35 2011

Copyright (c) 1982,201 0, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter the User Name:

3) use the "sqlplus/as sysdba" Logon Method for verification

C: \> sqlplus/as sysdba

SQL * Plus: Release 11.2.0.2.0 Production on Wednesday February 16 13:42:29 2011

Copyright (c) 1982,201 0, Oracle. All rights reserved.

ERROR:
ORA-01031: insufficient privileges

Enter the User Name:

For more information about Oracle, see Oracle topics page http://www.bkjia.com/topicnews.aspx? Tid = 12