Susan,

When you say "The database currently exists on only one.", does this
mean that the database files have been created on local disks? All
database files (data, index, redo, temp, control, SPFILE, voting file,
OCR file, etc) need to be on shared storage so every node has full
read/write access. This can be done through ASM, VCS or other shared
file system. I would try to avoid raw patitions if possible as they are
harder to manage, but they will work also.

For the config, you must use an SPFILE for RAC. There are a number of
mandatory parameters that should be set. I havent used RCONFIG, but
setting it up manually is quite easy. Assuming a 2 node RAC cluster with
a database_name of "FRED" and instance_names of "FRED1" and "FRED2", the
basic parameters you need to set in the SPFILE for RAC (in addition to
the standard parameters) are:

*.cluster_database_instances=2
*.cluster_database=TRUE
*.db_name='FRED'
*.undo_management='AUTO'
FRED1.instance_name='FRED1'
FRED2.instance_name='FRED2'
FRED1.instance_number=1
FRED2.instance_number=2
FRED1.thread=1
FRED2.thread=2
FRED1.undo_tablespace='UNDOTBS1'
FRED2.undo_tablespace='UNDOTBS2'

Theres a few other parameters that can be set dependant on your
requirements, but this should allow both instances to be started at
least (assuming the shared storage is correct). The errors you are
seeing indicates that the database config (SPFILE) is not correct. The
above should get round this.

HTH
John.

-----Original Message-----
From: Susan L Rapp
[mailto:oracledba-ezmlmshield-x45724880.[Email address protected]
Sent: 08 January 2008 19:42
To: LazyDBA Discussion
Subject: RAC EBIZ suit



I am trying to RAC an EBIZ suit environment 10.2.0.3 on Itanium. The
listeners created successfully on both nodes. The database currently
exists on only one. We are attempting to create a single instance rac
and
then add an instance on the second node. RCONFIG is failing with
ORA-00304
INSTANCE_NUMBER is busy. The docs say bring up the instance in the
RACed
home, and the pfile generated has no instance_number parameter
specified.
The alert log shows it trying to reuse 0, but if you leave the db down,
rconfig fails with instance not running. Anyone else run into (and
resolve) this?

---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



-----------------------------------------
Information in this email including any attachments may be
privileged, confidential and is intended exclusively for the
addressee. The views expressed may not be official policy, but the
personal views of the originator. If you have received it in error,
please notify the sender by return e-mail and delete it from your
system. You should not reproduce, distribute, store, retransmit,
use or disclose its contents to anyone.

Please note we reserve the right to monitor all e-mail
communication through our internal and external networks.

SKY and the SKY marks are trade marks of British Sky Broadcasting
Group plc and are used under licence. British Sky Broadcasting
Limited (Registration No. 2906991), Sky Interactive Limited
(Registration No. 3554332), Sky-In-Home Service Limited
(Registration No. 2067075) and Sky Subscribers Services Limited
(Registration No. 2340150) are direct or indirect subsidiaries of
British Sky Broadcasting Group plc (Registration No. 2247735). All
of the companies mentioned in this paragraph are incorporated in
England and Wales and share the same registered office at Grant
Way, Isleworth, Middlesex TW7 5QD.


Oracle LazyDBA home page