when I try to add a tns entry as I got from someone like:
TPBD.WORLD =
(DESCRIPTION =(LOAD_BALANCE = ON)
(FAILOVER = on)
(ADDRESS = (PROTOCOL = TCP)
(HOST = cittpbd2.ny.jpmorgan.com)
(PORT = 16830))(ADDRESS = (PROTOCOL = TCP)(HOST = cittpbd3.ny.jpmorgan.com)(PORT = 16830))(CONNECT_DATA =(SERVICE_NAME = TPBD.WORLD)))
its always gives me an error when I try to do a tnsping... and I thought it only happens with me..
I found an alternative.. you just have to rearrange things a little bit.:) and everything is fine :)
TPBD.WORLD =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cittpbd2.ny.jpmorgan.com)(PORT = 16830))
(ADDRESS = (PROTOCOL = TCP)(HOST = cittpbd3.ny.jpmorgan.com)(PORT = 16830))
(LOAD_BALANCE = ON)
(FAILOVER = on)
(CONNECT_DATA =
(SERVICE_NAME = TPBD.WORLD)
)
)
have fun :)
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment