Database Software

Oracle10g on RHEL 4

Hi All,

A little problem here. I used DBCA to create a RAC database and in the end it told me that the database could not come up becauase the instance_number parameter was not set...I don't know how I missed that. I can't create a pfile from the spfile to add the parameter because the instance won't come up. How can I add this parameter now??

[oracle@vtl-rac1 dbs]$ sqlplus /nolog

SQL*Plus: Release 10.2.0.3.0 - Production on Tue Mar 25 13:57:22 2008

Copyright (c) 1982, 2006, Oracle. All Rights Reserved.

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> create pfile='/home/oracle/initTEST.ora' from spfile;
create pfile='/home/oracle/initTEST.ora' from spfile
*
ERROR at line 1:
ORA-27037: unable to obtain file status
Linux-x86_64 Error: 2: No such file or directory
Additional information: 3

SQL> startup nomount;
ORA-29760: instance_number parameter not specified
SQL> alter system set instance_number=1 scope=spfile;
alter system set instance_number=1 scope=spfile
*
ERROR at line 1:
ORA-01034: ORACLE not available

-----

SQL> connect sys as sysdba
Enter password:
Connected to an idle instance.
SQL> alter system reset instance_number scope=spfile sid='*';
alter system reset instance_number scope=spfile sid='*'
*
ERROR at line 1:
ORA-01034: ORACLE not available