Wednesday, July 1, 2015

12.2.4 Upgrade Patch has been Hang due to error java.sql.SQLRecoverableException: IO Error: Got minus one from a read call

Patch Error: workerlog shows below error
While applying the upgrade patch of 12.2.4 am getting below error. 

Reading product information from file... 

Reading language and territory information from file... 

Reading language information from applUS.txt ... 
Temporarily resetting CLASSPATH to: 
"/apps/dba1mgr/VISAPPL/fs1/EBSapps/appl/ad/12.0.0/java/adjava.zip:/apps/dba1mgr/VISAPPL/fs1/EBSapps/comn/util/jdk32/lib/dt.jar:/apps/dba1mgr/VISAPPL/fs1/EBSapps/comn/util/jdk32/lib/tools.jar:/apps/dba1mgr/VISAPPL/fs1/EBSapps/comn/util/jdk32/jre/lib/rt.jar:/apps/dba1mgr/VISAPPL/fs1/EBSapps/comn/shared-libs/ebs-3rdparty/WEB-INF/lib/ebs3rdpartyManifest.jar:/apps/dba1mgr/VISAPPL/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-fmw/WEB-INF/lib/ebsFMWManifest.jar:/apps/dba1mgr/VISAPPL/fs1/FMW_Home/Oracle_EBS-app1/shared-libs/ebs-appsborg/WEB-INF/lib/ebsAppsborgManifest.jar:/apps/dba1mgr/VISAPPL/fs1/FMW_Home/oracle_common/modules/oracle.uix_11.1.1/uix2.jar:/apps/dba1mgr/VISAPPL/fs1/EBSapps/comn/java/classes:/apps/dba1mgr/VISAPPL/fs1/EBSapps/10.1.2/forms/java:/apps/dba1mgr/VISAPPL/fs1/EBSapps/10.1.2/forms/java/frmall.jar:/apps/dba1mgr/VISAPPL/fs1/EBSapps/10.1.2/jlib/ewt3.jar:/apps/dba1mgr/VISAPPL/fs1/EBSapps/10.1.2/j2ee/OC4J_BI_Forms/applications/formsapp/formsweb/WEB-INF/lib/frmsrv.jar" 

Calling /apps/dba1mgr/VISAPPL/fs1/EBSapps/comn/util/jdk32/jre/bin/java ... 
Exception in thread "main" java.sql.SQLRecoverableException: IO Error: Got minus one from a read call 
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:482) 
at oracle.jdbc.driver.PhysicalConnection.(PhysicalConnection.java:678) 
at oracle.jdbc.driver.T4CConnection.(T4CConnection.java:238) 
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34) 
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:567) 
at java.sql.DriverManager.getConnection(DriverManager.java:571) 
at java.sql.DriverManager.getConnection(DriverManager.java:215) 
at oracle.apps.ad.worker.AdJavaWorker.getAppsConnection(AdJavaWorker.java:1050) 
at oracle.apps.ad.worker.AdJavaWorker.main(AdJavaWorker.java:278) 
Caused by: oracle.net.ns.NetException: Got minus one from a read call 
at oracle.net.ns.Packet.receive(Packet.java:305) 
at oracle.net.ns.NSProtocol.connect(NSProtocol.java:308) 
at oracle.jdbc.driver.T4CConnection.connect(T4CConnection.java:1222) 
at oracle.jdbc.driver.T4CConnect


Solution
:
SQLNET.INBOUND_CONNECT_TIMEOUT Parameter has been changed 60 to 0 in sqlnwt.ora file.

location: $ORACLE_HOME/network/admin
By default value is 60 always.

After change the above parameter upgrade patch applied successfully.




No comments:

Post a Comment