Home » Developer & Programmer » Forms » Connection not establising ( ORA-12203: TNS:unable to connect to destination) and Forms Installation
Connection not establising ( ORA-12203: TNS:unable to connect to destination) and Forms Installation [message #321232] Mon, 19 May 2008 08:38 Go to next message
aslamsadia
Messages: 19
Registered: December 2006
Junior Member
I have installed Forms 6i in my computer and trying to make a data block. But whenever I tried to connect to Database (Oracle 9i) the error ORA-12203: TNS:unable to connect to destination is displaying. I have developed application on VB.NET & Oracle 9i, but after installing Forms 6i the application developed on VB.NET also failed to connect to database (Oracle 9i). Pls help me. Sad
Re: Connection not establising ( ORA-12203: TNS:unable to connect to destination) [message #321327 is a reply to message #321232] Mon, 19 May 2008 21:24 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Searching this forum for 'tnsnames.ora' will show reference to 'tns_admin'. I suggest you search this forum for 'tns_admin' and follow these threads' directions.

David
Forms Installation [message #322147 is a reply to message #321232] Thu, 22 May 2008 10:55 Go to previous messageGo to next message
aslamsadia
Messages: 19
Registered: December 2006
Junior Member
Whenever I am installing Forms 6i in my computer, the connection from Oracle 9i database is not establishing from VB.NET Application. Whenever I am trying to run my VB.NET Application the following error is occuring :-
ORA-12203: TNS:unable to connect to destination.

Pls somebody help me. Sad
Re: Forms Installation [message #322151 is a reply to message #322147] Thu, 22 May 2008 11:19 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Oracle
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.

So, this VB.NET application works fine until Forms 6i is installed? If so, where did you install Developer Suite 6i? Did you choose a different Oracle Home for it (i.e. directory different from Oracle 9i database's directory)? If not, you should have.

If you decide to reinstall Oracle products, install database first. Save LISTENER.ORA, TNSNAMES.ORA and SQLNET.ORA files to safe place before installing Developer Suite 6i (just in case, if its installation overwrites previously created files).
Re: Forms Installation [message #322738 is a reply to message #322151] Mon, 26 May 2008 02:15 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
Please don't start a new thread for the same problem.

Get your database working and then use 'tns_admin' to point to THAT copy of 'tnsnames.ora'.

David
Previous Topic: how to display stored image?
Next Topic: how to connect lov to push button?
Goto Forum:
  


Current Time: Sun Dec 04 08:47:35 CST 2016

Total time taken to generate the page: 0.08146 seconds