facebook twitter youtube facebook facebook facebook

E-Mail : info@askmlabs.com

Phone : +1.215.353.8306

Latest Post

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.

  1. A. Environment
  2. B. Prepare the source system 
    1. 1. Prepare the source system database tier for cloning
    2. 2. Prepare the Source System Application Tier for cloning
  3. C. Copy the Source System to the Target System
    1. 1. Copy the Database Node file system
    2. 2. Copy the Application Tier file system from the Source "Run Edition File System" to the Target "Run Edition File System"
  4. D. Configure the Target System
    1. 1. Configure the Target System database server
    2. 2. Configure the Target System Application Tier server nodes
    3. 3. Run adpreclone.pl on the "Run Edition File System" in the Target System. (NEW in R12.2)
    4. 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. 5. Configure Patch file system on target appsTier (NEW in R12.2)
  5. 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. 1. Update profile options
  2. 2. Update printer settings
  3. 3. Update Workflow configuration settings
  4. 4. Verify the APPLCSF variable setting
  5. 5. Update the SESSION_COOKIE_DOMAIN value in ICX_PARAMETERS
  6. 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

OEM : AMP and Change Management Implementation

In this article, we are going to see the implementation plan for AMP ( application management pack) and change management in oem 12c. This article gives you an idea of complete plan to implement with screen shots and references and don't eloborate detailed patching and session log. DBAs already working in oem 12c and oracle apps R12, should feel comfortable to understand the plan presented here.
  1. 1. Patches required for EBS R12
  2. 2. Patches required for OEM 12c
  3. 3. Deploy fusion middleware plug-in on the EBS host
  4. 4. Deploy plug-in on OMS and EBS agent
  5. 5. Apply recommended patches for AMP
  6. 6. Prevalidate discovery for oracle E-business suite
  7. 7. Using discovery wizard to discover EBS targets

1) Patches required for EBS R12
Product/Feature Release 12.1+ with R12.ATG_PF.B.DELTA.3
AMP: Administration  Patch 8919489
AMP: User Monitoring and Diagnostics  Patch 10168359
AMP: Cloning  Patch 9171651
ACMP: Setup Manager  Patch 9444535
ACMP: Customization Manager  Patch 9967338, Patch 7648894, Patch 16770159
Patch 9171651 - R12 rapidclone consolidated fixes jul/2010 for Release R12
Patch 14825718 - oracle forms bundle patch 10.1.2.3.2 for product Developer Forms.
Note: This patch conflicts with other existing patches in ORACLE_HOME 10.1.2.3, but conflict messages can be safely ignored

Download and apply the above recommended patches to the EBS R12

2) Patches required for OEM 12c 
Patch 13510835: hold:proceduremanager.getprocedureexecutioninfos performance
patch 14068462: merge request on top of 12.1.0.1.0 for bugs 13622118 13875571
patch 13865299: aggregate service stays down when sub-service is up
 patch 17035004 upgrade of ebs plugin 4.0 to 12.1.0.1.0 fails with em12c r3
 Patch 14660238 just before deploying the management pack on the OMS Server.
 Patch 14238075: release update pack for oracle e-business suite plug-in 12.1.0.1.0.
 Patch 12965899:  start with and connect by clause is not working in xpath query context ( If RDBMS is greater than 11.2.0.2. )

Apply all the above patches to OEM12c


3) Deploy fusion middleware plug-in on the EBS host
Goto SetupàExtensibilityàself updateàplug-in
Select Oracle Fusion Middleware in the Plug-ins table. Select Deploy On andthen select Management Agent.


4)  Deploy plug-in on OMS and EBS agent
Goto SetupàExtensibilityàself updateàplug-in
Select Oracle E-Business Suite and click Download
 After the file get downloaded click on Apply buttonOnce apply is done the status of the plug-in will be applied. Now click plug-in button to go to the plug-in page for deployment
 Select Oracle E-Business SuiteàDeploy OnàManagement Servers
Provide the repository password
During this time OMS will be down and users will not be able to login.
 Select Oracle E-Business SuiteàDeploy OnàManagement Agent
Click Add to add the EBS host and deploy the plugin. 
On OMS 








On EBS Agent :






5)  Apply recommended patches for AMP
Product/Component
Apply On
Patch Number
AMP: Discovery
Agent
AMP: Clone
Agent
EM: Framework
OMS
AMP: Install
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Discovery
OMS
AMP: Diagnostics
OMS
AMP: Diagnostics
OMS
AMP: Other
OMS
AMP: Other
OMS
AMP: Other
OMS
ACMP: Patch Manager
OMS
ACMP: Customization Manager
OMS
ACMP: Customization Manager
OMS
ACMP: Customization Manager
OMS
ACMP: Setup Manager
OMS
ACMP: Setup Manager
OMS


6) Pre-validate discovery for oracle E-business suite
TagetsàOracle E-Business SuiteàDiscovery WizardàAdd Databases and select the R12 DBàPrevalidate.
 Select the R12 database and click on Prevalidate button and give the apps username and password to prevalidate Discovery.

We will get new option from targets menu as Oracle E-Business Suite.








7) Using discovery wizard to discover EBS targets
Once prevalidation in successful start discovering the EBS targets
TagetsàOracle E-Business SuiteàDiscovery WizardàAdd Databases and select the R12 DBàDiscover
Click on Discover Button to start the normal discover process to discover EBS targets.

Discovering EBS targets after prevalidation succeeded. 






Hope this helps
SRI


Installing OpenNMS in CentOS 6

Written By askMLabs on Friday, February 21, 2014 | 9:33 AM

In this article, we will see how to install OpenNMS in CentOS 6.5 version.

OpenNMS is the world’s first enterprise grade network management application platform developed under the open source model. It is a free and open-source enterprise grade network monitoring and network management platform. It is developed and supported by a community of user and developers as well as by the The OpenNMS Group, offering commercial services, training and support.

The installation procedure differs based on the host OS you choose. As we are installing it on CentOS, i am choosing to install using YUM/RPM method. For other OS installation , please refer to the link  Installing OpenNMS

1) Check the Java Version and Install repository RPM.

[root@askmlabstools pgsql]# which java
/usr/bin/java
[root@askmlabstools pgsql]# java -version
java version "1.7.0_45"
OpenJDK Runtime Environment (rhel-2.4.3.4.el6_5-x86_64 u45-b15)
OpenJDK 64-Bit Server VM (build 24.45-b08, mixed mode)
[root@askmlabstools pgsql]#
[root@askmlabstools pgsql]# rpm -Uvh http://yum.opennms.org/repofiles/opennms-repo-stable-rhel6.noarch.rpm
Retrieving http://yum.opennms.org/repofiles/opennms-repo-stable-rhel6.noarch.rpm
warning: /var/tmp/rpm-tmp.n91osI: Header V3 DSA/SHA1 Signature, key ID 5b9efd43: NOKEY
Preparing...                ########################################### [100%]
   1:opennms-repo-stable    ########################################### [100%]
[root@askmlabstools pgsql]#

2) Verify if you have postgresql installed and operational. If you don't have postgresql installed, please complete the following steps to install postgre.
yum install postgresql postgresql-server
/sbin/service postgresql start
Some distributions will require you to first initialize the database. If you see an error when running that command, try initdb first, and then start again
/sbin/service postgresql initdb
/sbin/service postgresql start
/sbin/chkconfig postgresql on
Modify the file pg_hba.conf located under /var/lib/pgsql/data/ as shown below ...
local   all         all                               trust
host    all         all         127.0.0.1/32          trust
host    all         all         ::1/128               trust
Then restart the postgre database as root user.
/sbin/service postgresql restart 

3) Now install OpenNMS using the following command ....
[root@askmlabstools data]# yum -y install opennms
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
.....
.....
.......
Installed:
  opennms.noarch 0:1.12.4-1
Dependency Installed:
  jdk.x86_64 2000:1.6.0_24-fcs     jicmp.x86_64 0:1.4.1-1     jicmp6.x86_64 0:1.2.1-1     opennms-core.noarch 0:1.12.4-1     opennms-webapp-jetty.noarch 0:1.12.4-1
Complete!
[root@askmlabstools data]#
4) Configure java to tell OpenNMS which java it has to use. Execute the following command to complete java configuration.
[root@askmlabstools bin]# /opt/opennms/bin/runjava -S /usr/java/latest/bin/java
runjava: checking specified JRE: "/usr/java/latest/bin/java"...
runjava: specified JRE is good.
runjava: value of "/usr/java/latest/bin/java" stored in configuration file
[root@askmlabstools bin]# 

5) Now create database in postgresql database for OpenNMS to use. Run the following command to create database...
[root@askmlabstools bin]# /opt/opennms/bin/install -dis
===============================================================
OpenNMS Installer
===============================================================
Configures PostgreSQL tables, users, and other miscellaneous settings.
- searching for libjicmp.so:
  - trying to load /usr/lib64/libjicmp.so: OK
- searching for libjicmp6.so:
...
...
...
Finished in 2 seconds
Upgrade completed successfully!
[root@askmlabstools bin]#
Verify that you have schema created and able to connect to database using following commands .....
bash-4.1$ psql -p5432 -dpostgres
psql (8.4.18)
Type "help" for help.
postgres=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ******** |          |
 nagiosxi |    16384 | f           | f        | f         | ******** |          |
 opennms  |    16520 | t           | t        | t         | ******** |          |
(3 rows)
postgres=# \q
bash-4.1$ exit
6) Then install "iplike", which provides an API for easily performing complicated IP address queries.
[root@askmlabstools bin]# yum -y install iplike
Loaded plugins: fastestmirror, refresh-packagekit, security
Loading mirror speeds from cached hostfile
..
..
Complete!
[root@askmlabstools bin]#
7) Modify iptables to allow opennms port to be accessible. Run following commands ...
iptables -A INPUT -p tcp -m tcp --dport 8980 -j ACCEPT
service iptables save 
8) Now restart OpenNMS service as root  user and access the url.
[root@askmlabstools bin]# /sbin/service opennms status
opennms is stopped
[root@askmlabstools bin]# /sbin/service opennms start
Starting OpenNMS:
Started OpenNMS, but it has not finished starting up
                                                           [FAILED]
[root@askmlabstools bin]#
[root@askmlabstools bin]# service opennms status
opennms is running
[root@askmlabstools bin]# service opennms restart
Stopping OpenNMS:                                          [  OK  ]
Starting OpenNMS: Started OpenNMS, but it has not finished starting up
                                                           [FAILED]
[root@askmlabstools bin]
Please follow my forum thread to resolve this issue. The link is here.

Finally the url to access OpenNMS is :   http://<YOUR-OPENNMS-IP>:8980/opennms/    
The default username and password to login to url are :  admin and admin.

Hope it helps
SRI

Reference:
Install OpenNMS

How to connect to Postgre database

In this article, i am going to show you the steps to connect to the postgre database.

First you need to know the port on which postgresql is running. To know this use the following command ..

grep -i  postgresql  /etc/services

The output from the above command lists you the port the postgre is using. Now use the following command to connect to the postgre.

Assuming you installed your postgre with user "postgres" and the port used by postgre is 5432. Now switch user to  postgres and connect to it.

[root@askmlabstools pgsql]# su postgres
bash-4.1$ psql -p5432 -dpostgres
psql (8.4.18)
Type "help" for help.
postgres=# select name,setting from pg_settings where name='post';
 name | setting
------+---------
(0 rows)
postgres=# select name,setting from pg_settings where name='poRT';
 name | setting
------+---------
(0 rows)
postgres=# select name,setting from pg_settings where name='port';
 name | setting
------+---------
 port | 5432
(1 row)
postgres=# select * from pg_user;
 usename  | usesysid | usecreatedb | usesuper | usecatupd |  passwd  | valuntil | useconfig
----------+----------+-------------+----------+-----------+----------+----------+-----------
 postgres |       10 | t           | t        | t         | ******** |          |
 nagiosxi |    16384 | f           | f        | f         | ******** |          |
(2 rows)
postgres=# exit
postgres-# \q

Hope it help.
SRI


RAC Health Checks

This article is to present various commands used to perform rac health checks. In oracle RAC, there are various components and to know the status of individual components, these commands may help you as reference. The commands are not limited , but as an easy reference to check the status.


Login to server using grid user ( clusterware software owner ) :
Execute the environment profile.


1) RAC Node Apps Health Checks :
[grid@rac11gdb01 ~]$ srvctl status nodeapps
VIP rac11gdb01-vip is enabled
VIP rac11gdb01-vip is running on node: rac11gdb01
VIP rac11gdb02-vip is enabled
VIP rac11gdb02-vip is running on node: rac11gdb02
Network is enabled
Network is running on node: rac11gdb01
Network is running on node: rac11gdb02
GSD is disabled
GSD is not running on node: rac11gdb01
GSD is not running on node: rac11gdb02
ONS is enabled
ONS daemon is running on node: rac11gdb01
ONS daemon is running on node: rac11gdb02
[grid@rac11gdb01 ~]$



2) ASM Status : 
[grid@rac11gdb01 ~]$ srvctl status asm
ASM is running on rac11gdb02,rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status asm -n rac11gdb01
ASM is running on rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status asm -n rac11gdb02
ASM is running on rac11gdb02
[grid@rac11gdb01 ~]$



3) Database Status:
[grid@rac11gdb01 ~]$ srvctl status database -d racdb
Instance racdb1 is running on node rac11gdb01
Instance racdb2 is running on node rac11gdb02
[grid@rac11gdb01 ~]$ srvctl status instance -d racdb -i racdb1
Instance racdb1 is running on node rac11gdb01
[grid@rac11gdb01 ~]$ srvctl status instance -d racdb -i racdb2
Instance racdb2 is running on node rac11gdb02
[grid@rac11gdb01 ~]$


4) CRS Status:
[grid@rac11gdb01 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@rac11gdb01 ~]$


5) Cluster Status:
[grid@rac11gdb01 ~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[grid@rac11gdb01 ~]$


6) RAC High Availability Services Status:
[grid@rac11gdb01 ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online
[grid@rac11gdb01 ~]$


7) Database Services Status : 
[grid@rac11gdb01 ~]$ srvctl status service -d racdb
Service racdb_service is running on instance(s) racdb1,racdb2
[grid@rac11gdb01 ~]$


8) Listener Status: 
[grid@rac11gdb01 ~]$ srvctl status listener
Listener LISTENER is enabled
Listener LISTENER is running on node(s): rac11gdb02,rac11gdb01
[grid@rac11gdb01 ~]$


9) SCAN VIP Status : 
[grid@rac11gdb01 ~]$ srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node rac11gdb02
SCAN VIP scan2 is enabled
SCAN VIP scan2 is running on node rac11gdb01
SCAN VIP scan3 is enabled
SCAN VIP scan3 is running on node rac11gdb01
[grid@rac11gdb01 ~]$


10) Scan Listener Status : 
[grid@rac11gdb01 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac11gdb02
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac11gdb01
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac11gdb01
[grid@rac11gdb01 ~]$


11) Server Status : 
[grid@rac11gdb01 ~]$ srvctl status server -n rac11gdb01 -a
Server name: rac11gdb01
Server state: ONLINE
Server active pools: Generic ora.racdb ora.racdb_racdb_service
Server state details:
[grid@rac11gdb01 ~]$ srvctl status server -n rac11gdb02 -a
Server name: rac11gdb02
Server state: ONLINE
Server active pools: Generic ora.racdb ora.racdb_racdb_service
Server state details:
[grid@rac11gdb01 ~]$


12)CVU Status: 
[grid@rac11gdb01 ~]$ srvctl status cvu
CVU is enabled and running on node rac11gdb01
[grid@rac11gdb01 ~]$



13) GNS Status :  ( As root user)
[root@rac11gdb01 ~]# /o001/home/11.2.0.2/grid/bin/srvctl status gns
PRCS-1065 : GNS is not configured.
[root@rac11gdb01 ~]#


14) Serverpool Details : 
[grid@rac11gdb01 ~]$ srvctl status srvpool
Server pool name: Free
Active servers count: 0
Server pool name: Generic
Active servers count: 2
[grid@rac11gdb01 ~]$


15) Cluster Interconnect Details : 
[grid@rac11gdb01 ~]$ oifcfg getif
eth0  192.168.1.0  global  public
eth1  192.168.50.0  global  cluster_interconnect


16) OCR Checks:
[grid@rac11gdb01 ~]$ ocrcheck
Status of Oracle Cluster Registry is as follows :
         Version                  :          3
         Total space (kbytes)     :     262120
         Used space (kbytes)      :       3224
         Available space (kbytes) :     258896
         ID                       : 1449084471
         Device/File Name         :  +OCR_VOTE
                                    Device/File integrity check succeeded
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
                                    Device/File not configured
         Cluster registry integrity check succeeded
         Logical corruption check bypassed due to non-privileged user
[grid@rac11gdb01 ~]$



17) OCR Backups:
[grid@rac11gdb01 ~]$ ocrconfig -showbackup
rac11gdb01     2013/09/23 11:46:41     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup00.ocr
rac11gdb01     2013/09/23 04:19:26     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup01.ocr
rac11gdb01     2013/09/23 00:19:25     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/backup02.ocr
rac11gdb01     2013/09/22 08:19:24     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/day.ocr
rac11gdb01     2013/09/10 08:18:54     /o001/home/11.2.0.2/grid/cdata/orrcdbdv-clstr/week.ocr
PROT-25: Manual backups for the Oracle Cluster Registry are not available
[grid@rac11gdb01 ~]$




18) Voting Disk Status: 
[grid@rac11gdb01 ~]$ crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
 1. ONLINE   9bc0828570854fa5bff3221500a1fc63 (ORCL:CRSVOL1) [OCR_VOTE]
Located 1 voting disk(s).
[grid@rac11gdb01 ~]$



19) Node apps config details : 
[grid@rac11gdb01 ~]$ srvctl config nodeapps  -a -g -s
Network exists: 1/192.168.1.0/255.255.255.0/eth0, type static
VIP exists: /rac11gdb01-vip/192.168.1.73/192.168.1.0/255.255.255.0/eth0, hosting node rac11gdb01
VIP exists: /rac11gdb02-vip/192.168.1.74/192.168.1.0/255.255.255.0/eth0, hosting node rac11gdb02
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016
[grid@rac11gdb01 ~]$



20) Diskgroups Status:
[grid@rac11gdb01 ~]$ crs_stat -t | grep -i dg
ora....DATA.dg ora....up.type ONLINE    ONLINE    rac11gdb01
ora.FLASH.dg   ora....up.type ONLINE    ONLINE    rac11gdb01
ora....VOTE.dg ora....up.type ONLINE    ONLINE    rac11gdb01
[grid@rac11gdb01 ~]$

Hope this helps
SRI



Oracle Apps Technology Stack Details

Written By askMLabs on Wednesday, February 19, 2014 | 5:40 AM

In this article, i am going to show you the steps to obtain the technology stack details in oracle apps. After generating the technology stack details in html format, we can access using the apps url.

Create any temporary directory and make sure apps user has full access to that directory.
Then execute the following command to generate the tech stack inventory ...

perl $FND_TOP/patch/115/bin/TXKScript.pl
-script=$FND_TOP/patch/115/bin/txkInventory.pl
-txktop=$APPLTMP
-contextfile=$CONTEXT_FILE
-appspass=apps
-outfile=/tmp/askm/Report_Inventory.html

Session Log:
[root@ebiz1222ap01 ~]# chmod 777 /tmp/askm
[root@ebiz1222ap01 ~]# exit
logout
[applmgr@ebiz1222ap01 askm]$ touch askm
[applmgr@ebiz1222ap01 askm]$ rm askm
[applmgr@ebiz1222ap01 askm]$ perl $FND_TOP/patch/115/bin/TXKScript.pl -script=$FND_TOP/patch/115/bin/txkInventory.pl -txktop=$APPLTMP -contextfile=/home/apps/VIS/fs1/inst/apps/VIS_ebiz1222ap01/appl/admin/VIS_ebiz1222ap01.xml -appspass=apps -outfile=/tmp/askm/Report_Inventory.html
*** ALL THE FOLLOWING FILES ARE REQUIRED FOR RESOLVING RUNTIME ERRORS
*** STDOUT   = /home/apps/VIS/fs1/inst/apps/VIS_ebiz1222ap01/logs/appl/rgf/TXK/txkInventory_Tue_Feb_18_21_14_25_2014_stdout.log
Reportfile /tmp/askm/Report_Inventory.html generated successfully.
[applmgr@ebiz1222ap01 askm]$

The generated file  /tmp/askm/Report_Inventory.html can be copied to $OA_HTML directory to be accessible with the apps url.

[applmgr@ebiz1222ap01 ~]$ cd $OA_HTML
[applmgr@ebiz1222ap01 html]$ pwd
/home/apps/VIS/fs1/FMW_Home/Oracle_EBS-app1/applications/oacore/html
[applmgr@ebiz1222ap01 html]$ cp /tmp/askm/Report_Inventory.html .
[applmgr@ebiz1222ap01 html]$


Now you should be able to access the tech stack inventory using the following apps URL.

http://ebiz1222ap01.askmlabs.com:8000/OA_HTML/Report_Inventory.html


To generate the report for database tier node, you can use the following command ...

perl $ORACLE_HOME/appsutil/bin/TXKScript.pl
-script=$ORACLE_HOME/appsutil/bin/txkInventory.pl
-txktop=$ORACLE_HOME/appsutil/temp
-contextfile=$CONTEXT_FILE
-appspass=apps
-outfile=/tmp/askm/Report_Inventory.html

Option -reporttype=text  controls whether you need the output in text format or html format.


Hope This helps,
SRI


 
Support :
Copyright © 2013. askMLabs - All Rights Reserved
Proudly powered by Blogger