Cloning cheat list - EBS 11i / R12.1 / R12.2

Application Cloning

Post clone steps

1. Clean FND_NODES

SQL> select node_name, node_mode, support_cp, support_web, support_admin,support_forms from FND_NODES;

NODE_NAME       N S S S S

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

SGERP01       O Y Y Y Y

AUTHENTICATION       O N N N N

SQL> EXEC FND_CONC_CLONE.SETUP_CLEAN;

PL/SQL procedure successfully completed.

SQL> commit;

Commit complete.

2. Run AutoConfig on all tiers, firstly on the DB tier and then the APPS tiers

EBS R12.2 - Application Cloning

Issue 1:

############################################################

Started ApplyAppsTier at Sun Oct 26 13:38:45 SGT 2014

Version:

        ApplyAppsTier.java      :       120.11.12020000.6

#############################################################

Found the directory : /r122va/VIS3/fs1/FMW_Home

Exiting cloning as FMW Home already exists..

~                                                                                                          

Fix: Move this folder to some other name

Issue 2:

#########################################################

Started ApplyAppsTier at Sun Oct 26 13:40:13 SGT 2014

Version:

        ApplyAppsTier.java      :       120.11.12020000.6

#############################################################

Below Oracle Homes are already registered in the global inventory:

/r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1

/r122va/VIS3/fs1/FMW_Home/webtier

/r122va/VIS3/fs1/FMW_Home/oracle_common

/r122va/VIS3/fs1/FMW_Home/Oracle_OAMWebGate1

Exiting Cloning...

Ensure that the above Oracle Homes are unregistered from the global inventory "/r122vd/VIS3/oraInventory//ContentsXML/inventory.xml" and re-run adcfgclone.pl script

~                                                                                                           

~                                                                                                           

Fix :
move inventory.xml file so new file will be created

mv /r122vd/VIS3/oraInventory//ContentsXML/inventory.xml /r122vd/VIS3/oraInventory//ContentsXML/inventory.xml.jm1

Error 3:

END: Executed adupdlobs.pl

ERROR: AutoConfig completed with errors. Check logfile at /r122va/VIS3/fs1/inst/apps/VIS3_sar122vis1/admin/log/clone/ApplyAppsTier_10261341.log for details.

FMW JDK version in use: 1.7.0_25

/r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1/jdk is not a symbolic link, creating it...

Running ln -s /r122va/VIS3/fs1/EBSapps/comn/util/jdk64 /r122va/VIS3/fs1/FMW_Home/Oracle_EBS-app1/jdk

-- further errors

Updating s_tnsmode to 'generateTNS'

UpdateContext exited with status: 0

AC-50480: Internal error occurred: java.lang.Exception: Error while generating listener.ora.

Error generating tnsnames.ora from the database, temporary tnsnames.ora will be generated using templates

Instantiating Tools tnsnames.ora

Tools tnsnames.ora instantiated

adgentns.pl exiting with status 2

ERRORCODE = 2 ERRORCODE_END

fix: run fnd_node clean and run autoconfig on application and databsae node

applmgr@sar122vis1 bin]$ . /r122va/VIS3/EBSapps.env run

  E-Business Suite Environment Information

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

  RUN File System           : /r122va/VIS3/fs1/EBSapps/appl

  PATCH File System         : /r122va/VIS3/fs2/EBSapps/appl

  Non-Editioned File System : /r122va/VIS3/fs_ne

  DB Host: sar122vis1.stone-apple.com  Service/SID: VIS3

  Sourcing the RUN File System ...

[applmgr@sar122vis1 bin]$ cd $ADMIN_SCRIPTS_HOME 

[applmgr@sar122vis1 scripts]$ ./adautocfg.sh 

Enter the APPS user password:

RPM required for RHEL 6 to run Oracle Database 11gR2

Install following Rpm from the Yum / Installation Media

yum install libSM.i686 libXp.i686 libXp.x86_64 libX11.i686 libXt.i686 libXrender.i686 compat-db43.i686 gcc.x86_64 gcc-c++.x86_64 glibc-devel.i686 libgcc.i686 \
libstdc++-devel.i686 libstdc++-devel.x86_64 libstdc++.i686 libXi.i686 libaio.i686 gdbm.i686 compat-libstdc++-296.i686 compat-libstdc++-33.i686 compat-libcap1.x86_64 \
compat-libstdc++-33.x86_64 elfutils-libelf-devel.x86_64 libaio-devel.x86_64 unixODBC.i686 unixODBC.x86_64 unixODBC-devel.i686 unixODBC-devel.x86_64 xorg-x11-utils.x86_64 \
ksh.x86_64

Download following package from the Oracle website and Install it.

wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/openmotif21-2.1.30-11.EL6.i686.rpm

rpm -ivh openmotif21-2.1.30-11.EL6.i686.rpm 

wget https://oss.oracle.com/projects/compat-oracle/dist/files/Enterprise_Linux/xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

rpm -ivh xorg-x11-libs-compat-6.8.2-1.EL.33.0.1.i386.rpm

How to connect to AWS EC2 Server

Step 1 : Connect to the Jumpin server

From mac Pc

Copy secure key to your mac and run the below command

ssh -i <secure key> <username>@<server IP Address>

from Jump-in server to the actual server

From Putty

Oracle EBS R12.1.3 - WebADI with 64bit Office

 

Issue 1: Users are unable to open WebADI Document in some of the PC with Office 2010.

Error: java.lang.NoSuchMethodError: oracle.apps.bne.utilities.oa.BneDFFStructure.setValType(Ljava/lang/String;)



Solution:
1. Apply Patch - 14209751:R12.BNE.B
2. Bounce Middle-tier

Change:
BneDFFStructure.java 120.1.12010000.2 2009/08/03 16:23:37
to
BneDFFStructure.java 120.1.12010000.4 2012/11/30 19:32:09

Install AWS Command Line Interface on Oracle Linux 5

1. Download Active Perl from below website
2. Download AWS CLI from the Amazon website


1. Install Active Perl

cd /tmpwget http://downloads.activestate.com/ActivePython/releases/2.7.8.10/ActivePython-2.7.8.10-linux-x86_64.tar.gztar -xzvf ActivePython-2.7.8.10-linux-x86_64.tar.gzcd ActivePython-2.7.8.10-linux-x86_64
[root@bastion ActivePython-2.7.8.10-linux-x86_64]# ./install.shEnter directory in which to install ActivePython. Leave blank andpress 'Enter' to use the default [/opt/ActivePython-2.7].Install directory:()Installing ActivePython to '/opt/ActivePython-2.7'...Relocating dir-dependent files...

2. Install AWS CLI

cd /tmp
export PATH=/opt/ActivePython-2.7/bin:$PATH
wget https://s3.amazonaws.com/aws-cli/awscli-bundle.zip
[root@bastion tmp]# export PATH=/opt/ActivePython-2.7/bin:$PATH
[root@bastion tmp]# ./awscli-bundle/install -i /usr/local/aws -b /usr/local/bin/aws
Running cmd: /opt/ActivePython-2.7/bin/python virtualenv.py --python /opt/ActivePython-2.7/bin/python /usr/local/aws
Running cmd: /usr/local/aws/bin/pip install --no-index --find-links file:///tmp/awscli-bundle/packages awscli-1.4.0.tar.gz
You can now run: /usr/local/bin/aws --version
[root@bastion tmp]# /usr/local/bin/aws --version
aws-cli/1.4.0 Python/2.7.8 Linux/2.6.18-194.0.0.0.3.el5xen
[root@bastion tmp]#

3. Configure AWS 

[root@sar12vis tmp]# aws configure

AWS Access Key ID [None]: xxxxxxxxxxxxxxxxxxxxxxAWS

Secret Access Key [None]: xxxxxxxxxxxxxxxxxxxxxx

Default region name [None]: ap-southeast-1

Default output format [None]:

[root@sar12vis tmp]#

4. Ready to use

[xxxx@bastion ~]$ aws ec2 help