Java.sql.sqlexception Error =12505
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you ora 12505 error in sql developer might have Meta Discuss the workings and policies of this
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers ora 12505 error in oracle 11g or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community ora-12505 tns listener does not currently know of sid of 4.7 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 7 64 bit OS
Listener Refused The Connection With The Following Error Ora-12514
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.
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the java.sql.sqlexception: listener refused the connection with the following error: workings and policies of this site About Us Learn more about ora 12505 error in oracle 12c Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions
Ora-12505 Jdbc Thin Client
Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript Join them; it only takes a minute: Sign up ORA-12505, TNS:listener does not currently know of SID given in connect des up vote 1 down vote favorite 1 Please kindly help me as I just installed Oracle 11g but cannot connnect using SQL Devloper using the settings below: Username: system Password: mypassword Hostname: localhost Port: 1521 SID: XE Error http://stackoverflow.com/questions/23209962/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-des message: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor I checked on Windows Services: OracleServiceXE: Started OracleXETNSListener: Started I also unable to connect to admin page: **http://localhost:8080/apex/f?p=4950** It says "This page can't be displayed" I also tested to connect using SqlPlus: Test 1: Result is ORA-12170: TNS:Connect timeout occurred C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe system/mypassword@XE SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 22 11:22:31 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12170: TNS:Connect timeout occurred Enter user-name: Test 2: Result is Successful C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe system/mypassword SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 22 11:33:22 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> Test 3: Result is Successful C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 22 11:34:29 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> Listener.log 22-APR-2014 11:53:51 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=SQL
connect to the appropriate Oracle database, we'll need to expound a bit on how Oracle behaves and, therefore, what is causing this issue in the first place. SIDs https://chartio.com/resources/tutorials/how-to-fix-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descriptor vs SERVICE_NAMES It is important to understand the (slight) difference between what Oracle defines as a SID compared to a SERVICE_NAME, as we'll use this information to create a proper connection http://community.jaspersoft.com/questions/820090/ora-12505-tnslistener-does-not-currently-know-sid-given-connect-descriptor string later on. In Oracle, the system identifier (or SID) is a local identifier of up to eight characters in length that is used to identify a particular database and differentiate ora 12505 it from other databases on the system. Often the SID is the prefix word or DB_UNIQUE_NAME that precedes the DB_DOMAIN. For example, the SID of our bookstore database, as seen in in the full global database name of bookstore.company.com. SERVICE_NAMES, on the other hand, represent the names by which database instances can be connected to. A SERVICE_NAME will typically follow the format ora 12505 error of the SID followed by the database domain, like so: DB_UNIQUE_NAME.DB_DOMAIN The TNS Listener When a client is attempting to connect to an Oracle database, rather than connecting to the database directly, there is a broker service that intervenes and handles the connection request for the client. This broker application is known as the listener and it performs the task of listening for incoming client requests. When a request is received, the listener processes and forwards that request onto the appropriate Oracle database server using a service handler, which just acts as the connection between the listener and the database server. TNS Names and Configuration When connecting to an Oracle database, typically your database server will have tnsnames.ora, which is a configuration file that informs the server about NET_SERVICE_NAMES which are valid database connections. By default, this file is located at ORACLE_HOME/network/admin. For example, a NET_SERVICE_NAME descriptor in tnsnames.ora may be formatted like this: myDatabaseNetService = (DESCRIPTION = (ADDRESS = (PROTOCOL = tcp)(HOST = localhost)(PORT = 1521)(QUEUESIZE = 100)) (CONNECT_DATA = (SERVICE_NAME = bookstore.company.com) ) ) This would define a NET_SERVICE_NAME using the SERVICE_NAME we
Community Contact Login/Register Download Now ProductsAnswersExchangeDocsWikiPlanetTracker You are hereHome » Answers » ORA-12505, TNS:listener does not currently know of SID given in connect descriptor ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Posted on October 27, 2013 at 8:35am 0 From Ireporter If i try to add the data source, I am getting the following error: Exception Message: 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 Level: SEVERE Stack Trace: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:419) oracle.jdbc.driver.PhysicalConnection.