Oracle Error Ora 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 how to solve ora-12224 tns no listener AskTom team: On Consistent Results, Different Constraints, and Unlearning Latest Followup ora-12224 no listener error You Asked sir i change host name with ip address in user computer i got server ip address ora-12224 tns no listener in toad by oracle command select SYS_CONTEXT('USERENV', 'IP_ADDRESS', 15) ipaddr from dual; result 127.0.0.1 i change this ip address with host orcl = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL
Ora 12541 No Listener
= 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, inc
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 and Tnsname Listener.ora: LISTENER= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=uplinkdb) ) (ADDRESS= (PROTOCOL = TCP) (HOST = 10.2.0.49) (PORT = 1200) https://asktom.oracle.com/pls/apex/f?p=100:11:::NO:RP:P11_QUESTION_ID:9530903900346265531 ) ) 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) https://bytes.com/topic/oracle/answers/689069-ora-12224-tns-no-listener ) ) 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. please tell how to check for the services of oracle database and the oracle listener in oracle 8.0.5 in solarix operating system Aug 8 '07 #3 reply Expert 5K+ P: 8,127 debasisdas you can find some details here and here. Aug 9 '07 #4 reply Expert 5K+ P: 8,127 debasisdas Run the command lsnrctl stat
Library mySQL Code Library PHP Code Library 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: ora-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 74 users online © 2009 psoug.org PSOUG LOGIN Username: Password: Forgot your password?