Ora 12505 Error In Sql Developer
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta Discuss ora-12505 sql developer 11g the workings and policies of this site About Us Learn more about
Ora 12505 Tns Listener Could Not Resolve Sid
Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack Overflow ora 12505 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 ora 12505 error in oracle 11g solution 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 the
Ora 12505 Error In Oracle 12c
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 answer edite
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 the workings and policies of ora 12505 oracle 11g windows 7 this site About Us Learn more about Stack Overflow the company Business Learn ora-12514 error in sql developer more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges Unanswered Ask Question _
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes http://stackoverflow.com/questions/17780187/ora-12505-error-with-sql-developer-connecting-to-oracle11g-on-windows-7 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 are similar questions asked and answered in this network related to the error message given in http://dba.stackexchange.com/questions/121251/sqldeveloper-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-co 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)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) ) ORCL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SE
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 https://community.oracle.com/thread/2451625 not post a blank message. Please type your message and try again. More discussions in Oracle Database Express Edition (XE) All PlacesDatabaseDatabase Application DevelopmentOracle Database Express Edition (XE) This discussion is archived 1 https://coderanch.com/t/585051/JDBC/databases/Listener-refused-connection-error-ORA 2 3 Previous Next 33 Replies Latest reply on Oct 19, 2012 1:39 PM by 967142 ORA-12505, TNS:listener does not currently know of SID given in connect des 967142 Oct 9, 2012 ora 12505 1:35 PM Hello, After installation of Oracle Database Express Edition 11g and Oracle SQL Developer 3.0, I tryed connect a database. Informations entered : Nom de connexion : xe_sys Nom utilisateur : sys Mdp : ********* Type de connexion : de base, role sysdba Nom d'hote : POST1.compteUs.local Port : 1521 SID : XE when I tested the connection I have this famous message that appears: ora 12505 error Statut : échec -Echec du test : Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor this is listener.ora : SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) (SID_DESC = (SID_NAME = CLRExtProc) (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server) (PROGRAM = extproc) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) (ADDRESS = (PROTOCOL = TCP)(HOST = POST1.compteUs.local)(PORT = 1521)) ) ) DEFAULT_SERVICE_LISTENER = (XE) this is sqlnet.ora : SQLNET.AUTHENTICATION_SERVICES = (NTS) this is tnsname.ora : XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = POST1.compteUs.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = XE) ) ) EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) ) ORACLR_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (CONNECT_DATA = (SID = CLRExtProc) (PRESENTATION = RO) ) ) Can you help me please ? Thanks I have the same question Show 0 Likes(0) 5651Views Tags: none (add) connectionContent tagged with connection, connexionContent tag
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 during creating new connection using SQL developer. Does it matter if i use SIVA or XE. please tell me step by step, what i need to do next.?? thanks chris webster