Friday, June 8, 2007

trouble with tns :)

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 :)

No comments: