【FAQ】ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

小咪咪 2022-08-31 14:28 8阅读 0赞

## 需求来源 ##

oracle连通性问题

--------------------

## 问题一 ##

ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

## 解决方式 ##

1、联系数据库dba；  
2、看看是不是监听服务没有起来，这个错误是因为Listener出了问题，请检查一下你的listener.ora文件；

SID_LIST_LISTENER = 
     (SID_LIST =  
           (SID_DESC =   
                   (SID_NAME = PLSExtProc)    
                   (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)   
                   (PROGRAM = extproc)
             )
    )

如果说是这样，那么请将一段改成

SID_LIST_LISTENER =
       (SID_LIST =
                  (SID_DESC = 
                            (SID_NAME = PLSExtProc)
                            (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)  
                            (PROGRAM = extproc)  )
                            (SID_DESC =    
                                     (GLOBAL_DBNAME = ORCL)
                                     (ORACLE_HOME = E:\oracle\product\10.2.0\db_1)   
                                      (SID_NAME = ORCL) 
                  )
     )

3、检查有没有修改IP地址,计算机名称。oracle安装目录，一般都是这样的 home\\oracle\\product\\10.1.0\\Db\_1\\NETWORK\\ADMIN下的tnsnames.ora文件

(DESCRIPTION =  
             (ADDRESS_LIST =     
                       (ADDRESS = 
                                (PROTOCOL = TCP)
                                (HOST = "你的IP")
                                (PORT = 1521)
                        )
               )
               (CONNECT_DATA =     
               (SERVICE_NAME = "你要连接的数据库名")   
                ) 
    )

--------------------

## 问题二 ##

Oracle数据库无法连接，报IO 错误: The Network Adapter could not establish the connection

## 解决方式 ##

1、联系数据库dba；  
2、核实数据库IP、账号密码是否有变更。

--------------------

## 参考文章 ##

[ORA-12514: TNS:listener does not currently know of service requested in connect descriptor][ORA-12514_ TNS_listener does not currently know of service requested in connect descriptor]

[ORA-12514_ TNS_listener does not currently know of service requested in connect descriptor]: http://blog.sina.com.cn/s/blog_7c0e26230100t0ci.html

【FAQ】ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

发表评论取消回复

还没有评论，来说两句吧...

相关阅读

相关 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

相关 ORA-12514, TNS:listener does not currently know of service requested in connect descriptor

相关错误信息 “ORA-12514: TNS:listener does not currently know of service requested in connect descriptor“

相关 ORA-12514:TNS:listener does not currently know of service requested in connect descriptor

相关 Oracle 出现问题：ORA_12514:TNS:listener does not currently know of service requested in connect 解决方案

相关 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

相关【FAQ】ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

相关 ORA-12514: TNS:listener does not currently know of service requested in connect descriptor

相关 ORA-12514: TNS:listener does not currently know of service requested in connect descri

相关 ORA-12505, TNS:listener does not currently know of SID given in connect descriptor