ORA-01031: Insufficient Privileges With Oracle Shutdown

ORA-01031: Insufficient Privileges With Oracle Shutdown

October 15, 2019
Oracle DBA
oracle dba oracle database management database management system database oracle performance tuning oracle sql learn sql learn personal injury attorney new york mesothelioma lawyers mesothelioma lawyers new york mesothelioma lawyer the stock market plumbing retirement planning barclays stock broker financial advisor personal retirement financial advisor

Our Oracle DBA has found an oracle database management bug shutdown commands raising error ORA-01031: insufficient privileges. Let play through the most common way it appears and then we will explain why it is occurring in the database system and how to fix it.

For example you have just executed a shutdown normal to your database and it is just hanging. The oracle alert tells that the shutdown progress waits after an open user session. You have just killed all connections, but the shutdown is still hanging, so you’ll log on as SYSDBA:

$ sqlplus / as sysdba

And as Oracle DBA executing one more time oracle shutdown immediate:

SQL> shutdown immediate

dba oracle dba database management system oracle performance tuning oracle database oracle ORA-01090: shutdown in progress - connection is not permitted ORA-01031: insufficient privileges shutdown abort shutdown immediate startup the stock market plumbing

The Oracle database management system warns you about the shutdown is in progress. Next you will try to do shutdown abort as you are still logged on as Oracle DBA and the Oracle database respond is:

SQL> shutdown abort

dba oracle dba database management system oracle performance tuning oracle database oracle ORA-01090: shutdown in progress - connection is not permitted ORA-01031: insufficient privileges shutdown abort shutdown immediate startup the stock market plumbing

This is quite strange your Oracle DBA does not have enough permissions. The reason comes out when you executed “shutdown immediate” then your Oracle database just levelled your permissions since the database will be doing shutdown soon and you couldn’t do anything “funny” or trying to cancel the shutdown process.

Your situation is different because the database shutdown is still hanging and to execute shutdown abort, you just log off and on again. With the fresh logging your permissions will be back and you can execute shutdown abort without problems. So do the following:

SQL> exit

Log on as SYSDBA again:

$ sqlplus / as sysdba

And execute the shutdown command:

SQL> shutdown abort;

dba oracle dba database management system oracle performance tuning oracle database oracle ORA-01090: shutdown in progress - connection is not permitted ORA-01031: insufficient privileges shutdown abort shutdown immediate startup the stock market plumbing

Of course, if you want to do start up then the follow and don’t forgot to exit in the end:

SQL> startup;

dba oracle dba database management system oracle performance tuning oracle database oracle ORA-01090: shutdown in progress - connection is not permitted ORA-01031: insufficient privileges shutdown abort shutdown immediate startup the stock market plumbing

SQL> exit
select SYS_CONTEXT('USERENV','DB_NAME') from dual;

See Also:
Oracle Select Home

Leave a Reply

Your email address will not be published. Required fields are marked *

*