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

Report message to a moderator

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

Report message to a moderator

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

Report message to a moderator

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: 21823
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).

Report message to a moderator

Re: Forms Installation [message #322738 is a reply to message #322151] Mon, 26 May 2008 02:15 Go to previous message
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Feb 09 23:41:50 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.