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
jrdavisgo
Messages: 1
Registered: January 2010
Location: San Andres Island, Colomb...
Junior Member
Hi.
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
ramoradba
Messages: 2456
Registered: January 2009
Location: AndhraPradesh,Hyderabad,I...
Senior Member
Quote:
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.

regards
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
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator
Use the 'tns_admin' environment variable.

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


Current Time: Fri Apr 26 00:03:50 CDT 2024