如何获取Oracle的SID列表

概述我有主机,端口,用户名和密码,但缺少连接到Oracle DBMS的SID.如何找到该服务器上的SID列表？ 更好的方法是,如果您可以访问主机,并且Oracle安装是使用命令：lsnrctl status.这适用于Unix, Linux和Windows机器. status命令将显示所有侦听器(及其关联的SID). C:\>lsnrctl statusLSNRCTL for 32-bit Wind 我有主机,端口,用户名和密码,但缺少连接到Oracle DBMS的SID.如何找到该服务器上的SID列表？ 更好的方法是,如果您可以访问主机,并且Oracle安装是使用命令：lsnrctl status.这适用于Unix,Linux和windows机器. status命令将显示所有侦听器(及其关联的SID).

C:\>lsnrctl statusLSNRCTL for 32-bit windows: Version 10.2.0.1.0 - Production on 15-JUN-2009 16:16:34copyright (c) 1991,2005,Oracle.  All rights reserved.Connecting to (DESCRIPTION=(ADDRESS=(PROTOCol=IPC)(KEY=EXTPROC_FOR_XE)))STATUS of the ListENER------------------------Alias                     ListENERVersion                   TNSLSNR for 32-bit windows: Version 10.2.0.1.0 - ProductionStart Date                13-JUN-2009 12:04:14Uptime                    2 days 4 hr. 12 min. 19 secTrace Level               offSecurity                  ON: Local OS AuthenticationSNMP                      OFFDefault Service           XEListener Parameter file   C:\oracle\XE\app\oracle\product.2.0\server\network\admin\Listener.oraListener Log file         C:\oracle\XE\app\oracle\product.2.0\server\network\log\Listener.logListening Endpoints Summary...  (DESCRIPTION=(ADDRESS=(PROTOCol=ipc)(PIPEname=\.\pipe\EXTPROC_FOR_XEipc)))  (DESCRIPTION=(ADDRESS=(PROTOCol=tcp)(HOST=ThinkpadT61)(PORT=1521)))  (DESCRIPTION=(ADDRESS=(PROTOCol=tcp)(HOST=127.0.0.1)(PORT=8080))(Presentation=http)(Session=RAW))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",has 1 handler(s) for this service...Service "XEXDB" has 1 instance(s).   Instance "xe",status READY,has 1 handler(s) for this service...Service "XE_XPT" has 1 instance(s).   Instance "xe",has 1 handler(s) for this service...Service "xe" has 1 instance(s).   Instance "xe",has 1 handler(s) for this service...The command completed successfully

在上述示例中,您可以使用Conect Strings XEXDB,XE_XPT或XE连接到XE数据库.

总结

以上是内存溢出为你收集整理的如何获取Oracle的SID列表全部内容，希望文章能够帮你解决如何获取Oracle的SID列表所遇到的程序开发问题。

如果觉得内存溢出网站内容还不错，欢迎将内存溢出网站推荐给程序员好友。