Manual cloning of appsTier and db tier with out Rapid cloning adcfgclone.pl

Manual cloning of Oracle apps server with our Rapid cloning method.

Major steps:
Step-1 Create Init File in DB node.
Step-2 Create controfile after starting db in nomount and open the db in resetlogs.
Step-3 Create  xml file using adbldxml.pl in DB Tier
Step-4  Run Auto config in DB tier
Step-5 In Apps Tier run the cloning step using adcfgclone.pl appsTier

Details steps:
++Step:1

++ Create Init File in DB node: /u01/dev/db/tech_st/11.2.0.3/dbs/initDEV.ora

####################################################################
++Step:2

++Create controlfile after starting db in nomount

SQL> STARTUP NOMOUNT
CREATE CONTROLFILE SET DATABASE "DEV" RESETLOGS  NOARCHIVELOG
    .....
    .....
LOGFILE
  GROUP 1 (
    '/u01/dev/db/apps_st/data/log01a.dbf',
    '/u01/dev/db/apps_st/data/log01b.dbf'
 ....
 ....
DATAFILE
  '/u01/dev/db/apps_st/data/system01.dbf',
  '/u01/dev/db/apps_st/data/system02.dbf',
  '/u01/dev/db/apps_st/data/system03.dbf',
  .....
  .....
  '/u01/dev/db/apps_st/data/a_txn_ind05.dbf',
  '/u01/dev/db/apps_st/data/a_ref02.dbf'
CHARACTER SET WE8ISO8859P1
;

++ Open in resetlogs
SQL> alter database open resetlogs;

++ Add temp files:
ALTER TABLESPACE TEMP1 ADD TEMPFILE '/u01/dev/db/apps_st/data/temp01.dbf'
     SIZE 2000M REUSE AUTOEXTEND OFF;
ALTER TABLESPACE TEMP2 ADD TEMPFILE '/u01/dev/db/apps_st/data/temp02.dbf'
     SIZE 2000M REUSE AUTOEXTEND OFF;
alter system switch logfile;
/
++ Clean the fnd tables.
EXEC FND_CONC_CLONE.SETUP_CLEAN;

####################################################################
++Step-3:
Create xml file using adbldxml.pl in DB Tier

[oradev@host_db_01 bin]$ perl adbldxml.pl
Starting context file generation for db tier..
Using JVM from /u01/dev/db/tech_st/11.2.0.3/appsutil/jre/bin/java to execute java programs..
APPS Password: 
The log file for this adbldxml session is located at:
/u01/dev/db/tech_st/11.2.0.3/appsutil/log/adbldxml_03240939.log
Please answer the Questions below
Enter Hostname of Database server: host_db_01
Enter Port of Database server: 1521
Enter SID of Database server: DEV
Enter Hostname of Database server[host_db_01]:
Enter Port of Database server[1521]:
Enter SID of Database server[DEV]:
Enter the value for Display Variable: host_db_01:0.0
The context file has been created at:
/u01/dev/db/tech_st/11.2.0.3/appsutil/DEV_host_db_01.xml
[oradev@host_db_01 bin]$
####################################################################
++ Step-4:

++ Run Auto config in DB tier

[oradev@host_db_01 bin]$ ./adconfig.sh contextfile=/u01/dev/db/tech_st/11.2.0.3/appsutil/DEV_host_db_01.xml
Enter the APPS user password:
The log file for this session is located at: /u01/dev/db/tech_st/11.2.0.3/appsutil/log/DEV_host_db_01/03240944/adconfig.log
AutoConfig is configuring the Database environment...
AutoConfig will consider the custom templates if present.
        Using ORACLE_HOME location : /u01/dev/db/tech_st/11.2.0.3
        Classpath                   : :/u01/dev/db/tech_st/11.2.0.3/jdbc/lib/ojdbc6.jar:/u01/dev/db/tech_st/11.2.0.3/appsutil/java/xmlparserv2.jar:/u01/dev/db/tech_st/11.2.0.3/appsutil/java:/u01/dev/db/tech_st/11.2.0.3/jlib/netcfg.jar
        Using Context file          : /u01/dev/db/tech_st/11.2.0.3/appsutil/DEV_host_db_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.
[oradev@host_db_01 bin]$

####################################################################
++ Step-5:

++ In Apps Tier run the cloning step using adcfgclone.pl

[appldev@host_app_01 bin]$ pwd
/u01/dev/apps/apps_st/comn/clone/bin
[appldev@host_app_01 bin]$ perl adcfgclone.pl appsTier
.....
.....
....
Running:
Log file located at /u01/dev/apps/apps_st/comn/clone/bin/CloneContext_0324102651.log
Provide the values required for creation of the new APPL_TOP Context file.
Target System Hostname (virtual or normal) [host_app_01] :
Target System Database SID : DEV
Target System Database Server Node [host_app_01] : host_db_01
Target System Database Domain Name [abc.local] : dev.host.local
Target System Base Directory : /u01/dev
Target System Tools ORACLE_HOME Directory [/u01/dev/apps/tech_st/10.1.2] :
Target System Web ORACLE_HOME Directory [/u01/dev/apps/tech_st/10.1.3] :
Target System APPL_TOP Directory [/u01/dev/apps/apps_st/appl] :
Target System COMMON_TOP Directory [/u01/dev/apps/apps_st/comn] :
Target System Instance Home Directory [/u01/dev/inst] :
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] :
Do you want to preserve the Display [za-ohcsa-uat-01:0] (y/n)  : y
Do you want the the target system to have the same port values as the source system (y/n) [y] ? : y
.....
.....
Log file located at /u01/dev/apps/apps_st/comn/clone/bin/CloneContext_0324102651.log
Check Clone Context logfile /u01/dev/apps/apps_st/comn/clone/bin/CloneContext_0324102651.log for details.
....
....
APPS Password : Log file located at /u01/dev/inst/apps/DEV_host_app_01/admin/log/ApplyAppsTier_03241028.log
  \     88% completed
Completed Apply...
Tue Mar 24 10:36:04 2015
....
....
Do you want to startup the Application Services for DEV? (y/n) [y] : y
Starting application Services for DEV:
Running:
/u01/dev/inst/apps/DEV_host_app_01/admin/scripts/adstrtal.sh -nopromptmsg
....
...
[appldev@host_app_01 bin]$