I'm part of the end user computing and we are in the process of making a consolidated tnsnames.ora file as part of our migration from Windows XP to 7.
The following two entries are to the same host, but are named different and use different ports, we can't locate the original programmer that set it up.
I need to know if this would cause conflicts or not?
################################################################################################
PYRPROD.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = [same hostname])(Port = 1521))
)
(CONNECT_DATA =
(SID = pyrp1)
)
)
PYRP1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = [same hostname])(PORT = 1526))
)
(CONNECT_DATA =
(SERVICE_NAME = pyrp1)
)
)
################################################################################################