一台俩个实例的数据库，其中一个实例连接不上

blue_prince10 · 发表于 2005-2-28 12:40

lsnrctl status;看一下，在命令行下。把listener.ora贴上来看看吧。

rwq_ · 发表于 2005-2-28 13:36

一台机上二个实例？？？RAC？报出错误来吧

rgbahnh · 发表于 2005-2-28 14:17

LSNRCTL> version
连接至(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS：无监听器
TNS-12560: TNS：协议适配器出现错误
TNS-00511: 无监听器
32-bit Windows Error: 2: No such file or directory
连接至(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rgb-note)(PORT=1521)))
TNS-12541: TNS：无监听器
TNS-12560: TNS：协议适配器出现错误
TNS-00511: 无监听器
32-bit Windows Error: 61: Unknown error

worldli · 发表于 2005-2-28 14:30

最初由 rgbahnh 发布
[B]LSNRCTL> version
连接至(DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0)))
TNS-12541: TNS：无监听器
TNS-12560: TNS：协议适配器出现错误
TNS-00511: 无监听器
32-bit Windows Error: 2: No such file or directory
连接至(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=rgb-note)(PORT=1521)))
TNS-12541: TNS：无监听器
TNS-12560: TNS：协议适配器出现错误
TNS-00511: 无监听器
32-bit Windows Error: 61: Unknown error [/B]

是因为你没有启动监听，可以在在WINDOWS的服务里把类似于OracleOraHome92TNSListener这样的服务启动起来。
启动监听服务前把检查%ORACLE_HOME%/network/admin/listener.ora文件，以确保所指定的两个数据库所对应的监听端口不相同。

yanggq · 发表于 2005-2-28 14:32

port in listener.ora
& Tnsnames.ora

coolyl · 发表于 2005-2-28 14:38

post listener.ora file

rgbahnh · 发表于 2005-2-28 14:48

# LISTENER.ORA Network Configuration File: D:\oracle\ora81\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
(DESCRIPTION =
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = GEOSOFT1)(PORT = 1521))
   )
   (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
   )
)
  )

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = D:\oracle\ora81)
   (PROGRAM = extproc)
)
(SID_DESC =
   (GLOBAL_DBNAME = DGGIS.GEOSOFT1.GEOSOFT)
   (ORACLE_HOME = D:\oracle\ora81)
   (SID_NAME = DGGIS)
)
(SID_DESC =
   (GLOBAL_DBNAME = tpgismb)
   (ORACLE_HOME = D:\oracle\ora81)
   (SID_NAME = tpgismb)
)
(SID_DESC =
   (GLOBAL_DBNAME = DGMB)
   (ORACLE_HOME = D:\oracle\ora81)
   (SID_NAME = DGMB)
)
(SID_DESC =
   (GLOBAL_DBNAME = zsgis)
   (ORACLE_HOME = D:\oracle\ora81)
   (SID_NAME = zsgis)
)
  )

husthxd · 发表于 2005-2-28 15:04

post the output of lsnrctl>service here.