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/