Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

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

Dileep Tallam
Occasional Advisor

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

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.
5 REPLIES
Steven E. Protter
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Dileep Tallam
Occasional Advisor

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

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
Exalted Contributor

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

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Dileep Tallam
Occasional Advisor

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

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
Occasional Advisor

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

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.