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 )

 

 338 views last month,  4 views today

About Mehmet Salih Deveci

I am Founder of SysDBASoft IT and IT Tutorial and Certified Expert about Oracle & SQL Server database, Goldengate, Exadata Machine, Oracle Database Appliance administrator with 10+years experience.I have OCA, OCP, OCE RAC Expert Certificates I have worked 100+ Banking, Insurance, Finance, Telco and etc. clients as a Consultant, Insource or Outsource.I have done 200+ Operations in this clients such as Exadata Installation & PoC & Migration & Upgrade, Oracle & SQL Server Database Upgrade, Oracle RAC Installation, SQL Server AlwaysOn Installation, Database Migration, Disaster Recovery, Backup Restore, Performance Tuning, Periodic Healthchecks.I have done 2000+ Table replication with Goldengate or SQL Server Replication tool for DWH Databases in many clients.If you need Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS Consultancy and Training you can send my email adress [email protected].-                                                                                                                                                                                                                                                 -Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  [email protected] a mail atabilirsiniz.

Leave a Reply