995273 wrote:It would be pointless to attempt to do so. The port is simply used by the listener to receive connection requests. They are not separated by database/instance. The closest you would come to that would be by configuring the client (tnsnames.ora) to make the distinction, like this:
good to know that.
Thank you for that reply!!!
Is it better to use different ports for different instances???
Edited by: 995273 on 21.03.2013 04:32
Note the port difference in the two. But this is really just an illusion. If the listener is listening on both 1521 and 1522, any request that reaches, through any port it is using, will be serviced. You could reverse the ports on the above example, and still be able to connect to both databases.
abbot = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = abbot) ) ) # costello = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1522)) ) (CONNECT_DATA = (SERVICE_NAME = costello) ) ) #