tnsnames.ora and SID's!!

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 ?

:confused: :confused:

Quote:

---

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.

Quote:

---

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 ?

:confused: :confused:

---

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. :rolleyes:

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.

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 ?

:)

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

:p :p

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.

Quote:

---

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