Oracle Error 12224
Contents |
02, 2016 - 10:05 am UTC Category: Developer � Version: orcle 12c with form 6i Whilst you are here, check out some content from the AskTom team: MERGE vs UPDATE/INSERT revisited Latest
How To Solve Ora-12224 Tns No Listener
Followup You Asked sir i change host name with ip address in user ora-12224 no listener error computer i got server ip address by oracle command select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual; result 127.0.0.1 i ora-12224 tns no listener in toad change this ip address with host orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = pdborcl) )) PDBORCL = (DESCRIPTION = (ADDRESS
Ora 12541 No Listener
= (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) ) Rep60_MFAMDA-PC,Rep60_MFAMDA-PC.world=(ADDRESS=(PROTOCOL=tcp)(HOST=MFAMDA-PC)(PORT=1949)) then error change now user computer give me error ora-12224 tns no listener ora-12224 tns no listener sir see new error in server both 12c and form 6i run fine but problme in user computer when i run compiled form in user computer that give me error ora-12224 tns no listener regard and we said... The IP_ADDRESS USERENV context returns the IP of your machine! You need to find the IP or name of the server the database is on. You can find the IP using utl_inaddr: select utl_inaddr.get_host_address from dual; Or the host name in various ways: select host_name from v$instance; select utl_inaddr.get_host_name from dual; select SYS_CONTEXT('USERENV', 'SERVER_HOST') host from dual; https://oracle-base.com/articles/misc/identifying-host-names-and-addresses But if you've updated your TNSNAMES you can't connect! Hopefully you saved a copy before changing it you can revert to. If not, you'll have to speak to someone else in your organization to find the correct values. Write a Review Set Screen Reader Mode On Integrated Cloud Applications and Platform Services About Oracle Contact Us Legal Notices Terms of Use Your Privacy Rights All information and materials provided here are provided "as-is"; Oracle disclaims all express and implied warranties, including, the implied warranties of merchantability or fitness for a particular use. Oracle shall not be liable for any damages, including, direct, indirect, incidental, special or consequential damages for loss of profits, revenue, data or data use, incurred by you or any third party in con
question and get tips & solutions from a community of 418,615 IT Pros & Developers. It's quick & easy. ORA-12224: TNS:no listener P: 2 Nitvar When i am trying to connect to oracle it is giving me these two errors ORA-12224: TNS:no listener ORA-01034: ORACLE not available I am new to oracle ,plz help I am using solaris 5.6 and oracle 8.0.5 version I am posting my listener.ora https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9530903900346265531 and Tnsname Listener.ora: LISTENER= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=uplinkdb) ) (ADDRESS= (PROTOCOL = TCP) (HOST = 10.2.0.49) (PORT = 1200) ) ) LISTENER1= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=AIRTEL) ) (ADDRESS= (PROTOCOL = TCP) (HOST = 10.2.0.49) (PORT = 1201) ) ) LISTENER2= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=onspire) ) (ADDRESS= (PROTOCOL = TCP) (HOST = 10.2.0.49) (PORT = https://bytes.com/topic/oracle/answers/689069-ora-12224-tns-no-listener 1551) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 SID_LIST_LISTENER= (SID_LIST= (SID_DESC= (SID_NAME=uplinkdb) (ORACLE_HOME=/usr/up/oracle) ) ) SID_LIST_LISTENER1= (SID_LIST= (SID_DESC= (SID_NAME=AIRTEL) (ORACLE_HOME=/usr/up/oracle) ) ) SID_LIST_LISTENER2= (SID_LIST= (SID_DESC= (SID_NAME=onspire) (ORACLE_HOME=/usr/up/oracle) ) ) TRACE_LEVEL_LISTENER = OFF Tnsname.ora : uplinkdb= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.2.0.49) (PORT=1200)) (CONNECT_DATA=(SID=uplinkdb))) AIRTEL= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.2.0.49) (PORT=1201)) (CONNECT_DATA=(SID=AIRTEL))) onspire= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.2.0.49) (PORT=1551)) (CONNECT_DATA=(SID=onspire))) airteldb= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.2.0.49) (PORT=1201)) (CONNECT_DATA=(SID=airteldb))) orcl= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=10.2.0.49) (PORT=1521)) (CONNECT_DATA=(SID=orcl))) AJAY = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 100.1.200.10)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = DP51.WORLD)) ) Aug 7 '07 #1 Post Reply Share this Question 5 Replies Expert 5K+ P: 8,127 debasisdas check for the services of oracle database and the oracle listener. ensure that both the services are in auto mode and runing. Aug 7 '07 #2 reply P: 2 Nitvar check for the services of oracle database and the oracle listener. ensure that both the services are in auto mode and runing.
- No listener [message #439636] Mon, 18 January 2010 14:03 jrdavisgo Messages: 1Registered: January 2010 Location: San Andres Island, Colomb... Junior Member http://www.orafaq.com/forum/t/154110/ Hi. I have on a Laptop, Oracle database 10g, and some http://www.dbforums.com/showthread.php?1198764-ORA-12224-TNS-no-listener 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 no listener 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 ModeratorReport message to a moderator Re: Forms 6i compatibility with 10g database [message ora-12224 tns no #439644 is a reply 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
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 L