Ora 12505 Error Solution
Contents |
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 ora 12505 error in sql developer About Us Learn more about Stack Overflow the company Business Learn more about listener refused the connection with the following error ora-12505 in oracle sql developer hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss Join ora 12505 error in oracle 11g 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 listener refused the connection with the following error ora-12514 know of SID given in connect des up vote 1 down vote favorite 1 Please kindly help me as I just installed Oracle 11g but cannot connnect using SQL Devloper using the settings below: Username: system Password: mypassword Hostname: localhost Port: 1521 SID: XE Error message: Status : Failure -Test failed: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know
Ora 12505 Error In Oracle 12c
of SID given in connect descriptor I checked on Windows Services: OracleServiceXE: Started OracleXETNSListener: Started I also unable to connect to admin page: **http://localhost:8080/apex/f?p=4950** It says "This page can't be displayed" I also tested to connect using SqlPlus: Test 1: Result is ORA-12170: TNS:Connect timeout occurred C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe system/mypassword@XE SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 22 11:22:31 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. ERROR: ORA-12170: TNS:Connect timeout occurred Enter user-name: Test 2: Result is Successful C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe system/mypassword SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 22 11:33:22 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> Test 3: Result is Successful C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe / as sysdba SQL*Plus: Release 11.2.0.2.0 Production on Tue Apr 22 11:34:29 2014 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production SQL> Listener.log 22-APR-2014 11:53:51 * (CONNECT_DATA=(SID=XE)(CID=(PROGRAM=SQL Developer)(HOST=__jdbc__)(USER=admin))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=50010)) * establish * XE * 12505 TNS-12505: TNS:listener does not currently know of SID given in connect descriptor tnsnames.ora: XE = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = NASAYAO2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVIC
Επιλέξτε τη γλώσσα σας. Κλείσιμο Μάθετε περισσότερα View this message in English Το YouTube εμφανίζεται στα Ελληνικά. Μπορείτε
Ora-12505 Jdbc Thin Client
να αλλάξετε αυτή την προτίμηση παρακάτω. Learn listener refused the connection with the following error ora-12519 more You're viewing YouTube in Greek. You can change this listener refused the connection with the following error ora-12528 preference below. Κλείσιμο Ναι, θέλω να τη κρατήσω Αναίρεση Κλείσιμο Αυτό το βίντεο δεν είναι διαθέσιμο. http://stackoverflow.com/questions/23209962/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-des Ουρά παρακολούθησηςΟυράΟυρά παρακολούθησηςΟυρά Κατάργηση όλωνΑποσύνδεση Φόρτωση... Ουρά παρακολούθησης Ουρά __count__/__total__ ORA-12505: TNS:listener does not currently know of SID given in connect descriptor INNo MATHs ΕγγραφήΕγγραφήκατεΚατάργηση εγγραφής145145 Φόρτωση... Φόρτωση... Σε λειτουργία... Προσθήκη σε... https://www.youtube.com/watch?v=vNJ7x_R7vN8 Θέλετε να το δείτε ξανά αργότερα; Συνδεθείτε για να προσθέσετε το βίντεο σε playlist. Σύνδεση Κοινή χρήση Περισσότερα Αναφορά Θέλετε να αναφέρετε το βίντεο; Συνδεθείτε για να αναφέρετε ακατάλληλο περιεχόμενο. Σύνδεση Στατιστικά στοιχεία 25.565 προβολές 160 Σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 161 6 Δεν σας αρέσει αυτό το βίντεο; Συνδεθείτε για να μετρήσει η άποψή σας. Σύνδεση 7 Φόρτωση... Φόρτωση... Φόρτωση... Η δυνατότητα αξιολόγησης είναι διαθέσιμη όταν το βίντεο είναι ενοικιασμένο. Αυτή η λειτουργία δεν είναι διαθέσιμη αυτήν τη στιγμή. Δοκιμάστε ξανά αργότερα. Δημοσιεύτηκε στις 27 Νοε 2015s
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 https://community.oracle.com/thread/433363 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 http://dba.stackexchange.com/questions/24857/listener-refused-the-connection-with-following-error-ora-12505-tns-listener-d 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 ora 12505 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 was: ora 12505 error localhost:1521:ORCL Please, if somebpdy could give me a tip, i repeat, i'm new with Oracle. Thanks 460755Views 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
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 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 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 Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor up vote 2 down vote favorite I am a newbie to oracle database. I am trying to make a connection but I receive the following error: Listener refused the connection with following error: ORA-12505, TNS: listener does not currently know of SID given in connect descriptor. I have done my research online and after executing the lsnrctl status and lsnrctl service I get the following. Does anyone what I need to do? All kind of help is highly appreciated. Thanks. C:\Users\myComputer>lsnrctl start LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-SEP-2012 23:33 :29 Copyright (c) 1991, 2010, Oracle. All rights reserved. TNS-01106: Listener using listener name LISTENER has already been started C:\Users\myComputer>lsnrctl service LSNRCTL for 32-bit Windows: Version 11.2.0.1.0 - Production on 24-SEP-2012 23:33 :46 Copyright (c) 1991, 2010, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1522))) Services Summary... Service "CLR