Document Type | Technical Information
Category | Interface/Integration
Applicable Product Version | 6FS07
Document Number | TIITI008
Overview
This guide explains how to check when DBLink connections disconnect intermittently.
This information is for cases suspected to be caused by firewall/network, timeout settings, etc., rather than link configuration issues.
Method
Increase Client Log Level to Check Logs
Set the client log level to 6.
alter system set _cli_log_level=6;
You can check for IO errors occurring in process_return_code.
[CLI-102] [I] process_return_code:diag[00000002117f7428] errcode[ERROR_IO(-18017)] [CLI-102] [I] I/O ERROR:errcode[ERROR_IO(-18017)] error[No error(0)]
Restore the client log level to the default value of 2.
alter system set _cli_log_level=2 (Default Value)
Attempt Connection Using tbsql sys/tibero@dblink
If connection via @dblink sometimes succeeds and sometimes fails, it is necessary to check the network environment, firewall settings, and other environmental factors.