Creating Single Database Instance in Exadata Setup having RAC databases with same name ,fails with ORA-00304
(Doc ID 1455218.1)
Last updated on JANUARY 30, 2022
Applies to:Oracle Database - Enterprise Edition - Version 126.96.36.199 and later
Oracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Database Cloud Exadata Service - Version N/A and later
Information in this document applies to any platform.
Unable to create a single instance "DUPDB" with a database name "XXXX" on a Exadata Server, when there are already exists a two node RAC database having Database Name "XXXX" on the Exadata servers.
- Exadata box with four servers: DB01, DB02, DB03 and DB04.
- A two node RAC database "XXXX" exists on DB01 and DB02.
- When attempting to create a single instance "DUPDB" with a database name of "XXXX" on DB03; it fails with:
$ echo $ORACLE_SID
SQL> STARTUP NOMOUNT PFILE='/u02/oradba/initdupdb.ora'
ORA-00304: requested INSTANCE_NUMBER is busy
- Pfile(initdupdb.ora) has:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document