Oracle troubleshooting ORA-01089

Source: Internet
Author: User

Oracle troubleshooting ORA-01089

After sending the shutdown immediate command to the test database today, observe the log and find the following content:
Tue May 12 09:52:45 2015
SHUTDOWN: Active processes prevent shutdown operation
 
Shutdown is blocked by the active process. Ctrl + C cannot interrupt the current session, quit the reconnection server, and open a new session:
[Oracle @ 021Y-SH-BKAP ~] $ Sqlplus/as sysdba
SQL * Plus: Release 11.2.0.1.0 Production on Tue May 12 09:54:17 2015
Copyright (c) 1982,200 9, Oracle. All rights reserved.
Connected.
SQL> shutdown immediate
The ORA-24324: service handle not initialized.
ORA-24323: value not allowed
ORA-01089: immediate shutdown in progress-no operations are permitted
SQL> startup abort
ORA-01031: insufficient privileges

View error message
[Oracle @ 021Y-SH-BKAP ~] $ Oerr ora 1, 01089

01089,000 00, "immediate shutdown in progress-no operations are permitted"

// * Cause: The shutdown immediate command was used to shut down

// A running ORACLE instance, so your operations have been

// Terminated.

// * Action: Wait for the instance to be restarted, or contact your DBA.

Disconnect session and try again
SQL> exit

Disconnected

[Oracle @ 021Y-SH-BKAP ~] $ Sqlplus/as sysdba

SQL * Plus: Release 11.2.0.1.0 Production on Tue May 12 09:57:24 2015

Copyright (c) 1982,200 9, Oracle. All rights reserved.

Connected.

SQL> shutdown abort

ORACLE instance shut down.

Related Article

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.