Basic Layers of EBS R12

You are welcome to leave a comment....

Getting Tech Stack Information on 11i and R12

We have to collect this information whenever boss ask :-). In Oracle Apps 11i and R12 instances we have txkInventory.pl and TXKScript.pl which can help us to get this information.
As applmgr user execute below command:
perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPL_TOP -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$OA_HTML/apps_techinfo.html

As Oracle user execute below command:
perl $ORACLE_HOME/appsutil/bin/TXKScript.pl -script=$ORACLE_HOME/appsutil/bin/txkInventory.pl -txktop=$ORACLE_HOME/appsutil/temp -contextfile=$CONTEXT_FILE -appspass=apps -outfile=$ORACLE_HOME/appsutil/temp/oracle_techdb.html.

You are welcome to leave a comment....

Finding XML Publisher Version in R12

1) The following SQL statement will show which patches and thus with version of Oracle XML Publisher is installed on an Oracle E-Business Suite Release 12.0 and 12.1 environment:

SELECT DECODE (bug_number, '4440000', '5.6.3') PATCH, bug_number
FROM ad_bugs WHERE bug_number IN('4440000');
PATCH BUG_NUMBER
----- ------------------------------
5.6.3 4440000

2) The version of a specific Java Class has a one to one relationship with the currently installed version of Oracle XML Publisher. This method is suitable for both Oracle E-Business Suite 11 and Release 12.

$ adident Header $OA_JAVA/oracle/apps/xdo/common/MetaInfo.class:
$Header MetaInfo.java 120.6 2006/08/17 01:25:30 bgkim noship $


Metainfo.class XML Publisher Patch Reference Included in ... R12
120.6 5.6.3 4440000 Note 422508.1

Session Time out Setting in R12

Many occassions we have seen end users reporting session timed out even though they were working on. This is for sure its an issue from client end and JRE version which client is running on is the culprit for the same. Try to have the same version of JRE which is running on your server or latest one.
Even if this doesn't help try at client end following setting with running JRE:
1. Navigate to: Start > Control Panel > Java > Advanced > Java Plug-in
2. De-select the option "Enable the next-generation Java Plug-in "
3 Restart the browser
4-Retest the issue

Next if you want to increase timeout setting from server end. Do the following:
1. Change profile option ICX: Session Timeout to 60 min from 30, which is default.
2. change s_oc4j_sesstimeout value to 60 again in context file and run adconfig.
3. Bounce the apps services and check.

 RW-50015 : Installation Error On Oracle EBS R12

RW-50015: Error: - HTTP Listener is not responding. The service might not have started on the port yet. Please check the service and use the retry button.

the Rapid Install window will show many errors for HTTP.

Checking status of OPMN managed Oracle HTTP Server (OHS) instance ...

Processes in Instance: PROD_ebs.ebs.sandiego.com

    -------------------+--------------------+---------+---------
    ias-component | process-type | pid | status
    -------------------+--------------------+---------+---------
    OC4J | oafm | 21168 | Alive
    OC4J | forms | 21078 | Alive
    OC4J | oacore | 20943 | Alive
    HTTP_Server | HTTP_Server | N/A | Down


Download and apply the patch 6078836 from OracleMetaLink to fix an issue with the Oracle HTTP Server bundled with the E-Business Suite technology stack. We unzip the patch:

    [oracle@ebs oracle]$ unzip p6078836_101330_LINUX.zip
    Archive: p6078836_101330_LINUX.zip
    creating: 6078836/
    inflating: 6078836/libdb.so.2
    inflating: 6078836/README.txt

    [oracle@ebs oracle]$ cd 6078836/
    [oracle@ebs 6078836]$ ls
    libdb.so.2 README.txt

    Then we copy to /usr/lib.

    [root@ebs 6078836] $ cp libdb.so.2 /usr/lib

    [root@ebs lib]# cd /usr/lib

    [root@ebs lib]# pwd
    /usr/lib


    [root@ebs lib]# ls libdb.so*
    libdb.so libdb.so.2
    

Processes in Instance: PROD_ebs.ebs.sandiego.com

    -------------------+--------------------+---------+---------
    ias-component | process-type | pid | status
    -------------------+--------------------+---------+---------
    OC4J | oafm | 21168 | Alive
    OC4J | forms | 21078 | Alive
    OC4J | oacore | 20943 | Alive
    HTTP_Server | HTTP_Server | 28519 | Alive .

We then re-start rapidwiz

You are welcome to leave a comment.

Oracle Apps R12 (12.1.1) Installation Issue – RW-50004 , RW-50010

Technology Stack changes in 12.1.1

1. Default database version is 11g  (10g in 12.0.X ; 9i in 11i)

2. Default forms and report version is 10.1.2.3 (10.1.2.2 in 12.0.4 ; 8.0.6 in 11i)

3. Default Web Server version is 10.1.3.4 (10.1.3.0.X in 12.0.X ; 9i/1.0.2.2.2 in 11i).

Disk Space for 12.1.1

Vision Database 194 GB

Application Tier 30 GB

Installation Issue   Oracle Apps Installation is 5 step process

Step1 & Step 2 are database tier related

Step 1 – 0-20% - Oracle Database Software Installation including registration of DB ORACLE_HOME in inventory. To know more about inventory click here

Step 2 - 20-40% - Oracle Database creation including copy of data files from staging area to data top

Install log file for 0-40% is located at $INSTALL_BASE/ db/ tech_st/ 11.1.0/appsutil/ log/<context_name>/MMDDHHMM.log 

Step 3, 4 and 5 are application tier related

Step 3 – 40-60% – Oracle Technology Stack Installation (10.1.2 and 10.1.3 ORACLE HOME) for Application Tier

Step 4 – 60-80%  – APPL_TOP and PRODUCT Top setup

Step 5- 80-100% – Configuration, Startup and Checks

Install log file for 60-100% is located at $INSTALL_BASE/ inst/ apps/ <context_name>/ logs/ MMDDHHMM.log

At around 37% Installer failed with message in log file at  $Install_Base/db/ tech_st/ 11.1.0/ appsutil/ log/ $SID_HOSTNAME/ MMDDHHMM.log ->  RW-50010: Error: – script has returned an error RW-50004: Error code received when running external process. Check log file for details.

after several unsuccessful attempts I looked at /var/log/messages and found messages like

Out of Memory: Killed process 2592 (ovisr12) .

OOM-KILLER - The OOM killer, a feature enabled by default (on Linux) to protect system from hang by terminating processes using high memory.

If kernel cannot find memory to allocate when it’s needed, it puts in-use user data pages on the swap-out queue, to be swapped out. If the Virtual Memory (VM) cannot allocate memory and cannot swap out in-use memory, the Out-of-memory killer may begin killing current user-space processes. It will sacrifice one or more processes in order to free up memory for the system when all else fails.

Solution : 

Turn oom-killer off:

  # echo “0″ > /proc/sys/vm/oom-kill   (turn off)

  # echo “1″ > /proc/sys/vm/oom-kill    (turn on) More information hereThis issue is also reported in Metalink Note # 460790.1

Other possible reasons for RW-50004/RW-50010

1. If RW-50004/10 @ ORACLE_HOME registration with inventory (DB_HOME or Oracle Application Server 10.1.2 & 10.1.3 HOME); check privileges to oraInventory location

or

If this is re-install (from previous failed installation), check ORACLE_HOME is not already registered in Inventory>

2. Corrupt media file – For error like AC-00023: Error: Exception: java. io. File NotFound Exception with RW-50004/10
You are welcome to leave a comment.