About ORA-01031: insufficient privileges

Source: Internet
Author: User

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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.