How To Fix Error Ora 12505
Contents |
Выбрать другой язык можно в списке ниже. Learn more You're viewing YouTube in Russian. ora 12505 error in sql developer You can change this preference below. ora 12505 solution Закрыть Да, сохранить Отменить Закрыть Это видео недоступно. Очередь просмотраОчередьОчередь ora-12505 tns listener does not know of sid просмотраОчередь Удалить всеОтключить Загрузка... Очередь просмотра Очередь __count__/__total__ ORA-12505: TNS:listener does not currently know of
Listener Refused The Connection With The Following Error Ora-12505 In Oracle Sql Developer
SID given in connect descriptor INNo MATHs ПодписатьсяПодписка оформленаОтменить подписку141141 Загрузка... Загрузка... Обработка... Добавить в Хотите сохраните это видео? Войдите в аккаунт и добавьте его в плейлист. Войти Поделиться Ещё Пожаловаться Пожаловаться на ora 12505 error in oracle 11g видео? Выполните вход, чтобы сообщить о неприемлемом контенте. Войти Статистика 24 839 просмотров 153 Понравилось? Войдите в аккаунт, чтобы поставить отметку. Войти 154 6 Не понравилось? Войдите в аккаунт, чтобы поставить отметку. Войти 7 Загрузка... Загрузка... Загрузка... Оценка становится доступна после аренды видео- В данный момент эта функция недоступна. Повторите попытку позже. Опубликовано: 27 нояб. 2015 г.solution 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 descriptor Категория Образование Лицензия Стандартная лицензия YouTube Ещё Свернуть Загрузка... Реклама Автовоспроизведение
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 oracle 12c About Us Learn more about Stack Overflow the company Business Learn more
Listener Refused The Connection With The Following Error Ora-12514
about hiring developers or posting ads with us Stack Overflow Questions Jobs Documentation Tags Users Badges Ask Question x Dismiss
Ora-12505 Jdbc Thin Client
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, TNS:listener does https://www.youtube.com/watch?v=vNJ7x_R7vN8 not currently know of SID given in connect descriptor up vote 81 down vote favorite 22 I have installed Oracle 11g Express Edition Release 2 in my windows 7 64 bit OS and tried to execute JDBC program, then I got the following error: java.sql.SQLException: Listener refused the connection with the following error: ORA-12505, TNS:listener does not currently know of SID given in connect descriptor http://stackoverflow.com/questions/18192521/ora-12505-tnslistener-does-not-currently-know-of-sid-given-in-connect-descript at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:412) at oracle.jdbc.driver.PhysicalConnection.
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 http://dba.stackexchange.com/questions/121251/sqldeveloper-ora-12505-tns-listener-does-not-currently-know-of-sid-given-in-co Discuss the workings and policies of this site About Us Learn more http://www-01.ibm.com/support/docview.wss?uid=swg21606207 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 ora 12505 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 sqldeveloper ORA-12505. TNS: listener does not currently know of SID given in connect descriptor up vote 3 down vote favorite ora 12505 error 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 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 =
does not currently know of SID given in connect descriptor" when testing database connection Technote (troubleshooting) Problem(Abstract) I.T. administrator launches "Controller Configuration" and creates new database connection to Oracle database schema. Administrator clicks 'Test Connection' but receives an error message. Symptom Connection failed Error Details ORA-12505: TNS:listener does not currently know of SID given in connect descriptor Cause There are many possible causes for the "ORA-12505: TNS:listener ..." error, such as: Scenario #1 - Incorrect configuration of Oracle database server Specifically, the LISTENER on the Oracle database server was not configured correctly. Scenario #2 - Incorrect configuration of Oracle database client (installed on Controller application server) For more details, see separate IBM Technote #1447103. Diagnosing the problem Scenario #1 Logon to the Oracle database server and launch a command prompt. Type the following command: lsnrctl status In one real-life example, the message included the following text: The listener supports no services Resolving the problem Scenario #1 - Incorrect configuration of Oracle database server Ask your I.T. department's Oracle DBA to reconfigure the Oracle server's listener correctly. Real-life example: In one real-life example, the customer wanted to connect to a database called "CCR11G". In this case the solution was to modify the "listener.ora" file from: LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVERNAME)(PORT = 1521)) ) (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) ) ) ADR_BASE_LISTENER = E:\app\Administrator\product\11.2.0\dbhome_2\log to: SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = E:\app\Administrator\product\11.2.0\dbhome_2) (PROGRAM = extproc) ) (SID_DESC= (GLOBAL_DBNAME=ccr11g) (ORACLE_HOME=E:\app\Administrator\product\11.2.0\dbhome_2) (SID_NAME=ccr11g) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1522)) (ADDRESS = (PROTOCOL = TCP)(HOST = MYSERVERNAME)(PORT = 1521)) ) ) ADR_BASE_LISTENER = E:\app\Administrator\product\11.2.0\dbhome_2\log Afterwards, restart the listener by typing: lsnrctl stop lsnrctl start Scenario #2 - Incorrect configuration of Oracle database client See separate IBM Technote #1447103. Related information 1447103 - "ORA-12505: TNS:listener does not currently k THIRD PARTY - "The listener supports no services" in Or Document information More support for: Cognos Controller Controller