TNS-12535,TNS-00505 Operation timed out

TNS-12535,TNS-00505 Operation timed out

در زمان مشاهده  خطای زیر در Alertlog می بایست اقدامات زیر را انجام داد:

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 – Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 – Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 – Production
Time: 06-APR-2015 12:38:46
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0

برای حل مشکل بالا می بایست پارامتر های SQLNET.INBOUND_CONNECT_TIMEOUTوTIMEOUTوSQLNET.EXPIRE_TIME در فایل sqlnet.ora مقدار دهی شود:

cat /u01/app/oracle/product/11.2.0.3/dbhome_1/network/admin/sqlnet.ora

SQLNET.EXPIRE_TIME=10

SQLNET.INBOUND_CONNECT_TIMEOUT=2000

DIAG_ADR_ENABLED_<listener_name>=OFF  (in listener.ora)

DIAG_ADR_ENABLED=OFF (in sqlnet.ora)

IN ENGLISH

The following error is reported in the database alert log.

Fatal NI connect error 12170.

VERSION INFORMATION:
TNS for 64-bit Windows: Version 11.2.0.4.0 – Production
Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 – Production
Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 11.2.0.4.0 – Production
Time: 06-APR-2015 12:38:46
Tracing not turned on.
Tns error struct:
ns main err code: 12535

TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505

TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0

SOLUTION

The non-Oracle solution would be to remove or increase the firewall setting for maximum idle time.  In cases where this is not feasible, Oracle offers the following suggestion:

The following parameter, set at the **RDBMS_HOME/network/admin/sqlnet.ora, can resolve this kind of problem. DCD or SQLNET.EXPIRE_TIME can mimic data transmission between the server and the client during long periods of idle time.

Cat /u01/app/oracle/product/11.2.0.3/dbhome_1/network/admin/sqlnet.ora

SQLNET.EXPIRE_TIME=10

SQLNET.INBOUND_CONNECT_TIMEOUT=2000

DIAG_ADR_ENABLED_<listener_name>=OFF  (in listener.ora)

DIAG_ADR_ENABLED=OFF (in sqlnet.ora)

با احترام

محسن

دیدگاهتان را بنویسید

نشانی ایمیل شما منتشر نخواهد شد. بخش‌های موردنیاز علامت‌گذاری شده‌اند *