Oracle 11g Error Ora-12505
Contents |
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 vs SERVICE_NAMES It is important to understand the (slight) difference between ora 12505 solution what Oracle defines as a SID compared to a SERVICE_NAME, as we'll use this information ora 12505 error in sql developer to create a proper connection string later on. In Oracle, the system identifier (or SID) is a local identifier of up to listener refused the connection with the following error ora-12505 in oracle sql developer eight characters in length that is used to identify a particular database and differentiate 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
Ora-12505 Tns Listener Does Not Currently Know Of Sid
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 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 ora 12505 error in oracle 12c 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 discussed earlier (bookstore.company.com) and connecting to localhost through port 1521. Connection String With a bit more knowledge about how Oracle actually connects to databases, we can now look at how connection strings are formatted. Connect via TNS Name/NET_SERVICE_NAME When connecting through a NET_SERVICE_NAME as specified in your tnsnames.ora config file, you must use the username, password, and then append the NET_SERVICE_NAME with the @ symbol, like so: username/
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss tns listener does not know of service requested in connect descriptor the workings and policies of this site About Us Learn more about
Ora 12505 Oracle 11g Windows 7
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow
Ora 12505 Error In Oracle 11g Solution
Questions Jobs Documentation Tags 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 https://chartio.com/resources/tutorials/how-to-fix-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descriptor other. Join them; it only takes a minute: Sign up ora-12505 error with sql developer connecting to oracle11g on windows 7 up vote 1 down vote favorite I installed oracle 11g successfully and was able to login with SQL plus. When I tried making a connection with the same username and password via SQL developer however I'm getting http://stackoverflow.com/questions/17780187/ora-12505-error-with-sql-developer-connecting-to-oracle11g-on-windows-7 the ora-12505 error Printout of my tnsname.ora: # tnsnames.ora Network Configuration File: C:\Oracle11g\product\11.2.0\dbhome_1\network\admin\tnsnames.ora # Generated by Oracle configuration tools. ORACLE11G = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = oracle11g) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) When I execute the tnspint orcl; I get: C:\Windows\system32>tnsping ORCL; TNS Ping Utility for 32-bit Windows: Version 11.2.0.1.0 - Production on 22-JUL-2013 00:52:10 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: C:\Oracle11g\product\11.2.0\dbhome_1\network\admin\sqlnet.ora TNS-03505: Failed to resolve name C:\Windows\system32> Could anyone assist in solving this problem and getting sql developer connected with my oracle database? oracle11g share|improve this question asked Jul 22 '13 at 4:55 D. Rattansingh 6683821 add a comment| 2 Answers 2 active oldest votes up vote 3 down vote Just Run This command in RUN SQL Command after connecting to username and password credentials. command: alter system set local_listener='(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))'; share|improve this a
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss the workings http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript and policies of this site About Us Learn more about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags https://github.com/wnameless/docker-oracle-xe-11g/issues/7 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 ora 12505 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 and tried to execute JDBC program, then I got the following error: java.sql.SQLException: Listener refused the connection with the following ora 12505 error 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.
Sign in Pricing Blog Support Search GitHub This repository Watch 41 Star 395 Fork 237 wnameless/docker-oracle-xe-11g Code Issues 5 Pull requests 2 Projects 0 Pulse Graphs New issue ORA-12505, TNS:listener does not currently know of SID given in connect descriptor #7 Closed toretto460 opened this Issue May 6, 2015 · 9 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 6 participants toretto460 commented May 6, 2015 I can't connect to the container via Toad (jdbc). 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 connection string: jdbc:oracle:thin:@localhost:49161:xe Anyone has some suggestion? toretto460 changed the title from Can't connect to the oracle DB to ORA-12505, TNS:listener does not currently know of SID given in connect descriptor May 6, 2015 kakawait commented Jun 23, 2015 Same here since few weeks Owner wnameless commented Jun 25, 2015 Here is a new version released. Please try it again. kakawait commented Jun 25, 2015 Thank you I will try that as soon as possible yannxia commented Dec 8, 2015 Today, i use it also tell me ORA-12541: TNS:no listner. how to fix it? matheustardivo commented Dec 22, 2015 Try using this: jdbc:oracle:thin:@localhost:49161/xe MattFriedman commented Feb 28, 2016 I have had the same problem; no ability to connect from a remote machine. I fixed it manually by doing the following: set ORACLE_SID=