Ora 12224 No Listener Error
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: Is
How To Solve Ora-12224 Tns No Listener
a year a leap year? Latest Followup You Asked sir i change ora-12224 tns no listener in toad host name with ip address in user computer i got server ip address by oracle command select SYS_CONTEXT('USERENV', ora 12541 no listener 'IP_ADDRESS', 15) ipaddr from dual; result 127.0.0.1 i 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 = (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,
question and get tips & solutions from a community of 418,614 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 https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9530903900346265531 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 and Tnsname Listener.ora: LISTENER= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=uplinkdb) ) (ADDRESS= (PROTOCOL = TCP) (HOST = 10.2.0.49) (PORT = 1200) https://bytes.com/topic/oracle/answers/689069-ora-12224-tns-no-listener ) ) 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 = 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
to check out the FAQ by clicking the link above. You may have to register before you can post: http://www.dbforums.com/showthread.php?1198764-ORA-12224-TNS-no-listener click the register link above to proceed. To start viewing messages, http://abduulwasiq.blogspot.com/2013/05/ora-12224-tnsno-listener.html 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 no listener 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 ora-12224 tns no #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 Vie
Links Friday, 3 May 2013 ORA-12224: TNS:no listener when database listener was down and you are trying to connect from other host.you will recieve this error.sqlplus apps/appsSQL*Plus: Release 8.0.6.0.0 - Production on Thu Apr 18 18:18:08 2013(c) Copyright 1999 Oracle Corporation. All rights reserved.ERROR:ORA-12224: TNS:no listener. Cause: Database listener was down. solution: Just bring up database listener and try to connect to database. If you want to learn basic,please click on the below link. What happen when you startup database?Click here to check in detail. Posted by Abdul Wasiq at 15:47 Email ThisBlogThis!Share to TwitterShare to FacebookShare to Pinterest No comments: Post a Comment Newer Post Older Post Home Subscribe to: Post Comments (Atom) Total Pageviews Followers Page Statistics Follow by Email Blog Archive ► 2016 (13) ► May (5) ► March (3) ► January (5) ► 2015 (43) ► August (4) ► May (2) ► April (24) ► March (9) ► February (1) ► January (3) ► 2014 (110) ► July (6) ► June (5) ► April (32) ► March (12) ► February (8) ► January (47) ▼ 2013 (172) ► November (3) ► October (14) ► September (30) ► August (16) ► July (18) ► June (28) ▼ May (16) Program was terminated by signal 25 java.lang.NoClassDefFoundError: Could not initiali... REP-3000: Internal Error Starting Oracle Toolkit. Troubleshoot Oracle HTTP Server in Oracle ebs R12?... ORA-04031: unable to allocate 42680 bytes of share... opmn in oracle apps R12 How to enable archive log in RAC? What are the components of Oracle Applications tec... How to you know the product versions,patchset leve... Servlet to socket mode conversion R12 Applications shows a blank page. AC-50480: Internal error occurred: java.lang.Excep... ORA-12224: TNS:no listener APP-FND-01630 cannot open .dbc file for reading. Node id does not exist for the current application... Concurrent Manager cannot find error description f... ► April (23) ► March (11) ► February (13) Powered by Blogger.