lsnrctl start啟動出錯﹐提示如下﹐請問是什麼原因

jerryzjp · 发表于 2005-1-12 17:41

最初由 blue_prince10 发布
[B]正常的listener.ora应该是这样的：
# LISTENER.ORA Network Configuration File: D:\oracle\ora92\network\admin\listener.ora
# Generated by Oracle configuration tools.

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

SID_LIST_LISTENER =
  (SID_LIST =
(SID_DESC =
   (SID_NAME = PLSExtProc)
   (ORACLE_HOME = D:\oracle\ora92)
   (PROGRAM = extproc)
)
  (SID_DESC =
   (GLOBAL_DBNAME = XUE)
   (ORACLE_HOME = D:\oracle\ora92)
   (SID_NAME = XUE)
)
  )
后面那个SID_DESC表示监听器监听的数据库名称。 [/B]

\識過了不行﹐格式不正確

jerryzjp · 发表于 2005-1-12 17:42

有創建數據庫﹐用SQLPLUS可以啟動

blue_prince10 · 发表于 2005-1-12 17:43

你那台机器我猜是根本没有创建过数据库，否则你的LISTENER不会是那样。你把你完整的LISTENER。LOG贴上来看一下吧。

husthxd · 发表于 2005-1-12 17:46

10g把?
监听器配置文件中
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\oracle\ora92)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_DBNAME = XUE)
(ORACLE_HOME = D:\oracle\ora92)
(SID_NAME = XUE)
)
)
这部分可以不需要.
实例会自动注册到监听器上.
手工注册监听:
sql>alter system register;

blue_prince10 · 发表于 2005-1-12 17:58

不好意思，没看清平台，10G还没模过：（

jerryzjp · 发表于 2005-1-13 08:52

那咝衐bstart後數據庫怎麼沒能啟動

jerryzjp · 发表于 2005-1-13 09:12

在系統重啟時咝衧udo -u oracle /opt/oracle/bin/lsnrctl start
sudo -u oracle /opt/oracle/bin/dbstart後數據庫為什麼不能啟動