针对你提出的错误“ORA-12514 TNS does not currently know of service requested in connect descriptor”,这是Oracle数据库连接中常见的错误,通常表示TNS监听器无法识别连接描述符中请求的服务。以下是根据你的提示提供的详细解决步骤: 确认ORACLE_HOME和TNS_ADMIN环境变量设置正确: 确保你的环境变量中正确设置了ORACL...
Listener refused the connection with the following error:ORA-12514,TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zsl)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=...
示例代码 以下是一个使用.NET框架连接到Oracle数据库的示例代码,演示了如何处理"ORA-12514: TNS:listener does not currently know of service requested"错误: usingSystem;usingSystem.Data;usingOracle.ManagedDataAccess.Client;classProgram{staticvoidMain(){stringconnectionString="Data Source=(DESCRIPTION=(ADDRESS=...
下面是一个简单的Python代码示例,展示了如何解决“listener does not currently know of service”错误: # 导入Listener模块importListener# 创建Listener对象listener=Listener()# 注册服务listener.register_service('my_service')# 进行服务通信service_name='my_service'ifservice_nameinlistener.get_known_services():...
Listener refused the connection with the following error: ORA-12514, TNS:listener does not currently know of service requested in connect descriptor 二、排查过程 1、telenet应用服务器到数据库服务器端口连接正常 2、数据库登陆sqlplus正常 SQL>selectcount(*)fromv$session; ...
Listener refused the connection with the following error:ORA-12514,TNS:listener does not currently know of service requested in connect descriptor The Connection descriptor used by the client was:(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=zsl)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=...
dataguard ORA-12514: TNS:listener does not currently know of service requested in connect descriptor 错误的意思是listener 不知道连接解析器中的请求服务,这里要说静态监听和动态监听了 动态注册是在instance启动的时候PMON进程根据init.ora中的instance_name,service_names两个参数将实例和服务动态注册到listener中...
ORA-12514, TNS:listener does not currently know of service requested in connect descriptor The datasource URL string has the format below1 Raw jdbc:oracle:thin:@(description=(address_list=(load_balance=off)(failover=on)(address=(protocol=tcp)(host=abc2)(port=1536))(address=(protocol=tcp)(...
ORA-12514,TNS：listenerdoesnotcurrentlyknowofs。。。今天使⽤SQL Developer连接⼀台测试服务器数据库（ORACLE 11g）时，遇到了“ORA-12514, TNS:listener does not currently know of service requested in connect descriptor”错误，具体提⽰如下所⽰：执⾏请求的操作时遇到错误:Listener refused the ...
1.首先默认的oracle配置文件中tnsnames.ora和listener.ora中默认监听的地址是localhost,如果删除了/etc/hosts中localhost的映射也会出现这个问题。 2.手动的修改listener.org和tnsnames.org文件 日志:/opt/oracle/product/11.2.0/dbhome_1/listener.log 解决方案 首先确定Oracle的安装位置: /opt/oracle/product/11.2.0...