Convert ebs 12.2.7 DB to two node rac database

[Raja]

Hi Erman

I have the existing node-EBS3- where ebs 12.2.7 is running with DB 12.1.0.2 in same server

I have another two nodes EBS1 and EBS2 where Grid infrastructure is running and have created a 2 node blank rac database. All version-12.1.0.2


Now i need to convert my existing EBS 12.2.7 db to two node rac. What would be the approach

Should i take a rman backup in EBS3 node and then transfer the rman backup to the target node first in some directory. Will i be able to use this backup in the target where it is already a 2 node rac db?

If yes, then do i need to transfer the rman backup in some temporary directory in target and start the db and then use rconfig to convert it to rac? Please advise on this

Thanks
Raja

[raja]

hi Erman

i have chalked down the below plan

1. In EBS 1 and EBS2 node, where rac is running, i will clone the ebs database which is running on EBS3 node using active duplication method and it will be running in EBS2 node with its own ORACLE_HOME, say OH2.

2. Now i will make EBS from EBS3 to interact with the new DB(created in EBS2 node using active duplicate) in EBS 2 server(autoconfig etc etc)

3. now i will convert the single instance database to two node rac(EBS2 and EBS3) using rconfig utility
In the rconfig xml file, i will feed the Source oracle home to OH2(which is single node DB created after active duplicate method running on EBS2 node) and the target ORACLE_HOME will be rac Oracle HOME(running in EBS2 and EBS3 node)

Does my approach look feasible to you?

Thanks

[ErmanArslansOracleBlog]

The general steps will be;

Duplicate your database to one of your target nodes (directly into the ASM)
Configure your database in the target nodes as RAC.  (this is a basic process, can be done by modifying the spfile/init.ora files)
transfer appsutil directories from your apps to you new db nodes (into the ORACLE HOME directories)
Clean the EBS setup stored in db (fnd_conc_clone.setup_clean)
run autoconfig on new DB nodes , 1 by 1.
Run " adcfgclone.pl " on Apps node to configure your Apps Tier  with your new target nodes..
 

[raja]

So in this case, i need not have to use any utility such as rconfig, dbca to convert my non rac to rac, correct?

The steps which you have highlighted looks easy, it is just a clone from single instance to rac instance.

[raja]

And also if the conversion can be done using clone, then in which case rconfig utilities can be used for converting single instance to rac instance?

[ErmanArslansOracleBlog]

If you restore/duplicate your db into the ASM, then you can convert your single instance to RAC by doing the necessary modifications on init.ora/spfile.
so, If your db is restored into the ASM , you don't need to use the rconfig.

[raja]

Ahh..got it. So in a case, where my source single instance Db is hosted in node 1 and grid/rac is installed in node 1 and node 2, then i think we need not have to duplicate the DB, right. Here we can use rconfig/dbca to convert my Single Db instance to 2 node rac.

[ErmanArslansOracleBlog]

You are complicating the things.

your db is currently located in node3, right?

So you will duplicate it to node1 ( directly into the shared storage/ASM where node2 has access too)

Then you will convert this migrated db to a RAC Db. (by modifying the spfile/init.ora)

There is no rconfig involved..

[raja]

Hi Erman

Can i also follow the note: Cloning Oracle E-Business Suite Release 12.2 RAC Enabled Systems with Rapid Clone (Doc ID 1679270.1)--just for the db part and then enable existing ebs 12.2.7 to connect to new rac system

??

Thanks
Raja

[ErmanArslansOracleBlog]

Yes , you can..
You can get benefit from that note as well..