|
需要连接的是12c的一个pdb数据库,服务器和客户端在不同的网络域,对数据库scan_ip做了映射。
在客户机 telnet 1521 端口可以通,tnsping 也可以通,但是使用sqlplus 连接会超时失败。
唐老师这种情况会是什么原因引起的?
[oracle@x86-mss-shitangdb ~]$ tnsping fj_rest
TNS Ping Utility for Linux: Version 11.2.0.4.0 - Production on 07-DEC-2017 16:43:53
Copyright (c) 1997, 2013, Oracle. All rights reserved.
Used parameter files:
/opt/app/oracle/product/11.2.0/db_1/network/admin/sqlnet.ora
Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.53.160.147)(PORT = 1521))) (CONNECT_DATA = (service_name = fj_rest_pri)))
OK (10 msec)
SQL*Plus: Release 11.2.0.4.0 Production on Thu Dec 7 16:43:57 2017
Copyright (c) 1982, 2013, Oracle. All rights reserved.
ERROR:
ORA-12170: TNS:Connect timeout occurred
|
|