Home > database >  A great god, please help see Oracle11.2 accidental connection timeout
A great god, please help see Oracle11.2 accidental connection timeout

Time:09-28

Great god door, rookie polite, please help to see how to solve:

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:
Type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
Host_addr='10.46.64.251 pid=' 29789 '& gt;
WARNING: the inbound connection timed out (ORA - 3136)


Type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
Host_addr='10.46.64.251 pid=' 29817 '& gt;
WARNING: the inbound connection timed out (ORA - 3136)


Type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
Host_addr='10.46.64.251 pid=' 29821 '& gt;
WARNING: the inbound connection timed out (ORA - 3136)


Type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
Host_addr='10.46.64.251 pid=' 29673 '& gt;
WARNING: the inbound connection timed out (ORA - 3136)


Type='UNKNOWN' level='16' host_id='iZbp1etmub1n1kbtp0sk8hZ'
Host_addr='10.46.64.251 pid=' 31964 '& gt;
WARNING: the inbound connection timed out (ORA - 3136)



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:

Have never met, you can try PING for a period of time to see if the network has a problem

CodePudding user response:

Test the network, to see how the stability of the network
  • Related