Oracle9iforLinux出现ORA-12541

关键的两个文件

$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/下即可