Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

Search This Blog

Tuesday, May 10, 2011

R12 change port pool

How to change port pool in Oracle Apps R12?

I had the opportunity to change the port pool in R12 and below is the procedure I followed:

for DB :

1) backup the existing context file
2) change the below ports with the new ports.

***** List of ports allocated based on port pool 3 *****
Database Port : 1524
DB ONS Local Port : 6303
DB ONS Remote Port : 6403
Oracle Connection Manager Port : 1524 (EXT_PORT)

verify what are the ports you used/allocated during the cfgclone.pl from the logs.

Checking the port pool 3
done: Port Pool 3 is free
Report file located at $ORA_HOME/appsutil/temp/portpool.lst
4)run the adautocfg.sh

on Apps Tier:

$COMMON_TOP/clone/bin/adcfgclone.pl appsTier

and pick the appropriate pool:

1 comment:

Md. Tanweer Qasim Mohnavi said...

How find PORT pool by sql statment ?