Home » Developer & Programmer » Forms » ORA-12224: TNS - No listener (Forms 6i, Database 10g)
ORA-12224: TNS - No listener [message #439636] Mon, 18 January 2010 14:03 Go to next message
Messages: 1
Registered: January 2010
Location: San Andres Island, Colomb...
Junior Member
I have on a Laptop, Oracle database 10g, and some applications on Forms 6i, but having problem to run Forms. Error: "ORA-12224: TNS - No listener."

Could you help me with a guideline of how setting up Forms6i to work with 10g database? Do I need some Patch? What special configuration to make? What about the many TNSNAMES.ORA and SQLNET.ORA files in the Forms 6i Folder, versus those on the 10g Database Folder?

Thank you.

[EDITED by LF: specified product versions after the topic has been split]

[Updated on: Tue, 19 January 2010 00:45] by Moderator

Report message to a moderator

Re: Forms 6i compatibility with 10g database [message #439644 is a reply to message #439636] Mon, 18 January 2010 21:52 Go to previous messageGo to next message
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
ORA-12224: TNS:no listener

Cause: The connection request could not be completed because the listener is not running.

Action: Ensure that the supplied destination address matches one of the addresses used by the listener - compare the TNSNAMES.ORA entry with the appropriate LISTENER.ORA file (or TNSNAV.ORA if the connection is to go by way of an Interchange). Start the listener on the remote machine.

Its a FAQ please search before posting.
And if you copy your database TNSNAMES.ORA file and replace the existing (C:\ORANT\NET80\ADMIN) TNSNAMES.ORA file with that ..then you can connect to the forms6i if your database is up and running without having any problem......

And next time please create your own topic don`t post in others topic.read the forum guide lines.

sriram Smile
[EDITED by DJM: change 'code' tags to 'quote' tags]

[Updated on: Wed, 24 February 2010 00:20] by Moderator

Report message to a moderator

Re: Forms 6i compatibility with 10g database [message #444760 is a reply to message #439644] Wed, 24 February 2010 00:21 Go to previous message
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use the 'tns_admin' environment variable.

Previous Topic: Developer 2000 Forms/Reports
Next Topic: Create stacked canvas on Tab page
Goto Forum:

Current Time: Fri Jul 21 21:47:19 CDT 2017

Total time taken to generate the page: 0.04955 seconds