Wednesday, 4 April 2018

perl adcfgclone.pl dbTier

Using admin directory: /u01/db/PROD/db/tech_st/11.1.0/appsutil/clone/bin
#----------------------------------------------
#------Log File time stamp: 0402222256------------
# $Header: CloneContext.java 120.92.12010000.5 2008/11/10 09:40:09 ksita ship $
# Running on          - tos01
# Source Host         - null
# Domain Name         - tosh02.com
# Context Location    - /u01/db/PROD/db/tech_st/11.1.0/appsutil/clone/bin/../context/db/CTXORIG.xml
# Context Type        - null
# Context Template    - null
# Clone Stage Area    - /u01/db/PROD/db/tech_st/11.1.0/appsutil/clone
# Pairs File          - /tmp/adpairsfile_3874.lst
# Destination Context - null
# Validation          - true
# Platform Migration  - false
# no prompt           - false
#----------------------------------------------


Variables extracted from pairsfile: /tmp/adpairsfile_3874.lst
****************************************************/n
  s_dbuser  =  oradev
  s_dbgroup  =  dba
****************************************************

PROMPT :
Target System Hostname (virtual or normal) [tos01]
ANSWER :
tos01

PROMPT :
Target Instance is RAC (y/n) [n]
ANSWER :
n

PROMPT :
Target System Database SID
ANSWER :
UAT

PROMPT :
Target System Base Directory
ANSWER :
/u01/db/PROD/

PROMPT :
Target System utl_file_dir Directory List
ANSWER :
/TMP

PROMPT :
Number of DATA_TOP's on the Target System [1]
ANSWER :
1

PROMPT :
Target System DATA_TOP Directory 1 [/u01/PROD/db/apps_st/data]
ANSWER :
/u01/db/PROD/db/apps_st/data/
Creating /u01/db/PROD/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.

PROMPT :
Target System RDBMS ORACLE_HOME Directory [/u01/db/PROD/db/tech_st/11.1.0]
ANSWER :
/u01/db/PROD/db/tech_st/11.1.0/
Creating /u01/db/PROD/db/tech_st/11.1.0/appsutil/clone/data/stage/addbhomtgt.xml which will contain Target system database mount points.

PROMPT :
Do you want to preserve the Display [null] (y/n) ?
ANSWER :
n

PROMPT :
Target System Display [tos01:0.0]
ANSWER :
tos01:0.0
Started testing the availabilty of ports in port pool 2

 Checking  Database Port on tos01:  Port Value = 1523
   Database Port available:  Port Value = 1523
 Checking  DB ONS Local Port on tos01:  Port Value = 6302
   DB ONS Local Port available:  Port Value = 6302
 Checking  DB ONS Remote Port on tos01:  Port Value = 6402
   DB ONS Remote Port available:  Port Value = 6402
setDestination s_contextfile to : /u01/db/PROD/db/tech_st/11.1.0/appsutil/UAT_tos01.xml
Clone Context Parameters:
    Pairs File      = /tmp/adpairsfile_3874.lst
    Target XML File = /u01/db/PROD/db/tech_st/11.1.0/appsutil/UAT_tos01.xml
    Template File   = /u01/db/PROD/db/tech_st/11.1.0/appsutil/template/adxdbctx.tmp


The following values will be used to create the context file

****************************************************

  s_isWeb  =  YES
  s_db_util_filedir  =  /TMP
  s_db_rollback_segs  =  NOROLLBACK
  s_dbhome4  =  /u01/db/PROD/db/apps_st/data/
  s_dbhome3  =  /u01/db/PROD/db/apps_st/data/
  s_dbhost  =  tos01
  s_db_oh  =  /u01/db/PROD/db/tech_st/11.1.0/
  s_dbhome2  =  /u01/db/PROD/db/apps_st/data/
  s_dbhome1  =  /u01/db/PROD/db/apps_st/data/
  s_dbgroup  =  dba
  s_dbGlnam  =  UAT
  s_dbdomain  =  tosh02.com
  s_dbSid  =  UAT
  s_dbuser  =  oradev
  s_isForms  =  YES
  s_database_type  = 
  s_temp  =  /u01/db/PROD/db/tech_st/11.1.0//appsutil/temp
  s_db_ons_localport  =  6302
  s_hostname  =  tos01
  s_dbSidLower  =  uat
  s_cmanport  =  1523
  s_dbCluster  =  false
  s_domainname  =  tosh02.com
  s_isAdmin  =  YES
  s_isConc  =  YES
  s_contextfile  =  /u01/db/PROD/db/tech_st/11.1.0/appsutil/UAT_tos01.xml
  s_dbport  =  1523
  s_display  =  tos01:0.0
  s_contextname  =  UAT_tos01
  s_db_ons_remoteport  =  6402
  s_clonestage  =  /u01/db/PROD/db/tech_st/11.1.0//appsutil/clone
  s_base  =  /u01/db/PROD
****************************************************

Clone Context will now iteratively apply changes
to create the new target context file.

instantiate file:
   source : /u01/db/PROD/db/tech_st/11.1.0/appsutil/temp.xml
   dest   : /tmp/tmpCtxClone.xml
instantiate file:
   source : /tmp/tmpCtxClone.xml
   dest   : /tmp/tmpCtxClone.xml
instantiate file:
   source : /tmp/tmpCtxClone.xml
   dest   : /tmp/tmpCtxClone.xml
instantiate file:
   source : /tmp/tmpCtxClone.xml
   dest   : /tmp/tmpCtxClone.xml
instantiate file:
   source : /tmp/tmpCtxClone.xml
   dest   : /u01/db/PROD/db/tech_st/11.1.0/appsutil/UAT_tos01.xml
instantiate file:
   source : /u01/db/PROD/db/tech_st/11.1.0/appsutil/temp.xml
   dest   : /tmp//dummy.xml
instantiate file:
   source : /tmp//dummy.xml
   dest   : /tmp//dummy.xml
instantiate file:
   source : /tmp//dummy.xml
   dest   : /tmp//dummy.xml
instantiate file:
   source : /tmp//dummy.xml
   dest   : /tmp//dummy.xml
instantiate file:
   source : /tmp//dummy.xml
   dest   : /tmp//dummy.xml

The values for these variables will be retained from the source context


****************************************************

  s_admin_restrictions  =  OFF
  s_metalink_id  = 
  s_parallel_max_servers  =  8
  s_lib_ext  =  so
  s_systemcsi  =  N/A
  s_apps_version  =  12.1.1
  s_contextserial  =  0
  s_instThread  =  0
  s_sqlnet_expire_time  =  10
  s_contexttype  =  Database Context
  s_db_sga_target  =  1G
  s_dbsharedpool_size  =  300000000
  s_db_shared_pool_size  =  400M
  s_clusterServicePort  =  9998
  s_dbcache_size  =  163577856
  s_rapidwizloc  =  /u02/ebs1211/startCD/Disk1/rapidwiz
  s_db_pga_aggregate_target  =  1G
  s_dbtype  =  PROD
  s_proxyhost  = 
  s_nthreads  =  5
  s_ecx_log_dir  =  /usr/tmp
  s_db_processes  =  200
  s_enable_listener_password  =  OFF
  s_alt_service_instances  = 
  s_dbClusterInst  =  1
  s_installedFrom  =  FS
  s_undo_tablespace  =  APPS_UNDOTS1
  s_adjreopts  =  -Xms128M -Xmx512M
  s_dbQuorumDisk  = 
  s_db_linkctrl  = 
  s_platform  =  LINUX_X86-64
  s_dbcomp  =  oracle.apps.dbseed.fresh
  /  =  /
  s_db_sessions  =  400
  s_installloc  =  /u02/ebs1211/startCD/Disk1
  s_isDB  =  YES
  s_proxyport  = 
  s_database  =  db111
  s_dbseed  =  Fresh Install
  s_apps_user  =  APPS
  s_dbfiles  =  512
  s_db_shared_pool_reserved_size  =  40M
  s_bits  =  32
  s_dbblock_buffers  =  20000
  s_sys_user  =  SYS
  s_bis_debug_log_dir  =  /usr/tmp
  s_dlsnstatus  =  enabled
  s_db_plsql_native_library_subdir_count  =  149
  s_country_code  = 
  s_subscribe_for_node_down_event  =  OFF
  s_instNumber  =  0

*********************************************


The new context file has been created at:
    /u01/db/PROD/db/tech_st/11.1.0/appsutil/UAT_tos01.xml

No comments:

Post a Comment