Summary of Oracle 10g SYS user authentication methods

Summary of Oracle 10g SYS user authentication method OS: Red Hat Enterprise Linux AS release 4 (Nahant Update 2) uname-r: 2.6.9-22. ELDB: Oracle Database 10g Release 10.2.0.1.0 first case: Set the initialization parameter remote_login_passwordfile to EXCLUSIVE 1. local SYS User Logon: Check sqlnet in the $ ORACLE_HOME/network/admin/directory. ora. The default value is NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT) at this time, the local sys user authentication method is system authentication, that is, you can log on through sqlplus/as sysdba without checking the password file. If sqlnet. AUTHENTICATION_SERVICES = (CNT) or SQLNET. AUTHENTICATION_SERVICES = (NONE) is added to SQLNET. ora, the local SYS user must Log On as sqlplus sys/123456 as sysdba. In this case, the local sys user authentication method is password authentication. You need to check the password file in the format of orapwSID. If the password file is lost, a ORA-01031 is reported. How to recreate the password file: orapwd file = orapworcl password = 123456 entries = 2 2. remote SYS User Logon: when a remote SYS user logs on, all users log on using sqlplus sys/123456 @ orcl as sysdba (regardless of the server sqlnet. ). If the remote SYS User Login times: ORA-12514: TNS: The listener is currently unable to identify the Service requested in the connection descriptor at this time check listener under the $ ORACLE_HOME/network/admin/directory. the ora file can be modified according to the following content. After modification, restart the lsnrctl service: lsnrctl reload. Case 2: Set the initialization parameter remote_login_passwordfile to NONEsqlnet. in ora, the default value is NAMES. DIRECTORY_PATH = (TNSNAMES, EZCONNECT) at this time, the remote SYS user cannot log on.