Oracle Connect Error 12505
Contents |
connect to the appropriate Oracle database, we'll need to expound a bit on how Oracle behaves and, therefore, what is causing ora 12505 error in sql developer this issue in the first place. SIDs vs SERVICE_NAMES It is
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
important to understand the (slight) difference between what Oracle defines as a SID compared to a ora 12505 error in oracle 11g SERVICE_NAME, as we'll use this information to create a proper connection string later on. In Oracle, the system identifier (or SID) is a local identifier of up to
Ora-12505 Tns Listener Does Not Know Of Sid
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 SID of our bookstore database, as seen in in the full global database name of bookstore.company.com. SERVICE_NAMES, on ora 12505 solution 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 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/a
log in tour help Tour Start here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss
Listener Refused The Connection With The Following Error Ora-12514
the workings and policies of this site About Us Learn more
Ora 12505 Error In Oracle 12c
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Database Administrators ora-12505 jdbc thin client Questions Tags Users Badges Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and https://chartio.com/resources/tutorials/how-to-fix-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descriptor learn from others in the community. Join them; it only takes a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers are voted up and rise to the top sqldeveloper ORA-12505. TNS: listener does not currently know of SID given in connect descriptor up vote 3 down vote favorite There http://dba.stackexchange.com/questions/121251/sqldeveloper-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-co are similar questions asked and answered in this network related to the error message given in the question, however this problem is a little different from each. I have installed oracle 12c in my ubuntu can successfully connect to my hr user with sqlplus hr/hr@pdborcl through command prompt. oracle@ubuntu:~$ sqlplus hr/hr@pdborcl SQL*Plus: Release 12.1.0.2.0 Production on Mon Nov 16 21:57:24 2015 Copyright (c) 1982, 2014, Oracle. All rights reserved. Last Successful login time: Mon Nov 16 2015 21:24:32 +05:45 Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL>show user; USER is "HR" I am however trying to use sqldeveloper for ease. In the create connection option in sqldeveloper when I give the following credentials I get the following error. ORA-12505. TNS: listener does not currently know of SID given in connect descriptor. However connection with Username: sys Password: ****** SID:orcl And same all other credentials work fine. My tnsname.ora has PDBORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOS
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 can not post a blank message. Please type your https://community.oracle.com/thread/433363 message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 11 Replies Latest reply on Oct 14, 2006 6:37 AM by Mohammed Taj ORA-12505, TNS:listener does not currently http://www-01.ibm.com/support/docview.wss?uid=swg21691583 know of SID given in connect des 538177 Oct 8, 2006 7:02 AM Hi, i'm new with Oracle. I'm using JDeveloper 10g, when i try to create a database connection with the hr/hr user i get ora 12505 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 460763Views 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 ora 12505 error 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 - Production on 10-OCT-20 06 01:03:53 Copyright (c) 1997 Oracle Corporation. All rights reserved. Used parameter files: C:\oracle\ora91\network\admin\sqlnet.ora TNS-03505: Failed to resolve name I don't know what this means, this is the TNSNames file: GLOBAL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = MARROC)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME =
in connect descriptor Technote (troubleshooting) Problem(Abstract) Upgraded database server from Oracle 11.2.0.2 to Oracle 12c. While testing content manager connection, it is failing to connect with the following error. [Content Manager database connection] [ ERROR ] The database connection failed. [ ERROR ] Content Manager failed to connect to the content store. The connection string is "jdbc:oracle:thin:@host_name:port:service_name". The error encountered is: "Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor Cause In an Oracle 12c container database, the client must specify a service name in order to connect to the PDB. Many Database clients with earlierreleases of Oracle Database might have hard-coded connect descriptors touse SID to connect to the database. Now if they choose to plug in their non-CDB?s into a CDB, they will have to modify the connect descriptors in tnsnames.ora on all the client sites. Environment Oracle Container Databases (CDB) / Pluggable Databases (PDB) Resolving the problem This problem can be resolved by the use of listener.ora parameter USE_SID_AS_SERVICE_listener_name. Setting this parameter to on instructs the listener to use the SID in the connect descriptor as a service name and connect the client to the specified database. The default value for this parameter is off and it has to be explicitly set to on to use this functionality. listener.ora to set USE_SID_AS_SERVICE_LISTENER to on USE_SID_AS_SERVICE_LISTENER=on Related information USE_SID_AS_SERVICE_listener_name. Document information More support for: Cognos Business Intelligence Install and Config Software version: 10.2.1 Operating system(s): Windows Reference #: 1691583 Modified date: 28 November 2014 Site availability Site assistance Contact and feedback Need support? Submit feedback to IBM Support 1-800-IBM-7378 (USA) Directory of worldwide contacts Contact Privacy Terms of use Accessibility