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
Its matching with below bug so please apply patch for this bug.
Bug 17308532 : ORA-1507 DETECTED WHEN STOP DB BY SRVCTL
Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected (Not specified)
Versions confirmed as being affected
Platforms affected Generic (all / most platforms affected)
The fix for 17308532 is first included in
220.127.116.11 (Base Release)
18.104.22.168 (Server Patch Set)
Error May Occur
Stack is likely to include kcblfxl
ORA-1507 from CKPT during shutdown
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 )
1,674 views last month, 2 views today