Shulou(Shulou.com)05/31 Report--

This article mainly shows you the "SYS user login Oracle error ORA-01031 how to do", the content is easy to understand, clear, hope to help you solve doubts, the following let the editor lead you to study and learn "SYS users login Oracle error ORA-01031 how to do" this article.

I wrote a script to run the script in the test environment, resulting in an abnormal downtime of the database, and then reconnecting caused the following problems. The following is the process of scenario restoration and solution:

[oracle@seiang ~] $sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Jan 30 08:39:21 2018

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected.

SYS@seiang11g > shutdown immediate

ORA-24324: service handle not initialized

ORA-24323: value not allowed

ORA-01089: immediate shutdown in progress-no operations are permitted

1. When you try to forcibly close and open the database, you get an error ORA-01031: insufficient privileges

SYS@seiang11g > shutdown abort

ORA-01031: insufficient privileges

SYS@seiang11g > startup

ORA-01031: insufficient privileges

2. Next, try to check the parameters of the database and indicate that you are not logged in

SYS@seiang11g > show parameter password

ERROR:

ORA-01012: not logged on

3. Next, use SYS to connect to the database instance and see the prompt to connect to an idle instance.

SYS@seiang11g > conn / as sysdba

Connected to an idle instance.

4. Next, try to restart the database and prompt again that you are not logged in

SYS@seiang11g > startup

ORA-01012: not logged on

5. Try to shut down the database forcefully again, and then restart the database successfully.

SYS@seiang11g > shutdown abort

ORACLE instance shut down.

SYS@seiang11g >

SYS@seiang11g > startup

ORACLE instance started.

Total System Global Area 1252663296 bytes

Fixed Size 2252824 bytes

Variable Size 738201576 bytes

Database Buffers 503316480 bytes

Redo Buffers 8892416 bytes

Database mounted.

Database opened.

Database started successfully!

Supplementary note:

For ORA-01031: insufficient privileges error, some common reasons and solutions:

1. If there are multiple database instances, set ORACLE_SID=''

2. Check whether sqlnet.ora (located in the% ORACLE_HOME%NETWORKADMIN directory under WINDOWS) contains this sentence:

SQLNET.AUTHENTICATION_SERVICES= (NTS), if not, add

3. Check whether the users who log in to windows (administrator or users used when installing oracle) are included in the ORA_DBA group. This phenomenon may occur when domain users are not connected to the domain server.

3. Make sure that the remote_login_passwordfile parameter = EXCLUSIVE.

4. Check whether the password file corresponds to the database instance. If not, you need to use orapwd to regenerate the password file.

The above is all the contents of the article "what to do when SYS users log in to Oracle and report an error ORA-01031". Thank you for reading! I believe we all have a certain understanding, hope to share the content to help you, if you want to learn more knowledge, welcome to follow the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.