Ora Error 12505
Contents |
here for a quick overview of the site ora 12505 error in sql developer Help Center Detailed answers to any questions you might
Ora-12505 Oracle 11g
have Meta Discuss the workings and policies of this site About Us Learn more
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags
Listener Refused The Connection With The Following Error Ora-12514
Users Badges Ask Question x Dismiss Join the Stack Overflow Community Stack Overflow 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 ora 12505 error in oracle 12c descriptor up vote 81 down vote favorite 22 I have installed Oracle 11g Express Edition Release 2 in my windows 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.
CommunityOracle User Group CommunityTopliners CommunityOTN Speaker BureauJava CommunityError: You don't have JavaScript enabled. This tool uses JavaScript and much of it will not work correctly without it enabled. Please turn JavaScript back on and reload this page. Please enter a title. You ora-12505 jdbc thin client can not post a blank message. Please type your message and try listener refused the connection with the following error ora-12519 again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 11 Replies Latest reply on listener refused the connection with the following error ora-12528 Oct 14, 2006 6:37 AM by Mohammed Taj ORA-12505, TNS:listener does not currently know of SID given in connect des 538177 Oct 8, 2006 7:02 AM Hi, i'm new with Oracle. http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript I'm using JDeveloper 10g, when i try to create a database connection with the hr/hr user i get this message: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor The Connection descriptor used by the client was: localhost:1521:ORCL Please, if somebpdy could give me a tip, i repeat, i'm new with Oracle. Thanks https://community.oracle.com/thread/433363 460755Views Tags: none (add) This content has been marked as final. Show 11 replies 1. Re: ORA-12505, TNS:listener does not currently know of SID given in connect RPuttagunta Oct 8, 2006 7:25 AM (in response to 538177) Is the oracle service on your computer? Can you do this from your command line: tnsping ORCL; and paste what you get. Rahul. Message was edited by: RPuttagunta Like Show 0 Likes(0) Actions 2. Re: ORA-12505, TNS:listener does not currently know of SID given in connect Eduardo Legatti Oct 8, 2006 3:48 PM (in response to 538177) Hi, Check to make sure that the SID is correct. The SIDs that are currently registered with the listener can be obtained by typing: LSNRCTL SERVICES on the Server These SIDs correspond to SID_NAMEs in TNSNAMES.ORA or DB_NAME in the initialization file. Cheers Like Show 0 Likes(0) Actions 3. Re: ORA-12505, TNS:listener does not currently know of SID given in connect 538177 Oct 10, 2006 4:14 AM (in response to RPuttagunta) Rahul: when i type what you told me i get this: C:\Documents and Settings\Alejandro>tnsping ORCL TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Product
does not currently know of SID given in connect descriptor" when http://www-01.ibm.com/support/docview.wss?uid=swg21606207 testing database connection Technote (troubleshooting) Problem(Abstract) I.T. administrator launches "Controller Configuration" and creates new database connection to Oracle database schema. Administrator clicks 'Test Connection' but receives an error message. Symptom Connection failed Error Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Cause There are listener refused many possible causes for the "ORA-12505: TNS:listener ..." error, such as: Scenario #1 - Incorrect configuration of Oracle database server Specifically, the LISTENER on the Oracle database server was not configured correctly. Scenario #2 - Incorrect configuration of Oracle database client (installed on Controller application server) For more details, listener refused the see separate IBM Technote #1447103. Diagnosing the problem Scenario #1 Logon to the Oracle database server and launch a command prompt. Type the following command: lsnrctl status In one real-life example, the message included the following text: The listener supports no services Resolving the problem Scenario #1 - Incorrect configuration of Oracle database server Ask your I.T. department's Oracle DBA to reconfigure the Oracle server's listener correctly. Real-life example: In one real-life example, the customer wanted to connect to a database called "CCR11G". In this case the solution was to modify the "listener.ora" file from: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVERNAME)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = E:\app\Administrator\product\11.2.0\dbhome_2\log to: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_2) (PROGRAM = extproc) ) (SID_DESC= (GLOBAL_DBNAME=ccr11g) (ORACLE_HOME=E:\app\Administrator\product\11