cx_Oracle.DatabaseError: ORA-12170: TNS:Connect timeout occurred错误处理一则
今早想学习cx_Oracle模块,结果错误不期而遇
[oracle@Ora10G admin]$ tnsping orclTNS Ping Utility for Linux: Version 10.2.0.1.0 - Production on 08-SEP-2013 10:31:10Copyright (c) 1997, 2005, Oracle. All rights reserved.Used parameter files:Used HOSTNAME adapter to resolve the aliasAttempting to contact (DESCRIPTION=(CONNECT_DATA=(SERVICE_NAME=orcl.bogon))(ADDRESS=(PROTOCOL=TCP)(HOST=220.250.64.30)(PORT=1521)))
tnsping不通、必然是因为tnsname.ora文件出问题
令人郁闷的是tnsname.ora排查没问题、/etc/hosts排查也没问题、抓狂ing
搞了一早上,竟然是tnsnames.ora被我写成tnsname.ora、
细节决定成败!
By DBA_WaterBin
2013-09-08
good luck
- 1楼Wentasy昨天 18:35
- 拼写问题是很常见的,多怀疑下自己写得是否正确。最后那就话看似平常,真正遇到了才知道是真知!
- Re: linwaterbin昨天 23:57
- 回复Wentasyn太马虎了,