tnsnames.ora and SID's!!

[cruser3]

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 ?

[gandolf989]

Originally posted by cruser3
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?

You need to reference them by different names on the client machine.

Originally posted by cruser3
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 ?

No, they need to have different aliases, otherwise how will Oracle know which database you are connecting to? You should just use a different sid for the other database, for example DEVX4.

[svk]

I don't think this is possible.

Having same db name on different machines is okay. But, they can't be addressed by same alias in a tnsnames.ora file. You either have to use a different alias or, have only the relevant entry in it.

[cruser3]

Tx. guys - I did'nt think it was possible - the db.'s are on different servers - so the only way is to have different SID'S isnt it ?

[cruser3]

oops forgot to add - how does one become an architect ? Looks like ours has some fancy ideas !!

[svk]

How does one become an architect ? Of course by having fancy ideas

But, it may not a very bad idea either. It all depends on WHAT is the architect trying to achieve.

[davey23uk]

Originally posted by cruser3
Tx. guys - I did'nt think it was possible - the db.'s are on different servers - so the only way is to have different SID'S isnt it ?

just give it a different alias in the tnsnames file as gandalf said - easy