Page 1 of 1

Multi org Setup

Posted: Thu Oct 16, 2008 2:30 pm
by vedanta
Hi,

We have just completed 11i (11.5.10.2) installation. It was not done as multi org setup. Now want to convert the instance to multi org. please let me know if any one of you had similar requirement, if so what steps we need to follow? Your valuable inputs would be highly appreciated.

Thanks in advance.

Regards
Vedanta

Posted: Tue Nov 04, 2008 2:07 am
by lukman
1.Start ONLY the database. No user may connect !!!

2.Change to APPL_TOP folder (usually indicated by <SID>appl folder)
$ cd /?/<SID>appl

3.Execute APPS<SID>.env script
$ ./APPS<SID>.env

4.Execute adadmin script
$ adadmin

5.Select No. 4 ? Maintain Applications Database Entities Menu

6.Select No. 6 ? Convert to Multi Org

7.Give the value asked by the system and select default worker number given

There will be message like below if that?s the first time system convert to multi organization:
Warning : File /<SID>appl/ar/11.5.0/patch/115/sql/arhmgmul.sql does not exist

Posted: Tue Nov 04, 2008 2:43 am
by admin
If successful then option 6.Select No. 6 ? Convert to Multi Org will be removed from adadmin. thanks

Posted: Fri Nov 07, 2008 6:20 am
by Manoj007
A word of caution. This conversion happens for only once, and there is supposedly no option to revert back.