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.

6 comments:

Anonymous said...

Hi Suresh,

I beleive it is dbTechStack, not dbTier at adcfgclone. Please correct me if I am wrong.

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

Thanks & Regards
Natarajan

Anonymous said...

Hi Suresh,

I beleive it is dbTechStack with adcfgclone, not dbTier.

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

Please correct me if I am wrong.

Thanksk & Regards

Natarajan

Suresh Lakshmanan said...

Hi Natarajan,

It should work well if you are not moving the file system (datafile locations). I think he had moved his datatop locations. In order to avoid manual recreation of control file he had used the dbTier option. hope this clarifies you.

Thanks
Suresh

Anonymous said...

Suresh,

I have the same task in R12in a different way, oracle user owns both Apps and DB Tier, now I want to have a new owner for Apps Tier i.e. applmgr.

I have run adpreclone, do I have to change the ownership for APPL_TOP, Common_TOP and INST_TOP to applmgr?


Please advise.

- Rao

Anonymous said...

Do I have to change the DB user details in DB Context file, before executing adcfgclone in db tier ?

-Rao

Suresh Lakshmanan said...

Hi Rao,

absolutely correct. You need to run adcfgclone for apps tier.

Thanks
Suresh