Shulou(Shulou.com)06/01 Report--

The method of logging in Database by operating system Authentication

1. The most basic method is to log in to the database using "sqlplus / as sysdba"

Sqlplus / as sysdba

The left side of the slash "/" is the user name, and the right side is the password, which means that you can log in to the database system without giving the user name and password.

two。 Disable operating system authentication to log in to the database

Edit Oracle_HOME/network/admin/sqlnet.ora

SQLNET.AUTHENTICATION_SERVICES= (NONE)

3. Verify whether it is effective

1) you must use the correct user name and password to log in 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, 2010, Oracle. All rights reserved.

Connect to:

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 the wrong password for login test

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, 2010, Oracle. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Please enter a user name:

3) use "sqlplus / as sysdba" login 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, 2010, Oracle. All rights reserved.

ERROR:

ORA-01031: insufficient privileges

Please enter a user name:

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.