Oracle E-Business Suite Cloning Notes Release 12 (12.1.1) for Linux x86

________________________________________



Scope :

i) The passed UAT server E-Business Suite to be cloned.

ii) The Apps Tier and DB Tier to be separated.



Precloning Steps on the UAT server E-Business Suite to be cloned.

1. Startup

1.1 Start Database Tier

1.1.1 Login as database tier user – sys as sysdba

1.1.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/db/tech_st/11.1.0

—- cd /u01/oracle/PNGRB/db/tech_st/11.1.0

—- . PNGRB_apps.env (note: dot in front)

1.1.3 Start database

—- sqlplus “/as sysdba”

—- SQL> startup

1.1.4 Start Database Listener (lsnrctl start $SID)

—- lsnrctl start PNGRB

.



1.2 Start Application Tier

1.2.1 Login as application tier user - apps

1.2.2 Set environment variable by running $SID_hostname.envfrom $INSTALL_BASE/apps/apps_st/appl

—- cd /oracle/PNGRB/apps/apps_st/appl

—- . PNGRB_apps.env (note: dot in front)

1.2.3 Start Application Tier (adstrtal.sh apps/$apps_password)

—- cd $ADMIN_SCRIPTS_HOME

—- ./adstrtal.sh apps/apps





1. DB Tier preparation for Cloning :



On Source System:



a) login in as Oracle user : $ sudo su - oracle



b) Run the following commands:



RDBMS HOME = $ORACLE_HOME



$ cd $ORACLE_HOME/appsutil/scripts/

$ perl adpreclone.pl dbTier



2. Verify the errors and warnings in the log.



RDBMS_HOME = $ORACLE_HOME



Location of the log file StageDBTier_.log



$cd $ORACLE_HOME/appsutil/log/ directory



3. Apps Tier preparation for Cloning



a) $ sudo su - appl



b) Run Pre-Clone on all the nodes that contains an APPL_TOP.



$cd $INST_TOP/admin/scripts

$perl adpreclone.pl appsTier



4. Verify the errors and warnings in the log.



Location of the log file StageAppsTier_.log



$cd $APPL_TOP/admin//log directory





Complete all operating system requirements, software requirements, and other requirements before cloning Oracle E-Business Suite on the target system.

This document may contains the following sections:

• Certification Information

• Operating Systems Requirements

• Software Requirements

• Other Requirements

• Before Installing or Upgrading

• Installing or Upgrading

• After Installing or Upgrading

• Change Record

• Documentation Accessibility

Certification Information

The latest certification information for Oracle E-Business Suite Release 12 is available on My Oracle Support's Certification tab:

http://support.oracle.com







Operating Systems Requirements

Oracle E-Business Suite is supported on various Linux 32-bit operating systems running on the x86 and x86-64 hardware architectures.

Operating System Supported Versions

The following table lists the supported operating system versions.

Operating System Name Supported Version

Oracle Linux 4 - Update 4 or higher (32-bit)

Oracle Linux 5 - Update 1 or higher (32-bit)

Red Hat Enterprise Linux 3 - Update 4 or higher (32-bit)*

Red Hat Enterprise Linux 4 - Update 4 or higher (32-bit)

Red Hat Enterprise Linux 5 - Update 1 or hgiher (32-bit)

SUSE Linux Enterprise Server 9 - SP3 or higher (32-bit)*

SUSE Linux Enterprise Server 10 - GA, SP1 or higher (32-bit)

*: only supported on the application (or middle) tier for upgrade customers in a multi-node system, or for both application and database tiers if the customer is on 10gR2. These OS'es are not supported for a new installation of 12.1.1 because version 11gR1 of the Database is delivered with Rapid Install and is not supported on these OS'es.

Kernel Requirements

The following table lists the required minimum kernel versions (to determine version, enter: $ uname -r):

Operating System Kernel

Red Hat Enterprise Linux 5 2.6.18-8.el5PAE

Required Packages

The following table lists the required packages and the minimum required versions for Linux (32-bit).

Operating System Required Packages

Oracle Linux 5*

Red Hat Enterprise Linux 5* (base and Advanced Platform) Update 1 (5.1) or higher of Oracle Linux 5 is required

Update 1 (5.1) or higher of Red Hat Enterprise Linux (RHEL) 5 is required

The following i386 packages are not part of the OS distribution media and must be downloaded separately (from http://oss.oracle.com/projects/compat-oracle/files/Enterprise_Linux for both Oracle Linux 5 and RHEL 5) and installed manually:

• openmotif21-2.1.30-11.EL5.i3861

• xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386

• For Update 1 or 2:

o binutils-2.17.50.0.6-6.0.1.i3862

• For Update 3:

o binutils-2.17.50.0.6-9.0.1.i3862

• For Update 4 (5.4) or higher, see workaround listed below in the 'After Installing or Upgrading' section.

The following i386 packages must be installed from the Oracle Linux 5 or RHEL 5 distribution media:

• compat-glibc-2.3.4-2.26

• compat-glibc-headers-2.3.4-2.26

• gcc-4.1.2-14.el5

• gcc-c++-4.1.2-14.el5

• glibc-2.5-123

• glibc-common-2.5-123

• glibc-devel-2.5-12

• glibc-headers-2.5-12

• kernel-headers-2.6.18-128.el5

• libgcc-4.1.2-14.el53

• libstdc++-devel-4.1.2-14.el5

• libstdc++-4.1.2-14.el53

• make-3.81-1.13

• gdbm-1.8.0-26.2.13

• libXp-1.0.0-8.1.el5

• libaio-0.3.106-3.23

• libgomp-4.1.2-14.el5

• sysstat-7.0.0-3.el5

• compat-libstdc++-296-2.96-138

• compat-libstdc++-33-3.2.3-61

Additionally, the following RPMs are required for an 11gR1 Database (which is bundled with the 12.1.1 release) on the database tier:

• elfutils-libelf-devel-0.125

• elfutils-libelf-devel-static-0.125

• libaio-devel-0.3.106

• unixODBC-2.2.11

• unixODBC-devel-2.2.11

• kernel-headers-2.6

Note:

1: The openmotif package version must be 2.1.30 (for example, openmotif-2.2.3-10.RHEL4.5 is not supported).

2: This GNU linker (ld) version 2.17 provided by Oracle is required for relinking the modules in Advanced Planning & Scheduling (MSC, MSO, MSR) and Profitability Manager (FEMCCE)

3: This rpm is distributed as part of the 'default' installation of Enterprise Linux

JDK 6 Requirements

JDK 6 is bundled with Oracle E-Business Suite version 12.1.1.

Additional Information: Check the Sun Web site for any updates to the JDK 6 requirements for Linux (32-bit):

http://java.sun.com/javase/6/webnotes/install/jdk/install-linux.html#requirements




Software Requirements

The following maintenance tools must be installed on all machines, and their locations specified both in the PATH of the account that runs Rapid Install and in the PATH of the accounts that will own the database tier and application tier file systems.

• ar

• gcc

• g++

• ld

• ksh

• make

• X Display Server

Other Requirements

The following are other requirements for Linux (32-bit).

Kernel Settings

Edit the /etc/sysctl.conf file to configure your kernel settings. After editing the file, use the "sysctl -p" command or restart the system to invoke the new settings.

Note: If the current value for any parameter is higher than the value listed in the following table, then do not change the value of that parameter.

The following table lists the kernel settings for Oracle Enterprise Linux 4 and 5, Red Hat Enterprise Linux AS/ES 3, 4, and 5 and SUSE Linux Enterprise Server 9 and 10:

Parameter Value

kernel.semmsl 2561

kernel.semmns 320001

kernel.semopm 1001

kernel.semmni 1421

kernel.shmall 2097152

kernel.shmmax Half the size of the physical memory (in bytes), and at least 21474836482

kernel.shmmni 4096

kernel.msgmax 8192

kernel.msgmnb 65535

kernel.msgmni 2878

fs.file-max 131072

net.ipv4.ip_local_port_range 10000 650003

net.core.rmem_default 262144

net.core.rmem_max 4194304

net.core.wmem_default 262144

net.core.wmem_max 262144

1: set using the following entry in the /etc/sysctl.conf file: kernel.sem = 256 32000 100 142

2: On the server running the EBS Database, this kernel parameter must be the lesser of half the size of the physical memory (in bytes) and 4294967295

3: values recommended for the local port range may need to be adjusted according to the specific needs of the user's environment in order to avoid port conflicts.

Domain Name System (DNS) Resolver Parameters

Two Domain Name System (DNS) resolver parameters (timeout and attempts) are set by default to low values when the operating system is installed. These low values may cause attempted network connections to an Oracle database to fail. If this happens, add or update the following entries to these minimum settings in the /etc/resolv.conf file on each server node:

options attempts:5

options timeout:15

Verifying Host Names

Use the following to verify host name settings:

For Oracle Linux 4 and 5, and Red Hat Enterprise Linux AS/ES 3, 4 and 5:

1. Verify that the /etc/hosts file is formatted as follows:

2. 127.0.0.1 localhost.localdomain localhost

[ip_address] [node_name].[domain_name] [node_name]

3. Verify that the /etc/sysconfig/network file is formatted as follows:

HOSTNAME=[node_name].[domain_name]

4. If the /etc/sysconfig/networking/profiles/default/network file exists, remove it.

5. If you changed any files in the previous steps, restart the system.

Modifying the Number of Open File Descriptors

Open the /etc/security/limits.conf file and change the existing values for "hard" and "soft" parameters as follows. Restart the system after making changes.

Note: If the current value for any parameter is higher than the value listed in this document, then do not change the value of that parameter.

* hard nofile 65535

* soft nofile 4096

* hard nproc 16384

* soft nproc 2047

OS Library Patch for Oracle HTTP Server (on Oracle Linux 5 and RHEL 5 only)

Download and apply the patch 6078836 from My Oracle Support to fix an issue with the Oracle HTTP Server (missing libdb.so.2) bundled with the E-Business Suite technology stack.

Note that this patch (which includes a required operating system library) must be applied before installing Oracle E-Business Suite.

Copy the libdb.so.2 file to /usr/lib

Link to Motif library for Oracle Application Server 10.1.2 (on Oracle Linux 5 and RHEL 5 only)

Perform the following command (as root on your system) to update a required link to a Motif library prior to relinking or patching the 10.1.2 Application Server Oracle Home:

# unlink /usr/lib/libXtst.so.6

# ln -s /usr/X11R6/lib/libXtst.so.6.1 /usr/lib/libXtst.so.6

Without this updated link, you may see the following errors during a relink of the 10.1.2 Oracle Home:

/usr/lib/libXtst.so.6: undefined reference to `__stack_chk_fail@GLIBC_2.4'

/usr/lib/libXtst.so.6: undefined reference to `__fprintf_chk@GLIBC_2.3.4'

/usr/lib/libXtst.so.6: undefined reference to `__sprintf_chk@GLIBC_2.3.4'

Since the ldconfig command overrides this link, the above link command (ln) will have to be re-issued after running the ldconfig command.

Relink Advanced Supply Chain Planning executables (for SLES 10 and Oracle Linux/RHEL 5.4 or higher only)

During the relink phase of the installation of EBS Release 12 (12.1.1) on SLES 10 or Oracle Linux/RHEL 5.4 (Update 4 or higher), failures will result while relinking the Advanced Supply Chain Planning (ASCP) executables. To fix this problem, users are required to replace the following line under the Linux section of the $AD_TOP/bin/adrelinknew.sh:

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh'

with

CPP_LDFLAGS=' -L$(ORACLE_HOME)/lib -L$(ORACLE_HOME)/lib/stubs -lclntsh -Wl,--noinhibit-exec'

After making this change, users are then required to run the adadmin utility and relink application executables.



LD_LIBRARY_PATH Environment Variable

Dynamic libraries are used as part of the relinking and execution processes. The LD_LIBRARY_PATH environment variable is used by Oracle E-Business Suite to locate the required dynamic libraries at runtime - this variable is set by the Rapid Install wizard during the installation of EBS as well as by the Rapid Clone script (adcfgclone) when configuring the target system.

If you need to change these values, use the Edit Parameters function of the OAM AutoConfig tool (by logging in as 'System Administrator' responsibility, clicking on 'System Administrator', selecting 'AutoConfig' under 'Oracle Applications Manager', and clicking on the 'Environments' tab):

On each application tier server node:

LD_LIBRARY_PATH is set in three places:

• $APPL_TOP/admin/adovars.env

• $ORA_CONFIG_HOME/10.1.2/[CONTEXT_NAME].env, in the 10.1.2 Oracle home directory

• $ORA_CONFIG_HOME/10.1.3/[CONTEXT_NAME].env, in the 10.1.3 Oracle home directory

In the AutoConfig interface, this corresponds to:

Location Parameter

adovars LD_LIBRARY_PATH

tools_home (10.1.2) LD_LIBRARY_PATH

web_home (10.1.3) LD_LIBRARY_PATH

On the database server node:

LD_LIBRARY_PATH is set in $ORACLE_HOME/[CONTEXT_NAME].env which corresponds in the AutoConfig interface to:

Location Parameter

db_home LD_LIBRARY_PATH

After making these changes, run AutoConfig (adautocfg.sh) to implement the changes on the application and database tiers.

Additional Information: See AutoConfig in Oracle E-Business Suite Maintenance Utilities for more information on AutoConfig.

Net Service Listeners in Multi-user Installations

Net Service Listeners use the /var/tmp.oracle directory to store temporary files. To give all users in a multi-user installation write privileges, update /var/tmp/.oracle with 777 permissions:

$ chmod 777 /var/tmp/.oracle





After preparing two target system namely

DB.pngrb.gov.in and

App.pngrb.gov.in.



The folders under mount point /u01 to be copied to the db.pngrb.gov.in and /u21 to be coped to app.pngrb.gov.in

• Clone Steps Start From Here



1. Copy or Tar ball or sftp source system application tier file system to the target system.



Note: You need not to shutdown your source system application node for this step.



File System which need to be Tar ball or sftp to target system from Source System

includes:

• APPL_TOP

• COMMON_TOP

• ORACLEAS_10.1.2_ORACLE_HOME

• ORACLEAS_10.1.3_ORACLE_HOME



2. copy or TAR ball or sftp source system database tier file system to the target system.



a) This step require you bring down your source sytem (i.e database node) as user oracle.

b) Shutdown normal the source system database

c) copy the database (.dbf) files from the source to the target system

d) copy or TAR ball or sftp the source database ORACLE_HOME to the target system.



3. DBTier Configuration and then start the Target System database Server.



a) sudo su - oracle on target system

b) Run adcfgclone.pl on DB Tier. You will be prompted for the values specific to the target system like SID,port etc.



RDBMS_HOME = $ORACLE_HOME



$ cd $ORACLE_HOME/appsutil/clone/bin



$ perl adcfgclone.pl dbTier



4. Verify errors and warnings in the log



Location of the log file ApplyDBTier_.log



$ cd $ORACLE_HOME/appsutil/log/



5. Apps Tier configuration on Target system application Server nodes.



a) $sudo su - appl

b) Run adcfgclone.pl on Apps Tier. You will be prompted wfor the values specific to the target system like SID,port etc.



$cd $COMMON_TOP/clone/bin

$perl adcfgclone.pl appsTier



6. Verify the errors and warnings in the log.



Location of log ApplyAppsTier_.log



$cd $APPL_TOP/admin//log





• Clone Steps End Here

• Test your cloned environment and enter the below URL in your browser



http://app.pngrb.gov.in:8000



or



http://.:





If concurrent manager fails to startup

Run cmclean.sql





Non Destructive Script to Clean Concurrent Manager Tables

---------------------------------------------------------



*** ATTENTION 11.5.7+ OAM Users ***



Please run the Concurrent Manager Recovery feature to address any Concurrent

Manager / Concurrent Processing issues within the Oracle Application Manager.



Using the Concurrent Manager Recovery wizard is the method to clear the errors upon bringing the

internal manager back up.



The cmclean script can still be used for 11.5.7+ instances provided the managers are down and

no FNDLIBR processes are still running.



For Concurrent Internal Manager failures, it is recommended to run the Concurrent Manager Recovery

feature using the Oracle Applications Manager.

This feature should be used for recovering from when the Internal Manager won't start. This is accessed

from the Troubleshooting wizards available within applications logged in as the sysadmin userid. Navigate:



Oracle Applications Manager > Concurrent Managers OR Concurrent Requests > Site Map > Diagnostics

and Repair > Concurrent Manager Recovery



For information on the Concurrent Manager Recovery feature, please reference the Oracle Applications

System Administrator's Guide - Maintenance provides information for frequent tasks such as monitoring

your system with Oracle Applications Manager, administering Oracle E-Business Suite Secure Enterprise

Search, managing concurrent managers and reports, using diagnostic utilities including logging, managing

profile options, and using alerts.



*** ATTENTION 11.5.7+ OAM Users ***



NOTE:



This script works with 10.7, 11.0, 11.5 & 12 Applications.



NOTE:



Ensure that No FNDLIBR processes are running as detailed within

the Troubleshooting Note:104541.1 and that the Concurrent Manager

is down.



You need to issue a commit once the script is run for the changes

to take effect.



NOTE:



Copy from the first REM statement below to last REM statement of this

document and save as: cmclean.sql

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



REM

REM FILENAME

REM cmclean.sql

REM DESCRIPTION

REM Clean out the concurrent manager tables

REM NOTES

REM Usage: sqlplus @cmclean

REM

REM

REM $Id: cmclean.sql,v 1.4 2001/04/07 15:55:07 pferguso Exp $

REM

REM

REM +======================================================================+





set verify off;

set head off;

set timing off

set pagesize 1000



column manager format a20 heading 'Manager short name'

column pid heading 'Process id'

column pscode format a12 heading 'Status code'

column ccode format a12 heading 'Control code'

column request heading 'Request ID'

column pcode format a6 heading 'Phase'

column scode format a6 heading 'Status'





WHENEVER SQLERROR EXIT ROLLBACK;



DOCUMENT



WARNING : Do not run this script without explicit instructions

from Oracle Support





*** Make sure that the managers are shut down ***

*** before running this script ***



*** If the concurrent managers are NOT shut down, ***

*** exit this script now !! ***



#



accept answer prompt 'If you wish to continue type the word ''dual'': '



set feed off

select null from &answer;

set feed on





REM Update process status codes to TERMINATED



prompt

prompt ------------------------------------------------------------------------



prompt -- Updating invalid process status codes in FND_CONCURRENT_PROCESSES

set feedback off

set head on

break on manager



SELECT concurrent_queue_name manager,

concurrent_process_id pid,

process_status_code pscode

FROM fnd_concurrent_queues fcq, fnd_concurrent_processes fcp

WHERE process_status_code not in ('K', 'S')

AND fcq.concurrent_queue_id = fcp.concurrent_queue_id

AND fcq.application_id = fcp.queue_application_id;



set head off

set feedback on

UPDATE fnd_concurrent_processes

SET process_status_code = 'K'

WHERE process_status_code not in ('K', 'S');







REM Set all managers to 0 processes



prompt

prompt ------------------------------------------------------------------------



prompt -- Updating running processes in FND_CONCURRENT_QUEUES

prompt -- Setting running_processes = 0 and max_processes = 0 for all managers



UPDATE fnd_concurrent_queues

SET running_processes = 0, max_processes = 0;









REM Reset control codes



prompt

prompt ------------------------------------------------------------------------



prompt -- Updating invalid control_codes in FND_CONCURRENT_QUEUES

set feedback off

set head on

SELECT concurrent_queue_name manager,

control_code ccode

FROM fnd_concurrent_queues

WHERE control_code not in ('E', 'R', 'X')

AND control_code IS NOT NULL;



set feedback on

set head off

UPDATE fnd_concurrent_queues

SET control_code = NULL

WHERE control_code not in ('E', 'R', 'X')

AND control_code IS NOT NULL;



REM Also null out target_node for all managers

UPDATE fnd_concurrent_queues

SET target_node = null;





REM Set all 'Terminating' requests to Completed/Error

REM Also set Running requests to completed, since the managers are down



prompt

prompt ------------------------------------------------------------------------



prompt -- Updating any Running or Terminating requests to Completed/Error

set feedback off

set head on

SELECT request_id request,

phase_code pcode,

status_code scode

FROM fnd_concurrent_requests

WHERE status_code = 'T' OR phase_code = 'R'

ORDER BY request_id;



set feedback on

set head off

UPDATE fnd_concurrent_requests

SET phase_code = 'C', status_code = 'E'

WHERE status_code ='T' OR phase_code = 'R';











REM Set all Runalone flags to 'N'

REM This has to be done differently for Release 10



prompt

prompt ------------------------------------------------------------------------



prompt -- Updating any Runalone flags to 'N'

prompt

set serveroutput on

set feedback off

declare

c pls_integer := dbms_sql.open_cursor;

upd_rows pls_integer;

vers varchar2(50);

tbl varchar2(50);

col varchar2(50);

statement varchar2(255);

begin



select substr(release_name, 1, 2)

into vers

from fnd_product_groups;



if vers >= 11 then

tbl := 'fnd_conflicts_domain';

col := 'runalone_flag';

else

tbl := 'fnd_concurrent_conflict_sets';

col := 'run_alone_flag';

end if;





statement := 'update '

tbl

' set '

col

'=''N'' where '

col

' = ''Y''';

dbms_sql.parse(c, statement, dbms_sql.native);

upd_rows := dbms_sql.execute(c);

dbms_sql.close_cursor(c);

dbms_output.put_line('Updated '

upd_rows

' rows of '

col

' in '

tbl

' to ''N''');

end;

/







prompt



prompt ------------------------------------------------------------------------



prompt Updates complete.

prompt Type commit now to commit these updates, or rollback to cancel.

prompt ------------------------------------------------------------------------



prompt



set feedback on



REM <= Last REM statment -----------------------------------------------------