oracle11g首先报监听程序配置错误，然后报listener does not currently know of SID given in connect descriptor

   今天安装oracle后，开始启动很好，但是过一段时间重启电脑后，发现再连接时：

                             Io 异常: The Network Adapter could not establish the connection

   我的做法是 1.先关闭了防火墙，发现还是不能启动监听!

                    2.查看注册表，imagePath正确

                    3.找到E:/app/sence/product/11.1.0/db_1/NETWORK/ADMIN/listener.ora，E:/app/sence/product/11.1.0/db_1/network/admin/tnsnames.ora将

 # listener.ora Network Configuration File: E:/app/sence/product/11.1.0/db_1/network/admin/listener.ora
 # Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

  

 # tnsnames.ora Network Configuration File: E:/app/sence/product/11.1.0/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

 中的Host修改为 localhost

 

 搞定后lsnrctl reload 重启监听，发现监听程序可以启动了 

 

然后连接数据库时 又发现：listener does not currently know of SID given in connect descriptor 异常

 

于是再次修改E:/app/sence/product/11.1.0/db_1/NETWORK/ADMIN/listener.ora 添加SID description

 

# listener.ora Network Configuration File: E:/app/sence/product/11.1.0/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.

SID_LIST_LISTENER =
        (SID_LIST =
            (SID_DESC =
                   (GLOBAL_DBNAME = orcl)
                   (ORACLE_HOME = /app/sence/product/11.1.0/db_1)
                   (SID_NAME = orcl)
            )
        )

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    )
  )

红色的三处根据自己的数据库名和安装路径写好

重启监听，OK (修改文件 例行重启)

试运行项目  发现 OK！

搞定 收工   说起来简单  呵呵~~其实花一下午！

贴出来给遇到相同情况的开发路上的同志提供点办法~~希望能帮到你们  00^_^