蒸小金瓜的做法大全:ORACLE 10G 连不上服务器,ERROR - ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务

来源：百度文库编辑：九乡新闻网时间：2024/04/29 04:42:23

前些天装好ORACLE 正常使用，但是今天启动连不上了, TNSPING 也能通，sqlplus能够登陆，但是NET ASSITANT 测试不通，解决如下：

1. Open the ""/network/admin/listener.ora" file in the host,and you will see:
   SID_LIST_LISTENER =
   (SID_LIST =
     (SID_DESC =
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
       (PROGRAM = extproc)
     )
   )
2. Add the following lines after the 7th line in the above
            (SID_DESC =
       (GLOBAL_DBNAME = ORACLE)
       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
       (SID_NAME = ORACLE)
      )
3. At last the content of the file become to the following section:
SID_LIST_LISTENER =
   (SID_LIST =
     (SID_DESC =
       (SID_NAME = PLSExtProc)
       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
       (PROGRAM = extproc)
     )
     (SID_DESC =
       (GLOBAL_DBNAME = ORACLE)
       (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
       (SID_NAME = ORACLE)
      )
   )
4. Save the file and restart the TNSListener service in the host. That's OK !  我现在的监听文件# listener.ora Network Configuration File: c:\oracle\product\10.2.0\db_1\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.SID_LIST_LISTENER =
(SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
      (PROGRAM = extproc)
    )
    (SID_DESC =
       (GLOBAL_DBNAME = orcl)
       (ORACLE_HOME = c:\oracle\product\10.2.0\db_1)
       (SID_NAME = orcl)
      )
)LISTENER =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)

ORACLE 10G 连不上服务器,ERROR - ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务 navicat连接oracle的错误：ora-12737：instant client l... 共享服务器-----连接Oracle 专用服务器----连接Oracle 双机负载rac ORA-12170: TNS: 连接超时问题 PL/SQL连接oracle服务器的连接串的书写 Ftp无法连接服务器的原因 Ftp无法连接服务器的原因关于 "服务器正在运行中，由于另一个程序正在运行中，此操作无法完成" 问题的解决 SQL Server中访问Oracle服务器的方法服务程序需要当前用户权限的方法（？） oracle的远程连接固定oracle 10g 的IP地址 ORA-12557: TNS:protocol adapter not loadable ORA-00257: archiver error ORA-00020 ORA-16038的解决(日志无法归档) Oracle 数据库监听配置 Oracle数据库监听配置 Oracle数据库监听配置 Oracle 启动监听命令新装外汇网上核销系统时，出现“无法连接服务器”时的操作 10G RAC DBCA报错 ORA-27504问题的解决 iis服务无法及时响应启动或控制请求 oracle 10g table shrink