issue with tns connection [message #556287] |
Fri, 01 June 2012 08:13 |
|
vijenderkdba
Messages: 28 Registered: May 2012 Location: mumbai
|
Junior Member |
|
|
Hi All,
This is my tns file,while connecting to the server database i am getting this error number
ORA-12545. but keep on trying again and again i am able to connect.
Plese help me on this issue.
Old:
dmsrp01r.world =
(description =
(address = (protocol = tcp)(host = xyz1.org)(port = 1521))
(address = (protocol = tcp)(host = xyz2.org)(port = 1521))
(load_balance = yes)
(connect_data =
(server = dedicated)
(service_name = dmsrp01r)
(failover_mode =
(type = select)
(method = basic)
(retries = 180)
(delay = 5)
)
)
)
-----------------------------------------------------------
with this tns file i am able to login successfully every time.
NEW:
dmsrp01r.world =
(description =
(address = (protocol = tcp)(host = xyz1.org)(port = 1521))
(address = (protocol = tcp)(host = xyz2.org)(port = 1521))
(load_balance = yes)
(connect_data =
(service_name = dmsrp01r)
)
)
if I am using this tns entry is it any problem?
Thanks
Vij
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
|
Re: issue with tns connection [message #557074 is a reply to message #557058] |
Fri, 08 June 2012 11:15 |
|
vijenderkdba
Messages: 28 Registered: May 2012 Location: mumbai
|
Junior Member |
|
|
If need any further information, I will ready to provide that information.
to my knowledge the way i have to connected to database is correct.
Please help me out on this issue.
and one more thing even i am able to ping those servers with same host name
which mentioned in the tns entry.
Thanks,
Vij
[Updated on: Fri, 08 June 2012 11:17] Report message to a moderator
|
|
|