Home » Developer & Programmer » Forms » TNS : Unable to connect to the destination
TNS : Unable to connect to the destination [message #271546] Tue, 02 October 2007 00:36 Go to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Hi guys,

I m using Oracle Forms 6i and Oracle 10g Express Edition. I am having the following error message when I am trying to connect to the database from client.

I have dont following configuration in my client's FORM's TNSNAMES.ORA file.

----------------------------------------------------------------


0001 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bankvigil)(PORT = 1521))
(CONNECT_DATA = (SID = XE))
)

----------------------------------------------------------------


In the above configuration

0001 = my connect string.
BankVigil = My Oracle database server hostname.

Plz advice what seems to be the problem. I need the solution urgently.

Regards,
Azam Khan
Re: TNS : Unable to connect to the destination [message #271608 is a reply to message #271546] Tue, 02 October 2007 03:19 Go to previous messageGo to next message
BILALg
Messages: 7
Registered: September 2007
Location: PAKISTAN
Junior Member

AOA

ur configuration will be as follows:-



0001 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = bankvigil)(PORT = 1521))
(CONNECT_DATA = (SID = 0001))
)


0001 = my connect string (Connect_String = SID)
BankVigil = My Oracle database server hostname

Hope It will be helpful to you.

Bilal
Re: TNS : Unable to connect to the destination [message #271615 is a reply to message #271608] Tue, 02 October 2007 03:40 Go to previous messageGo to next message
Littlefoot
Messages: 20888
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Ummm ... I wouldn't be that sure. SID doesn't have to be the same as the TNSNAMES.ORA database alias.

Azamkhan, what happens if you PING 'bankvigil'? Is it reachable? Do you know its IP address? What happens if you substitute 'bankvigil' with the IP address? For example:
C:\WINDOWS\system32>ping localhost

Pinging ... [127.0.0.1] with 32 bytes of data:

Reply from 127.0.0.1: bytes=32 time<1ms TTL=128

0001 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    (CONNECT_DATA = (SID = 0001)) 
  )


If it works, add 'bankvigil' alias and its IP address into the HOSTS file (if on MS Windows); then you'd be able to use 'bankvigil' in TNSNAMES.ORA again.

Unless I'm wrong about the issue, of course.
Re: TNS : Unable to connect to the destination [message #271621 is a reply to message #271615] Tue, 02 October 2007 04:24 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Have dont that
Re: TNS : Unable to connect to the destination [message #271622 is a reply to message #271608] Tue, 02 October 2007 04:26 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Mr. Bilal you have reply me with my own words.... read my post carefully then reply me... ok
Re: TNS : Unable to connect to the destination [message #271637 is a reply to message #271622] Tue, 02 October 2007 04:58 Go to previous messageGo to next message
BILALg
Messages: 7
Registered: September 2007
Location: PAKISTAN
Junior Member



Dear Azam
I have changed ur SID name which is 0001 but not same as ur words.

pls tell me what is "XE". And U also didnt mention error message which is appeared on connecting time.

Pls tell me in detail.

Bilal
Re: TNS : Unable to connect to the destination [message #271672 is a reply to message #271637] Tue, 02 October 2007 08:10 Go to previous messageGo to next message
azamkhan
Messages: 548
Registered: August 2005
Senior Member
Actualy Mr. Bilal you haven't read my post with open eyes. First tell me have you used Oracle 10g Express Edition? If yes then you can help me out.
Re: TNS : Unable to connect to the destination [message #272415 is a reply to message #271672] Fri, 05 October 2007 00:32 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
I don't know whether you can have a numeric SID. Change your '0001' to 'tst0001' and see whether that works.

David
Re: TNS : Unable to connect to the destination [message #459661 is a reply to message #272415] Mon, 07 June 2010 16:22 Go to previous messageGo to next message
alimahboob
Messages: 14
Registered: November 2005
Location: jeddah
Junior Member

its not working even by putting text in place of 0001. same error coming. as if 10g express edition doesnt support forms 6i
Re: TNS : Unable to connect to the destination [message #463915 is a reply to message #459661] Mon, 05 July 2010 03:16 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
This is my entry in 'tnsnames.ora'.
AXE_127.0.0.1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
    )
    (CONNECT_DATA = (SID = XE)(SERVER = DEDICATED))
  )
Try using a different name in your 'SID'.

David
Previous Topic: oracle 10g express edition can support forms 6i
Next Topic: problem in calling the report in form
Goto Forum:
  


Current Time: Fri Dec 02 14:26:52 CST 2016

Total time taken to generate the page: 0.44353 seconds