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

[Dileep Tallam]

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 other Tier.

Now we would like to convert this single instance database to RAC database. So, I would like to know what 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.

[Steven E. Protter]

Shalom,

You might want to give us more details on all three tiers.

There could be problems making this transition, demands on memory and such that are not good for a single system. Oracle generally recommends not running applications and database on the same server, though I've gotten away with it on powerful hardware.

Based on what you have posted, I can only recommend you plan carefully, check memory use on your tiers and make sure the single system is powerful enough to do the job.

SEP

[Dileep Tallam]

Hai,
You did not get a clear picture of what I was saying. We have distributed them over 3 nodes to have a better performance. Hence I was calling it a 3 Tier system.

So, If you have ever done this or have any idea about the conversion of Single Instance Database to RAC in Oracle 11i on HP-UX Using CFS, please let me know.


regards,
Dileep Tallam.

[Steven E. Protter]

Shalom Dileep,

It's like any other Oracle migration. Best thing to do is get a cold backup before you start so you have a backout plan.

If the version of oracle underlying RAC is the same as you currently use it should not be very hard to make the change.

Oracle has complex migration procedures that must be followed if there is a conversion in database version number in this plan.

SEP

[Dileep Tallam]

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.

[Dileep Tallam]

Hai.
Thanks for your reply. Our Current Version is 10g R2 (10.2.0.2). But, we want to have our final version as 10.2.0.3. But, any how
I would like to know whether the following steps are correct:

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.