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.
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
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