OraFAQ Forum: Forms » Unable to connect destination

Home » Developer & Programmer » Forms » Unable to connect destination (oracle 8.0.5 and form 6i)

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

Unable to connect destination [message #484275]

Mon, 29 November 2010 05:34

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

Dear
i am using client-server enviroment without using a domain.On One computer i have installed Oracle 8.0.5 and developer 2000. and on client side i have installed form 6i. i have made a service (star) in Tnsnames.ora in client side.
star.world =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS =
(PROtoCOL = TCP)
(Host = server)
(Port = 1521)
)
)
(connect_DATA = (SID = ORCL)
)
)
--------------------------------------------
it gives me error:
ORA-12203:TNS :unable to connect to destination

Report message to a moderator

Re: Unable to connect destination [message #484277 is a reply to message #484275]

Mon, 29 November 2010 05:41

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

ORA-12203: TNS:unable to connect to destination
 *Cause: Invalid address specified or destination is not listening.
 This error can also occur because of underlying network or network
 transport problems.
 *Action: Verify that the net service name you entered was correct.
 Verify that the ADDRESS portion of the connect descriptor which
 corresponds to the net service name is correct.  Ensure that the
 destination process (for example the listener) is running at the
 remote node.

Regards
Michel

Report message to a moderator

Re: Unable to connect destination [message #484281 is a reply to message #484277]

Mon, 29 November 2010 06:04

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

i have checked all the host name and server ip address,firewall and Oracle SID etc.
pls advised me.

Report message to a moderator

Re: Unable to connect destination [message #484295 is a reply to message #484281]

Mon, 29 November 2010 07:40

ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia

Senior Member

Dear,

Search All Tnsnames.ora Files from your system and see you've made correct Service name.

Regards,

Irfan

Report message to a moderator

Re: Unable to connect destination [message #484298 is a reply to message #484281]

Mon, 29 November 2010 07:51

Michel Cadot
Messages: 68732
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

shahzad-ul-hasan wrote on Mon, 29 November 2010 13:04

i have checked all the host name and server ip address,firewall and Oracle SID etc.
pls advised me.

Prove it.
Also prove you can reach the server.
Prove you use what you check.
Remember Oracle is right and you make a mistake.

Regards
Michel

Report message to a moderator

Re: Unable to connect destination [message #484300 is a reply to message #484298]

Mon, 29 November 2010 07:59

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

My mean is that my netwrking is worked. i have shared folder which is accessible to client and the server.but only when i connect oracle it gives me error.

Report message to a moderator

Re: Unable to connect destination [message #484301 is a reply to message #484300]

Mon, 29 November 2010 08:07

cookiemonster
Messages: 13963
Registered: September 2008
Location: Rainy Manchester

Senior Member

shahzad-ul-hasan wrote on Mon, 29 November 2010 13:59

My mean is that my netwrking is worked.

You tested this how?
shahzad-ul-hasan wrote on Mon, 29 November 2010 13:59

i have shared folder which is accessible to client and the server.

Of what relevance is this to your ability to connect to oracle?

Report message to a moderator

Previous Topic:	compile time error
Next Topic:	canvas and editor window sizes in froms designer

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 16:49:24 CST 2025