我在连接到本地 Oracle 数据库时遇到了一些问题。
我已经根据本指南完成了安装:installing-oracle-11g-r2-express
该教程运行良好，但安装后我无法使用 SQLDeveloper 或“sqlplus system/password@XE”连接到数据库
sqlplus system/password@XE
SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 11:57:06 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
ERROR:
ORA-12514: TNS:listener does not currently know of service requested in connect
descriptor
不使用 XE 进行连接工作:
:~$ sqlplus sys as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Sat Nov 16 11:54:54 2013
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Enter password:
Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
SQL>
当我尝试使用 SQLDeveloper 进行连接时，出现以下错误:
ORA-12505, TNS:listener does not currently know of SID given in connect descriptor
我错过了什么？
@Mihai 要求的 listener.ora:
已更改 20.11.2012 12:06
# listener.ora Network Configuration File:
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = XE)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0/xe)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC_FOR_XE))
(ADDRESS = (PROTOCOL = TCP)(HOST = <name_of_my_computer>)(PORT = 1521))
)
)
DEFAULT_SERVICE_LISTENER = (XE)
@BjarteBrandt 要求的 $ lsnrctl 状态:
$ lsnrctl status
LSNRCTL for Linux: Version 11.2.0.2.0 - Production on 18-NOV-2013 12:52:26
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC_FOR_XE)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.2.0 - Production
Start Date 18-NOV-2013 12:48:06
Uptime 0 days 0 hr. 4 min. 20 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Default Service XE
Listener Parameter File /u01/app/oracle/product/11.2.0/xe/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/<name_of_my_computer>/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC_FOR_XE)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=<name_of_my_computer>)(PORT=1521)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
最佳答案
首先，请确保 XE 数据库确实已注册到监听器。
我的听众的输出:
$ lsnrctl 状态
Services Summary...
Service "PLSExtProc" has 1 instance(s).
Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "XE" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
Service "XEXDB" has 1 instance(s).
Instance "XE", status READY, has 1 handler(s) for this service...
The command completed successfully
如果您的列表中没有任何服务，请退回监听器
$ lsnrctl stop
$ lsnrctl start
以 sys 用户身份通过 IPC 登录到数据库。 (不联系听者)
$ sqlplus / as sysdba
SQL>-- tell the listener to pick up this particular database service.
SQL>alter system register;
如果您的数据库服务仍未列出，请为 STATIC 服务配置您的 listener.ora 文件。
Static service
关于sql - 适用于 Ubuntu 上的 Oracle XE 11g 的 ORA-12505，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/20017638/