环境:两个node 10.2.0.5 rac 环境。linux REHL5.4平台。
现有个问题:客户端比如使用sqlplus等连接上数据库后,窗口空闲比如30分钟以后,去执行任何sql时,窗口会hang至少10秒,然后才报ora-03135错误。
接着我再立即又执行任何sql,一切正常。。。
有什么地方需要设置吗?
db1 ~]$ cat /app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora.db1 Network Configuration File: /app/oracle/product/10.2.0/db_1/network/admin/listener.ora.db1
# Generated by Oracle configuration tools.
LISTENER_DB1 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.2.43)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
db2 ~]$ cat /app/oracle/product/10.2.0/db_1/network/admin/listener.ora
# listener.ora.db2 Network Configuration File: /app/oracle/product/10.2.0/db_1/network/admin/listener.ora.db2
# Generated by Oracle configuration tools.
LISTENER_DB2 =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.31.2.46)(PORT = 1521)(IP = FIRST))
)
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
)
)
)
Client tnsname配置:
SOA =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = db1-vip)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = db2-vip)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = soa)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)