Problem description:
All oracle accidental error connection timeout, LSNRCTL stop after a few seconds, then LSNRCTL start will be okay,
A, sqlnet. The log report the following error:
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fatal NI connect error 12170.
The VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
NT TCP/IP Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 25 - JUN - 2017 17:52:44
Tracing not turned on.
Tns error struct:
Ns main err code: 12535
TNS - 12535: TNS: operation timed out
Ns secondary err code: 12606
Nt main err code: 0
Nt secondary err code: 0
Nt OS err code: 0
The Client address: (address=(TCP) PROTOCOL=(HOST=10.252.140.91) (36851) PORT=)
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Fatal NI connect error 12170.
The VERSION INFORMATION:
TNS for Linux: Version 11.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
NT TCP/IP Protocol Adapter for Linux: Version 11.2.0.1.0 - Production
Time: 25 - JUN - 2017 17:53:56
Tracing not turned on.
Tns error struct:
Ns main err code: 12535
TNS - 12535: TNS: operation timed out
Ns secondary err code: 12606
Nt main err code: 0
Nt secondary err code: 0
Nt OS err code: 0
The Client address: (address=(TCP) PROTOCOL=(HOST=10.252.140.91) (55450) PORT=)
Two, alert/log. XML has large error log:
Host_addr='10.46.64.251 pid=' 29789 '& gt;
Host_addr='10.46.64.251 pid=' 29817 '& gt;
Host_addr='10.46.64.251 pid=' 29821 '& gt;
Host_addr='10.46.64.251 pid=' 29673 '& gt;
Host_addr='10.46.64.251 pid=' 31964 '& gt;
Three, the relevant configuration:
Sessions: 20000
Process: 20000
# listener. Ora Network Configuration File:/MNT/edus/oracle/product/11.2.0 db_1/Network/admin/listener. Ora
# Generated by Oracle configuration tools.
The LISTENER=
(DESCRIPTION_LIST=
(the DESCRIPTION=
(ADDRESS=(PROTOCOL=IPC) (KEY=EXTPROC1521))
(ADDRESS=(TCP) PROTOCOL=(HOST=iZbp1etmub1n1kbtp0sk8hZ) (1521) PORT=)
)
)
ADR_BASE_LISTENER=/MNT/edus/oracle
INBOUND_CONNECT_TIMEOUT_LISTENER=90
# sqlnet. Ora Network Configuration File:/MNT/edus/oracle/product/11.2.0 db_1/Network/admin/sqlnet ora
# Generated by Oracle configuration tools.
# SQLNET. INBOUND_CONNECT_TIMEOUT=100
SQLNET. EXPIRE_TIME=5
DIAG_ADR_ENABLED=OFF
DIAG_ADR_ENABLED_LISTENER=OFF
SQLNET. INBOUND_CONNECT_TIMEOUT=100
NAMES. DIRECTORY_PATH=(TNSNAMES EZCONNECT)
Sqlnet. Authentication_services=(none)
ADR_BASE=/MNT/edus/oracle
~
# tnsnames. Ora Network Configuration File:/MNT/edus/oracle/product/11.2.0 db_1/Network/admin/tnsnames. Ora
# Generated by Oracle configuration tools.
Former=
(the DESCRIPTION=
(ADDRESS=(TCP) PROTOCOL=(HOST=iZbp1etmub1n1kbtp0sk8hZ) (1521) PORT=)
(CONNECT_DATA=
https://bbs.csdn.net/topics/(=DEDICATED SERVER)
(SERVICE_NAME=former)
)
)
~
CodePudding user response:
When the connection is not on, tnsping former 100, continuous monitoring and network statusCodePudding user response: