Solutions for Oracle ORA-01031 under the Windows platform

This afternoon encountered a very strange problem, under the Windows platform Sqlplus/as SYSDBA log in the database, prompting insufficient permissions,

At that time, I was wondering, sys user Login database can also insufficient authority, the problem arose, began to find a solution

First, look at the configuration information for the sqlnet.authentication_services item in $oracle_home/network/admin/sqlnet.ora.

Most of the posts on the Web agree with the conclusion that:

On the Windows platform, Sqlnet. Authentication_services must be set to NTS or all to use operating system authentication, not set or set to other can use operating system authentication

On the Linux platform, Sqlnet. Authentication_services must be set to all or not set to use operating system authentication, setting to others cannot use operating system authentication

Well, let's see Sqlnet.ora first.

My sqlnet.authentication_services is nts ah, that is what reason, and then find

Then analyze the behavior of the operating system user after logging into the operating system and then accessing the database instance. Www.it165.net

Using the SYSDBA identity to connect to a DB instance, the authentication method used is the operating system authentication, which is the process by which the operating system verifies that the user can connect to the database based on the information it manages.

Therefore, further analysis is required if the operating system determines that the Oracle user meets the authentication criteria. Obviously, the permissions of the Oracle users here are denied by the operating system or the Oracle system.

Oracle believes that users who need to meet the following criteria can connect to a DB instance using System authentication.

1, the system user Oracle must belong to a specific group

The user must belong to the OSDBA group to log on as SYSDBA. The OSDBA group here will have different names on various types of operating systems. On UNIX systems, the name is "DBA" and the name on the Windows system is "ORA_DBA".

2, the parameters of Sqlnet.authentication_services must be set correctly

On UNIX systems, the parameter value must be set to all, or not set; On Windows, it must be set to NTS

Look again, the current login user has not joined to ORA_DBA,

Broken, I am currently logged in as a administrator user, but did not add it to the ORA_DBA group for reasons found

Adding administrator users to the ORA_DBA group

Re-login database: Sqlplus/as sysdba

OK, problem solved!

Solutions for Oracle ORA-01031 under the Windows platform