TCP 长连接网络中断后,即使网络恢复了也无法使用该连接

# -*- coding:utf-8 -*-
# !/usr/bin/python
import cx_Oracle
import time
conn = cx_Oracle.connect('test/test@192.168.137.3/serv')
cursor = conn.cursor()
xsql="select * from p900 a "
while True:
 try :
  r = cursor.execute(xsql)
  result = cursor.fetchall()
  print(result)
  time.sleep(1)
 except:
  time.sleep(1)
  print '2222222222'
  
  
 即使数据库网络恢复,语病也没法使用