ORA-01012: not logged on Processing

Source: Internet
Author: User

ORA-01012: not logged on Processing

SQL> startup nomount
ORA-01012: not logged on
SQL> startup
ORA-01012: not logged on

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

View alert logs:

NOTE: Instance updated compatible. asm to 11.2.0.0.0 for grp 3
SUCCESS: diskgroup SYS_DG was mounted
SUCCESS: ALTER DISKGROUP ALL MOUNT
NOTE: diskgroup resource ora. DATA_DG.dg is online
NOTE: diskgroup resource ora. DG_FRA.dg is online
NOTE: diskgroup resource ora. SYS_DG.dg is online
Sat Feb 22 19:38:59 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
Sat Feb 22 19:44:02 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 19:49:04 2014
SHUTDOWN: Active processes prevent shutdown operation
[Grid @ myrac1 trace] $ date
Sat Feb 22 21:07:46 PST 2014
[Grid @ myrac1 trace] $ tail-f alert _ + ASM. log
Sat Feb 22 19:38:59 2014
Shutting down instance (immediate)
Shutting down instance: further logons disabled
Stopping background process MMNL
Stopping background process MMON
License high water mark = 4
Sat Feb 22 19:44:02 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 19:49:04 2014
SHUTDOWN: Active processes prevent shutdown operation
Sat Feb 22 21:09:49 2014
License high water mark = 4

From the log, you can find that an instance exception occurs, and shutdown cannot be started.

SQL> shutdown abort
ASM instance shutdown
SQL> startup
ASM instance started

Total System Global Area 284565504 bytes
Fixed Size 1336036 bytes
Variable Size 258063644 bytes
ASM Cache 25165824 bytes
ASM diskgroups mounted

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.