Oracle Apps R12.2 - Installation Steps

In this article I will post the steps to install Oracle Apps R12.2 Beta. This installation is performed on Linux x86-64.

Operating System and Storage details

 

Type of Installation	Single Node
Platform	Linux X86-64
Operating System	RHEL 5.4 (Tikanga)
Kernel Version	2.6.18-164.11.1.el5
Memory	16 GB (Minimum 4GB)

Storage
	Minimum Required	Used
Database Node
DB Oracle Home	10 GB	6.5 GB
DB Data file (Fresh Install)	60 GB	45 GB
Application Node
Application Tier (Primary)	40 GB	29 GB
Application Tier (Secondary)	40 GB	29 GB

Application Tier file system includes

·         FMW HOME (Fusion Middleware Home)

·         Inst (INST_TOP)

·         EBSapps (APPL_TOP, COMMON_TOP, 10.1.2)

Pre-Install Task

·         Update Kernel parameter with below value

fs.aio-max-nr = 1048576

Download

Download the software from www.oracle.com and unzip the software in stage area.

Install Oracle Apps R12.2

·         Invoke Rapidwizard

cd <Software Stage> /startCD/Disk1/rapidwiz

      ./rapidwiz

Post Install Validation

• Login in to application and verify.

• Weblogic Admin Console can be accessed via console

          http://tstrd01:7011/console/login/LoginForm.jsp

        Username : weblogic

              Password : welcome1

Find file version history of a file in Oracle Apps R12/11i

This post will help you to find File version history of any particular file with in Oracle Apps R12/11i

If you have requirement to find out patches which has updated any particular file, using below query you will be able to find out file history.

·          Below sql will list out details for  particular form  “FNDRSRUN.fmb”

set line 200;

col FILENAME for a15;

col APP_SHORT_NAME for a10;

col VERSION for a25;

col PATCH_NAME for a15;

select distinct af.app_short_name

, af.filename

, afv.version

, afv.creation_date

, apr.end_date

, aap.patch_name

, aprb.applied_flag

, aprb.success_flag

from ad_patch_drivers apd

, ad_applied_patches aap

, ad_patch_runs apr

, ad_patch_run_bugs aprb

, ad_patch_run_bug_actions aprba

, ad_file_versions afv

, ad_files af

where apd.patch_driver_id = apr.patch_driver_id

and apd.applied_patch_id = aap.applied_patch_id

and apr.patch_run_id = aprb.patch_run_id

and aprb.patch_run_bug_id = aprba.patch_run_bug_id

and aprba.patch_file_version_id = afv.file_version_id

and afv.file_id = af.file_id

and af.filename = 'FNDRSRUN.fmb'

order by 2, 4

The above output displays the file versions and patches which had updated this file.

Same way you will be able to find out history of any object.

Configuring OCM (Configuration Manager) on an E-Business R12

Installation Steps

Database Tier

1.      Download OCM Patch 5567658 from metalink and extract to it Oracle database tier home (unzip -d $ORACLE_HOME ocm.zip)

2.      Run SetupCCR script

a.       cd $ORACLE_HOME/ccr/bin

b.       Run setupCCR -s <CSI ID> <METALINK ID> US

While running setupCCR it will ask for proxy details. Please find the below screen shot and enter the values as per this.

          It will prompt for Proxy Password: Press Enter

3.      Execute $ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig

4.      Execute $ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh ebs_collectconfig –u apps

To Change the OCM Collection interval

Cd $ORACLE_HOME/ccr/bin

Execute below command (set the interval according to the reuirment)

 emCCR set collection_interval="FREQ=WEEKLY;BYDAY=SUN; BYHOUR=22;BYMINUTE=0"

Application Tier

1.       Download OCM Patch 5567658 from metalink and extract to it Oracle  home (Application Tier) (10.1.2 or 10.1.3) (unzip -d $ORACLE_HOME ocm.zip) 

2.       Run SetupCCR script

a.       cd $ORACLE_HOME/ccr/bin

b.       Run setupCCR -s <CSI ID> <METALINK ID> US

Uninstalling OCM

1.       Stop the Configuration manager

$ORACLE_HOME/ccr/bin/emCCR status

$ORACLE_HOME/ccr/bin/emCCR stop

2.       Connect as SYSDBA and run the below sql

$ORACLE_HOME/ccr/admin/scripts/dropocm.sql

 

3.       Connect as SYSDBA and run the below sql

               $ORACLE_HOME/ccr/admin/scripts/ebs_dropccr.sql APPS

4.       cd $ORACLE_HOME , remove the ccr directory.

Oracle Apps R12 Login page error

Issue:  When users try to login, gets below error

oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = oracle.apps.fnd.cache.CacheException;

Error Log shows

Caused by: oracle.apps.jtf.base.resources.FrameworkException: ORA-01578: ORACLE data block corrupted (file # 27, block # 183616)

ORA-01110: data file 27: '/oradata/testdata/ERPTEST/a_txn_data04.dbf'

ORA-26040: Data block was loaded using the NOLOGGING option

Cause : Tablespace  holding wf table got corrupted. This issue will occur in cloned instance or any other instance.

Solution :

·         Verify the data file which has block corruption using DBV (dbverify)

·         Connect to APPS user using sqlplus and submit Concurrent program “Sync workflow local tables” from back end.

begin

    apps.wf_local_synch.BULKSYNCHRONIZATION(

        P_ORIG_SYSTEM=>'ALL',

        P_PARALLEL_PROCESSES=>2,

        P_LOGGING=>'LOGGING',

        P_RAISEERRORS=>TRUE,

        P_TEMPTABLESPACE=>'APPS_TS_TX_DATA');

END;

/

·         Restart application services.

Oracle Apps R12.2 – A Glimpse

Oracle Apps R12.2 have major changes in technical areas, key changes are

1.     Replacing Oracle Containers for Java (OC4J) 10g with WebLogic Server 11g

2.     Online Patching support via 11gR2 Edition-Based Redefinition

Release 12.2 architecture has below Application Tier components.

·         Oracle OHS 11g

o    In terms of Web services, Oracle 10g AS (10.1.3) is replaced with OHS 11g.

·         Oracle Weblogic Server 11g (10.3.4)

o    Oracle 10g OC4j containers are replaced with Oracle Weblogic Server 11g. With the introduction of Weblogic middleware, lot of functionality can be leveraged with EBS. Weblogic server configuration consists of below servers

·         Oracle AS 10g (Forms & Reports) 10.1.2.3

o    It maintains same Oracle Forms and reports version as it is.

·         Oracle SOA Integration

o    Compared to previous releases of R12 it has built-in SOA integration capabilities.

·         Oracle 11g Database

o    Release 12.2 has 11g as the database 11.2.0.3

Online Patching

·         Improves high availability.

·         Online Patching allows users to continue using the application while patching.

·         Dual file system in conjunction with edition 11gR2 edition based redefinition facilitates online patching.

·         Reduces application downtime.

Dual File System needs

·         Additional storage for Primary APPL_TOP (RUN) and Secondary APPL_TOP (PATCH).

·         Dual Port pool configuration.

Reference:

Oracle ATG Presentation on R12.2

Oracle E-Business Suite Directions: Deployment and System Administration (Presentation)

Troubleshooting RMAN Duplicate Database issues

Issue 1 : Failed to load Media Management Library

RMAN-03009: failure of allocate command on ch1 channel at 10/25/2011 12:48:18

ORA-19554: error allocating device, device type: SBT_TAPE, device name:

ORA-27211: Failed to load Media Management Library

Additional information: 2

·         Check whether Media library agent is installed on server.

·         After Installation of Media Manager, if RMAN Channel Allocation Fails

Check in the trace file and sbio file if any error it generated (check USER_DUMP_DEST location)

If there is not much information, check if the issue is related to Media Mgmt library is not getting picked correctly. While allocating Channel force to use Media management library using parameter SBT_LIBRARY

Please use below commands to test (note : replace the env details)

Eg:

run

{

 ALLOCATE AUXILIARY CHANNEL ch2 DEVICE TYPE sbt parms='SBT_LIBRARY=/usr/lib/libnwora.so ENV=(NSR_SERVER=emcnetworker,NSR_CLIENT=prddb,NSR_DATA_VOLUME_POOL=Weekly)';

}

            Using this command if it is able to connect to Tape , then change the rman script to reflect the SBT_LIBRARY parameter

Issue 2 :  ora-01103 database name <> in control file is not <>

This is due to previous RMAN duplicate must have errored out or set the DB_name as Production.

(This is a known bug in 11g)

Please check the spfile/pfile whether db_name is set correctly.

Issue 3 : Debug RMAN commands

Rman target  <>      Auxilary   <> log=rmanLog.txt trace=rmanTrace.txt

run {

 debug on;

 ALLOCATE AUXILIARY CHANNEL ch1 DEVICE TYPE sbt parms 'SBT_LIBRARY=/usr/lib/libnwora.so ENV=(NSR_SERVER=emcnetworker,NSR_CLIENT=prderpdb,NSR_DATA_VOLUME_POOL=ADFCA Weekly)';

 ALLOCATE AUXILIARY CHANNEL ch2 DEVICE TYPE sbt parms 'SBT_LIBRARY=/usr/lib/libnwora.so ENV=(NSR_SERVER=emcnetworker,NSR_CLIENT=prderpdb,NSR_DATA_VOLUME_POOL=ADFCA Weekly)';

 duplicate target database to ERPUAT  UNTIL TIME 'SYSDATE-1' ;

 debug off;

 }

Please check the trace and log file for error info.

refer notes:

http://download.oracle.com/docs/cd/B12037_01/server.101/b10734/rcmtroub.htm

http://download.oracle.com/docs/cd/B19306_01/backup.102/b14191/rcmdupdb.htm#i1006474