使用Navicat连接Oracle数据库时,报错ORA-12514:TNS:listener does not currently know of service requested in connect descriptor,如下 经过几番检查,发现主机、端口号、用户名和密码都是正确的,剩下只有服务名没有检查。在Navicat连接Oracle时,服务名默认是ORCL,然后我通过终端连接Oracle,进入后执行
解决ORA-12514:TNS:listener does not currently know of service requested in connect descriptor问题,亲测有效
使用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