R12: Isolating DB and Apps Tier from Single User Installation

Hi Everyone!!

Vinod, one of the reader of the blog was splitting the apps and db tiers from single user installation. His client had R12 single user installation. Client wanted to have appstier owned by oraapps and dbtier by oradb.

He had both apps and dbtier owner by oraapps initially. He had decided move dbtier owned by oradb. Here are the steps Vinod performed to split the appstier and dbtier owned by oraapps and oradb respectively.

1) Create an OS level User oradb and assign the same group as the current user belongs to.

2) Run the preclone on dbTier
$ perl adpreclone.pl dbTier

3) After successful completion of the Pre-Clone. Bring down all the services related to Apps and DB tiers.

4) Change the ownership of ORACLE HOME and all the DATA TOP’s to be owned by the newly created OS user, oradb.

5) Login as newly created user

6) Run adcfgclone on dbTier as
$ perl adcfgclone.pl dbTier

7) Once the adcfgclone is completed successfully, services on DB Tier come up automatically.

8) After confirming that services are up on DB Tier (DB and listener), Login as App tier User and bring the Application services up.


Thank you Note: I give credit to Vinod Kumar for sending the article to publish. Thank youVinod for sharing the information to the entire user base of this blog.