askMLabs

10:10 AM

Database Upgrade From 11202 to 12101 Using DBUA

Written By askMLabs on Tuesday, February 25, 2014 | 10:10 AM

In this article, i am going to explain the single standalone database upgrade from 11202 version to latest 12c (12101) version using DBUA.

When we use DBUA to upgrade your database, most of the upgrade tasks are automated.
The outlined action plan to upgrade database is given below, but all steps mentioned below are explained in detail in the video.

1. Verify all the components status

set pagesize500
set linesize 100
select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;

2. Run dbupgdiag.sql : Note 556610.1
3. Disable the custom triggers that would fire before/after DDL and enable them after the upgrade is complete.
4. Take database backup.
5. Install database 12c software only installation in a new oracle home.
6. Copy preupgrd.sql file from new 12c home created in step 5 to any temporary location and run this script. This script creates two fixup scripts. Review those fixup scripts ( This step is optional ) - DBUA runs this step.
7. Check invalid objects and run utlrp.sql script if you have any invalids
8. Verify the time zone. Oracle database 12c brings time zone file 18. So you have the option, either you can upgrade time zone after completing database upgrade or during the database upgrade. Note 1522719.1
9. Gather optimizer statistics
10. Disable database vault Note 453902.1
11. Truncate audit records ( to avoid hanging issues while upgrading)

SQL> truncate table sys.aud$;
SQL> truncate table sys.fga_log$;

12. Remove oem database control if you have configured in your environment.

sql> connect / as sysdba
sql> spool emremoval.log
sql>@emremove.sql
sql> spool off

13. Unset ORACLE_HOME and invoke DBUA from the 12c binaries installed in step5.
14. Complete the upgrade database.
15. Verify for any invalid objects and run the utlrp.sql
16. Check if you have any special instructions specific to your environment and complete all the steps.
17. Post upgrade verification steps :

set pagesize500
set linesize 100
select substr(comp_name,1,40) comp_name, status, substr(version,1,10) version from dba_registry order by comp_name;
select substr(object_name,1,40) object_name,substr(owner,1,15) owner,object_type from dba_objects where status='INVALID' order by owner,object_type;
select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type order by owner,object_type ;
select name,user,created,CDB,CON_ID,CON_DBID from v$database;
select instance_name,status from v$instance;
SELECT version FROM v$timezone_file;
SELECT dbms_xdb_config.gethttpsport FROM dual;
https://<database-ip>:5500/em

Logfile for upgrade are located : $ORACLE_BASE/cfgtoollogs/$ORACLE_SID

Please watch the video for more details on database upgrade from 11202 to 12101 using DBUA.

NOTE : This video is created with audio. Due to some technical issues, the audio is not recorded properly. Reference : 1516557.1

Hope this helps

SRI

9:48 AM

Database 12c Installation on CentOS 6.5

Written By askMLabs on Monday, February 24, 2014 | 9:48 AM

In this article, i am going to show you the steps to install oracle database 12c on CentOS 6.5. Though CentOS 6.5 is officially not supported by oracle by its certification matrix, we do follow the same instructions that we use for OL6.x or RHEL6.x.

You might be finding so many other places about the instructions with screen shots to install oracle database 12c, and this is just another place to find the same content. The actual purpose to create this database is to use for oem 12c installation. So just collected the installation screen shots to present if it helps some newbies.

Download the software for database 12c. Download

Complete all the following pre-requisites before starting the oracle database 12c installation.

1. Hardware requirement:
RAM - 1.5 GB min
Swap - 1.5*RAM ( this is optional, we can configure temporary swap )
/tmp space - 1GB min
ORACLE_HOME -- 6.5GB

2. Software Requirements :
2.1 Check OS version and Kernel :

[root@db12c ~]# cat /etc/redhat-release
CentOS release 6.5 (Final)
[root@db12c ~]# uname -r
2.6.32-431.3.1.el6.x86_64
[root@db12c ~]#

2.2 Install all the required rpms. The following table lists all the required rpms for database 12c. This table is copied from the MOS ID 1587357.1
If you have configured YUM repository for your server, you can use the following commands to install rpms. Refer my other article to know how to configure YUM to your distribution.

yum install <rpm name>.

If you don't have YUM configured, you need to copy all the below specified rpms from your CentOS 6.5 distribution CD and need to install manually.

rpm -ivh <rpm name>

OS Version	Patches/Packages	Kernel settings
Oracle Linux 6 with the Unbreakable Enterprise kernel: 2.6.39-200.24.1.el6uek.x86_64 or later Oracle Linux 6 with the Red Hat Compatible kernel: 2.6.32-71.el6.x86_64 or later Red Hat Enterprise Linux 6: 2.6.32-71.el6.x86_64 or later Red Hat Enterprise Linux 6 with the Unbreakable Enterprise Kernel: 2.6.32-100.28.5.el6.x86_64 or later Reference : Note 1529864.1	binutils-2.20.51.0.2-5.11.el6 (x86_64) glibc-2.12-1.7.el6 (x86_64) libgcc-4.4.4-13.el6 (x86_64) libstdc++-4.4.4-13.el6 (x86_64) libaio-0.3.107-10.el6 (x86_64) libXext-1.1 (x86_64) libXtst-1.0.99.2 (x86_64) libX11-1.3 (x86_64) libXau-1.0.5 (x86_64) libxcb-1.5 (x86_64) libXi-1.3 (x86_64) make-3.81-19.el6 sysstat-9.0.4-11.el6 (x86_64) compat-libcap1-1.10-1 (x86_64) compat-libstdc++-33-3.2.3-69.el6 (x86_64) gcc-4.4.4-13.el6 (x86_64) gcc-c++-4.4.4-13.el6 (x86_64) glibc-devel-2.12-1.7.el6 (x86_64) ksh <== any version of ksh is acceptable libstdc++-devel-4.4.4-13.el6 (x86_64) libaio-devel-0.3.107-10.el6 (x86_64) Some depended RPMS for above listed packages cloog-ppl.x86_64 0:0.15.7-1.2.el6 cpp.x86_64 0:4.4.6-4.el6 glibc-headers.x86_64 0:2.12-1.80.el6 kernel-headers.x86_64 0:2.6.32-279.el6 mpfr.x86_64 0:2.4.1-6.el6 ppl.x86_64 0:0.10.2-11.el6	/etc/sysctl.conf kernel.shmmni = 4096 kernel.sem = 250 32000 100 128 fs.file-max = 6815744 fs.aio-max-nr = 1048576 Note: This value limits concurrent outstanding requests and should be set to avoid I/O subsystem failures. net.ipv4.ip_local_port_range = 9000 65500 net.core.rmem_default = 262144 net.core.rmem_max = 4194304 net.core.wmem_default = 262144 net.core.wmem_max = 1048576 /etc/security/limits.conf oracle soft nproc 2047 oracle hard nproc 16384 oracle soft nofile 1024 oracle hard nofile 65536 oracle soft stack 10240 oracle hard stack 10240 /etc/pam.d/login session required pam_limits.so /etc/profile if [ $USER = "oracle" ]; then if [ $SHELL = "/bin/ksh" ]; then ulimit -u 16384 ulimit -n 65536 else ulimit -u 16384 -n 65536 fi fi

Session Log For Reference:

[root@db12c ~]# egrep --color 'Mem|Cache|Swap' /proc/meminfoMemTotal: 49423668 kB
MemFree: 7364136 kB
Cached: 34088520 kB
SwapCached: 8060 kB
SwapTotal: 24780792 kB
SwapFree: 23905912 kB
[root@db12c ~]# df -h /tmpFilesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_db12c-lv_root 11G 5.1G 5.3G 50% /
[root@db12c ~]# df -h /homeFilesystem Size Used Avail Use% Mounted on
/dev/mapper/vg_db12c-lv_home 2.7T 641G 1.9T 25% /home
[root@db12c ~]# cat /etc/redhat-releaseCentOS release 6.5 (Final)
[root@db12c ~]# uname -r2.6.32-431.3.1.el6.x86_64
[root@db12c ~]#
[root@db12c ~]# rpm -qa | grep -i binutils-binutils-2.20.51.0.2-5.36.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i glibcglibc-devel-2.12-1.132.el6.i686
glibc-common-2.12-1.132.el6.x86_64
glibc-2.12-1.132.el6.x86_64
glibc-devel-2.12-1.132.el6.x86_64
glibc-headers-2.12-1.132.el6.x86_64
glibc-2.12-1.132.el6.i686
[root@db12c ~]# rpm -qa | grep -i libgcclibgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libstdc++libstdc++-4.4.7-4.el6.i686
libstdc++-4.4.7-4.el6.x86_64
libstdc++-devel-4.4.7-4.el6.x86_64
compat-libstdc++-33-3.2.3-69.el6.x86_64
compat-libstdc++-296-2.96-144.el6.i686
libstdc++-devel-4.4.7-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libaiolibaio-devel-0.3.107-10.el6.i686
libaio-0.3.107-10.el6.x86_64
libaio-devel-0.3.107-10.el6.x86_64
libaio-0.3.107-10.el6.i686
[root@db12c ~]# rpm -qa | grep -i libXextlibXext-1.3.1-2.el6.i686
libXext-devel-1.3.1-2.el6.x86_64
libXext-1.3.1-2.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libXtstlibXtst-1.2.1-2.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libX11libX11-1.5.0-4.el6.x86_64
libX11-common-1.5.0-4.el6.noarch
libX11-devel-1.5.0-4.el6.x86_64
libX11-1.5.0-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libXaulibXau-1.0.6-4.el6.i686
libXau-devel-1.0.6-4.el6.x86_64
libXau-1.0.6-4.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libxcblibxcb-1.8.1-1.el6.i686
libxcb-devel-1.8.1-1.el6.x86_64
libxcb-1.8.1-1.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i libXilibXinerama-devel-1.1.2-2.el6.x86_64
libXinerama-1.1.2-2.el6.x86_64
libXi-devel-1.6.1-3.el6.x86_64
libXi-1.6.1-3.el6.i686
libXi-1.6.1-3.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i makeautomake-1.11.1-4.el6.noarch
MAKEDEV-3.24-6.el6.x86_64
perl-ExtUtils-MakeMaker-6.55-136.el6.x86_64
perl-Locale-Maketext-Simple-0.18-136.el6.x86_64
make-3.81-20.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i sysstatsysstat-9.0.4-22.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i compat-libcap1compat-libcap1-1.10-1.x86_64
[root@db12c ~]# rpm -qa | grep -i compat-libstdc++compat-libstdc++-33-3.2.3-69.el6.x86_64
compat-libstdc++-296-2.96-144.el6.i686
[root@db12c ~]# rpm -qa | grep -i gccgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.x86_64
libgcc-4.4.7-4.el6.i686
gcc-gfortran-4.4.7-4.el6.x86_64
gcc-c++-4.4.7-4.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i gcc-c++gcc-c++-4.4.7-4.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i glibc-develglibc-devel-2.12-1.132.el6.i686
glibc-devel-2.12-1.132.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i kshpdksh-5.2.14-30.x86_64
[root@db12c ~]# rpm -qa | grep -i libstdc++-devellibstdc++-devel-4.4.7-4.el6.x86_64
libstdc++-devel-4.4.7-4.el6.i686
[root@db12c ~]# rpm -qa | grep -i libaio-devellibaio-devel-0.3.107-10.el6.i686
libaio-devel-0.3.107-10.el6.x86_64
[root@db12c ~]#
[root@db12c ~]# rpm -qa | grep -i cloog-pplcloog-ppl-devel-0.15.7-1.2.el6.x86_64
cloog-ppl-0.15.7-1.2.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i cppcpp-4.4.7-4.el6.x86_64
abrt-addon-ccpp-2.0.8-21.el6.centos.x86_64
cppunit-1.12.1-3.1.el6.x86_64
cppunit-doc-1.12.1-3.1.el6.x86_64
mcpp-2.7.2-4.1.el6.x86_64
cppunit-devel-1.12.1-3.1.el6.x86_64
libmcpp-2.7.2-4.1.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i glibc-headersglibc-headers-2.12-1.132.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i kernel-headerskernel-headers-2.6.32-431.3.1.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i mpfrmpfr-2.4.1-6.el6.x86_64
[root@db12c ~]# rpm -qa | grep -i pplpoppler-utils-0.12.4-3.el6_0.1.x86_64
wpa_supplicant-0.7.3-4.el6_3.x86_64
cloog-ppl-devel-0.15.7-1.2.el6.x86_64
poppler-0.12.4-3.el6_0.1.x86_64
poppler-qt4-0.12.4-3.el6_0.1.x86_64
cloog-ppl-0.15.7-1.2.el6.x86_64
gnome-python2-applet-2.28.0-5.el6.x86_64
gnome-applets-2.28.0-7.el6.centos.x86_64
ppl-devel-0.10.2-11.el6.x86_64
gdm-user-switch-applet-2.30.4-52.el6.x86_64
poppler-data-0.4.0-1.el6.noarch
ppl-0.10.2-11.el6.x86_64
[root@db12c ~]#

[root@db12c ~]# grep -i pam_limits.so /etc/pam.d/loginsession required pam_limits.so
[root@db12c ~]#
[root@db12c ~]# gcc --versiongcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4)
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
[root@db12c ~]# g++ --versiong++ (GCC) 4.4.7 20120313 (Red Hat 4.4.7-4)
Copyright (C) 2010 Free Software Foundation, Inc.
This is free software; see the source for copying conditions. There is NO
warranty; not even for MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.
[root@db12c ~]#
[root@db12c ~]# hostnamedb12c.askmlabs.com
[root@db12c ~]#

2.3 Extract the software and start the installation

[root@db12c ~]# /home/apps/oem12c/product/12.1.0/dbhome_1/root.sh
Performing root user operation for Oracle 12c

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /home/apps/oem12c/product/12.1.0/dbhome_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
[root@db12c ~]#

[root@db12c ~]# su - oracle
[oracle@db12c ~]$ ps -ef | grep -i pmonoracle 2598 1 0 Feb23 ? 00:00:02 ora_pmon_VIS
oracle 13254 1 0 01:09 ? 00:00:00 ora_pmon_oem12c
oracle 14186 14152 0 01:39 pts/2 00:00:00 grep -i pmon
[oracle@db12c ~]$ export ORACLE_SID=oem12c[oracle@db12c ~]$ export ORACLE_HOME=/home/apps/oem12c/product/12.1.0/dbhome_1[oracle@db12c ~]$ export PATH=$PATH:$ORACLE_HOME/bin[oracle@db12c ~]$ which sqlplus/home/apps/oem12c/product/12.1.0/dbhome_1/bin/sqlplus
[oracle@db12c ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 12.1.0.1.0 Production on Mon Feb 24 01:40:33 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> select name,user,created,CDB,CON_ID,CON_DBID from v$database;
NAME USER CREATED CDB CON_ID CON_DBID
--------- ------------------------------ --------- --- ---------- ----------
OEM12C SYS 24-FEB-14 NO 0 151531197
SQL> select instance_name,status from v$instance;
INSTANCE_NAME STATUS
---------------- ------------
oem12c OPEN
SQL>

Reference : MOS ID Note 1529864.1

Hope this helps
SRI

5:13 AM

E-Business Suite R12.2.3 Cloning

Written By askMLabs on Sunday, February 23, 2014 | 5:13 AM

In this article , i am going to present the cloning procedure on E-business suite R12.2.3 environment. The main procedure to clone an e-business suite environment in R12.2.3 is same except to clone the patch file system in target clone environment.
I collected session log and am presenting it for reference to see the prompts while cloning.

A. Environment
B. Prepare the source system

1. Prepare the source system database tier for cloning
2. Prepare the Source System Application Tier for cloning

C. Copy the Source System to the Target System

1. Copy the Database Node file system
2. Copy the Application Tier file system from the Source "Run Edition File System" to the Target "Run Edition File System"

D. Configure the Target System

1. Configure the Target System database server
2. Configure the Target System Application Tier server nodes
3. Run adpreclone.pl on the "Run Edition File System" in the Target System. (NEW in R12.2)
4. Copy Oracle E-Business Suite application directories from the "Run Edition File System" to the "Patch Edition File System" in the Target System. (NEW in R12.2)
5. Configure Patch file system on target appsTier (NEW in R12.2)

E. Finishing Tasks

A.Environment

	Source	Target
Database Name	VISDB	CLONE
Database Node	ebiz1222db01.askmlabs.com	ebiz1223db01.askmlabs.com
Application Node	ebiz1222ap01.askmlabs.com	ebiz1223ap01.askmlabs.com
Run File system	/u01/install/fs1	/u01/install/fs1
Patch File System	/u01/install/fs2	/u01/install/fs2

As we have dual file system in R12.2, we need to first clone run file system from source to target. Then patch file system on target environment is created from the run file system cloned from the source environment. The diagramatic representation is given below. This picture is taken from Oracle E-business suite documentation.

B.1 Prepare the source system database tier for cloning :

Log on to the Source System as the ORACLE user, and run the following commands:

$ cd <RDBMS ORACLE_HOME>/appsutil/scripts/<CONTEXT_NAME>
$ perl adpreclone.pl dbTier

B.2 Prepare the Source System Application Tier for cloning:

Log on to the "Run Edition File System" in the Source System as the APPLMGR

user, and run the following commands on the node that contains an

APPL_TOP:

$ cd <INST_TOP>/admin/scripts
$ perl adpreclone.pl appsTier

C.1 Copy the Database Node file system
There are various procedures to clone database from source to target. You can use hotbackup of the source database , you can also use RMAN duplication from active database option. But in this article, i am using simple and easy method of cold backup to copy the source database to target database.

Log on to the Source System Database node as the ORACLE user, and then:
Perform a normal shutdown of the Source System database

[root@ebiz1222db01 ~]# su - oracle
[oracle@ebiz1222db01 ~]$ . /u01/install/11.2.0/VISDB_ebiz1222db01.env
[oracle@ebiz1222db01 ~]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Sun Feb 23 02:16:16 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

Copy the database (.dbf) files from the Source System to the Target System

[oracle@ebiz1222db01 data]$ pwd
/u01/install/data
[oracle@ebiz1222db01 data]$ ls
apps_ts_interface.dbf ctx1.dbf omo1.dbf summary5.dbf sys8.dbf system20.dbf tx_data18.dbf tx_data3.dbf tx_idx15.dbf tx_idx6.dbf
archive dcm.dbf opmtr01.dbf summary6.dbf sys9.dbf temp0001.dbf tx_data19.dbf tx_data4.dbf tx_idx16.dbf tx_idx7.dbf
archive1.dbf dm_olaptrain_arc.dbf owb1.dbf summary7.dbf sysaux01.dbf temp01.dbf tx_data1.dbf tx_data5.dbf tx_idx17.dbf tx_idx8.dbf
a_ref03.dbf log1.dbf owb2.dbf sys10.dbf sysaux02.dbf temp02.dbf tx_data20.dbf tx_data6.dbf tx_idx18.dbf tx_idx9.dbf
a_ref04.dbf log2.dbf queues1.dbf sys11.dbf system12.dbf tx_data10.dbf tx_data21.dbf tx_data7.dbf tx_idx19.dbf undotbs001.dbf
a_ref05.dbf log3.dbf queues2.dbf sys1.dbf system13.dbf tx_data11.dbf tx_data22.dbf tx_data8.dbf tx_idx1.dbf undotbs002.dbf
cntrl01.dbf media1.dbf reference1.dbf sys2.dbf system14.dbf tx_data12.dbf tx_data23.dbf tx_data9.dbf tx_idx20.dbf undotbs003.dbf
cntrl02.dbf media2.dbf reference2.dbf sys3.dbf system15.dbf tx_data13.dbf tx_data24.dbf tx_idx10.dbf tx_idx21.dbf xdb01.dbf
cntrl03.dbf media3.dbf summary1.dbf sys4.dbf system16.dbf tx_data14.dbf tx_data25.dbf tx_idx11.dbf tx_idx2.dbf
controlfile_VS1222B71.ctl nologging1.dbf summary2.dbf sys5.dbf system17.dbf tx_data15.dbf tx_data26.dbf tx_idx12.dbf tx_idx3.dbf
controlfile_VS1222B72.ctl nologging3.dbf summary3.dbf sys6.dbf system18.dbf tx_data16.dbf tx_data27.dbf tx_idx13.dbf tx_idx4.dbf
controlfile_VS1222B73.ctl odm.dbf summary4.dbf sys7.dbf system19.dbf tx_data17.dbf tx_data2.dbf tx_idx14.dbf tx_idx5.dbf
[oracle@ebiz1222db01 data]$ scp * oracle@ebiz1223db01:/u01/install/data

Copy the Source System database ORACLE_HOME to the Target System

[oracle@ebiz1222db01 install]$ cd /u01/install
[oracle@ebiz1222db01 install]$ tar czf db1120.tar.gz 11.2.0/
[oracle@ebiz1222db01 install]$ pwd
/u01/install
[oracle@ebiz1222db01 install]$ ls -lrt
total 3652404
drwxr-xr-x 3 oracle oracle 4096 Sep 5 04:44 data
drwxr-xr-x 82 oracle oracle 4096 Jan 30 08:46 11.2.0
drwxrwx--- 4 oracle oracle 4096 Jan 30 08:49 oraInventory
-rw-rw-r-- 1 oracle oracle 3736392676 Feb 4 03:30 db1120.tar.gz
[oracle@ebiz1222db01 install]$
[oracle@ebiz1222db01 install]$ scp db1120.tar.gz oracle@ebiz1223db01:/u01/install/

Start the Source Applications system database and Application Tier
processes

C.2 Copy the Application Tier file system from the Source "Run Edition File System" to the Target "Run Edition File System"

Log on to "Run Edition File System" in the Source System Application Tier
nodes as the APPLMGR user.

[applmgr@ebiz1222ap01 ~]$ cd /u01/install
[applmgr@ebiz1222ap01 install]$ ls
adctrl.log EBSapps.env fs1 fs2 fs_ne oraInventory scripts sqlnet.log webgate
[applmgr@ebiz1222ap01 install]$ . ./EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/install/fs1/EBSapps/appl
PATCH File System : /u01/install/fs2/EBSapps/appl
Non-Editioned File System : /u01/install/fs_ne
DB Host: ebiz1222db01.localdomain.com Service/SID: VISDB
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Would you like to set the E-Business Suite environment [R/P]:R
Sourcing the RUN File System ...
[applmgr@ebiz1222ap01 install]$ echo $FILE_EDITION
run
[applmgr@ebiz1222ap01 install]$ echo $RUN_BASE
/u01/install/fs1
[applmgr@ebiz1222ap01 install]$ echo $PATCH_BASE
/u01/install/fs2
[applmgr@ebiz1222ap01 install]$ cd $RUN_BASE
[applmgr@ebiz1222ap01 fs1]$ ls
EBSapps FMW_Home inst
[applmgr@ebiz1222ap01 fs1]$ cd EBSapps/
[applmgr@ebiz1222ap01 EBSapps]$ ls
10.1.2 appl comn
[applmgr@ebiz1222ap01 EBSapps]$ cd ..
[applmgr@ebiz1222ap01 fs1]$ tar cvf EBSapps.tar.gz EBSapps/
[applmgr@ebiz1222ap01 fs1]$ scp EBSapps.tar.gz applmgr@ebiz1223ap01:/u01/install/fs1

D.1 Configure the Target System database server

Log on to the Target System as the ORACLE user and enter the following commands:

$ cd <RDBMS ORACLE_HOME>/appsutil/clone/bin
$ perl adcfgclone.pl dbTier

[oracle@ebiz1223db install]$ tar xzf db1120.tar.gz
[oracle@ebiz1223db install]$ cd 11.2.0/
[oracle@ebiz1223db 11.2.0]$ ls
admin ccr crs deinstall hs jdbc log odbc oui rdbms slax temp wwg
apex cdata csmig demo ide jdev md olap owb relnotes sqldeveloper timingframework xdk
appsutil cfgtoollogs css diagnostics install jdk mesg OPatch owm root.sh sqlj ucp
appsutil.old checkpoints ctx dv instantclient jlib mgw opmn perl root.sh.old sqlpatch uix
appsutil.zip clone cv emcli inventory jpub network oracore plsql root.sh.old.1 sqlplus usm
assistants config dbs EMStage j2ee ldap nls oraInst.loc precomp root.sh.ouibak srvm utl
bin cpu dc_ocm has javavm lib oc4j ord racg scheduler sysman VISDB_ebiz1222db01.env
[oracle@ebiz1223db 11.2.0]$ cd clone
[oracle@ebiz1223db clone]$ ls
bin clonehome.xml clonehome.xsd config excludefiles.xml excludefiles.xsd toplevelcomps.xml toplevelcomps.xsd
[oracle@ebiz1223db clone]$ cd ../appsutil
[oracle@ebiz1223db appsutil]$ ls
autobuild clone driver install jre media outbound scripts temp VISDB_ebiz1222db01.xml VISION_ebs.xml VISION_ebs.xml.bak
bin clone_04FEB2014 html java log out perl sql template VISION_db.xml VISION_ebs.xml0.bak
[oracle@ebiz1223db appsutil]$ cd clone
[oracle@ebiz1223db clone]$ ls
bin context data dbts html jlib jre oui
[oracle@ebiz1223db clone]$ cd bin
[oracle@ebiz1223db bin]$ ls
adcfgclone.pl adchkutl.sh adclonectx.pl adclone.pl
[oracle@ebiz1223db bin]$
[oracle@ebiz1223db bin]$ perl adcfgclone.pl dbTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.22
Enter the APPS password :
Running:
/u01/install/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/11.2.0/appsutil/clone/jlib/java:/u01/install/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/install/11.2.0/appsutil/clone/jlib/ojdbc5.jar:/u01/install/11.2.0/appsutil/clone/jlib/obfuscatepassword.jar:/u01/install/11.2.0/appsutil/clone/jlib/ojmisc.jar:/u01/install/11.2.0/appsutil/clone/jlib/java:/u01/install/11.2.0/appsutil/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/11.2.0/appsutil/clone/bin/../context/db/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_2588.lst -stage /u01/install/11.2.0/appsutil/clone 2> /tmp/adcfgclone_2588.err; echo $? > /tmp/adcfgclone_2588.res
Log file located at /u01/install/11.2.0/appsutil/clone/bin/CloneContext_0210070912.log
Provide the values required for creation of the new Database Context file.
Target System Hostname (virtual or normal) [ebiz1223db] :
Target Instance is RAC (y/n) [n] :
Target System Database SID : CLONE
Target System Base Directory : /u01/install
Target System utl_file_dir Directory List : /tmp
Number of DATA_TOP's on the Target System [1] :
Target System DATA_TOP Directory 1 [/u01/install/data] :
Target System RDBMS ORACLE_HOME Directory [/u01/install/11.2.0] :
Do you want to preserve the Display [localhost:5.0] (y/n) : y
Do you want the target system to have the same port values as the source system (y/n) [y] ? : y
RC-50220: Warning: Database Port: 1521 is not free. Unable to preserve the port settings from source system.
Target System Port Pool [0-99] : 0
Checking the port pool 0
RC-50221: Warning: Port Pool 0 is not free. Please check logfile /u01/install/11.2.0/appsutil/clone/bin/CloneContext_0210070912.log for conflicts.
Target System Port Pool [0-99] : 1
Checking the port pool 1
done: Port Pool 1 is free
Report file located at /u01/install/11.2.0/appsutil/temp/portpool.lst
Complete port information available at /u01/install/11.2.0/appsutil/temp/portpool.lst
Creating the new Database Context file from :
/u01/install/11.2.0/appsutil/clone/context/db/adxdbctx.tmp
The new database context file has been created :
/u01/install/11.2.0/appsutil/CLONE_ebiz1223db.xml
Log file located at /u01/install/11.2.0/appsutil/clone/bin/CloneContext_0210070912.log
Check Clone Context logfile /u01/install/11.2.0/appsutil/clone/bin/CloneContext_0210070912.log for details.

One or more listeners are currently running in your Target ORACLE_HOME.
Please make sure there are no processes running before proceeding.
Continue? (y/n) [n]) : y
Running Rapid Clone with command:
Running:
perl /u01/install/11.2.0/appsutil/clone/bin/adclone.pl java=/u01/install/11.2.0/appsutil/clone/bin/../jre mode=apply stage=/u01/install/11.2.0/appsutil/clone component=dbTier method=CUSTOM dbctxtg=/u01/install/11.2.0/appsutil/CLONE_ebiz1223db.xml showProgress contextValidated=true

Beginning database tier Apply - Mon Feb 10 07:11:22 2014
/u01/install/11.2.0/appsutil/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/u01/install/11.2.0/oui -classpath /u01/install/11.2.0/appsutil/clone/jlib/xmlparserv2.jar:/u01/install/11.2.0/appsutil/clone/jlib/ojdbc6.jar:/u01/install/11.2.0/appsutil/clone/jlib/java:/u01/install/11.2.0/appsutil/clone/jlib/oui/OraInstaller.jar:/u01/install/11.2.0/appsutil/clone/jlib/oui/ewt3.jar:/u01/install/11.2.0/appsutil/clone/jlib/oui/share.jar:/u01/install/11.2.0/appsutil/clone/jlib/oui/srvm.jar:/u01/install/11.2.0/appsutil/clone/jlib/ojmisc.jar oracle.apps.ad.clone.ApplyDBTier -e /u01/install/11.2.0/appsutil/CLONE_ebiz1223db.xml -stage /u01/install/11.2.0/appsutil/clone -showProgress
APPS Password : Log file located at /u01/install/11.2.0/appsutil/log/CLONE_ebiz1223db/ApplyDBTier_02100711.log
\ 15% completed
Completed Apply...
Mon Feb 10 07:27:21 2014
Starting database listener for CLONE:
Running:
/u01/install/11.2.0/appsutil/scripts/CLONE_ebiz1223db/addlnctl.sh start CLONE
Logfile: /u01/install/11.2.0/appsutil/log/CLONE_ebiz1223db/addlnctl.txt
You are running addlnctl.sh version 120.4

Starting listener process CLONE ...

Listener CLONE has already been started.

addlnctl.sh: exiting with status 0
addlnctl.sh: check the logfile /u01/install/11.2.0/appsutil/log/CLONE_ebiz1223db/addlnctl.txt for more information ...
[oracle@ebiz1223db bin]$ ps ucx
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
oracle 2469 0.0 0.0 66092 1444 pts/0 S 06:37 0:00 bash
oracle 2716 0.0 0.0 66092 1232 pts/1 S+ 07:10 0:00 bash
oracle 9052 0.0 0.3 87816 13736 ? Ss 07:17 0:00 tnslsnr
oracle 9747 0.0 0.5 2336600 20776 ? Ss 07:22 0:00 oracle
oracle 9749 0.0 0.4 2334312 16664 ? Ss 07:22 0:00 oracle
oracle 9751 0.0 0.4 2334312 16560 ? Ss 07:22 0:00 oracle
oracle 9755 0.0 0.4 2334312 16504 ? Ss 07:22 0:00 oracle
oracle 9757 0.0 0.4 2334312 16424 ? Ss 07:22 0:00 oracle
oracle 9759 0.0 0.6 2334824 26852 ? Ss 07:22 0:00 oracle
oracle 9761 0.0 0.5 2335848 22224 ? Ss 07:22 0:00 oracle
oracle 9763 0.0 3.5 2334312 141796 ? Ss 07:22 0:00 oracle
oracle 9765 0.0 1.3 2340836 53324 ? Ss 07:22 0:00 oracle
oracle 9767 0.0 0.7 2349864 29076 ? Ss 07:22 0:00 oracle
oracle 9769 0.0 0.6 2334824 24672 ? Ss 07:22 0:00 oracle
oracle 9771 3.8 8.0 2341104 326872 ? Ss 07:22 0:34 oracle
oracle 9773 0.0 0.5 2334824 23736 ? Ss 07:22 0:00 oracle
oracle 9775 0.1 2.6 2340280 106544 ? Ss 07:22 0:01 oracle
oracle 9777 0.0 0.6 2335544 27068 ? Ss 07:22 0:00 oracle
oracle 9790 0.0 0.5 2334312 20856 ? Ss 07:23 0:00 oracle
oracle 9795 0.0 0.8 2335880 33824 ? Ss 07:23 0:00 oracle
oracle 9797 0.0 1.4 2339032 58388 ? Ss 07:23 0:00 oracle
oracle 9799 0.0 0.6 2334820 25748 ? Ss 07:23 0:00 oracle
oracle 9801 0.0 0.4 2334308 19452 ? Ss 07:23 0:00 oracle
oracle 9830 0.0 1.1 2345072 46532 ? Ss 07:23 0:00 oracle
oracle 9924 0.0 0.4 2334312 16944 ? Ss 07:26 0:00 oracle
oracle 9991 0.0 0.6 2334828 24256 ? Ss 07:26 0:00 oracle
oracle 10549 0.0 0.4 2334308 16240 ? Ss 07:31 0:00 oracle
oracle 10558 0.0 0.0 65652 1028 pts/0 R+ 07:37 0:00 ps
[oracle@ebiz1223db bin]$ exit
logout
s[root@ebiz1223db install]# su - oracle
[oracle@ebiz1223db ~]$ cd /u01/install/11.2.0/
[oracle@ebiz1223db 11.2.0]$ ls
admin ccr cpu dc_ocm has javavm lib oc4j ord racg root.sh.old.3 sqlpatch uix
apex cdata crs deinstall hs jdbc log odbc oui rdbms root.sh.ouibak sqlplus usm
appsutil cfgtoollogs csmig demo ide jdev md olap owb relnotes root.sh.ouibak.1 srvm utl
appsutil.old checkpoints css diagnostics install jdk mesg OPatch owm root.sh scheduler sysman wwg
appsutil.zip clone ctx dv instantclient jlib mgw opmn perl root.sh.old slax temp xdk
assistants CLONE_ebiz1223db.env cv emcli inventory jpub network oracore plsql root.sh.old.1 sqldeveloper timingframework
bin config dbs EMStage j2ee ldap nls oraInst.loc precomp root.sh.old.2 sqlj ucp
[oracle@ebiz1223db 11.2.0]$ . ./CLONE_ebiz1223db.env
[oracle@ebiz1223db 11.2.0]$ ls
admin ccr cpu dc_ocm has javavm lib oc4j ord racg root.sh.old.3 sqlpatch uix
apex cdata crs deinstall hs jdbc log odbc oui rdbms root.sh.ouibak sqlplus usm
appsutil cfgtoollogs csmig demo ide jdev md olap owb relnotes root.sh.ouibak.1 srvm utl
appsutil.old checkpoints css diagnostics install jdk mesg OPatch owm root.sh scheduler sysman wwg
appsutil.zip clone ctx dv instantclient jlib mgw opmn perl root.sh.old slax temp xdk
assistants CLONE_ebiz1223db.env cv emcli inventory jpub network oracore plsql root.sh.old.1 sqldeveloper timingframework
bin config dbs EMStage j2ee ldap nls oraInst.loc precomp root.sh.old.2 sqlj ucp
[oracle@ebiz1223db 11.2.0]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 10 07:37:51 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select instance_name,status from v$instance;INSTANCE_NAME STATUS
---------------- ------------
CLONE OPEN
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebiz1223db 11.2.0]$ lsnrctl status CLONE
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 10-FEB-2014 07:38:13
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=ebiz1223db.askmlabs.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias CLONE
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 10-FEB-2014 07:17:38
Uptime 0 days 0 hr. 20 min. 34 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/install/11.2.0/network/admin/CLONE_ebiz1223db/listener.ora
Listener Log File /u01/install/11.2.0/admin/CLONE_ebiz1223db/diag/tnslsnr/ebiz1223db/clone/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=ebiz1223db.askmlabs.com)(PORT=1522)))
Services Summary...
Service "CLONE" has 2 instance(s).
Instance "CLONE", status UNKNOWN, has 1 handler(s) for this service...
Instance "CLONE", status READY, has 1 handler(s) for this service...
Service "ebs_patch" has 1 instance(s).
Instance "CLONE", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@ebiz1223db 11.2.0]$ sqlplus '/as sysdba'
SQL*Plus: Release 11.2.0.3.0 Production on Mon Feb 10 07:38:31 2014
Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select created from v$database;CREATED
------------------
10-FEB-14
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@ebiz1223db 11.2.0]$ hostname
ebiz1223db.askmlabs.com
[oracle@ebiz1223db 11.2.0]$

D.2 Configure the Target System Application Tier server nodes
Log on to the "Run Edition File System" in the Target System as the APPLMGR user and enter the following commands:

$ cd <COMMON_TOP>/clone/bin
$ perl adcfgclone.pl appsTier

[applmgr@ebiz1223ap01 fs1]$ tar xzf EBSapps.tar.gz
[applmgr@ebiz1223ap01 fs1]$ pwd
/u01/install/fs1
[applmgr@ebiz1223ap01 fs1]$ ls
EBSapps
[applmgr@ebiz1223ap01 fs1]$ cd EBSapps/
[applmgr@ebiz1223ap01 EBSapps]$ cd comn/clone/bin
[applmgr@ebiz1223ap01 bin]$ perl adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.26
Enter the APPS password :
Running:
/u01/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/clone/jlib/ojmisc.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/instal/u01/install/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/clone/jlib/ojmisc.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/instal/fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01/clone/jlib/ojmisc.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/instal/fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] :

Running:
/u01/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/install/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/install/fs1/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/fs1/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_29136.lst -stage /u01/install/fs1/EBSapps/comn/clone 2> /tmp/adcfgclone_29136.err; echo $? > /tmp/adcfgclone_29136.res
Log file located at /u01/install/fs1/EBSapps/comn/clone/bin/CloneContext_0210074038.log
Target System File Edition type [run] :
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [ebiz1223ap01] :
Target System Database SID : CLONE
Target System Database Server Node [ebiz1223ap01] : ebiz1223db
Target System Database Domain Name [askmlabs.com] :
Target System Base Directory : /u01/install
Target System Base Directory set to /u01/install
Target System Current File System Base set to /u01/install/fs1
Target System Other File System Base set to /u01/install/fs2
Target System Fusion Middleware Home set to /u01/install/fs1/FMW_Home
Target System Web Oracle Home set to /u01/install/fs1/FMW_Home/webtier
Target System Appl TOP set to /u01/install/fs1/EBSapps/appl
Target System COMMON TOP set to /u01/install/fs1/EBSapps/comn
Target System Instance Home Directory [/u01/install] :
Target System Instance Top set to /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01
Do you want to preserve the Display [localhost:5.0] (y/n) : y
Target System Root Service [enabled] :
Target System Web Administration [enabled] :
Target System Web Entry Point Services [enabled] :
Target System Web Application Services [enabled] :
Target System Batch Processing Services [enabled] :
Target System Other Services [disabled] :
Do you want the target system to have the same port values as the source system (y/n) [y] ? : y
Complete port information available at /u01/install/fs1/EBSapps/comn/clone/bin/out/CLONE_ebiz1223ap01/portpool.lst
RC-40201: Unable to connect to Database CLONE.
Enter the Database listener port [1521] :
RC-40201: Unable to connect to Database CLONE.
Enter the Database listener port [1521] : 1522
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /u01/install/11.2.0/appsutil/outbound/CLONE_ebiz1223db
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 2
Creating the new APPL_TOP Context file from :
/u01/install/fs1/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml
Log file located at /u01/install/fs1/EBSapps/comn/clone/bin/CloneContext_0210074038.log
Check Clone Context logfile /u01/install/fs1/EBSapps/comn/clone/bin/CloneContext_0210074038.log for details.
Running Rapid Clone with command:
Running:
perl /u01/install/fs1/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/fs1/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/install/fs1/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/install/fs1/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/install/fs1/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml -stage /u01/install/fs1/EBSapps/comn/clone -log /u01/install/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Mon Feb 10 07:43:15 2014
/u01/install/fs1/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/fs1/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/install/fs1/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/oui/share.jar:/u01/install/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml -stage /u01/install/fs1/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/admin/log/clone/ApplyAppsTier_02100743.log
/ 100% completed
Completed Apply...
Mon Feb 10 08:14:54 2014

Executing command: /u01/install/fs1/EBSapps/10.1.2/bin/sqlplus @/u01/install/fs1/EBSapps/appl/ad/12.0.0/patch/115/sql/truncate_ad_nodes_config_status.sql

Do you want to startup the Application Services for CLONE? (y/n) [n] : y
Starting application Services for CLONE:
Running:
/u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/admin/scripts/adstrtal.sh -nopromptmsg
You are running adstrtal.sh version 120.24.12020000.8

adstrtal.sh: Database connection could not be established. Either the database is down or the APPS credentials supplied are wrong.
USAGE: adstrtal.sh <appsusername/appspassword> [-nothreading]
adstrtal.sh <applications_username/applications_password> -secureapps
adstrtal.sh -nodbchk

adstrtal.sh: exiting with status 1
[applmgr@ebiz1223ap01 bin]$

It did not start the services, though i gave option to start services. So i started services manually using the following command.

[root@ebiz1223ap01 install]# su - applmgr
[applmgr@ebiz1223ap01 ~]$ cd /u01/install
[applmgr@ebiz1223ap01 install]$ ls
EBSapps.env EBSapps.tar.gz fs1 fs2 fs_ne oraInventory
[applmgr@ebiz1223ap01 install]$ . ./EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/install/fs1/EBSapps/appl
PATCH File System : /u01/install/fs2/EBSapps/appl
Non-Editioned File System : /u01/install/fs_ne
DB Host: ebiz1223db.askmlabs.com Service/SID: CLONE
E-Business Suite Environment Setting
------------------------------------
- Enter [R/r] for sourcing Run File System Environment file, or
- Enter [P/p] for sourcing Patch File System Environment file, or
- Enter anything else to exit
Would you like to set the E-Business Suite environment [R/P]:R
Sourcing the RUN File System ...
[applmgr@ebiz1223ap01 install]$ which adstrtal.sh
/u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/admin/scripts/adstrtal.sh
[applmgr@ebiz1223ap01 install]$ adstrtal.sh apps/apps
....
....
[applmgr@ebiz1223ap01 install]$ ps ucx
USER PID %CPU %MEM VSZ RSS TTY STAT START TIME COMMAND
applmgr 300 0.0 0.0 21148 6580 ? S 08:56 0:00 CYQLIB
applmgr 301 0.0 0.0 21460 6656 ? S 08:56 0:00 INCTM
applmgr 302 0.0 0.0 20356 6588 ? S 08:56 0:00 RCVOLTM
applmgr 303 0.0 0.0 20688 6588 ? S 08:56 0:00 POXCON
applmgr 304 0.0 0.0 19564 6664 ? S 08:56 0:00 FFTM
applmgr 305 1.5 1.1 1164908 93600 ? Sl 08:56 0:17 java
applmgr 307 1.6 1.3 491840 107776 ? Sl 08:56 0:18 java
applmgr 315 1.7 1.3 496540 105448 ? Sl 08:56 0:19 java
applmgr 319 2.8 1.4 494616 118652 ? Sl 08:56 0:31 java
applmgr 325 1.7 1.3 493268 106628 ? Sl 08:56 0:19 java
applmgr 326 0.0 0.0 19828 6996 ? S 08:56 0:00 FNDCRM
applmgr 327 0.0 0.0 19252 6756 ? S 08:56 0:00 FNDLIBR
applmgr 328 0.0 0.1 20364 8328 ? S 08:56 0:00 FNDLIBR
applmgr 334 0.0 0.0 20372 7764 ? S 08:56 0:00 FNDLIBR
applmgr 335 0.0 0.0 19248 6500 ? S 08:56 0:00 FNDLIBR
applmgr 336 0.0 0.0 21276 6652 ? S 08:56 0:00 MRCLIB
applmgr 339 0.0 0.0 21164 6676 ? S 08:56 0:00 INVLIBR
applmgr 340 0.0 0.0 19292 6660 ? S 08:56 0:00 PALIBR
applmgr 396 12.6 12.2 2263240 989980 ? Ssl 08:56 2:17 java
applmgr 676 0.0 0.1 85952 10292 pts/0 S 08:58 0:00 perl
applmgr 749 1.8 2.0 351212 162876 pts/0 Sl 08:58 0:18 java
applmgr 2092 11.7 11.1 2178580 898744 ? Ssl 08:58 1:53 java
applmgr 2095 16.0 11.9 2310320 959976 ? Ssl 08:58 2:35 java
applmgr 2097 9.2 9.5 815512 772464 ? Ssl 08:58 1:29 java
applmgr 2127 12.4 11.4 2215888 923508 ? Ssl 08:58 2:00 java
applmgr 2527 0.0 0.0 65676 1064 pts/0 R+ 09:15 0:00 ps
applmgr 22019 0.0 0.0 17316 1128 ? Ss 07:56 0:00 opmn
applmgr 22021 0.0 0.0 160048 3944 ? Sl 07:56 0:00 opmn
applmgr 31348 0.0 0.0 66352 1660 pts/0 S 08:31 0:00 bash
applmgr 31845 0.0 0.1 68048 8456 ? Ss 08:55 0:00 opmn
applmgr 31846 0.0 0.2 151460 16388 ? Sl 08:55 0:01 opmn
applmgr 31941 0.0 0.2 131404 20920 ? S 08:55 0:00 httpd.worker
applmgr 32137 2.8 1.0 4525224 85084 pts/0 Sl 08:56 0:32 java
applmgr 32155 0.0 0.0 27472 1312 ? S 08:56 0:00 odl_rotatelogs
applmgr 32156 0.0 0.0 27472 1176 ? S 08:56 0:00 odl_rotatelogs
applmgr 32157 0.0 0.0 27404 1164 ? S 08:56 0:00 rotatelogs
applmgr 32158 0.0 0.0 27404 1168 ? S 08:56 0:00 rotatelogs
applmgr 32159 0.0 0.0 27472 1172 ? S 08:56 0:00 odl_rotatelogs
applmgr 32160 0.0 0.2 197068 18540 ? Sl 08:56 0:00 httpd.worker
applmgr 32194 0.0 0.2 352696 19288 ? Sl 08:56 0:00 httpd.worker
applmgr 32249 0.0 0.2 352696 19388 ? Sl 08:56 0:00 httpd.worker
applmgr 32385 0.0 0.0 17192 4236 ? Ss 08:56 0:00 tnslsnr
applmgr 32576 0.0 0.0 64020 1404 pts/0 S 08:56 0:00 sh
applmgr 32581 0.0 0.0 20440 8032 pts/0 S 08:56 0:00 FNDLIBR
applmgr 32713 0.0 0.0 19400 6992 ? Ss 08:56 0:00 FNDSM
applmgr 32767 0.0 0.0 20356 6596 ? S 08:56 0:00 RCVOLTM
[applmgr@ebiz1223ap01 install]$ grep -i s_login $CONTEXT_FILE
<login_page oa_var="s_login_page">http://ebiz1223ap01.askmlabs.com:8000/OA_HTML/AppsLogin</login_page>
[applmgr@ebiz1223ap01 install]$

D.3 Run adpreclone.pl on the "Run Edition File System" in the Target System. (NEW in R12.2)

[applmgr@ebiz1223ap01 install]$ cd /u01/install/fs1/EBSapps/comn/
[applmgr@ebiz1223ap01 comn]$ mv clone clone_10FEB2014
[applmgr@ebiz1223ap01 comn]$ mkdir clone
[applmgr@ebiz1223ap01 comn]$ ls -ld clone*
drwxrwxr-x 2 oracle oracle 4096 Feb 10 09:55 clone
drwxr-xr-x 11 oracle oracle 4096 Feb 3 14:24 clone_04FEB2014
drwxrwxr-x 12 oracle oracle 4096 Feb 4 00:52 clone_10FEB2014
[applmgr@ebiz1223ap01 comn]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@ebiz1223ap01 scripts]$ pwd
/u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/admin/scripts
[applmgr@ebiz1223ap01 scripts]$ ls
adadminsrvctl.sh adautocfg.sh adformsrvctl.sh adopmnctl.sh adstrtal.sh gsmstart.sh jtffmctl.sh mwactlwrpr.sh
adalnctl.sh adcmctl.sh admanagedsrvctl.sh adpreclone.pl cz64bitengine.pl ieo msc pon64bitengine.pl
adapcctl.sh adexecsql.pl adnodemgrctl.sh adstpall.sh gmf java.sh mwactl.sh
[applmgr@ebiz1223ap01 scripts]$ perl adpreclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adpreclone Version 120.31.12020000.11
Enter the APPS User Password:
Enter the Weblogic AdminServer password :
Checking the status of the Oracle WebLogic Administration Server....
Running perl /u01/install/fs1/EBSapps/appl/ad/12.0.0/patch/115/bin/adProvisionEBS.pl ebs-get-serverstatus -contextfile=/u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml -servername=AdminServer -promptmsg=hide
The Oracle WebLogic Administration Server is up.
Running:
perl /u01/install/fs1/EBSapps/appl/ad/12.0.0/bin/adclone.pl java=/u01/install/fs1/FMW_Home/jrockit64 mode=stage stage=/u01/install/fs1/EBSapps/comn/clone component=appsTier method= appctx=/u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml showProgress

Setting the wls environment
Beginning application tier Stage - Mon Feb 10 09:59:30 2014
/u01/install/fs1/FMW_Home/jrockit64/bin/java -Xmx600M -DCONTEXT_VALIDATED=false -Doracle.installer.oui_loc=/oui -classpath /u01/install/fs1/FMW_Home/webtier/lib/xmlparserv2.jar:/u01/install/fs1/FMW_Home/webtier/jdbc/lib/ojdbc6.jar:/u01/install/fs1/EBSapps/comn/java/classes:/u01/install/fs1/FMW_Home/webtier/oui/jlib/OraInstaller.jar:/u01/install/fs1/FMW_Home/webtier/oui/jlib/ewt3.jar:/u01/install/fs1/FMW_Home/webtier/oui/jlib/share.jar:/u01/install/fs1/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/fs1/FMW_Home/webtier/jlib/ojmisc.jar:/u01/install/fs1/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/install/fs1/FMW_Home/oracle_common/jlib/obfuscatepassword.jar oracle.apps.ad.clone.StageAppsTier -e /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml -stage /u01/install/fs1/EBSapps/comn/clone -tmp /tmp -method CUSTOM -showProgress -nopromptmsg
Log file located at /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/admin/log/clone/StageAppsTier_02100959.log
- 20% completed .
Completed Stage...
Mon Feb 10 10:36:03 2014
[applmgr@ebiz1223ap01 scripts]$

D.4 Copy Oracle E-Business Suite application directories from the "Run Edition File System" to the "Patch Edition File System" in the Target System. (NEW in R12.2)

[applmgr@ebiz1223ap01 scripts]$ cd /u01/install/fs1
[applmgr@ebiz1223ap01 fs1]$
[applmgr@ebiz1223ap01 fs1]$ tar czf EBSapps.tar.gz EBSapps/
[applmgr@ebiz1223ap01 fs1]$ ls -lrt
total 14672284
drwxr-xr-x 5 oracle oracle 4096 Oct 12 21:25 EBSapps
drwxrwxr-x 3 oracle oracle 4096 Feb 10 07:43 inst
drwxr-x--- 13 oracle oracle 4096 Feb 10 08:07 FMW_Home
-rw-rw-r-- 1 oracle oracle 15009725011 Feb 10 11:27 EBSapps.tar.gz
[applmgr@ebiz1223ap01 fs1]$ cd /u01/install/fs2
[applmgr@ebiz1223ap01 fs2]$ tar xzf /u01/install/fs1/EBSapps.tar.gz
[applmgr@ebiz1223ap01 fs2]$ pwd
/u01/install/fs2
[applmgr@ebiz1223ap01 fs2]$ ls
EBSapps
[applmgr@ebiz1223ap01 fs2]$

D.5 Configure Patch file system on target appsTier (NEW in R12.2)

[applmgr@ebiz1223ap01 fs2]$ pwd
/u01/install/fs2
[applmgr@ebiz1223ap01 fs2]$ ls
EBSapps
[applmgr@ebiz1223ap01 fs2]$ cd EBSapps/
[applmgr@ebiz1223ap01 EBSapps]$ cd comn/clone/bin
[applmgr@ebiz1223ap01 bin]$ perl adcfgclone.pl appsTier
Copyright (c) 2011 Oracle Corporation
Redwood Shores, California, USA
Oracle E-Business Suite Rapid Clone
Version 12.2
adcfgclone Version 120.63.12020000.26
Enter the APPS password :
Running:
/u01/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01 /clone/jlib/ojmisc.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/instal /u01/install/fs1/EBSapps/comn/clone/bin/../FMW/tempinfoApps.txt
Enter the Weblogic AdminServer password :
Running:
/u01/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01 /clone/jlib/ojmisc.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/instal /fs1/EBSapps/comn/clone/bin/../FMW/tempinfo.txt
Running:
/u01/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -classpath /u01 /clone/jlib/ojmisc.jar:/u01/install/fs1/EBSapps/comn/clone/jlib/java:/u01/instal /fs1/EBSapps/comn/clone/bin/../FMW/EBSDataSource

Do you want to add a node (yes/no) [no] :

Running:
/u01/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -cp /u01/install/fs2/EBSapps/comn/clone/jlib/java:/u01/install/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/ojdbc5.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/java:/u01/install/fs2/EBSapps/comn/clone/jlib/emCfg.jar oracle.apps.ad.context.CloneContext -e /u01/install/fs2/EBSapps/comn/clone/bin/../context/apps/CTXORIG.xml -validate -pairsfile /tmp/adpairsfile_29136.lst -stage /u01/install/fs2/EBSapps/comn/clone 2> /tmp/adcfgclone_29136.err; echo $? > /tmp/adcfgclone_29136.res
Log file located at /u01/install/fs2/EBSapps/comn/clone/bin/CloneContext_0210231637.log
Target System File Edition type [run] : patch
Enter the full path of Run File System Context file : /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml
Provide the values required for creation of the new APPL_TOP Context file.
Target System Fusion Middleware Home set to /u01/install/fs2/FMW_Home
Target System Web Oracle Home set to /u01/install/fs2/FMW_Home/webtier
Target System Appl TOP set to /u01/install/fs2/EBSapps/appl
Target System COMMON TOP set to /u01/install/fs2/EBSapps/comn
Target System Instance Top set to /u01/install/fs2/inst/apps/CLONE_ebiz1223ap01
Target System Port Pool [0-99] : 0
Checking the port pool 0
done: Port Pool 0 is free
Report file located at /u01/install/fs2/inst/apps/CLONE_ebiz1223ap01/admin/out/portpool.lst
Complete port information available at /u01/install/fs2/inst/apps/CLONE_ebiz1223ap01/admin/out/portpool.lst
UTL_FILE_DIR on database tier consists of the following directories.
1. /usr/tmp
2. /tmp
3. /u01/install/11.2.0/appsutil/outbound/CLONE_ebiz1223db
4. /usr/tmp
Choose a value which will be set as APPLPTMP value on the target node [1] : 2
Creating the new APPL_TOP Context file from :
/u01/install/fs2/EBSapps/comn/clone/context/apps/adxmlctx.tmp
The new APPL_TOP context file has been created :
/u01/install/fs2/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml
Log file located at /u01/install/fs2/EBSapps/comn/clone/bin/CloneContext_0210231637.log
Check Clone Context logfile /u01/install/fs2/EBSapps/comn/clone/bin/CloneContext_0210231637.log for details.
Running Rapid Clone with command:
Running:
perl /u01/install/fs2/EBSapps/comn/clone/bin/adclone.pl java=/u01/install/fs2/EBSapps/comn/clone/bin/../jre mode=apply stage=/u01/install/fs2/EBSapps/comn/clone component=appsTier method=CUSTOM appctxtg=/u01/install/fs2/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml showProgress contextValidated=true

FMW Pre-requisite check log file location : /u01/install/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running: /u01/install/fs2/EBSapps/comn/clone/FMW/t2pjdk/bin/java -classpath /u01/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/engine.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereq.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraPrereqChecks.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstaller.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/OraInstallerNet.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/srvm.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl2.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/Scripts/ext/jlib/ojdl-log4j.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/xmlparserv2.jar:/u01/install/fs2/EBSapps/comn/clone/prereq/webtier/oui/jlib/share.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/java oracle.apps.ad.clone.util.FMWOracleHomePreReqCheck -prereqCheckFMW -e /u01/install/fs2/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml -stage /u01/install/fs2/EBSapps/comn/clone -log /u01/install/fs2/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Beginning application tier Apply - Mon Feb 10 23:18:34 2014
/u01/install/fs2/EBSapps/comn/clone/bin/../jre/bin/java -Xmx600M -DCONTEXT_VALIDATED=true -Doracle.installer.oui_loc=/oui -classpath /u01/install/fs2/EBSapps/comn/clone/jlib/xmlparserv2.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/ojdbc6.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/java:/u01/install/fs2/EBSapps/comn/clone/jlib/oui/OraInstaller.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/oui/ewt3.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/oui/share.jar:/u01/install/fs2/FMW_Home/webtier/../Oracle_EBS-app1/oui/jlib/srvm.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/ojmisc.jar:/u01/install/fs2/FMW_Home/wlserver_10.3/server/lib/weblogic.jar:/u01/install/fs2/EBSapps/comn/clone/jlib/obfuscatepassword.jar oracle.apps.ad.clone.ApplyAppsTier -e /u01/install/fs2/inst/apps/CLONE_ebiz1223ap01/appl/admin/CLONE_ebiz1223ap01.xml -stage /u01/install/fs2/EBSapps/comn/clone -showProgress -nopromptmsg
Log file located at /u01/install/fs2/inst/apps/CLONE_ebiz1223ap01/admin/log/clone/ApplyAppsTier_02102318.log
\ 100% completed
Completed Apply...
Mon Feb 10 23:48:33 2014
Looking for incomplete CLONE record in ad_adop_session_patches table
The CLONE record status is no rows selected
Updating incomplete CLONE record to COMPLETED
[applmgr@ebiz1223ap01 bin]$

E. Finishing Tasks : Complete all the following tasks after successfully completing all the above cloning tasks.

1. Update profile options
2. Update printer settings
3. Update Workflow configuration settings
4. Verify the APPLCSF variable setting
5. Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
6. Re-Implement SSL and SSO configuration

NOTE : If your source system is integrated with OID, you will have references to OID in your target cloned environment. To remove all the references to OID in the newly cloned environment, execute the following command. Then restatrt all the target cloned apps services.

[applmgr@ebiz1223ap01 install]$ $FND_TOP/bin/txkrun.pl -script=SetSSOReg -removereferences=yes -appspass=APPS
You are removing all SSO-OID related preferences.

*** Log File = /u01/install/fs1/inst/apps/CLONE_ebiz1223ap01/logs/appl/rgf/TXK/txkSetSSOReg_Mon_Feb_10_09_25_26_2014.xml
Beginning input parameter validation for Removing Preferences.
Input parameter validation for Removing Preferences completed.
BEGIN REMOVING PREFERENCES:
Oracle Home Instance preferences removed successfully
Updated APPS_SSO profile with value SSWA successfully.
SSO Preferences Removed successfully.
Removing OID References Started.
Removing OID References Completed Successfully.
Custom DIT Preferences Removed Successfully.
REMOVING PREFERENCES COMPLETED.
End of /u01/install/fs1/EBSapps/appl/fnd/12.0.0/patch/115/bin/txkSetSSOReg.pl : No Errors encountered
[applmgr@ebiz1223ap01 install]$

Hope this helps

SRI

askMLabs

Database Upgrade From 11202 to 12101 Using DBUA

Written By askMLabs on Tuesday, February 25, 2014 | 10:10 AM

Database 12c Installation on CentOS 6.5

Written By askMLabs on Monday, February 24, 2014 | 9:48 AM

E-Business Suite R12.2.3 Cloning

Written By askMLabs on Sunday, February 23, 2014 | 5:13 AM

Popular post

Labels

Blog Archive

Certifications

Total Pageviews

About askMLabs

askMLabs

Database Upgrade From 11202 to 12101 Using DBUA

Written By askMLabs on Tuesday, February 25, 2014 | 10:10 AM

Database 12c Installation on CentOS 6.5

Written By askMLabs on Monday, February 24, 2014 | 9:48 AM

E-Business Suite R12.2.3 Cloning

Written By askMLabs on Sunday, February 23, 2014 | 5:13 AM

Popular post

Labels

Blog Archive

Subscribe To

Certifications

Total Pageviews

About askMLabs

Written By askMLabs on Tuesday, February 25, 2014 | 10:10 AM

Written By askMLabs on Monday, February 24, 2014 | 9:48 AM

Written By askMLabs on Sunday, February 23, 2014 | 5:13 AM