1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Databases with identical SID, how to change NET service names for developer

Discussion in 'General' started by rajthampi, Jan 27, 2011.

  1. rajthampi

    rajthampi Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi guys
    We are on a class C subnet and have two databases with same SID (TEST) deployed on two different servers.
    TNS entries are like following:

    TEST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = erp-devp.abc.com)(PORT = 1523))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = test)
    )
    )

    TEST =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = erp-test.abc.com)(PORT = 1522))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = test)
    )
    )

    We would like to know whether we can change the erp-devp net service name to something "devp" to avoid issues connecting to respective databases through development tools like forms and reports. Currently both the tools return TNS no listener error...

    regards,
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Change the TNS alias so it can be resolved correctly; name the devp alias to TESTD or TESTDVP as two configurations with the same name won't resolve as you have already discovered.
     
  3. rajthampi

    rajthampi Active Member

    Messages:
    5
    Likes Received:
    0
    Trophy Points:
    55
    Hi David
    Thanks. Actually it was my mistake and our dba was the culprit who didn't forward the correct port. The aliasing was not working hence I posted this entry with the forum. Anyway correct port is forwarded now and connections are established successfully.

    Regards,

    raj
     
  4. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,345
    Likes Received:
    347
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    You are certain you can connect to BOTH databases aliased TEST? That doesn's appear to be possible as Oracle will resolve to the first alias with a given name and use it so I expect all of your connections are being made to the devp server and none are established with the test server. You should have distinct tns aliases for all of your listed databases regardless of the SID.
     
  5. janste

    janste Active Member

    Messages:
    23
    Likes Received:
    6
    Trophy Points:
    90
    Test your alias with tnsping. It will show you if it is going in the direction you want it to go.
    If that one fails it could be that you have a network problem.