Hi Guys,

   I have issue after apply command sqlnet.ora, in network ping normally no loss connect.

Because, I found that log on oracle ifs sometime  time out to database

Fatal NI connect error 12170.

  VERSION INFORMATION:
    TNS for 64-bit Windows: Version 12.1.0.2.0 - Production
    Oracle Bequeath NT Protocol Adapter for 64-bit Windows: Version 12.1.0.2.0 - Production
    Windows NT TCP/IP NT Protocol Adapter for 64-bit Windows: Version 12.1.0.2.0 - Production
  Time: 26-AUG-2024 20:50:16
  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
  Client address: (ADDRESS=(PROTOCOL=tcp)(HOST=x.x.x.x)(PORT=61952))
Mon Aug 26 20:50:17 2024

and i fix by sqlnet.ora and no reboot ifs application

# sqlnet.ora Network Configuration File
# This file is generated by Oracle configuration tools.

SQLNET.INBOUND_CONNECT_TIMEOUT = 120
SQLNET.SEND_TIMEOUT = 30
SQLNET.RECV_TIMEOUT = 30
SQLNET.EXPIRE_TIME = 10
TCP.CONNECT_TIMEOUT = 10

Error Log

Ifs.Fnd.FndSystemException: Explorer: A fatal error occurred. Application will terminate. Sorry for any inconvenience. ---> Ifs.Fnd.FndSystemException: Unexpected error while calling server method AccessPlsql/Invoke ---> Ifs.Fnd.FndServerFaultException: DB_SWITCH_SESSION:Could not switch database proxy session to user oIFSAPP]: No more data to read from socket

No more data to read from socket

   at Ifs.Fnd.AccessProvider.FndConnection.ParseErrorHeader(FndBuffer buffer, FndManualDecisionCollection decisions)

   at Ifs.Fnd.AccessProvider.FndConnection.UnMarshalResponseHeader(Stream responseStream, FndManualDecisionCollection decisions)

   at Ifs.Fnd.AccessProvider.FndConnection.HandleHttpSuccessResult(HttpWebResponse result, FndManualDecisionCollection decisions, String operation, FndBodyType responseBodyType, Object responseBody)

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(Object requestBody, Object responseBody, String intface, String operation, FndRequestContext requestContext, FndManualDecisionCollection decisions, Boolean forcedSync)

   --- End of inner exception stack trace ---

   at Ifs.Fnd.AccessProvider.FndConnection.InvokeInternal(String intface, String operation, Object requestBody, Object responseBody, FndRequestContext requestContext, Boolean forcedSync)

   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommandCollection.Invoke()

   at Ifs.Fnd.AccessProvider.PLSQL.FndPLSQLCommand.ExecuteNonQuery()

   at Ifs.Fnd.ApplicationRuntime.Core.FndApplication.InitializeSystemSettingsFromServer()

   at Ifs.Fnd.ApplicationRuntime.Core.FndApplication.StartupApplication()

   --- End of inner exception stack trace ---

Thank you