ORA-7445-Troubleshooting Tool

ORA-7445 Trouble shooting Tool Helped lot to me in my daily activites.When am checking my DB health check am seeing couple of times see ORa-7445 error in my alert log.

I found ORA-7445 trouble shooting Tool in support.oracle.com used as an online .

Here is the Information:

ORA-7445 Troubleshooting Tool (Doc ID 1521910.1)

Accessing the ORA-7445 Troubleshooting Tool

Click here to access the Troubleshooting Tool (Standalone Version).

Create the IPS package base on Incident Number and upload here.it will suggest you.based on that take appropriate action on that issues.
adrci

ADRCI: Release 11.1.0.7.0 - Production on Tue Jul 28 11:15:58 2015

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

ADR base = "/oracle/xxx/orabin/11.1.0/admin/xxx_xxdbprd02"
adrci> show home
ADR Homes:
diag/tnslsnr/xxdbprd02/xxx
diag/rdbms/xxxprd/XXXPRD
adrci> SET HOME diag/rdbms/xxxprd/XXXPRD
adrci> ips pack incident 7496407 in /tmp
Generated package 2 in file /tmp/ORA7445ns_20150728111628_COM_1.zip, mode complete
adrci> exit

DIA-48448: This command does not support multiple ADR homes

adrci> IPS CREATE PACKAGE INCIDENT 7496407
DIA-48448: This command does not support multiple ADR homes

adrci> show homes
ADR Homes:
diag/tnslsnr/xxxdbprd02/xxprd
diag/rdbms/xxxx/XXXXX
adrci> SET HOME diag/rdbms/xxxx/XXXXX
adrci> show homes
ADR Homes:
diag/rdbms/xxxx/XXxxx

adrci> ips pack incident 7496407 in /tmp
Generated package 2 in file /tmp/ORA7445ns_20150728111628_COM_1.zip, mode complete

Zip file name in /tmp:

ORA7445ns_20150728111628_COM_1.zip

This file will include all the trace files, instance alert file and other diagnostic information for the critical error

weblogic uninstall 10.3.6

Stop the Admin Server and Managed Server

 Go to WL_HOME/uninstall

sh uninstall.sh

uninstall all the components .Remove some of the related directories Manually.

ORA-07445: exception encountered: core dump [nstimexp()+36] [SIGSEGV] [ADDR:0x58] [PC:0x76E1482] [Address not mapped to object]

1. Use the workaround:

    Set sqlnet.expire_time=0 in $ORACLE_HOME/network/admin/sqlnet.ora, on the server.
    Restart the listener to ensure that these changes take effect.

Removing SSL on a Cloned EBS R12.1.3 instance

txkrun.pl -script=SetAdvCfg \-appsuser=apps -appspass=apps -disable=SSL \-s_webport=8007


This script will remove all https configuration from context file and other areas too if any.

SYSADMIN Password Retrival in R12

How verify the sysadmin password from command line?
*********************************************************************************


Ans:
This utility can be used to verify the GUEST/ORACLE password
SQL>select fnd_web_sec.validate_login('SYSADMIN','')from dual;
If it returns Y then sysadmin password is correct
If it returns N then sysadmin password that we are using
Eg:
SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN123') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN123')
--------------------------------------------------------------------------------
N
SQL> select fnd_web_sec.validate_login('SYSADMIN','SYSADMIN') from dual;
FND_WEB_SEC.VALIDATE_LOGIN('SYSADMIN','SYSADMIN')
--------------------------------------------------------------------------------
Y


CREATE OR REPLACE PACKAGE xxx_GET_PWD AS
FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
RETURN VARCHAR2;
END XXX_GET_PWD;
/

CREATE OR REPLACE PACKAGE BODY xxx_GET_PWD AS
 FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)
 RETURN VARCHAR2 AS
 LANGUAGE JAVA NAME 'oracle.apps.fnd.security.WebSessionManagerProc.decrypt
 (java.lang.String,java.lang.String) return java.lang.String';
 END XXX_GET_PWD;
/

SELECT Usr.User_Name,
 Usr.Description,
 XXX_GET_PWD.Decrypt (
 (SELECT (SELECT XXX_GET_PWD.Decrypt (
 Fnd_Web_Sec.Get_Guest_Username_Pwd,
 Usertable.Encrypted_Foundation_Password)
 FROM DUAL)
 AS Apps_Password
 FROM applsys.Fnd_User Usertable
 WHERE Usertable.User_Name =
 (SELECT SUBSTR (
 Fnd_Web_Sec.Get_Guest_Username_Pwd,
 1,
 INSTR (Fnd_Web_Sec.Get_Guest_Username_Pwd,
 '/')
 - 1)
 FROM DUAL)),
 Usr.Encrypted_User_Password)
 Password
 FROM applsys.Fnd_User Usr
 WHERE Usr.User_Name = '&User_Name';

USER_NAME
--------------------------------------------------------------------------------
DESCRIPTION
--------------------------------------------------------------------------------
PASSWORD
--------------------------------------------------------------------------------
SYSADMIN
System Administrator
xxxxxx

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.