ORA-00304: requested INSTANCE_NUMBER is busy due to db_unique_name parameter and Startup Oracle Instance

Hi,

When I startup the new Oracle Instance,  I got ” ORA-00304: requested INSTANCE_NUMBER is busy ” error.

 

Details of error are as follows.

ORA-00304: requested INSTANCE_NUMBER is busy

Cause: An instance tried to start by using a value of the initialization parameter INSTANCE_NUMBER that is already in use.

Action: Either
a) specify another INSTANCE_NUMBER,
b) shut down the running instance with this number
c) wait for instance recovery to complete on the instance with this number.

 

[NEWDB]/home/oracle $ . NEWDB_profile 
[NEWDB]/home/oracle $ sqlplus / as sysdba            

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Jun 19 23:14:04 2020
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/home/oracle/initNEWDB.ora';
ORA-00304: requested INSTANCE_NUMBER is busy
SQL> exit
Disconnected
[NEWDB]/home/oracle $

 

 

This error is related with the same Database Name or Instance name on Same Server.

 

To solve this problem, You should check if same Instance name exist on same Server or not.

If the same Instance name exist on same server, then rename the new Instance name or DB Name.

*.db_unique_name=’NEWDB’

 

I would restore the existing database at the same server from backup with different instance name, To solve this error you should use the db_unique_name parameter in the parameter ( spfile, pfile ) file as follows.

[NEWDB]/home/oracle $ cat initNEWDB.ora 
*.audit_file_dest='/u01/app/oracle/admin/NEWDB/adump'
*.audit_trail='DB'
*.cluster_database=false
*.compatible='18.3.0'
*.control_files='+DATATEST/NEWDB/controlfile/control01.ctl'
*.core_dump_dest='/u01/app/oracle/diag/rdbms/NEWDB/NEWDB/cdump'
*.db_block_size=8192
*.db_domain=''
*.db_name='MSDB'
*.db_unique_name='NEWDB'
*.db_recovery_file_dest_size=2147483648000
*.db_recovery_file_dest='+DATATEST'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=NEWDBXDB)'
*.local_listener='LISTENER_NEWDB'
*.optimizer_mode='ALL_ROWS'
*.processes=300
*.result_cache_max_size=52448K
*.sga_target=10G
[NEWDB]/home/oracle $

 

Now try again, it will be solved.

 

[NEWDB]/home/oracle $ . NEWDB_profile 
[NEWDB]/home/oracle $ sqlplus / as sysdba 

SQL*Plus: Release 18.0.0.0.0 - Production on Fri Jun 19 23:16:23 2020
Version 18.3.0.0.0

Copyright (c) 1982, 2018, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup nomount pfile='/home/oracle/initNEWDB.ora';
ORACLE instance started.

Total System Global Area 1.0737E+10 bytes
Fixed Size 12207952 bytes
Variable Size 2717908992 bytes
Database Buffers 7952400384 bytes
Redo Buffers 54898688 bytes
SQL> exit
Disconnected from Oracle Database 18c Enterprise Edition Release 18.0.0.0.0 - Production
Version 18.3.0.0.0
[NEWDB]/home/oracle $

 

 

 

 

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

https://ittutorial.org/oracle-database-19c-tutorials-for-beginners/

 352 views last month,  2 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 mehmetsalih.deveci@outlook.com. -                                                                                                                                                                                                                                                 - Oracle DBA, SQL Server DBA, APPS DBA,  Exadata, Goldengate, EBS ve linux Danışmanlık ve Eğitim için  mehmetsalih.deveci@outlook.com a mail atabilirsiniz.

Check Also

blank

ORA-01438: value larger than specified precision allowed for this column

Hi, I got ” ORA-01438: value larger than specified precision allowed for this column” error …

Leave a Reply