OraFAQ Forum: Forms » TNS : Unable to connect to the destination

Home » Developer & Programmer » Forms » TNS : Unable to connect to the destination

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

TNS : Unable to connect to the destination [message #271546]

Tue, 02 October 2007 00:36

azamkhan
Messages: 557
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

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #271608 is a reply to message #271546]

Tue, 02 October 2007 03:19

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

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #271615 is a reply to message #271608]

Tue, 02 October 2007 03:40

Littlefoot
Messages: 21818
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.

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #271621 is a reply to message #271615]

Tue, 02 October 2007 04:24

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Have dont that

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #271622 is a reply to message #271608]

Tue, 02 October 2007 04:26

azamkhan
Messages: 557
Registered: August 2005

Senior Member

Mr. Bilal you have reply me with my own words.... read my post carefully then reply me... ok

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #271637 is a reply to message #271622]

Tue, 02 October 2007 04:58

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

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #271672 is a reply to message #271637]

Tue, 02 October 2007 08:10

azamkhan
Messages: 557
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.

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #272415 is a reply to message #271672]

Fri, 05 October 2007 00:32

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #459661 is a reply to message #272415]

Mon, 07 June 2010 16:22

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

Report message to a moderator

Re: TNS : Unable to connect to the destination [message #463915 is a reply to message #459661]

Mon, 05 July 2010 03:16

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 19 18:00:21 CDT 2024