OraFAQ Forum: Networking and Gateways » issue with tns connection

Home » RDBMS Server » Networking and Gateways » issue with tns connection (oracle 10g, windows server 2003)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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

Report message to a moderator

Re: issue with tns connection [message #556288 is a reply to message #556287]

Fri, 01 June 2012 08:21

Michel Cadot
Messages: 68633
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

Report message to a moderator

Re: issue with tns connection [message #556299 is a reply to message #556288]

Fri, 01 June 2012 09:23

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

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: issue with tns connection [message #556301 is a reply to message #556300]

Fri, 01 June 2012 09:40

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

Report message to a moderator

Re: issue with tns connection [message #556302 is a reply to message #556301]

Fri, 01 June 2012 09:42

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

Report message to a moderator

Re: issue with tns connection [message #556305 is a reply to message #556302]

Fri, 01 June 2012 09:48

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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?

Report message to a moderator

Re: issue with tns connection [message #556308 is a reply to message #556305]

Fri, 01 June 2012 09:57

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

vijenderkdba
Messages: 28
Registered: May 2012
Location: mumbai

Junior Member

Please help on the above issue asap.

Thanks,
Vij

Report message to a moderator

Re: issue with tns connection [message #556954 is a reply to message #556953]

Thu, 07 June 2012 09:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>with this tns file i am able to login successfully every time.

use what works

Report message to a moderator

Re: issue with tns connection [message #556960 is a reply to message #556954]

Thu, 07 June 2012 10:53

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

Report message to a moderator

Re: issue with tns connection [message #556980 is a reply to message #556960]

Thu, 07 June 2012 18:27

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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.

Report message to a moderator

Re: issue with tns connection [message #557025 is a reply to message #556980]

Fri, 08 June 2012 05:07

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

Report message to a moderator

Re: issue with tns connection [message #557058 is a reply to message #557025]

Fri, 08 June 2012 08:55

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

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".

Report message to a moderator

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

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Apr 16 00:21:04 CDT 2024