您的位置: 首页 > 文章 > 解决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问题,亲测有效 分类: 文章 • 2024-10-04 10:30:16 使用Navicat连接Oracle数据库时,报错ORA-12514:TNS:listener does not currently know of service requested in connect descriptor,如下 经过几番检查,发现主机、端口号、用户名和密码都是正确的,剩下只有服务名没有检查。在Navicat连接Oracle时,服务名默认是ORCL,然后我通过终端连接Oracle,进入后执行 select global_name from global_name; 语句查询Oracle的服务名发现: 之后把Navicat连接Oracle时默认的服务名改为XE,连接成功!