Oracle.net.ns.netexception Listener Refused The Connection With The Following Error
Contents |
here for a quick overview of the site Help Center Detailed answers to any listener refused the connection with the following error ora-12514 questions you might have Meta Discuss the workings and policies of java.sql.sqlexception: listener refused the connection with the following error: ora-12505 this site About Us Learn more about Stack Overflow the company Business Learn more about
Listener Refused The Connection With The Following Error Ora-12519
hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
is a community of 6.2 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ORA-12505, TNS:listener does not currently know of SID given in connect descriptor up vote 81 down vote favorite 22 I have installed Oracle 11g Express Edition Release 2 in my windows ora 12505 error in oracle 11g 7 64 bit OS and tried to execute JDBC program, then I got the following error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.
This Site Careers Other all forums Forum: JDBC and Relational Databases getting Listener refused the connection with the following error: ORA-12514 Omkar chary
Ora 12505 Error In Sql Developer
Greenhorn Posts: 11 I like... posted 4 years ago I just listener refused the connection with the following error ora-12516 installed the oracle 11 g -win x 64 bit software in win 7 home premium operating system. ora 12505 error in oracle 12c 1)with the following details global database name: "orcl" admin password: "Oracle11g" oracle system identifier(SID): "orcl" user: "system" after installation complete then it displayed The db control URL is http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript : "https://localhost:1158/em". 2)This is my tnsnames.ora.. # tnsnames.ora Network Configuration File: C:\app\amma\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) https://coderanch.com/t/595091/JDBC/databases/Listener-refused-connection-error-ORA (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) 3)and i checked this.. C:\>lsnrctl services LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 13-OCT-2012 13:06 :55 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:80 refused:0 state:ready LOCAL SERVER Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:0 refused:0 current:0 max:1022 state:ready DISPATCHER
for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Ask a Question Ask for Help Receive Real-Time Help Create a Freelance Project Hire for a Full Time Job Ways to Get Help Expand Search Submit https://www.experts-exchange.com/questions/27685856/What-do-I-get-this-error-even-if-my-tns-entry-is-there-Listener-refused-the-connection-with-the-following-error.html Close Search Login Join Today Products BackProducts Gigs Live Careers Vendor Services Groups Website Testing Store Headlines Experts Exchange > Questions > What do I get this error even if my tns entry is there Listener refused the connection with the following error: Want to Advertise Here? Solved What do I get this error even if my tns entry is there Listener refused the connection with the following error: Posted on 2012-04-20 Java Oracle listener refused Database 1 Verified Solution 9 Comments 1,776 Views Last Modified: 2012-04-27 Hi Guys, I installed Oracle11g on my local machine. I successfully installed it and I was able to import customer database into it. I am able to login into my database both with sqlplus and sql dev by using following details user name ajoo_123 password qa123 host localhost sid orcl When I start my server, in the property file I have mentioned same user listener refused the details. However I get this error when It is trying to connect to database. Caused by: oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor at oracle.net.ns.NSProtocol.connect(NSProtocol.java:361) at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:966) at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:292) ... 80 more 16:05:57,613 INFO [TomcatDeployment] deploy, ctxPath=/ecm_help I added an entry into tnsnames.ora aswell still getting same error Can someone please help me on this THanks Ajoo 0 Question by:Ajoo71 Facebook Twitter LinkedIn Google LVL 86 Active today Best Solution byCEHJ In case it wasn't clear, my last comment is in relation to host localhost Go to Solution 9 Comments LVL 15 Overall: Level 15 Oracle Database 2 Java 1 Message Expert Comment by:dave4dl2012-04-20 Try the following things from http://ora-12514.ora-code.com/ : - Wait a moment and try to connect a second time. - Check which services are currently known by the listener by executing: lsnrctl services