Site icon IT Tutorial

ORA-01507: database not mounted

I got ” ORA-01507: database not mounted ”  error in Oracle database.

 

ORA-01507: database not mounted

 

Details of error are as follows.

ORA-01507: database not mounted
ORA-449 signalled during: ALTER DATABASE DISMOUNT...
Sat Mar 07 23:31:57 2020
System state dump requested by (instance=1, osid=11803 (CKPT)), summary=[abnormal instance termination].
System State dumped to trace file...._diag_11771_20200307233157.trc
Sat Mar 07 23:31:57 2020
SUCCESS: diskgroup FRA was dismounted
CKPT (ospid: 11803): terminating the instance due to error 1507



 

 

database not mounted

This ORA-01507 error is related with the Bug 17308532 : ORA-1507 DETECTED WHEN STOP DB BY SRVCTL.

Check and try to make database in mount mode as follows.

 

SQL> alter database mount;

 

Read the following post if your controlfile doesn’t exist.

ORA-00205: error in identifying control file, check alert log for more info

Second case’s is as follows.

Its matching with below bug so please apply patch for this bug.

Bug 17308532 : ORA-1507 DETECTED WHEN STOP DB BY SRVCTL
Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected (Not specified)
Versions confirmed as being affected

11.2.0.4
11.2.0.3

Platforms affected Generic (all / most platforms affected)

Fixed:

The fix for 17308532 is first included in

12.2.0.1 (Base Release)
12.1.0.2 (Server Patch Set)

Symptoms:

Error May Occur
ORA-1507
Stack is likely to include kcblfxl

Description

ORA-1507 from CKPT during shutdown

Workaround
Ignore the error

 

Do you want to learn Oracle Database for Beginners, then read the following articles.

Oracle Tutorial | Oracle Database Tutorials for Beginners ( Junior Oracle DBA )

 

Exit mobile version