oracle 数据库常见错误

朱雀 2021-02-12 17:44 597阅读 0赞

**1. 安装启动 PL/SQL 错误**

**eg:**

## ORA-12514 TNS 监听程序当前无法识别连接描述符中请求服务 的解决方法 ##

**解决方法：**

修改文件

D:\\app\\Feihong247\\product\\11.2.0\\dbhome\_1\\NETWORK\\ADMIN\\listener.ora

如下：

源文件：

# listener.ora Network Configuration File: D:\app\Feihong247\product\11.2.0\dbhome_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    
    SID_LIST_LISTENER =
      (SID_LIST =
    
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = D:\app\Feihong247\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Feihong247\product\11.2.0\dbhome_1\bin\oraclr11.dll")
        )
      )
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = D:\app\Feihong247

修改为：

# listener.ora Network Configuration File: D:\app\Feihong247\product\11.2.0\dbhome_1\network\admin\listener.ora
    # Generated by Oracle configuration tools.
    
    SID_LIST_LISTENER =
      (SID_LIST =
    	
          (SID_DESC =
          (GLOBAL_DBNAME = ORCL)
          (ORACLE_HOME = D:\app\Feihong247\product\11.2.0\dbhome_1)
          (SID_NAME = ORCL)
          )
    
        (SID_DESC =
          (SID_NAME = CLRExtProc)
          (ORACLE_HOME = D:\app\Feihong247\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:D:\app\Feihong247\product\11.2.0\dbhome_1\bin\oraclr11.dll")
        )
      )
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = D:\app\Feihong247

然后重新启动oracle的监听服务即可重新使用PL/SQL。