ORA-12505，TNS:侦听器当前不知道connect des中给出的SID [英] ORA-12505, TNS:listener does not currently know of SID given in connect des
问题描述
请好帮我，因为我刚刚安装了Oracle 11g，但无法通过以下设置使用SQL Devloper进行连接:
Please kindly help me as I just installed Oracle 11g but cannot connnect using SQL Devloper using the settings below:
用户名:系统
密码:mypassword
Password: mypassword
主机名:localhost
Hostname: localhost
端口:1521
SID:XE
错误消息:
状态:失败-测试失败:侦听器拒绝连接并出现以下错误:
Status : Failure -Test failed: Listener refused the connection with the following error:
ORA-12505，TNS:侦听器当前不知道连接描述符中给出的SID
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
我检查了Windows服务:
OracleServiceXE:已启动
OracleServiceXE: Started
OracleXETNSListener:已启动
OracleXETNSListener: Started
我也无法连接到管理页面:**http://localhost:8080/apex/f?p=4950**
I also unable to connect to admin page: **http://localhost:8080/apex/f?p=4950**
显示无法显示此页面"
It says "This page can't be displayed"
我还测试了使用SqlPlus进行连接:
测试1:结果为ORA-12170:TNS:发生连接超时
C:\ oraclexe \ app \ oracle \ product \ 11.2.0 \ server \ bin> sqlplus.exe系统/mypassword @ XE
C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe system/mypassword@XE
SQL * Plus:11.2.0.2.0版本于2014年4月22日星期二11:22:31投入生产 版权所有(c)1982、2010，Oracle.保留所有权利.
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.
错误: ORA-12170:TNS:发生连接超时
ERROR: ORA-12170: TNS:Connect timeout occurred
输入用户名:
测试2:结果成功
C:\ oraclexe \ app \ oracle \ product \ 11.2.0 \ server \ bin> sqlplus.exe系统/mypassword
C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe system/mypassword
SQL * Plus:11.2.0.2.0版本在2014年4月22日星期二生产 版权所有(c)1982、2010，Oracle.保留所有权利.
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.
已连接到: Oracle Database 11g Express Edition 11.2.0.2.0版-生产
Connected to: Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production
SQL>
测试3:结果成功
C:\ oraclexe \ app \ oracle \ product \ 11.2.0 \ server \ bin> sqlplus.exe/作为sysdba
C:\oraclexe\app\oracle\product\11.2.0\server\bin>sqlplus.exe / as sysdba
SQL * Plus:11.2.0.2.0版本于2014年4月22日星期二11:34:29投入生产 版权所有(c)1982、2010，Oracle.保留所有权利.
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.
已连接到: Oracle Database 11g Express Edition 11.2.0.2.0版-生产
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)
(SERVICE_NAME = XE)
)
)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
LSNRCTL>状态
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Produ
ction
Start Date 22-APR-2014 14:29:22
Uptime 0 days 0 hr. 56 min. 43 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\a
dmin\listener.ora
Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\NASAYAO2\listener\
alert\log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=NASAYAO2)(PORT=1521)))
Services Summary...
Service "CLRExtProc" has 1 instance(s).
Instance "CLRExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
请帮助我.
推荐答案
我有同样的问题，但是我在oracle linux上运行. 搜索和测试后，无需设置listener.ora即可将sqldeveloper连接到我的oracle11g
I have same problem, but I run on oracle linux. After searching and testing, i can connect sqldeveloper to my oracle11g without setting my listener.ora or else
这是我在终端sql上运行的语法
here is the syntax that i run on terminal sql
alter system set LOCAL_LISTENER='(DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))))';
然后
alter system register;
我得到了教程 此处
这篇关于ORA-12505，TNS:侦听器当前不知道connect des中给出的SID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
