tnsnames.ora and SID's!!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: tnsnames.ora and SID's!!

  1. #1
    Join Date
    Jul 2003
    Posts
    323

    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 ?


  2. #2
    Join Date
    Nov 2000
    Location
    Pittsburgh, PA
    Posts
    3,997

    Re: tnsnames.ora and SID's!!

    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.
    this space intentionally left blank

  3. #3
    Join Date
    Jul 2000
    Posts
    521
    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.
    svk

  4. #4
    Join Date
    Jul 2003
    Posts
    323
    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 ?


  5. #5
    Join Date
    Jul 2003
    Posts
    323
    oops forgot to add - how does one become an architect ? Looks like ours has some fancy ideas !!


  6. #6
    Join Date
    Jul 2000
    Posts
    521

    Post

    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.
    svk

  7. #7
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width