Error Ora 12224
Contents |
because the
Error Ora 12224 Tns No Listener
listener is not running. This can be ora 12224 tns pas de listener confirmed using the command: lsnrctl status on the database server. Remedy:
Ora-12224 No Listener Error
Start the listener on the remote machine. (Use ‘lsnrctl start'). If the server name has recently been changed how to solve ora-12224 tns no listener then try running ‘Net 8 Configuration Assistant' and select ‘Listener Configuration'. Work through the dialogs without changing anything and it will automatically update the server name. The listener can then be started. (Oracle 8 - but ora-12224 tns no listener in toad may apply to earlier versions.) 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. This page represents one page of many pages of notes I made whilst working with Oracle 7 through to 10i. I now no longer work with Oracle databases, but hope that these notes will continue to be of benefit to others. About the author: Brian Cryer is a dedicated software developer and webmaster. For his day job he develops websites and desktop applications as well as providing IT services. He moonlights as a technical author and consultant.
- No listener [message #439636] Mon, 18 January 2010 14:03 jrdavisgo Messages: 1Registered: January 2010 Location: San Andres Island, Colomb... Junior Member Hi.
Ora 12541 No Listener
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 http://www.cryer.co.uk/brian/oracle/ORA12224.htm 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 ModeratorReport message to a moderator Re: Forms 6i compatibility with 10g database [message #439644 is a reply http://www.orafaq.com/forum/t/154110/ to message #439636] Mon, 18 January 2010 21:52 ramoradba Messages: 2454Registered: 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 [EDITED by DJM: change 'code' tags to 'quote' tags] [Updated on: Wed, 24 February 2010 00:20] by ModeratorReport message to a moderator Re: Forms 6i compatibility
Library mySQL Code Library PHP Code Library http://www.dbforums.com/showthread.php?1198764-ORA-12224-TNS-no-listener JavaScript Code Library Oracle Terms & Definitions Oracle Error Codes PSOUG Community Blogs Oracle Jobs Board PSOUG Forum Oracle User Group Directory Free Oracle Magazines Online Learning Center PSOUG Presentations Advanced no listener Code Search News and Events Sponsors Page Submit Code Contact Us Oracle Error: ORA-12224 Error Description: TNS:no listener Error Cause: The connection request could not be completed because the listener is not running. Action: 12224 tns no 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. There haven't been any comments added for this error yet. You may add one if you like. Add a comment Name: Email: URL: Chars left:1000 (1000 max) (No HTML, but newlines will be preserved) Home : Code Library : Sponsors : Privacy : Terms of Use : Contact Us 187 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?
to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results 1 to 9 of 9 Thread: ORA-12224: TNS:no listener Tweet Thread Tools Show Printable Version Subscribe to this Thread… Search Thread Advanced Search Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-12-05,20:59 #1 chewy_fruiti View Profile View Forum Posts Registered User Join Date Oct 2005 Posts 4 Unanswered: ORA-12224: TNS:no listener May I know what's that error? I had the listener.ora, tnsnames.ora and the sqlnet.ora in my C:\orant\net80\admin But i still get the No Listener error. Please help. Reply With Quote 10-12-05,21:41 #2 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 what does $ lsnrctl status display You can lead some folks to knowledge, but you can not make them think. The average person thinks he's above average! For most folks, they don't know, what they don't know. Good judgement comes from experience. Experience comes from bad judgement. Reply With Quote 10-12-05,21:45 #3 n_i View Profile View Forum Posts Visit Homepage :-) Join Date Jun 2003 Location Toronto, Canada Posts 5,516 Provided Answers: 1 Originally Posted by anacedent what does $ lsnrctl status display I think that would be C:\>lsnrctl status Reply With Quote 10-12-05,21:47 #4 chewy_fruiti View Profile View Forum Posts Registered User Join Date Oct 2005 Posts 4 C:\>lsnrctl status 'lsnrctl' is not recognized as an internal or external command, operable program or batch file Reply With Quote 10-12-05,21:50 #5 anacedent View Profile View Forum Posts Registered User Join Date Aug 2003 Location Where the Surf Meets the Turf @Del Mar, CA Posts 7,776 Provided Answers: 1 >'lsnrctl' is not recognized as an internal or external command, operable program or batch file Then $ORACLE_HOME/bin is not in your PATH. Is this a brand new Oracle installation? Did Oracle ever run successfully on this system? You can lead some folks to knowledge, but you can not make them think. The average person thinks he's above average! For most folks, they don't know, what they