您现在的位置:速学网教学教育考试频道计算机考试ORACLE/CIW认证Oracle9iforLinux出现ORA-12541» 正文

Oracle9iforLinux出现ORA-12541

[01-23 15:54:13]   来源:http://www.suxue6.com  ORACLE/CIW认证   阅读:8897

概要: 关键的两个文件: $ORACLE_HOME/network/admin/listener.ora $ORACLE_BASE/config/9.2.0.4/tnsnames.ora 当出现这个提示时首先检查:(1)$ORACLE_HOME/network/admin/listener.ora是否缺少监听器的SID_LIST描述项,以下是一个样本(netca真是奇怪,不会自动添加SID_LIST的描述项): SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /opt/oracle/product/9.2.0.4) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = SAMPLE.COM) (ORACLE_HOME = /opt/oracle/product/9.2.0.4) (SID_NAME = SAMPLE) ) ) LISTENER = (DESCRIPTION_LIST = (DESCRIP...
Oracle9iforLinux出现ORA-12541,标签:ciw认证考试,oracle认证,http://www.suxue6.com

    关键的两个文件:
  $ORACLE_HOME/network/admin/listener.ora
  $ORACLE_BASE/config/9.2.0.4/tnsnames.ora
  当出现这个提示时首先检查:(1)$ORACLE_HOME/network/admin/listener.ora是否缺少监听器的SID_LIST描述项,以下是一个样本(netca真是奇怪,不会自动添加SID_LIST的描述项):
  SID_LIST_LISTENER =
  (SID_LIST =
  (SID_DESC =
  (SID_NAME = PLSExtProc)
  (ORACLE_HOME = /opt/oracle/product/9.2.0.4)
  (PROGRAM = extproc)
  )
  (SID_DESC =
  (GLOBAL_DBNAME = SAMPLE.COM)
  (ORACLE_HOME = /opt/oracle/product/9.2.0.4)
  (SID_NAME = SAMPLE)
  )
  )
  LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = tcy.com)(PORT = 1521))
  )
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
  )
  )
  )
  (2) 如果以上文件无误,当使用dbastudio时还出现ORA-12541: TNS:no listener,那么将$ORACLE_HOME/network/admin/tnsnames.ora复制到$ORACLE_BASE /config/9.2.0.4下即可。


Tag:ORACLE/CIW认证ciw认证考试,oracle认证考试频道 - 计算机考试 - ORACLE/CIW认证

Copyright 速学网 © 版权所有 All Rights Reserved.

1 2 3 4 5 6