ORA-29760: instance_number parameter not specified

[Former Member]

We are doing the installation of NW7.31 Portal with Oracle RAC and phase "create database" is showing the following message.
"ORA-29760: instance_number parameter not specified"

What do we do with this problem.
Annex log in error and log the installation.

S.O: Linux
DB: Oracle 11.2.0.3

sapinst_dev.txt.zip

ora_sql_results.txt.zip

[janos_mucsi-besze]

Hi Ary.

It sound very easy, but please make sure you downloaded latest SWPM tool. There were problems with RAC installations in the early stages, where RAC specific SID (e.g. SIDXYZ) wasn't correctly recognized and processed internally.

Regards,

János

[ACE-SAP]

Hi

These parameters should have been set during instance installation.

Check if these parameters are set

set lines 200

select INST_ID, NAME, substr(VALUE,1,6) from gv$parameter where NAME in ('instance_number', 'thread');

You could try to set them running the here under commands on  every node, and restart instance.

alter system set "instance_number" = 1 scope = spfile sid='PP1001';

alter system set "instance_number" = 2 scope = spfile sid='PP1002';

...

alter system set "instance_number" = x scope = spfile sid='PP1xxx';

Also make sure thread parameter is set with the same value as instance_number

Regards

[former_member182657]

Hi Ary,

Could you share output result for command echo $ORACLE_SID .Try to set the correct value with instance name & retry the process again.

Regards,

[Former Member]

Hello Gaurav,

We've tried this procedure and we can manually do the startup of the database instance, but when we do retry in SAPinst error remains.