- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- 10g R2 Single Instance to RAC(HP-UX with CFS)
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2007 09:25 AM
тАО10-04-2007 09:25 AM
10g R2 Single Instance to RAC(HP-UX with CFS)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2007 11:04 AM
тАО10-04-2007 11:04 AM
Re: 10g R2 Single Instance to RAC(HP-UX with CFS)
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2007 11:12 AM
тАО10-04-2007 11:12 AM
Re: 10g R2 Single Instance to RAC(HP-UX with CFS)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2007 11:58 AM
тАО10-04-2007 11:58 AM
Re: 10g R2 Single Instance to RAC(HP-UX with CFS)
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
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-04-2007 12:06 PM
тАО10-04-2007 12:06 PM
Re: 10g R2 Single Instance to RAC(HP-UX with CFS)
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-05-2007 08:48 AM
тАО10-05-2007 08:48 AM
Re: 10g R2 Single Instance to RAC(HP-UX with CFS)
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.