Listener Refused The Connection With The Following Error Ora-12505 Weblogic
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings and policies of this site About Us Learn more about Stack Overflow the ora 12505 sql developer error company Business Learn more about hiring developers or posting ads with us Stack Overflow
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 6.2 ora 12505 error in oracle 11g million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up How to specify URL correctly for connection pool in Weblogic up vote 3 down vote favorite How would I
Listener Refused The Connection With The Following Error Ora-12514
create a connection pool with the below information. I think I am getting wrong in URL. (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = myDB01.com)(PORT = 1821)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = myDB.com) ) ) I tried specifying the below in URL, but, didn't work jdbc:oracle:thin:@myDB01.com:1821:myDB.com This is the exception I see in the logs on server start up oracle.net.ns.NetException: Listener refused the connection with the following error: ORA-12505, TNS:listener does java.sql.sqlexception listener refused the connection with the following error ora-12505 not currently know of SID given in connect descriptor Note: I am able to connect to the DB from Oracle client successfully. jdbc weblogic datasource connection-pooling share|improve this question asked Apr 10 '13 at 20:53 hop 1,20572851 add a comment| 2 Answers 2 active oldest votes up vote 5 down vote accepted You need to use this format: jdbc:oracle:thin:[USER/PASSWORD]@//[HOST][:PORT]/SERVICE http://www.orafaq.com/wiki/JDBC share|improve this answer answered Apr 10 '13 at 20:58 anazimok 1,26911527 Thanks, it worked. But, I have to wait another 8 mins for accepting the answer as per the community validations :) –hop Apr 10 '13 at 21:01 add a comment| up vote 1 down vote Version 10.3 of Oracle weblogic has a bug in its console application. When it generates the URL for your database, it is generated with this format: jdbc:oracle:thin:@HOST:PORT:SERVICE But the console SHOULD generate with this format: jdbc:oracle:thin:@HOST:PORT/SERVICE Pay attention to the character between PORT and SERVICE. share|improve this answer answered May 23 '14 at 13:28 Claudio Bezerra 111 add a comment| Your Answer draft saved draft discarded Sign up or log in Sign up using Google Sign up using Facebook Sign up using Email and Password Post as a guest Name Email Post as a guest Name Email discard By posting your answer, you agree to the privacy
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript
Ora 12505 Error In Oracle 12c
and much of it will not work
Listener Refused The Connection With The Following Error Ora-12519
correctly without it enabled. Please turn JavaScript back on and reload this ora-12505 jdbc thin client page. Please enter a title. You can not post a blank message. Please type your message and try again. http://stackoverflow.com/questions/15936174/how-to-specify-url-correctly-for-connection-pool-in-weblogic More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 15 Replies Latest reply on Mar 11, 2014 12:00 PM by EdStevens ORA-12505, TNS:listener does not currently know of SID given https://community.oracle.com/thread/3527046 in connect descriptor 1012869 Mar 6, 2014 1:11 PM HI,Currently iam facing this issue on my local (weblogic) server. Am not able to run any application due to this. Its says ce has property needsSeparateUserInfo set true, and property database set non-null. The value for property database will not be passed to DriverManager.getConnection unless it is explicitly encoded as part of --- CONTAINER:atg.repository.RepositoryException; SOURCE:java.sql.SQLException: atg.service.resourcepool.ResourcePoolException: java.sql.SQLException: Listener refused the connection with the following erro ORA-12505, TNS:listener does not currently know of SID given in connect descriptor at atg.adapter.gsa.GSAItemDescriptor.executeQuery(GSAItemDescriptor.java:8347) at atg.adapter.gsa.GSAView.executeUncachedQuery(GSAView.java:362) at atg.repository.query.QueryCache.executeUncachedQuery(QueryCache.java:719) at atg.repository.query.QueryCache.populateEntry(QueryCache.java:1011) at atg.repository.query.QueryCache.executeCachedCountQuery(QueryCache.java:547) at atg.adapter.gsa.GSAView.executeCachedCountQuery(GSAView.java:800) at atg.adapter.gsa.GSAView.executeCountQuery(GSAView.java:688) at atg.adapter.gsa.GSAView.executeCountQuery(GSAView.java:666) at atg.multisite.SiteManager.getSiteCount(SiteManager.java:1049) at atg.multisite.session.MultisiteComponentSessionManager.hasSites(MultisiteComponentSessionManager.java:352) at atg.multisite.session.MultisiteComponentSessionManager.createSessionNameContext(MultisiteComponentSessionManager.java:206) at atg.servlet.NameContextManager.getSessionNameContext(NameContextManager.java:199) at atg.servlet.ServletUtil.getSessionNameContext(ServletUtil.java:825) at atg.servlet.pipeline.HeadPipelineServlet.serv
Certification Databases Caching Books Engineering Languages Frameworks Products This Site Careers Other all forums Forum: JDBC and Relational Databases Listener refused the connection with https://coderanch.com/t/585051/JDBC/databases/Listener-refused-connection-error-ORA the following error: ORA-12505 lalit khera Ranch Hand Posts: 39 posted 4 years ago hi i am getting the error as-"Status: Failure - Test Failed: Listener refused the connection http://www.redstonecontentsolutions.com/technical-blog/tnslistener-does-not-currently-know-of-sid-given-in-connect-descriptor-error-message-of-the-monthjanuary with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor" when instead of xe as sid, i write SIVA it works successfully. please reply. listener refused its urgent listener-error.PNG listener error lsnrctl.PNG attach Sumit Patil Ranch Hand Posts: 296 I like... posted 4 years ago lalit khera wrote: please reply. its urgent Please EaseUp Thanks & Regards, Sumeet SCJP 1.4, SCWCD 5, LinkedIn Profile Sumit Patil Ranch Hand Posts: 296 I like... posted 4 years ago Check your TNSNAMES.ora file, if it contains an listener refused the entry having service_name as "xe" Thanks & Regards, Sumeet SCJP 1.4, SCWCD 5, LinkedIn Profile lalit khera Ranch Hand Posts: 39 posted 4 years ago Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe" hi i am new bee in oracle. please tell me where to find that file and if find what next thing i need to do. lalit khera Ranch Hand Posts: 39 posted 4 years ago Sumit Patil wrote:Check your TNSNAMES.ora file, if it contains an entry having service_name as "xe" hey thanks sumit i found the file tnsnames.ora and the content of that file is as follows # tnsnames.ora Network Configuration File: G:\app\windows7\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. LISTENER_SIVU = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) LISTENER_ORCL = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) LISTENER_SIVA = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 15
Distributed Index Content Synergy Hub Digital Experience Gateway DocBox ArchMan RedstoneXperience Technical Blog Business Blog Support Contact TNS:listener does not currently know of SID given in connect descriptor – Error Message of the Month (January) 1/7/2011 2 Comments We decided to start something new here at Core Content Only. Each month we will review a UCM error and share how to solve it. Error messages are a part of a developer’s life. They can be very helpful when they make sense. Sadly, sometimes the error messages do not always make the most sense. We are going to showcase errors we have found when coding and how we solved them. We hope this will help you in your development work.Failed to initialize the server. Unable to initialize the system provider ‘SystemDatabase’. Unable to create database connection for the database ‘SystemDatabase’ with connection string ‘jdbc:oracle:thin:@localhost:1521:orcl’. Please make sure that the connection string, user and password are correct. Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptorThe Connection descriptor used by the client was:localhost:1521:orclUnable to create database connection for the database ‘SystemDatabase’ with connection string ‘jdbc:oracle:thin:@localhost:1521:orcl’. Please make sure that the connection string, user and password are correct. Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptorThe Connection descriptor used by the client was:localhost:1521:orcljava.sql.SQLException: Listener refused the connection with the following error:ORA-12505, TNS:listener does not currently know of SID given in connect descriptorThe Connection descriptor used by the client was:localhost:1521:orcl [ Details ]We do most of our development work in Windows virtual machines. This particular VM has been in use for quite some time. This error message stops UCM from starting. This error message has to do with the (Oracle) database not being available. You will needAdministrativerights to be able to complete this task.Step 1 – Check the DB listener status lsnrctl statusNotice that th