Oracle监听启动不了...HOST没错...

ChinaUnixAdm1n

我昨天安装了Oracle10g. 并且将对应的服务都设置为手动.
今天我启动Oracle服务.发现其监听启动不了.

上网查了点资料,也没有解决..只要到这里来请教高手了.
我的listener.ora如下,其中Rooock是我的电脑名
SQL code
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = E:\DB\Oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
  )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
      (ADDRESS = (PROTOCOL = TCP)(HOST = Rooock)(PORT = 1521))
    )
  )



另外说下,我的环境变量是:
HTML code
ORACLE_BASE=E:\DB\Oracle\product\10.2.0


HTML code
ORACLE_HOME=E:\DB\Oracle\product\10.2.0\db_1



在cmd下使用lsnrctl start命令得到如下信息:
SQL code
Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Message 1070 not found; No message file for product=NETWORK, facility=TNSTNS-12557: Message 12557 not found;
No message file for product=NETWORK, facility=TNS
TNS-12560: Message 12560 not found; No message file for product=NETWORK, facility=TNS
  TNS-00527: Message 527 not found; No message file for product=NETWORK, facility=TNS



如果使用tnsping Rooock命令的话(Rooock是我电脑名):
SQL code
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on 17-APR-2009 20:54:31

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage 3512 not found;
No message file for product=NETWORK, facility=TNSAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERV
ICE_NAME=Rooock))(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.85)(PORT=1521)))
TNS-12557: Message 12557 not found; No message file for product=NETWORK, facility=TNS



请问这是什么原因.我不太熟悉Oracle.  No message file for product=NETWORK, facility=TNS是什么意思??

rainyuers

因为你的TNS配置有问题，tnsnames.ora这个文件你是怎么配置的？

[ 本帖最后由 rainyuers 于 2009-4-18 11:08 编辑 ]

blue_stone

system32\drivers\etc\hosts文件中有主机名么?
Message 12560 not found可能和环境变量,或注册表有关.
删除listener.ora文件看看能否启动监听

[ 本帖最后由 blue_stone 于 2009-4-20 16:14 编辑 ]

snail506891

重新配置tnsnames.ora