-
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)
)
)
-
Yes, as you are connecting to two different databases.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|