Oracle Connection Error Ora-12505
Contents |
here for a quick overview of the site Help Center Detailed answers to any questions you might have Meta ora 12505 error in sql developer Discuss the workings and policies of this site About Us Learn more
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
about Stack Overflow the company Business Learn more about hiring developers or posting ads with us Stack
Ora-12505 Oracle 11g
Overflow 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,
Listener Refused The Connection With The Following Error Ora-12514
helping each other. Join them; it only takes a minute: Sign up TNS-12505: TNS:listener does not currently know of SID given in connect descriptor up vote 34 down vote favorite 11 I'm trying to connect to Oracle 10.2.0 from NetBeans, using the following connection string: jdbc:oracle:thin:@localhost:1521:XE The weirdest part is that everything worked fine, until the one of ora 12505 error in oracle 12c the reboots. I started getting this TNS-12505 errors all the time; look at the final entries in my listener.log: TNSLSNR for 32-bit Windows: Version 10.2.0.1.0 - Production on 14-APR-2011 13:46:48 Copyright (c) 1991, 2005, Oracle. All rights reserved. System parameter file is D:\oraclexe\app\oracle\product\10.2.0\server\network\admin\listener.ora Log messages written to D:\oraclexe\app\oracle\product\10.2.0\server\network\log\listener.log Trace information written to D:\oraclexe\app\oracle\product\10.2.0\server\network\trace\listener.trc Trace level is currently 0 Started with pid=3460 Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC_FOR_XEipc))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Brodyaga-PC)(PORT=1521))) Listener completed notification to CRS on start TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 14-APR-2011 13:48:54 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Brodyaga))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58458)) * establish * XE * 12505 TNS-12505: TNS:listener does not currently know of SID given in connect descriptor 14-APR-2011 13:49:00 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Brodyaga))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58481)) * establish * XE * 12505 TNS-12505: TNS:listener does not currently know of SID given in connect descriptor 14-APR-2011 13:49:02 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=JDBC Thin Client)(HOST=__jdbc__)(USER=Brodyaga))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=58487)) * establish * XE * 12505 TNS-12505: TNS:listener does not currently know of SID given in connect descriptor 14-APR-2011 13:50:23 * (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Brodyaga))(COMMAND=services)(ARGUMENTS=64
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 jdbc thin client page. Please enter a title. You can not post a blank listener refused the connection with the following error ora-12519 message. Please type your message and try again. More discussions in General Database Discussions All PlacesDatabaseGeneral Database Discussions listener refused the connection with the following error ora-12528 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 know of SID given in connect des http://stackoverflow.com/questions/5661610/tns-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript 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 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 https://community.oracle.com/thread/433363 was: localhost:1521:ORCL Please, if somebpdy could give me a tip, i repeat, i'm new with Oracle. Thanks 460771Views 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 conn
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 http://dba.stackexchange.com/questions/121251/sqldeveloper-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-co and policies of this site About Us Learn more about Stack Overflow https://github.com/yajra/laravel-oci8/issues/49 the company Business Learn more about hiring developers or posting ads with us Database Administrators 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 learn from others in the listener refused 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 are similar questions asked and answered in listener refused the 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)(HOST = localhost)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = pdborcl) ) ) ORCL
Sign in Pricing Blog Support Search GitHub This repository Watch 20 Star 210 Fork 52 yajra/laravel-oci8 Code Issues 14 Pull requests 0 Projects 0 Wiki Pulse Graphs New issue Error: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor #49 Closed AnowarCST opened this Issue Jan 12, 2015 · 4 comments Projects None yet Labels None yet Milestone No milestone Assignees No one assigned 3 participants AnowarCST commented Jan 12, 2015 'oracle' => array( 'driver' => 'oracle', 'host' => '192.168.152.189',//server IP 'port' => '1521', 'database' => 'orcl', //SID 'username' => 'system', 'password' => '123456', ), I've add this code in app/config/database.php But I couldn't connected to Oracle with Laravel, from my client PC to Server. show this Error: ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Owner yajra commented Jan 12, 2015 double check your SID. 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 Check that the SID parameter in the connect descriptor specifies an instance known by the listener. Check for an event in the listener.log file. AnowarCST commented Jan 21, 2015 I was install a oracle 11g client in my local PC to connect Oracle server (by IP). It is connected & working fine with CodeIgniter Framework. But I'm fail to connect with Laravel. as you tell: I don't know about this listener & there (client) have no option to create listener. How can i config this listener? [Thanks for your kind reply & sorry for late.] Owner yajra commented Jan 22, 2015 Oracle listener would