Error Ora 12505 Sql Developer
Contents |
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 this site About Us Learn more about Stack Overflow the company Business ora 12505 error in oracle 11g Learn more about hiring developers or posting ads with us Database Administrators Questions Tags Users Badges
Error Ora 12505 Tns Listener
Unanswered Ask Question _ Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database ora 12505 tns listener could not resolve sid skills and 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 ora-12505 sql developer 11g 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 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
Ora 12505 Solution
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) (SERVICE_NAME = orcl) ) ) oracle ubuntu sqlplus oracle-sql-developer share|improve this question asked Nov 16 '15 at 16:10 Prakash Gautam 120117 You'll be wanting to connect to the SERVICE NAME not the SID –Philᵀᴹ Nov 16 '15 at 16:15 1 I feel completely ashamed now. I spent hours on internet search spent quite a time to post this question too, but what solves is changing using SERVICE NAME instead of SID. –Pr
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 this ora 12505 error in oracle 11g solution site About Us Learn more about Stack Overflow the company Business Learn more ora 12505 error in oracle 12c about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Ora 12505 Oracle 11g Windows 7
Join the Stack Overflow Community Stack Overflow is a community of 4.7 million programmers, just like you, helping each other. Join them; it only takes a minute: Sign up ora-12505 error with http://dba.stackexchange.com/questions/121251/sqldeveloper-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-co 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 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. http://stackoverflow.com/questions/17780187/ora-12505-error-with-sql-developer-connecting-to-oracle11g-on-windows-7 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 6633821 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 edited Jul 27 '15 at 6:55 Sathya 13.2k1667106 answered Jul 27 '15 at 6:14 Amritanshu 312 You should change code format in this message. –Slava Avsenev Jul 27 '15 at 6:26 add a comment| up vote
does not currently know of SID given in connect descriptor INNo MATHs SubscribeSubscribedUnsubscribe140140 Loading... Loading... Working... Add to Want to watch this again later? Sign in https://www.youtube.com/watch?v=vNJ7x_R7vN8 to add this video to a playlist. Sign in Share More https://community.oracle.com/thread/2323769 Report Need to report the video? Sign in to report inappropriate content. Sign in Statistics 24,521 views 149 Like this video? Sign in to make your opinion count. Sign in 150 5 Don't like this video? Sign in to make your opinion count. ora 12505 Sign in 6 Loading... Loading... Loading... Rating is available when the video has been rented. This feature is not available right now. Please try again later. Published on Nov 27, 2015solution of error: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 ora 12505 error descriptor Category Education License Standard YouTube License Show more Show less Loading... Advertisement Autoplay When autoplay is enabled, a suggested video will automatically play next. Up next Oracle - Understanding the tnsnames.ora and listener.ora files - Duration: 12:46. Chris Ostrowski 88,976 views 12:46 How to fix error ORA-12505 - Duration: 6:03. Nguyễn Văn Thân 727 views 6:03 Resolved: The Network Adapter could not establish the connection - Duration: 9:36. daniele perrotta 30,047 views 9:36 How to know your oracle SID name - Duration: 7:15. Oracle Database 412 views 7:15 Oracle: fixed errors 17002 and 12505 - Duration: 2:52. Integral 1,055 views 2:52 ora - 12514 and ora - 12505 tns listener error fixed in 90 seconds - Duration: 1:30. CBOT 1,621 views 1:30 Create new connection with new user in Oracle SQL Developer - Duration: 10:28. Chitu Okoli 96,491 views 10:28 The Listener ora file - Duration: 4:39. Hemant K Chitale 172 views 4:39 creating a new connection in sqlDeveloper - Duration: 1:
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 message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This discussion is archived 1 2 Previous Next 25 Replies Latest reply on Dec 16, 2012 8:53 PM by sb92075 Listener does not currently know of SID given in connection descriptor 905429 Dec 15, 2011 2:40 AM Oracle 11g R2 64bit on Windows 7 professional giving following Error Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor. Oracle 11g R1 64bit on windows 7 professional works perfectly fine Test through Net Manager. no use check files ../Network/Admin/listerner.ora and tnsnames.ora which is perfectly fine. Still getting same error when trying to connect using sql developer. 89147Views Tags: none (add) connectContent tagged with connect, descriptorContent tagged with descriptor, doesContent tagged with does, givenContent tagged with given, inContent tagged with in, knowContent tagged with know, listenerContent tagged with listener, ofContent tagged with of, sidContent tagged with sid This content has been marked as final. Show 25 replies 1. Re: Listener does not currently know of SID given in connection descriptor sb92075 Dec 15, 2011 2:51 AM (in response to 905429) 12505, 00000, "TNS:listener does not currently know of SID given in connect descriptor" // *Cause: The listener received a request to establish a connection to a // database or other service. The connect descriptor received by the listener // specified