My Oracle Support Banner

ORA-1103 While Mounting the Database Using PFILE (Doc ID 237073.1)

Last updated on JUNE 05, 2024

Applies to:

Oracle Database Cloud Exadata Service - Version N/A and later
Oracle Database Backup Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Cloud Service - Version N/A and later
Oracle Database - Enterprise Edition - Version 8.1.7.4 and later
Information in this document applies to any platform.

Symptoms

Mounting the database using pfile option fails with error:
startup mount pfile='D:\oracle\admin\db92\pfile\initDB92.ora'

ORA-01103 - database name <name> in control file is NOT <name>

But if you just issue "startup" it opens the database.

SQL> startup

ORACLE instance started.

Total System Global Area 135338868 bytes
Fixed Size 453492 bytes
Variable Size 109051904 bytes
Database Buffers 25165824 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
SQL>

In this case it is using spfile by default. Spfile file for the same instance is intact.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.