Monday 17 September 2018

How to change EBS R12 Database and Application Port Number

Recently we had faced the application port blocking issue in oracle EBS R12.
We had follow the below steps to resolve this issue...

Execute the below in Application Tier:

Run adpreclone on Application Tier
   $ perl ./adpreclone.pl appsTier

Execute the following on the Database Tier:

Logon as oracle database user and set envirnoment variable for R12 RDBMS ORACLE_HOME

Start the database instance for which you want to change R12 port

Backup contextfile

Change as below parameters values in the contextfile

        dbport  : Change database port from 1521 to 1531
        cmanport : 1521 to 1531

Run adautocfg.sh on Database Tier

And also change the port in listener.ora & tnsnames.ora file.

Again Execute the following in Application Tier:

Logon as application user and set environment variable for R12.

Backup context file

Stop all oracle services for Applications by running "adstpall.sh".

Run adcfgclone and choose new port pool
   $ cd $COMMON_TOP/clone/bin
   $ perl ./adcfgclone.pl appsTier

Check new application URL

SQL> select home_url from icx_parameters;

HOME_URL
------------------------------------------------------------
http://<hostname.domainname>:8010/OA_HTML/AppsLogin

No comments:

Post a Comment