One of our architects wants to create a dev db with the same SID as
an existing one - how will this affect the tns names for the users and can something be done so as to make them connect to the right instances ? What I think is that the tnsnames will look like this:
----------------------------------------------------------------------
# TNSNAMES.ORA Network Configuration File: C:\oracle\ora92\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

DEVX2.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.55.82.50)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEVX2)
)
)

DEVX2.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.67.91.58)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = DEVX2)
)
)
----------------------------------------------------------------------
Only the ip address of the host will be different - is this at all
possible ?