how to change database listener port in R12.1.3

[SrinivasaN]

We need to change database listener port from 1621 to 1632 in EBS R12.1.3. Please share document

[ErmanArslansOracleBlog]

It seems we have a lack of documentation for this.

You may follow the action plan.. But first implement it in a TEST env.


1)In DB tier context file make the necessary changes for the new database listener port.
2)Shutdown your app tier services
3)Change the port values manually in your listener.ora and tnsnames.ora, which are located in directory pointed by $TNS_ADMIN
4)Restart your listener with the updated port.
5)Run autoconfig on db tier. (ensure it finishes successfully)
6)Change the db port value in Apps Tier context file.. (update all the necessary places in this file)
7)Run autoconfg in apps tier. (ensure it finishes successfully)
8)Start your app tier services.