1)Uncheck the any .env entries in .bash_profile for
applmgr and oracle user
a)For
database user "Oracle"
[oracle@oel-01
~]$ vi .bash_profile
To save it use
command "Esc :wq!"
b)For application user "applmgr"
[root@oel-01 ~]#
su - applmgr
[applmgr@oel-01
~]$
To save it use
command "Esc :wq!"
Clone the Db Tier
1)switch to database OS user
[root@oel-01 ~]#
su - oracle
Last login: Fri
Sep 2 07:53:23 PDT 2016 on pts/3
[oracle@oel-01
~]$
2)Go to oracle home appsutil/clone/bin directory
[oracle@oel-01
clone]$ cd /u01/db/11.2.0/appsutil/clone/bin
[oracle@oel-01
clone]$ pwd
/u01/db/11.2.0/appsutil/clone/bin
3)Run the adcfgclone.pl script
check the logfile at
the end should show below statement
END: ApplyDatabase
Completed Successfully
4)Clean the fnd_nodes table
source the database env
[oracle@oel-01
11.2.0]$ cd /u01/db/11.2.0
[oracle@oel-01
11.2.0]$ . DEV_oel-01.env
[oracle@oel-01
11.2.0]$ sqlplus "/as sysdba"
SQL*Plus:
Release 11.2.0.4.0 Production on Fri Sep 2 07:58:18 2016
Copyright
(c) 1982, 2013, Oracle. All rights
reserved.
Connected
to:
Oracle
Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With
the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL>
select open_mode from v$database
2 ;
OPEN_MODE
--------------------
READ
WRITE
SQL>
conn apps/apps
Connected.
SQL>
EXEC FND_CONC_CLONE.SETUP_CLEAN;
PL/SQL
procedure successfully completed.
SQL>
commit;
Commit
complete.
SQL>exit
5)Run
autoconfig
[oracle@oel-01
DEV_cscoel-01]$ pwd
/u01/db/11.2.0/appsutil/scripts/DEV_cscoel-01
[oracle@cscoel-01
DEV_cscoel-01]$ sh adautocfg.sh
Enter the APPS user password:
The
log file for this session is located at:
/u01/db/11.2.0/appsutil/log/DEV_cscoel-01/09020803/adconfig.log
AutoConfig
is configuring the Database environment...
AutoConfig
will consider the custom templates if present.
Using ORACLE_HOME location :
/u01/db/11.2.0
Classpath :
:/u01/db/11.2.0/jdbc/lib/ojdbc6.jar:/u01/db/11.2.0/appsutil/java/xmlparserv2.jar:/u01/db/11.2.0/appsutil/java:/u01/db/11.2.0/jlib/netcfg.jar:/u01/db/11.2.0/jlib/ldapjclnt11.jar
Using Context file :
/u01/db/11.2.0/appsutil/DEV_oel-01.xml
Context
Value Management will now update the Context file
Updating Context file...COMPLETED
Attempting upload of Context file and
templates to database...COMPLETED
Updating
rdbms version in Context file to db112
Updating
rdbms type in Context file to 64 bits
Configuring
templates from ORACLE_HOME ...
AutoConfig completed successfully.
[oracle@oel-01
DEV_cscoel-01]$
Its
completes the Db clone part
Clone apps Tier
1)Switch to application OS user
[root@oel-01 ~]# su
- applmgr
Last login: Fri
Sep 2 07:26:11 PDT 2016 on pts/2
[applmgr@oel-01 ~]$
2)Move
or delete the previous filesystem files
adcfgclone.pl will recreate this files once
again
[applmgr@oel-01
apps]$ mv EBSapps.env EBSapps.env_bkp
[applmgr@oel-01
apps]$ mv fs2 fs2_bkp
[applmgr@oel-01
apps]$ mv fs_ne fs_ne_bkp
move the below files
from fs1 directory
[applmgr@oel-01
fs1]$ mv inst inst_bkp
[applmgr@oel-01
fs1]$ mv FMW_Home FMW_Home_bkp
[applmgr@oel-01
fs1]$ mv inst inst_bkp
Only EBSapps
directory is enough to perform the clone rest will be created automatically by
postclone step
3)Run
adcfglone.pl
Go to below directory
Make note of apps
and weblogic passwords
[applmgr@oel-01 bin]$ pwd
/u01/apps/fs1/EBSapps/comn/clone/bin
Note::
Port pool of run file system should be same as db port pool which we have given
in db clone, port pool of patch files system can be choose anyvalue we like
[applmgr@oel-01
bin]$ perl adcfgclone.pl appsTier dualfs
Copyright (c) 2002, 2015
Oracle Corporation
Redwood Shores,
California, USA
Oracle E-Business Suite
Rapid Clone
Version 12.2
adcfgclone Version
120.63.12020000.56
Enter
the APPS password :
Enter
the Weblogic AdminServer password :
Do
you want to add a node (yes/no) [no] :
Running:
Context clone...
Log
file located at
/u01/apps/fs1/EBSapps/comn/clone/bin/CloneContext_0902082439.log
Provide
the values required for creation of the new APPL_TOP Context file.
Target
System Hostname (virtual or normal) [oel-01] : oel-01
Target
System Database SID : DEV
Target
System Database Server Node [oel-01] : oel-01
Target
System Database Domain Name [xxxx.com] : xxxx.com
Target
System Base Directory : /u01/apps
Target
System Base Directory set to /u01/apps
Target
System Current File System Base set to /u01/apps/fs1
Target
System Other File System Base set to /u01/apps/fs2
Target
System Fusion Middleware Home set to /u01/apps/fs1/FMW_Home
Target
System Other File System Fusion Middleware Home set to /u01/apps/fs2/FMW_Home
Target
System Web Oracle Home set to /u01/apps/fs1/FMW_Home/webtier
Target
System Other File System Web Oracle Home set to /u01/apps/fs2/FMW_Home/webtier
Target
System Appl TOP set to /u01/apps/fs1/EBSapps/appl
Target
System Other File System Appl TOP set to /u01/apps/fs2/EBSapps/appl
Target
System COMMON TOP set to /u01/apps/fs1/EBSapps/comn
Target
System Other File System COMMON TOP set to /u01/apps/fs2/EBSapps/comn
Target System Instance
Home Directory [/u01/apps] : /u01/apps
Target System Current
File System Instance Top set to /u01/apps/fs1/inst/apps/DEV_oel-01
Do
you want to preserve the Display [cscoel-01:0.0] (y/n) : n
Target
System Display [cscoel-01:0.0] : cscoel-01:1.0
Target
System Root Service [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] :
Target
System Port Pool [0-99] : 0
Checking
the port pool 0
done:
Port Pool 0 is free
Report
file located at /u01/apps/fs1/inst/apps/DEV_cscoel-01/admin/out/portpool.lst
UTL_FILE_DIR
on database tier consists of the following directories.
1.
/usr/tmp
2.
/usr/tmp
3.
/u01/db/11.2.0/appsutil/outbound/DEV_cscoel-01
4.
/usr/tmp
Choose
a value which will be set as APPLPTMP value on the target node [1] : 1
The
new APPL_TOP context file has been created :
/u01/apps/fs1/inst/apps/DEV_oel-01/appl/admin/DEV_oel-01.xml
Check
Clone Context logfile
/u01/apps/fs1/EBSapps/comn/clone/bin/CloneContext_0902082439.log for details.
Creating
Patch file system context file.....
Log
file located at
/u01/apps/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0902082811.log
Target
System Other File System Instance Top set to
/u01/apps/fs2/inst/apps/DEV_cscoel-01
Target
System Port Pool [0-99] : 1
Checking
the port pool 1
done:
Port Pool 1 is free
Report
file located at /u01/apps/fs2/inst/apps/DEV_cscoel-01/admin/out/portpool.lst
The
new APPL_TOP context file has been created :
/u01/apps/fs2/inst/apps/DEV_cscoel-01/appl/admin/DEV_cscoel-01.xml
Check
Clone Context logfile /u01/apps/fs1/EBSapps/comn/clone/bin/CloneContextPatch_0902082811.log
for details.
FMW
Pre-requisite check log file location :
/u01/apps/fs1/EBSapps/comn/clone/FMW/logs/prereqcheck.log
Running:
FMW pre-req check...
Do you want to start the services (y/n) : N
it should
exists with status 0
---Above
process completes the Clone of Oracle applications and DB
To
Start and stop services
1)How
to start the db services
a)Switch
to Oracle user
[root@oel-01
~]# su - oracle
Last
login: Tue Sep 6 02:10:31 PDT 2016 on
pts/0
[oracle@oel-01
~]$
b)Go
to Oracle home
[oracle@oel-01
~]$ cd /u01/db/11.2.0
[oracle@oel-01
11.2.0]$
c)Source
the env
[oracle@oel-01
11.2.0]$ . DEV_cscoel-01.env
[oracle@oel-01
11.2.0]$
d)Start
the database
[oracle@oel-01
11.2.0]$ sqlplus "/as sysdba"
SQL*Plus:
Release 11.2.0.4.0 Production on Tue Sep 6 02:12:21 2016
Copyright
(c) 1982, 2013, Oracle. All rights
reserved.
SQL>startup
SQL>exit
e)Start
the Listener
[oracle@oel-01
11.2.0]$ lsnrctl start DEV
check
the status of Listiner until you see below
Service
"ebs_patch" has 1 instance(s).
Instance "DEV", status READY, has 1
handler(s) for this service...
The
command completed successfully
2)To
start the application
a)switch
to application user
[root@oel-01
~]# su - applmgr
Last
login: Sat Sep 3 06:17:08 PDT 2016 on
pts/1
[applmgr@oel-01
~]$
b)source
the generic env and select run file system
[applmgr@oel-01
apps]$ pwd
/u01/apps
[applmgr@oel-01
apps]$ .
EBSapps.env
E-Business Suite Environment Information
----------------------------------------
RUN File System : /u01/apps/fs1/EBSapps/appl
PATCH File System : /u01/apps/fs2/EBSapps/appl
Non-Editioned File System : /u01/apps/fs_ne
DB Host: oel-01.xxxx.com Service/SID: DEV
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
Please choose the
environment file you wish to source [R/P]:R
Sourcing the RUN File System ...
[applmgr@oel-01
apps]$
c)Locate
the scripts directory
[applmgr@oel-01
apps]$ cd $ADMIN_SCRIPTS_HOME
[applmgr@oel-01
scripts]$ pwd
/u01/apps/fs1/inst/apps/DEV_cscoel-01/admin/scripts
d)Start
the application services
[applmgr@oel-01
scripts]$ sh adstrtal.sh
Which
prompts for apps and weblogic password (starting of services takes 15-20 min )
3)To stop the db and apps services
a)To
stop apps services
Note::
please do the same as start process steps expect the adstpall.sh command as
below
[applmgr@oel-01
scripts]$ sh adstpall.sh
it
prompts for apps and weblogic password
it
should exists with status 0
check
for any process running under applmgr user wait until it stops
[applmgr@oel-01
scripts]$ ps -ef | grep applmgr
b)To
stop db services
Note::
please do the same as start process expect the shutdown command as below
SQL>shut
immediate
SQL>exit
CMD>lsnrctl
stop DEV
