oracle啟動、停止問題

68930089

各位請問一下若啟動或停止oracle時出現下列文字且停止，是那裡出了問題呢?
麻煩各位前輩幫我解決一下謝謝。

[oracle@SAMS bin]$ lsnrctl stop

LSNRCTL for Linux: Version 9.2.0.4.0 - Production on 01-SEP-2004 10:22:05

Copyright (c) 1991, 2002, Oracle Corporation.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC)))

valuechina

没有出现：The command completed successfully？

hming2000

应该是你的监听配置有问题
先检查一下你的监听文件listener.ora,重要的看看你的ora_sid和address是否正确。

68930089

設定內容如下：SID：SAMS IP：172.27.10.39 可以麻煩幫我確認一下那
裡有錯誤嗎?

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 172.27.10.39 )(PORT = 1521))
      )
    )
  )

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = /opt/oracle/product/9.2.0.4.0)
      (PROGRAM = extproc)
    )
(SID_DESC =
      (GLOBAL_DBNAME = SAMS)
      (ORACLE_HOME = /opt/oracle/product/9.2.0.4.0)
      (SID_NAME = SAMS)
    )
  )

TRACE_LEVEL_LISTENER=OFF
TRACE_FILE_LISTENER = "listener"
LOG_FILE_LISTENER = "listener"
CONNECT_TIMEOUT_LISTENER = 10
STOP_LISTENER = YES
DBA_GROUP = dba