熱點推薦:
您现在的位置: 電腦知識網 >> 編程 >> Oracle >> 正文

Oracle9iforLinux出現ORA-12541

2013-11-13 22:23:32  來源: Oracle 

  關鍵的兩個文件

  $ORACLE_HOME/network/admin/listenerora

  $ORACLE_BASE/config//tnsnamesora

  當出現這個提示時首先檢查)$ORACLE_HOME/network/admin/listenerora是否缺少監聽器的SID_LIST描述項以下是一個樣本(netca真是奇怪不會自動添加SID_LIST的描述項)

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

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

    () 如果以上文件無誤當使用dbastudio時還出現ORA TNSno listener那麼將$ORACLE_HOME/network/admin/tnsnamesora復制到$ORACLE_BASE /config/下即可
From:http://tw.wingwit.com/Article/program/Oracle/201311/18971.html
  • 上一篇文章:

  • 下一篇文章:
  • 推薦文章
    Copyright © 2005-2013 電腦知識網 Computer Knowledge   All rights reserved.