File $ Oracle_HOME/network/admin/sqlnet. ora
Does this involve oracle OS authentication or password file authentication?
The AUTHENTICATION_SERVICES parameter in $ ORACLE_HOME/network/admin/sqlnet. ora is as follows:
1. In windows, SQLNET. AUTHENTICATION_SERVICES must be set to ETS to use OS authentication. If it is not set or set to any other value, OS authentication cannot be used.
2. In linux, OS verification can be successful only when the value of SQLNET. AUTHENTICATION_SERVICES is set to ALL or not;
A. SQLNET. AUTHENTICATION_SERVICES parameters in linux:
1. If the value is all, you cannot log on as sysdba.
2. If it is set to an ETS, users such as sys and system can log on as sysdba management identities, but can log on directly as sysdba.
B. This parameter is also available.
The REMOTE_LOGIN_PASSWORDFILE parameter in spfile:
1. If the value is exclusive, remote logon can be performed as sysdba.
2. If the value is none, you cannot log on as sysdba.
This article from the "O & M transcript Mei Ling" blog, please be sure to keep this source http://meiling.blog.51cto.com/6220221/1572826
About ORA-01031: insufficient privileges