Oracle Error 12505
Contents |
here for a quick overview of the site Help Center Detailed answers listener refused the connection with the following error ora-12505 in oracle sql developer to any questions you might have Meta Discuss the workings
Ora 12505 Error In Sql Developer
and policies of this site About Us Learn more about Stack Overflow the company Business
Ora-12505 Oracle 11g
Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join the Stack
Listener Refused The Connection With The Following Error Ora-12514
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 descriptor up vote 81 down vote favorite 22 I have installed Oracle 11g ora 12505 error in oracle 12c 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.
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 ora-12505 jdbc thin client to understand the (slight) difference between what Oracle defines as a SID compared listener refused the connection with the following error ora-12519 to a SERVICE_NAME, as we'll use this information to create a proper connection string later on. In Oracle, the system java.sql.sqlexception: listener refused the connection with the following error identifier (or SID) is a local identifier of up to eight characters in length that is used to identify a particular database and differentiate it from other databases on the system. Often the http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript 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 of the SID followed by the database domain, like so: DB_UNIQUE_NAME.DB_DOMAIN The TNS Listener https://chartio.com/resources/tutorials/how-to-fix-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-connect-descriptor 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 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 no
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube https://www.youtube.com/watch?v=vNJ7x_R7vN8 εμφανίζεται στα Ελληνικά. Μπορείτε να αλλάξετε αυτή την προτίμηση παρακάτω. Learn more You're viewing https://coderanch.com/t/585051/JDBC/databases/Listener-refused-connection-error-ORA YouTube in Greek. You can change this preference below. Κλείσιμο Ναι, θέλω να τη listener refused κρατήσω Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ ORA-12505: TNS:listener does not currently know of SID given in listener refused the connect descriptor INNo MATHs ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής145145 Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Στατιστικά στοιχεία 25.574 προβολές 160 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 161 6 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 7 Φόρτωση... Φόρτωση... Φόρτωση... Η δ
This Site Careers Other all forums Forum: JDBC and Relational Databases Listener refused the connection with 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 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. 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 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 = 1521)) SIVU = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = sivu) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = orcl) ) ) SIVA = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = siva) ) ) now please tell me what it is all about. what is the significance of using SID du