RA-00304: requested INSTANCE_NUMBER is busy in DB Instance Installation

[Former Member]

Hi,experts.

In "Perfom ORA Post load activities" phase in DB Instance Installation of systemcopy an error occured.

In accordance with this wiki below, I changed initSID.ora and then restarted oracle.

However I can't solve it.

http://wiki.sdn.sap.com/wiki/display/Basis/Problems+Installing+or+System+Copy+Import+to+Oracle+11g

someone please help me to solve it?

■Error message in sapinstgui
RA-00304: requested INSTANCE_NUMBER is busy Disconnected .
SOLUTION: For more information, see ora_sql_results.log and the Oracle documentation.

■ora_sql_results.log
Connected to an idle instance.

ORA-00304: requested INSTANCE_NUMBER is busy
Disconnected

SAPINST: End of output of SQL executing program /oracle/'SID'/112/bin/sqlplus.

SAPINST found errors.
SAPINST The current process environment may be found in sapinst_ora_environment.log.

■sapinst_ora_environment.log
2013-09-04, 18:31:16 SAPINST Current process environment:
G_BROKEN_FILENAMES=1
HISTSIZE=1000
HOME=/root
HOSTNAME='hostname'
INPUTRC=/etc/inputrc

[Reagan]

Hello

Stop Oracle manually and make sure all the Oracle processes are stopped at the OS level.

Start Oracle database and see whether the instance starts without any issues.

Check whether the parameter INSTANCE_NUMBER is set in the pfile or spfile.

If yes then unset it and restart the database.

Regards

RB

[Former Member]

Hi All,

Thank you for yor help.

I stopped Oracle manually, and checked some settings in OS level.

However I couldn't find what coused this problem.

I interrupted this DB instance installation, and deleted incomplete data.
After that, I started again from the beginning.

In this my second attempt, DB installation completed successful.

Regards,

Naomi Yamane

[Former Member]

Hello,

It will be helpful if you check output from ADRCI for the alerts and then make sure that the instance_number is correct. You can change it to correct instance using below statement.

ALTER SYSTEM SET instance_number=XX SCOPE=spfile;

Regards,

Suhas