Solution to oracle ORA-01031 on windows Platform

This afternoon, I encountered a strange problem. On windows, I logged on to the database with sqlplus/as sysdba, prompting that I had insufficient permissions,

650) this. width = 650; "title =" qq 30608164853.jpg "src =" http://www.bkjia.com/uploads/allimg/131228/223A03R9-0.jpg "/>

At that time, I was puzzled. The sys user still had insufficient permissions to log on to the database. When the problem occurred, I began to find a solution.

First, check the configuration information of sqlnet. AUTHENTICATION_SERVICES in $ ORACLE_HOME/network/admin/SQLNET. ora,

Most posts on the Internet agree that:

On windows platform, SQLNET. AUTHENTICATION_SERVICES must be set to ETS or ALL to use operating system verification. If it is not set or set to another one, operating system verification can be used.

On linux, SQLNET. AUTHENTICATION_SERVICES must be set to ALL or not to use operating system verification. If it is set to another, operating system verification cannot be used.

Well, check sqlnet. ora first.

650) this. width = 650; "title =" qq 30608172206.jpg "src =" http://www.bkjia.com/uploads/allimg/131228/223A040K-1.jpg "/>

Why is my SQLNET. AUTHENTICATION_SERVICES?

 

Analyze the behavior of operating system users logging on to the operating system before accessing the database instance.

Use sysdba to connect to the database instance. The authentication method is operating system authentication, this authentication operation is performed by the operating system to verify whether the user can connect to the database based on the information it manages.

Therefore, it is necessary to further analyze whether the operating system determines that the oracle user meets the authentication conditions. Apparently, the permissions of our oracle users are denied by the operating system or the oracle system.

Oracle believes that only users who meet the following conditions can use the system authentication method to connect to the database instance.

1. The system user oracle must belong to a specific group

This user must belong to the OSDBA group to Log On As sysdba. Here, the OSDBA group has different names in different operating systems. The name is "dba" On unix systems, while the name is "ORA_DBA" on windows systems ".

2. The sqlnet. authentication_services parameter must be set correctly.

On unix systems, this parameter value must be set to ALL or not. On windows, it must be set

Check whether the current logon user has been added to ORA_DBA,

650) this. width = 650; "title =" qq 3060817.03.jpg "src =" http://www.bkjia.com/uploads/allimg/131228/223A0J64-2.jpg "/>

The error message returned when I logged in as administrator but did not add it to the ORA_DBA group.

Add the administrator user to the ORA_DBA Group

650) this. width = 650; "title =" qq 3060817.04.jpg "src =" http://www.bkjia.com/uploads/allimg/131228/223A04958-3.jpg "/>

Log on to the database: sqlplus/as sysdba

650) this. width = 650; "title =" qq 30608174526.jpg "src =" http://www.bkjia.com/uploads/allimg/131228/223A04K1-4.jpg "/>

OK, solve the problem!

This article is from the blog "Kick little sister", please be sure to keep this source http://chunke.blog.51cto.com/2753715/1219092