Oracle Verification Method

There are two ways to verify Oracle: operating system verification and password verification. Operating system verification means to use the operating system's account and password system to protect the security of the oracle database

There are two ways to verify Oracle: operating system verification and password verification. Operating system verification means to use the operating system's account and password system to protect the security of the oracle database

Basic Concepts
There are two ways to verify Oracle: operating system verification and password verification. Operating system verification means to use the account and password system of the operating system to protect the security of the oracle database. Generally, only the dba in the production system has the account of the operating system, therefore, operating system verification is convenient and highly secure. Password Verification ensures the security of the oracle database through the oracle password file.
The simplest way to determine the current database authentication method is:
1. Enter "sqlplusw/nolog" in the command line to log on to sqlplus as nolog.
2. Enter the command "conn/as sysdba"
If the system prompts "connected", the current authentication method is strictly controlled by the operating system. If an error message is displayed, password verification is used.

Steps for operating system verification
1. Create an operating system account for the user
2. Add ora_dba (in Control Panel) to the user's permissions)
3. Modify the initialization parameter remote_login_passwordfile = none.
4. Modify the sqlnet. ora file SQLNET. AUTHENTICATION_SERVICES = (ETS)

3. Steps for Password File Verification
1. Modify the initialization parameter remote_login_passwordfile = exclusive.
Or remote_login_passwordfile = exclusive = shared
2. Modify the sqlnet. ora file SQLNET. AUTHENTICATION_SERVICES = (NONE)
3. Call the orapwd command in the command line to generate the password file.
Example: orapwd file = D: \ Oracle \ Ora81 \ DATABASE \ PWDmyoracle. ora password = admin entries = 10

4. Note
You can only delete the ora_dba permission from all users in the control panel. After the modification, no matter which user cannot log on to the oracle database as sysdba, the direct result is that the database cannot be started or stopped manually.