使用plsql或者navicat连接本地数据库出现ORA-12514错误解决

ゝ一世哀愁。 2022-05-24 11:14 699阅读 0赞

经过查询发现需要配置监听文件：

D:\\ITSoft\\oracle\\product\\11.2.0\\dbhome\_1\\NETWORK\\ADMIN\\listener.ora

原先文件:

# listener.ora Network Configuration File: D:\ITSoft\oracle\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:\ITSoft\oracle\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:D:\ITSoft\oracle\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:\ITSoft\oracle

后来更改为（更改后需要重启oracle监听服务）：

# listener.ora Network Configuration File: D:\ITSoft\oracle\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:\ITSoft\oracle\product\11.2.0\dbhome_1)
          (PROGRAM = extproc)
          (ENVS = "EXTPROC_DLLS=ONLY:D:\ITSoft\oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
        )
    	#增加内容
    	(SID_DESC = 
          (GLOBAL_DBNAME = orcl) 
          (ORACLE_HOME = D:\ITSoft\oracle\product\11.2.0\dbhome_1) 
          (SID_NAME = orcl) 
        ) 
      )
    
    LISTENER =
      (DESCRIPTION_LIST =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
          (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
        )
      )
    
    ADR_BASE_LISTENER = D:\ITSoft\oracle

解决问题。希望能帮助到大家！！！

这是我的数据库信息：

![20180525235203332][]

[20180525235203332]: /images/20220524/42f23cf35a474b6ab43168dad9c70405.png