Oracle2expert

    IN R12.1.* IN R12.2.* Startup/shutdown Apps tier services are started and stopped frequently and we must know logfiles when troubleshooting startup/shutdown issues. $INST_TOP/logs/appl/admin/log $INST_TOP/logs/appl/admin/log2 Apache OHS being part of opmn in r12.1 has continued in r12.2. Logfile locations for troubleshooting have been changed $INST_TOP/logs/ora/10.1.3/Apache/error_log[timestamp] $IAS_ORACLE_HOME/instances/*/diagnostics/logs/OHS/*/*log*      $INST_TOP/logs/ora/10.1.3/opmn/HTTP_Server~1.log   OPMN Logfile locations for … More R12.2 and R12.1 Log file locations

Executing Autoconfig on database tier completed with status 2 failing to execute afdbprf.sh adcrobj.sh scripts. Observed that the FND_NODES table is not getting updated/populated with the respective node entries. Logfile shows the below ORA error while execting adgentns.pl script. Error —— [ Config tool : /d01/oracle/EBS/db/tech_st/11.1.0/appsutil/bin/adgentns.pl ] Command            : /d01/oracle/EBS/db/tech_st/11.1.0/perl/bin/perl -I /d01/oracle/EBS/db/tech_st/11.1.0/perl/lib/5.8.3 -I /d01/oracle/EBS/db/tech_st/11.1.0/perl/lib/site_perl/5.8.3 -I … More ORA-06512: at “APPS.FND_NET_SERVICES” ORA-01403: no data found While running adautoconfig on DB tier

After performing R12.1  EBS clone on IBM-AIX 6.1 for one of our customer we were not able to access EBS forms due to frm-92101 error. Forms was not launching. Cause: One of the application dependent library file is still exists with the old production OS username – oraprod where as system is expecting this link … More FRM-92101: There was a failure in form server during startup on IBM-AIX 6.1

Error $ opatch lsinventory Invoking OPatch 11.1.0.6.2 Oracle Interim Patch Installer version 11.1.0.6.2 Copyright (c) 2007, Oracle Corporation. All rights reserved. Oracle Home : /prddb03/oradb/db/tech_st/11.1.0 Central Inventory : /prddb03/oradb/db/tech_st/11.1.0/admin/oui/PROD_hlifedb/oraInventory from : /etc/oraInst.loc OPatch version : 11.1.0.6.2 OUI version : 11.1.0.7.0 OUI location : /prddb03/oradb/db/tech_st/11.1.0/oui Log file location : /prddb03/oradb/db/tech_st/11.1.0/cfgtoollogs/opatch/opatch2015-06-10_16-22-18PM.log Unhandled exception Type=Segmentation error vmState=0x00000000 J9Generic_Signal_Number=00000004 … More opatch lsinventory Unhandled exception Type=Segmentation error JVMDUMP*

Error OPATCH_JAVA_ERROR  : An exception of type “OPatchException” has occurred: OPatch Exception: OUI found no such ORACLE_HOME set in the environment Can not get details for given Oracle Home An exception occurs null Solution Attach (10.1.2) ORACLE_HOME to an existing Inventory/new Inventory  using OUI – Installer. Step 1: Go to 10.1.2 Oracle Home. /testappwms/apps/tech_st/10.1.2/oui/bin Step … More OPATCH_JAVA_ERROR : An exception of type “OPatchException” has occurred during opatch lsinventory