Oracle sets the initialization parameter remote_login_passwordfile

Set the initialization parameter remote_login_passwordfile:

In the initialization parameter file of the Oracle database instance, this parameter controls the usage and status of the password file. It can have the following options:

None: indicates that the Oracle system does not use password files. Privileged users can log on to the Oracle System for authentication;

Exclusive: indicates that only one database instance can use this password file. Only the password file under this setting can contain user information except sys, that is, the system permission sysoper/sysdba can be granted to other users except sys.

Shared: indicates that multiple database instances can use this password file. In this setting, only the sys account can be identified by the password file. Even if the file contains information from other users, they are not allowed to log on with the sysoper/sysdba permission. This is the default value.
---- When the remote_login_passwordfile parameter is set to exclusive and shared, the order of password files searched by the Oracle system is: Search for the ora_sid_pwfile parameter value in the System Registration Database (which is the full path name of the password file ); if not, search for the ora_pwfile parameter value. If not, use the default value ORACLE_HOME \ database \ pwdsid. ora; the SID represents the corresponding Oracle database system identifier.