Find Installed Modules in Oracle E-Business Suite R12

Using SQL Query:

SELECT a.application_name,a.product_code, DECODE (b.status, ‘I’, ‘Installed’, ‘S’, ‘Shared’, ‘N/A’) status,patch_level FROM apps.fnd_application_vl a, apps.fnd_product_installations b WHERE a.application_id = b.application_id and b.status=’I’ order by product_code asc;

Fatal Error: TXK Install Service occurred on rapidwiz install R12.2 start CD 51 at step-1 of the database install

SYMPTOMS:

On Oracle Applications 12.2, the following: Fatal Error: TXK Install Service occurred on rapidwiz install R12.2 start CD 51 at step-1 of the database install:

Fatal Error: TXK Install Service

oracle.apps.fnd.txk.config.ProcessStateException: OUI process failed : Exit=253 See log for details. CMD= /u01/stage/stage_R122_51/TechInstallMedia/database/examples/runInstaller -waitForCompletion -ignoreSysPrereqs -force -silent -responseFile /u01/ora_prod/PROD/12.1.0/temp/PROD_erpnode1/cfgHome/response/DB_HOME/txkDB12cR1_12102_examples.rsp

  at oracle.apps.fnd.txk.config.OUIPatchActionNode.processState(OUIPatchActionNode.java:160)

  at oracle.apps.fnd.txk.config.PatchActionNode.processState(PatchActionNode.java:187)

  at oracle.apps.fnd.txk.config.PatchNode.processState(PatchNode.java:338)

  at oracle.apps.fnd.txk.config.PatchesNode.processState(PatchesNode.java:79)

  at oracle.apps.fnd.txk.config.InstallNode.processState(InstallNode.java:68)

  at oracle.apps.fnd.txk.config.TXKTopology.traverse(TXKTopology.java:594)

  at oracle.apps.fnd.txk.config.InstallService.doInvoke(InstallService.java:224)

  at oracle.apps.fnd.txk.config.InstallService.invoke(InstallService.java:237)

  at oracle.apps.fnd.txk.config.InstallService.main(InstallService.java:291)

====================================

In logfile:

============================

INFO: -----------------------------------------------

INFO: Verification Result for Node:erpnode1

INFO: Expected Value:x86_64

INFO: Actual Value:x86_64

INFO: -----------------------------------------------

INFO: *********************************************

INFO: OS Kernel Version: This is a prerequisite condition to test whether the system kernel version is at least "2.6.39".

INFO: Severity:CRITICAL

INFO: OverallStatus:VERIFICATION_FAILED

INFO: -----------------------------------------------

INFO: Verification Result for Node:erpnode1

INFO: Expected Value:2.6.39

INFO: Actual Value:2.6.32-100.34.1.el6uek.x86_64

INFO: Error Message:Kernel of proper version is not found on node "erpnode1" [Expected = "2.6.39" ; Found = "2.6.32-100.34.1.el6uek.x86_64"]

INFO: Cause:Cause Of Problem Not Available

INFO: Action:User Action Not Available

INFO: -----------------------------------------------

SOLUTION:

1. Edit both staging files for database:

 - Oracle RDBMS

location: <stage_area>/TechInstallMedia/database/database/stage/cvu/cvu_prereq.xml

 - Oracle Examples

location:<stage_area>/TechInstallMedia/database/examples/stage/cvu/cvu_prereq.xml

2. Modify the value of kernel value in prerequisites check file from 2.6.39 to 2.6.32 and save.

3. Retry the installation.

Reference Doc: Rapidwiz Install R12.2 Start CD 51 Fails With Fatal Error: TXK Install Service in Database Pre-install Checks (Doc ID 2155494.1)

Apache HTTP_Server - Failed to start a managed process after the maximum retry limit Log (HTTP_Server~1)

Oracle HTTP Server, residing on a Unix platform, fails to start using OPMN. For example, OPMN reports the generic error

opmnctl startall
opmnctl: starting opmn and all managed processes...
================================================================================
opmn id=oradb:6200
0 of 1 processes started.

ias-instance id=infra.oracle.com
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
ias-component/process-type/process-set:
HTTP_Server/HTTP_Server/HTTP_Server

Error
--> Process (pid=24042)
Failed to start a managed process after the maximum retry limit Log::
/opt/oracle/infra/opmn/logs/HTTP_Server~1

The HTTP_Server~1 OPMN log file just reports that the HTTP Server has been started, but there are actually no httpd processes present on the system.

There is also nothing written to the $ORACLE_HOME/apache/apache/logs directory even when HTTP Server logLevel is set to debug.

Furthermore there are no core / segmentation fault files created.

In order for the HTTP Server to listen on ports < 1024 e.g 80 and 443 the ownership and permissions of the Oracle HTTP Server binary - '.apachectl' - have been changed as follows:

One possible work-around is to change .apachectl to belong to another group - such as the generic one users (rather than have the file belong to the oracle group - typically called 'oinstall') e.g

Solution:

chown root:users .apachectl
chmod 6750 .apachectl

MOS Reference: OPMN Fails to Start Oracle HTTP Server 10g After Changing 'apachectl' to Root Ownership and 6750 Permissions (Doc ID 735023.1)