10g R2 Single Instance to RAC(HP-UX with CFS)

[tvrdileep]

Hai All,
We have Oracle 11i (11.5.10.2) e-business setup. We have upgraded the database to 10g R2.The database is running on HP-UX 11i(11.23). The entire setup is running in 3 tiers.

Forms & Web on one Tier, Reports & Concurrent Manager on other Tier and Database on the othre Tier.

Now we would like to convert this single instance database to RAC database. So, I would like to knowwhat is the procedure for this.

We would be using HP-UX CFS with Service Guard. If any one has done a similar thing or has idea about this please share the information with me.


regards,
Dileep Tallam.

[tvrdileep]

Hai,
Are the following steps correct:

1) Stop the complete application tier.
2) Stop the Database.
3) Move Databasefiles, Controlfiles, Redologs & Archivelogs to the newly
created respective Cluster Filesystems from Local Filessystem.
3) Modify init.ora file for control_files, log_archive_dest_n entries
and re-create the spfile.
4) Startup Database Mount.
5) Rename Redologs & Datafiles with new names.
6) Open the Database.
7) Shutdown the Database again.
8) Install the Oracle Clusterware on existing Database Node.
9) Start the Oracle Clusterware.
10) Modify the spfile and add Cluster Database parameters.
11) Register the database in the OCR Registry.
12) Now, prepare the second node of the two node RAC.
13) Install Oracle Clusterware & Oracle RAC binaries on the second node.
14) Join this to the existing single instance RAC Database.
15) Do a final test by shutting down and starting the services etc.

regards,
Dileep Tallam

[hrishy]

Hi Dileep

For the less adventorous and weak hearted like me who need lot of guidance and hand holding Oracle 10gr2 introduces some exciting things to convert single instance to RAC.

we can use
dbca
Enterprise Grid Manager
rconfig

I know a friend of mine who has used rconfig to convert many single instances to RAC.

Hope this helps

regards
Hrishy

[bang_dba]

http://download-west.oracle.com/docs...htm#sthref1241

[tvrdileep]

Hai All,
Our Current Version is 10g R2 (10.2.0.2). But, we want to have our final version as 10.2.0.3.

So, I would like to know whether the following steps are right:

1) Install Oracle Clusterware 10.2.0.1 in the new CRS ORACLE_HOME using
the same oraInventory location as the existing 10.2.0.2 ORACLE_HOME.
2) Install Oracle 10.2.0.1 RAC Software using the same oraInventory location
in the above step.
3) Install Database Components from Oracle 10g 10.2.0.1 Companion CD.
4) Upgrade Oracle Clusterware Software from 10.2.0.1 to 10.2.0.3
5) Upgrade Oracle RAC Software from 10.2.0.1 to 10.2.0.3
6) Upgrade the existing 10.2.0.2 (Old ORACLE_HOME) Single Instance
Database to 10.2.0.3 using DBUA from the newly installed 10.2.0.3
ORACLE_HOME.
7) Use rconfig/DBCA to convert the Database to RAC Database.
8) Post RAC Migration Steps.


regards,
Dileep Tallam.