different port numbers in the same tnsnames.ora file
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: different port numbers in the same tnsnames.ora file

  1. #1
    Join Date
    Sep 2007
    Posts
    19

    different port numbers in the same tnsnames.ora file

    Hi,

    Can we use 2 different port numbers (eg., 1521 and 1522) in the same tnsnames.ora file? Similar to the below tnsnames.ora file?

    Address1 =
    (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = node1)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = node2)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA = (SERVER = DEDICATED)(SERVICE_NAME = sid1)(FAILOVER_MODE = (TYPE = SELECT)(METHOD = BASIC)(RETRIES = 180)(DELAY = 5)
    )
    )
    )


    Address2 =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server3)(PORT = 1522))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = sid2)
    )
    )

  2. #2
    Join Date
    Dec 2002
    Posts
    60
    Yes, as you are connecting to two different databases.

  3. #3
    Join Date
    Feb 2013
    Posts
    8
    Yes i think should not be any problem in using the different tnsname, unless and until 1521 and 1522 are Oracle PORT allocated to specified database.

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