How do you change DB connection tcp port number on a Oracle application server 10g server
I need to change DB connection string TCP port number from IAS 10g client. There are two Oracle homes on the server, one is for IAS infrastructure DB and another is for Forms and Reports Home. Can I change database TCP port number in connection string in TNSNAMES.ora in both Oracle Homes directly? I found there are two same connection string in TNSNAMES.ora files in both homes.
Thank you for your input!
April