Oracle 10g Error Ora-12505
Contents |
here for a quick overview of the site Help Center Detailed ora 12505 error in sql developer answers to any questions you might have Meta Discuss ora-12505 tns listener does not currently know of sid the workings and policies of this site About Us Learn more about Stack Overflow the
Ora-12505 Oracle 11g
company Business Learn more about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
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 takes a minute: Sign up ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) up vote 8 down vote listener refused the connection with the following error ora-12514 favorite 3 I created a Windows 2003 R2 Virtual Machine running on VirtualBox and I installed Oracle (10201_database_win32). I assigned a static IP on the Virtual Ethernet too. Everything worked great right after installation. I listed(lsnrctl services) the services the listener knew right after installation and the result was: LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Production on 15-JUL-2010 23:02 :19 Copyright (c) 1991, 2005, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1))) Services Summary... Service "PLSExtProc" has 1 instance(s). Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER Service "orcl" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:39 refused:0 state:ready LOCAL SERVER Service "orclXDB" has 1 instance(s). Instance "orcl", status READY, has 1 handler(s) for this service... Handler(s): "D000" established:0 refused:0 current:0 max:1002 state:ready DISPATCHER
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
Ora 12505 Error In Oracle 12c
page. Please enter a title. You can not post a blank message. ora-12505 jdbc thin client Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions This listener refused the connection with the following error ora-12519 discussion is archived 11 Replies Latest reply on Oct 14, 2006 6:37 AM by Mohammed Taj ORA-12505, TNS:listener does not currently know of SID given in connect des 538177 http://stackoverflow.com/questions/3267850/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript 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 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: https://community.oracle.com/thread/433363 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 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
log in tour help Tour Start here for a quick overview of the site Help Center http://dba.stackexchange.com/questions/13262/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript Detailed answers to any questions you might have Meta Discuss http://www.orafaq.com/forum/t/146536/ the workings 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 Database Administrators Questions Tags Users Badges Unanswered Ask Question _ Database Administrators listener refused 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 a minute: Sign up Here's how it works: Anybody can ask a question Anybody can answer The best answers listener refused the are voted up and rise to the top ORA-12505: TNS:listener does not currently know of SID given in connect descriptor up vote 4 down vote favorite Couple of days back, I execute shutdown on my DB but it took very long time so I shutdown my m/c. After restarting my machine, I get this exception when I try to connect to my database using TOAD. I referred below mentioned threads, but issue is still not resolved: http://stackoverflow.com/questions/5661610/tns-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript http://stackoverflow.com/questions/3267850/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript Contents of my tnsnames.ora: ORCL= (DESCRIPTION= (ADDRESS= (PROTOCOL=TCP) (HOST=localhost) (PORT=1521) ) (CONNECT_DATA= (SERVER=dedicated) (SERVICE_NAME=orcl) ) ) Output of 'lsnrctl services': LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 15-FEB-2012 23:53:33 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1521))) Services Summary... Service "CLRExtProc" has 1 instance(s). Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service... Handler(s): "DEDICATED" established:0 refused:0 LOCAL SERVER The comm
Tue, 16 June 2009 03:43 westen30 Messages: 13Registered: June 2009 Junior Member Hi, I have Oracle 10g installed on a Windows 2003 Server Virtual Machine and I have the following problem that I hope someone can help me with. All the Oracle services seem to start ok on OS startup, but I am unable to access my database, so I run up Enterprise Manager in my Browser. I get the following statuses: Database Instance Down Listener Up Agent has the error message. ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach) So I click on the Startup button and I enter my OS username and password and the database starts and I'm able to access it. I don't understand why the Database starts manually but not automatically on startup. Its not a major problem to do this as its just a test environment its just annoying. If you require any more info let me know. Regards Martin Report message to a moderator Re: ORA-12505 [message #408451 is a reply to message #408433] Tue, 16 June 2009 04:50 babuknb Messages: 1734Registered: December 2005 Location: NJ Senior Member ORA-12505: 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 a SID for an instance (usually a database instance) that either has not yet dynamically registered with the listener or has not been statically configured for the listener. This may be a temporary condition such as after the listener has started, but before the database instance has registered with the listener. Action: - Wait a moment and try to connect a second time. - Check which instances are currently known by the listener by executing: lsnrctl services