Wednesday, 16 May 2012

How to change port pool in Oracle EBS R12?

Today I will show how to change port pool in Oracle Apps R12:

on DB Tier
-----------------

1. Logon as oracle database user and source environment for R12 RDBMS ORACLE_HOME

2. Start database instance for which you want to change R12 port

3. Backup contextfile

4. Change as below in contextfile
    [for example: Let's change port pool from 1 (old) to 10 (new)]
        dbport  : from 1521 to 1531
        db_ons_localport : 6300 to 6310
        db_ons_remoteport : 6400 to 6410
        cmanport : 1521 to 1531

5. Run adautocfg.sh


on Apps Tier
--------------------

1. Logon as application manager user and source environment for R12

2. Backup contextfile

3. Run adpreclone
[oraoba2@grpkml370g6 scripts]$ perl ./adpreclone.pl appsTier

4. Run adcfgclone and choose new port pool
[oraoba2@grpkml370g6 scripts]$ cd $COMMON_TOP/clone/bin
[oraoba2@grpkml370g6 bin]$ perl ./adcfgclone.pl appsTier

5. Check new application URL
SQL> select home_url from icx_parameters;

HOME_URL
--------------------------------------------------------------------------------
http://grpkml370g6.groupinfra.com:8010/OA_HTML/AppsLogin

6. Re-implement SSL, if it was configured earlier.

7. Run adpreclone on both apps and db tier.

No comments:

Post a Comment