Home » RDBMS Server » Networking and Gateways » issue with tns connection (oracle 10g, windows server 2003)
issue with tns connection [message #556287] Fri, 01 June 2012 08:13 Go to next message
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 #556288 is a reply to message #556287] Fri, 01 June 2012 08:21 Go to previous messageGo to next message
Michel Cadot
Messages: 58489
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-12545: Connect failed because target host or object does not exist
 *Cause: The address specified is not valid, or the program being
 connected to does not exist.
 *Action: Ensure the ADDRESS parameters have been entered correctly; the
 most likely incorrect parameter is the node name.  Ensure that the
 executable for the server exists (perhaps "oracle" is missing.)
 If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
 host name to a numeric IP address and try again.
}
Regards
Michel
Re: issue with tns connection [message #556299 is a reply to message #556288] Fri, 01 June 2012 09:23 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
but I have mention the same host name in the new tns entry, it's working fine why?

[Updated on: Fri, 01 June 2012 09:23]

Report message to a moderator

Re: issue with tns connection [message #556300 is a reply to message #556299] Fri, 01 June 2012 09:36 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
Senior Member
>but I have mention the same host name in the new tns entry, it's working fine why?
It could be Oracle bug.
Re: issue with tns connection [message #556301 is a reply to message #556300] Fri, 01 June 2012 09:40 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
In one of the portal they suggested that configure the local listener.
how to configure the local listener? can any one tell me the steps
Re: issue with tns connection [message #556302 is a reply to message #556301] Fri, 01 June 2012 09:42 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
(failover_mode =
(type = select)
(method = basic)
(retries = 180)
(delay = 5)

please descibe the above parameters.

Thanks,
Vij
Re: issue with tns connection [message #556305 is a reply to message #556302] Fri, 01 June 2012 09:48 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
Senior Member
>please descibe the above parameters.
Unwilling or incapable to Read The Fine Manual yourself?
Why should I write here what is already documented at http://tahiti.oracle.com?
Re: issue with tns connection [message #556308 is a reply to message #556305] Fri, 01 June 2012 09:57 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
Hi Michel,

I tried with numeric ip's but still getting the same problem.
help me on this.

Thanks,
Vij

[Updated on: Fri, 01 June 2012 09:58]

Report message to a moderator

Re: issue with tns connection [message #556953 is a reply to message #556287] Thu, 07 June 2012 09:08 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
Please help on the above issue asap.

Thanks,
Vij
Re: issue with tns connection [message #556954 is a reply to message #556953] Thu, 07 June 2012 09:10 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
Senior Member
>with this tns file i am able to login successfully every time.

use what works
Re: issue with tns connection [message #556960 is a reply to message #556954] Thu, 07 June 2012 10:53 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
One of my collegue ran the report in cognose he is getting this error ora-12545.
and the cognos job will pull the data from oracle database,but he is not able to pull the data.

Plese help me out on this.sholud i need set any parameters in sqlnet.ora file?

Thanks,
Vij
Re: issue with tns connection [message #556980 is a reply to message #556960] Thu, 07 June 2012 18:27 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
Senior Member
bcm@bcm-laptop:~$ oerr ora 12545
12545, 00000, "Connect failed because target host or object does not exist"
// *Cause: The address specified is not valid, or the program being 
// connected to does not exist.
// *Action: Ensure the ADDRESS parameters have been entered correctly; the
// most likely incorrect parameter is the node name.  Ensure that the 
// executable for the server exists (perhaps "oracle" is missing.)
// If the protocol is TCP/IP, edit the TNSNAMES.ORA file to change the
// host name to a numeric IP address and try again.
Re: issue with tns connection [message #557025 is a reply to message #556980] Fri, 08 June 2012 05:07 Go to previous messageGo to next message
vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai
Junior Member
even i have try with numeric ips..but still i am getting the same error.

Thanks,
Vij
Re: issue with tns connection [message #557058 is a reply to message #557025] Fri, 08 June 2012 08:55 Go to previous messageGo to next message
BlackSwan
Messages: 22481
Registered: January 2009
Senior Member
we don't know what you are doing so we can't speculate what exactly might be wrong.
error of commission?
error of omission?
We could only guess at which of the above should be answered "YES".
Re: issue with tns connection [message #557074 is a reply to message #557058] Fri, 08 June 2012 11:15 Go to previous message
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

Previous Topic: What Is ISP concept in oracle????
Next Topic: Listener failed to start.
Goto Forum:
  


Current Time: Wed Jul 23 00:46:09 CDT 2014

Total time taken to generate the page: 0.08009 seconds