日期:2014-05-17 浏览次数:20877 次
LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = peng-VAIO)(PORT = 1521))
  [color=#FF0000] (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) [/color]
  )
  )
--把所有oracle相关服务都启动,看看是不是有的服务是手动启动的,关了电脑后服务就关闭了!
--还有如果你DB是关闭状态,把下面这段加的监听中就可以了
SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = G:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
   (SID_DESC =
    (GLOBAL_DBNAME = ORCL)
    (ORACLE_HOME = G:\oracle\product\10.2.0\db_1)  
    (SID_NAME = ORCL)
    )
  )
------解决方案--------------------
参考这篇文章:http://blog.csdn.net/luiseradl/article/details/7064916