Status : Test failed: IO Error: Got minus one from a read call, connect laps 3 sec...authentication laps 0 ms.

This document describes how to fix database connectivity issue when we try to connect database using sql developer.

Error: Status : Test failed: IO Error: Got minus one from a read call, connect laps 3 sec...authentication laps 0 ms.

Cause and Solution:

tcp.validnode_checking is set to yes in sqlnet.ora is causing the issue in standalone database. Set the value to no and bounce the listener. Retest the issue.

[oracle@ebsdb PROD_ebsdb]$ cat sqlnet.ora
###############################################################
#
# Do not edit settings in this file manually. They are managed
# automatically and will be overwritten when AutoConfig runs.
# For more information about AutoConfig, refer to the Oracle
# E-Business Suite Setup Guide.
#
#$Header: NetServiceHandler.java 120.28.12020000.4 2013/12/04 10:30:05 sbandla ship $
#
###############################################################

NAMES.DIRECTORY_PATH=(TNSNAMES, ONAMES, HOSTNAME)
SQLNET.EXPIRE_TIME= 10
tcp.validnode_checking = no
tcp.invited_nodes=(EBSDB.apps.com, EBSAPPS.apps.com)
SQLNET.INBOUND_CONNECT_TIMEOUT =60
DIAG_ADR_ENABLED=ON
ADR_BASE=/u01/app/oracle/11.2.0/admin/PROD_ebsdb
SEC_USER_AUDIT_ACTION_BANNER = /u01/app/oracle/11.2.0/appsutil/template/txkDBSecUserAuditActionBanner.txt


Reload the listener:

[oracle@ebsdb PROD_ebsdb]$ lsnrctl reload PROD

LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 22-SEP-2018 12:51:56

Copyright (c) 1991, 2011, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebsdb.apps.com)(PORT=1521)))
The command completed successfully

[oracle@ebsdb PROD_ebsdb]$

Retest the issue:

Thanks for your patience to view this post.....................

How to submit "Active Users" report in R12 to validate applicatioins

This document describes how to submit "Active Users" request to validate Oracle Applications. This is a part of pre and post validation of oracle applications when we do any maintenance activity.


Step 1: Find application URL

Login to database as APPS and find the url to login oracle applications

SQL> show parameter db_name

NAME      TYPE VALUE
------------------------------------ ----------- ------------------------------
db_name      string PROD

SQL> show user
USER is "APPS"

SQL> select home_url from icx_parameters;

HOME_URL
--------------------------------------------------------------------------------
http://ebsapps.apps.com:8000/OA_HTML/AppsLogin

Step 2: Login to oracle applications using sysadmin account.

Login oracle applications using sysadmin account using above url.

Step 3: Submit "Active Users" request using System Administrator responsibility.

Navigation: System Administrator --> Concurrent --> Requests

Click on "Submit a New Request", select "Single Request" and click OK

Select  "Active Users" from drop down menu and click on submit.

Click on OK

Write down Requested ID and click on "No"

Step 4: Find the request status and should be able to open log and out files once request completes.

Select "Specific Request" and provide request number and click on "Find"

Click on "View Oupput"and "View  log" buttons to verify.

Thanks for your patience to go through the blog.........

FRM-92101: There was a failure in the Forms Server during startup. This could happen due to invalid configuration in R12.2 fresh installation

This document describes how to fix forms in R12.2 fresh installation.

Error: Getting below error when launch the forms.

####<Sep 17, 2018 8:50:22 AM IST> <Info> <ServletContext-/forms> <ebsapps.apps.com> <forms_server1> <[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005TWYbFL1dF8DWFLzBT8A00037300005V> <1537154422191> <BEA-000000> <Forms session <4> aborted: runtime process failed during startup with errors frmweb: error while loading shared libraries: libXm.so.2: cannot open shared object file: No such file or directory

> 

####<Sep 17, 2018 8:50:22 AM IST> <Error> <ServletContext-/forms> <ebsapps.apps.com> <forms_server1> <[ACTIVE] ExecuteThread: '21' for queue: 'weblogic.kernel.Default (self-tuning)'> <<anonymous>> <> <005TWYbFL1dF8DWFLzBT8A00037300005V> <1537154422193> <BEA-000000> <Forms session <4> exception stack trace: 

oracle.forms.engine.RunformException: Forms session <4> failed during startup: no response from runtime process

at oracle.forms.servlet.RunformProcess.connect(Unknown Source)

at oracle.forms.servlet.RunformProcess.dataToRunform(Unknown Source)

at oracle.forms.servlet.RunformSession.dataToRunform(Unknown Source)

at oracle.forms.servlet.ListenerServlet.doPost(Unknown Source)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:727)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)

at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)

at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)

at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:301)

at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)

at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:119)

at java.security.AccessController.doPrivileged(Native Method)

at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:324)

at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:460)

at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:103)

at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:171)

at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)

at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:163)

at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:60)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3748)

at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3714)

at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)

at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)

at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2283)

at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2182)

at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1491)

at weblogic.work.ExecuteThread.execute(ESxecuteThread.java:256)

at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)

Cause and Solution: Missing below mentioned RPM. Please install the RPM and retest the issue.

openmotif21-2.1.30-8.i386.rpm

[root@ebsapps RPMs]# rpm -ivh openmotif21-2.1.30-8.i386.rpm

warning: openmotif21-2.1.30-8.i386.rpm: Header V3 DSA/SHA1 Signature, key ID 73307de6: NOKEY

Preparing...                ########################################### [100%]

   1:openmotif21            ########################################### [100%]

[root@ebsapps RPMs]# 

Validation:

Thanks for your patience to view this post............