adpreclone.pl dbtier
it will run the below two stages
1)Techstack
1)Database
Techstack:
it will $ORACLE_HOME/clone/Jlib -->directory it will create and update the all library files (when we apply psu patches like that it will udpate the psu version related class files in this directory)
NOTE: if
-bash-3.2$ pwd
$FND_TOP/sql
-bash-3.2$ ls wfver.sql
wfver.sql ---> this script will idetify the xmlparser version if psu related issues (need to be run from application node)
related to datafile and required for cloning
creates the driver files ORACLE_HOME/appsutil/driver/instconf.drv
convert the inventory file from binary to xml
$ORACLE_HOME/appsutil/clone/context/db/Sid_context.xml
example: it will save the binary information to xml as like below
</nls_settings>
<oa_db_server>
<dbhost oa_var="s_dbhost">xxxxxxp2</dbhost>
<dbport oa_var="s_dbport" oa_type="PORT">1522</dbport>
<dbtype oa_var="s_dbtype">VISION</dbtype>
<dbcset oa_var="s_dbcset">UTF8</dbcset>
<dbseed oa_var="s_dbseed">Fresh Install</dbseed>
<dbcomp oa_var="s_dbcomp">oracle.apps.dbseed.fresh</dbcomp>
<dbprocesses oa_var="s_db_processes">1500</dbprocesses>
<SESSIONS oa_var="s_db_sessions">400</SESSIONS>
<dbfiles oa_var="s_dbfiles">1500</dbfiles>
<dbblockbuffers oa_var="s_dbblock_buffers">0</dbblockbuffers>
<dbcachesize oa_var="s_dbcache_size">163577856</dbcachesize>
<dbsharedpool oa_var="s_dbsharedpool_size">300000000</dbsharedpool>
<dbrollbacksegs oa_var="s_db_rollback_segs">NOROLLBACK</dbrollbacksegs>
<dbutilfiledir oa_var="s_db_util_filedir" osd="unix">/xxxxxxp2/app/comn/temp, /usr/tmp, /tmp</dbutilfiledir>
<undotablespace oa_var="s_undo_tablespace">APPS_UNDOTS1</undotablespace>
<APPS_DATA_FILE_DIR oa_var="s_db_data_file_dir">/xxxxxxp2/oracle/db/11.2.0/appsutil/outbound/xxxxxxp2_xxxxxxp2</APPS_DATA_FILE_DIR>
<o7dictionaryaccess oa_var="s_o7_dictionary_accessibility">TRUE</o7dictionaryaccess>
<db_walletdir oa_var="s_dbWalletDir">/xxxxxxp2/oracle/db/11.2.0/appsutil/wallet</db_walletdir>
Database:
creating datbase control file script/datafile location information file
at $ORACLE_HOME/appsutil/template/adcrdbclone.sql, dbfinfo.lst
example:
$ cat dbfinfo.lst
param|s_undo_tablespace|APPS_UNDOTS1
param|s_database|db112
param|UNDO_MANAGEMENT|AUTO
param|isspfileexists|false
param|s_dbfiles|1500
log|7|/xxxxxxp2/dbdata/redo1/log07.dbf|1610612736
log|8|/xxxxxxp2/dbdata/redo2/log08.dbf|1610612736
log|9|/xxxxxxp2/dbdata/redo1/log09.dbf|1610612736
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp04.dbf
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp03.dbf
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp02.dbf
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp01.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system04.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system03.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system02.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system01.dbf
dat2|USERS|/xxxxxxp2/dbdata/data1/users01.dbf
dat2|OWAPUB|/xxxxxxp2/dbdata/data1/owad01.dbf
dat2|APPS_TS_TOOLS|/xxxxxxp2/dbdata/data1/apps_ts_tools01.dbf
dat2|xxxxxxSRX|/xxxxxxp2/dbdata/data1/xxxxxxSrx01.dbf
dat2|xxxxxxSRD|/xxxxxxp2/dbdata/data1/xxxxxxSrd01.dbf
dat2|DISCOVERER|/xxxxxxp2/dbdata/data1/discoverer01.dbf
dat2|APPS_UNDOTS1|/xxxxxxp2/dbdata/data1/undots09.dbf
dat2|APPS_UNDOTS1|/xxxxxxp2/dbdata/data1/undots08.dbf
dat2|APPS_UNDOTS1|/xxxxxxp2/dbdata/data1/undots07.dbf
sys|SYSAUX|/xxxxxxp2/dbdata/data1/sysaux01.dbf
dat2|APPS_TS_TX_DATA|/xxxxxxp2/dbdata/data1/APPS_TS_TX_DATA21.dbf
dat2|APPS_TS_MEDIA|/xxxxxxp2/dbdata/data1/APPS_TS_MEDIA03.dbf
example:#cat adcrdbclone.sql -->because of this we can able to recreate controlfile
define arg1=&1
spool %s_db_oh%/appsutil/log/%s_contextname%/adcrdb_%s_dbSid%.txt
connect / as sysdba
shutdown abort
connect / as sysdba
startup nomount pfile=%s_db_oh%/dbs/init%s_dbSid%.ora;
CREATE CONTROLFILE REUSE SET DATABASE "%s_dbGlnam%"
LOGFILE
GROUP 7 ('%s_dbhome2%/log07.dbf') SIZE 1610612736,
GROUP 8 ('%s_dbhome2%/log08.dbf') SIZE 1610612736,
GROUP 9 ('%s_dbhome2%/log09.dbf') SIZE 1610612736
DATAFILE
'%s_dbhome1%/system05.dbf',
'%s_dbhome1%/system04.dbf',
'%s_dbhome1%/system03.dbf',
'%s_dbhome1%/system02.dbf',
'%s_dbhome1%/system01.dbf',
'%s_dbhome1%/sysaux01.dbf',
'%s_dbhome3%/ctxd01.dbf',
'%s_dbhome4%/users01.dbf',
'%s_dbhome4%/owad01.dbf',
'%s_dbhome4%/apps_ts_tools01.dbf',
'%s_dbhome4%/dresrx01.dbf',
'%s_dbhome4%/dresrd01.dbf',
'%s_dbhome4%/dresd02.dbf',
'%s_dbhome4%/dresd01.dbf',
'%s_dbhome4%/discoverer01.dbf',
'%s_dbhome4%/APPS_TS_TX_IDX_LG06.dbf',
'%s_dbhome4%/APPS_TS_TX_IDX_LG05.dbf',
creation of the database driver file
ORACLE_HOME/appsutil/clone/data/driver/data.drv
$ cat data.drv
#=====================================================================+
# Copyright (c) 2002 Oracle Corporation Belmont, California, USA |
# All rights reserved. |
#=====================================================================+
# FILENAME
# /xxxxxxp2/oracle/db/11.2.0/appsutil/clone/data/driver/data.drv
# DESCRIPTION
# Template file driver file for applying a clone using AutoClone
#=====================================================================*/
#
# <src top> <src dir> <src name> <file type> <dst dir> <dst name>
# =========================================================================
if installation-type db
ad <s_clonestage>/data/stage adcrdb.zip UNZIP <s_db_oh>/appsutil/template
endif
Copy JDBC Libraries at ORACLE_HOME/appsutil/clone/jlib/classes12.jar and appsoui
it will run the below two stages
1)Techstack
1)Database
Techstack:
it will $ORACLE_HOME/clone/Jlib -->directory it will create and update the all library files (when we apply psu patches like that it will udpate the psu version related class files in this directory)
NOTE: if
-bash-3.2$ pwd
$FND_TOP/sql
-bash-3.2$ ls wfver.sql
wfver.sql ---> this script will idetify the xmlparser version if psu related issues (need to be run from application node)
related to datafile and required for cloning
creates the driver files ORACLE_HOME/appsutil/driver/instconf.drv
convert the inventory file from binary to xml
$ORACLE_HOME/appsutil/clone/context/db/Sid_context.xml
example: it will save the binary information to xml as like below
</nls_settings>
<oa_db_server>
<dbhost oa_var="s_dbhost">xxxxxxp2</dbhost>
<dbport oa_var="s_dbport" oa_type="PORT">1522</dbport>
<dbtype oa_var="s_dbtype">VISION</dbtype>
<dbcset oa_var="s_dbcset">UTF8</dbcset>
<dbseed oa_var="s_dbseed">Fresh Install</dbseed>
<dbcomp oa_var="s_dbcomp">oracle.apps.dbseed.fresh</dbcomp>
<dbprocesses oa_var="s_db_processes">1500</dbprocesses>
<SESSIONS oa_var="s_db_sessions">400</SESSIONS>
<dbfiles oa_var="s_dbfiles">1500</dbfiles>
<dbblockbuffers oa_var="s_dbblock_buffers">0</dbblockbuffers>
<dbcachesize oa_var="s_dbcache_size">163577856</dbcachesize>
<dbsharedpool oa_var="s_dbsharedpool_size">300000000</dbsharedpool>
<dbrollbacksegs oa_var="s_db_rollback_segs">NOROLLBACK</dbrollbacksegs>
<dbutilfiledir oa_var="s_db_util_filedir" osd="unix">/xxxxxxp2/app/comn/temp, /usr/tmp, /tmp</dbutilfiledir>
<undotablespace oa_var="s_undo_tablespace">APPS_UNDOTS1</undotablespace>
<APPS_DATA_FILE_DIR oa_var="s_db_data_file_dir">/xxxxxxp2/oracle/db/11.2.0/appsutil/outbound/xxxxxxp2_xxxxxxp2</APPS_DATA_FILE_DIR>
<o7dictionaryaccess oa_var="s_o7_dictionary_accessibility">TRUE</o7dictionaryaccess>
<db_walletdir oa_var="s_dbWalletDir">/xxxxxxp2/oracle/db/11.2.0/appsutil/wallet</db_walletdir>
Database:
creating datbase control file script/datafile location information file
at $ORACLE_HOME/appsutil/template/adcrdbclone.sql, dbfinfo.lst
example:
$ cat dbfinfo.lst
param|s_undo_tablespace|APPS_UNDOTS1
param|s_database|db112
param|UNDO_MANAGEMENT|AUTO
param|isspfileexists|false
param|s_dbfiles|1500
log|7|/xxxxxxp2/dbdata/redo1/log07.dbf|1610612736
log|8|/xxxxxxp2/dbdata/redo2/log08.dbf|1610612736
log|9|/xxxxxxp2/dbdata/redo1/log09.dbf|1610612736
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp04.dbf
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp03.dbf
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp02.dbf
tmp|TEMP|/xxxxxxp2/dbdata/temp/temp01.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system04.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system03.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system02.dbf
sys|SYSTEM|/xxxxxxp2/dbdata/data1/system01.dbf
dat2|USERS|/xxxxxxp2/dbdata/data1/users01.dbf
dat2|OWAPUB|/xxxxxxp2/dbdata/data1/owad01.dbf
dat2|APPS_TS_TOOLS|/xxxxxxp2/dbdata/data1/apps_ts_tools01.dbf
dat2|xxxxxxSRX|/xxxxxxp2/dbdata/data1/xxxxxxSrx01.dbf
dat2|xxxxxxSRD|/xxxxxxp2/dbdata/data1/xxxxxxSrd01.dbf
dat2|DISCOVERER|/xxxxxxp2/dbdata/data1/discoverer01.dbf
dat2|APPS_UNDOTS1|/xxxxxxp2/dbdata/data1/undots09.dbf
dat2|APPS_UNDOTS1|/xxxxxxp2/dbdata/data1/undots08.dbf
dat2|APPS_UNDOTS1|/xxxxxxp2/dbdata/data1/undots07.dbf
sys|SYSAUX|/xxxxxxp2/dbdata/data1/sysaux01.dbf
dat2|APPS_TS_TX_DATA|/xxxxxxp2/dbdata/data1/APPS_TS_TX_DATA21.dbf
dat2|APPS_TS_MEDIA|/xxxxxxp2/dbdata/data1/APPS_TS_MEDIA03.dbf
example:#cat adcrdbclone.sql -->because of this we can able to recreate controlfile
define arg1=&1
spool %s_db_oh%/appsutil/log/%s_contextname%/adcrdb_%s_dbSid%.txt
connect / as sysdba
shutdown abort
connect / as sysdba
startup nomount pfile=%s_db_oh%/dbs/init%s_dbSid%.ora;
CREATE CONTROLFILE REUSE SET DATABASE "%s_dbGlnam%"
LOGFILE
GROUP 7 ('%s_dbhome2%/log07.dbf') SIZE 1610612736,
GROUP 8 ('%s_dbhome2%/log08.dbf') SIZE 1610612736,
GROUP 9 ('%s_dbhome2%/log09.dbf') SIZE 1610612736
DATAFILE
'%s_dbhome1%/system05.dbf',
'%s_dbhome1%/system04.dbf',
'%s_dbhome1%/system03.dbf',
'%s_dbhome1%/system02.dbf',
'%s_dbhome1%/system01.dbf',
'%s_dbhome1%/sysaux01.dbf',
'%s_dbhome3%/ctxd01.dbf',
'%s_dbhome4%/users01.dbf',
'%s_dbhome4%/owad01.dbf',
'%s_dbhome4%/apps_ts_tools01.dbf',
'%s_dbhome4%/dresrx01.dbf',
'%s_dbhome4%/dresrd01.dbf',
'%s_dbhome4%/dresd02.dbf',
'%s_dbhome4%/dresd01.dbf',
'%s_dbhome4%/discoverer01.dbf',
'%s_dbhome4%/APPS_TS_TX_IDX_LG06.dbf',
'%s_dbhome4%/APPS_TS_TX_IDX_LG05.dbf',
creation of the database driver file
ORACLE_HOME/appsutil/clone/data/driver/data.drv
$ cat data.drv
#=====================================================================+
# Copyright (c) 2002 Oracle Corporation Belmont, California, USA |
# All rights reserved. |
#=====================================================================+
# FILENAME
# /xxxxxxp2/oracle/db/11.2.0/appsutil/clone/data/driver/data.drv
# DESCRIPTION
# Template file driver file for applying a clone using AutoClone
#=====================================================================*/
#
# <src top> <src dir> <src name> <file type> <dst dir> <dst name>
# =========================================================================
if installation-type db
ad <s_clonestage>/data/stage adcrdb.zip UNZIP <s_db_oh>/appsutil/template
endif
Copy JDBC Libraries at ORACLE_HOME/appsutil/clone/jlib/classes12.jar and appsoui
