Uncategorized | IT Remote

GoldenGate18 New Features

Cloning Oracle ClusterWare 18c

Ability to Create a Duplicate of an Oracle Database Using DBCA in Silent Mode

You can now create a duplicate of an Oracle database by using the createDuplicateDB command of DBCA in silent mode.

This feature enables developers to work on identical copies of an Oracle database.

Support for Dry-Run Validation of Oracle Clusterware Upgrade

Oracle 18c now has the ability to do in-database row archival native to the database.

This could be good for databases that have both active data and archive data in the same database.

Test code additional

To find any errors prior to install execute the CLUVFY Cluster Verify Utility

Oracle 18c

cluvfy -stage pre crs -n allnodes

<div id="crayon-5cf7fd8d3a526415552138-1" class="crayon-line"><span class="crayon-sy">$</span> <span class="crayon-i">cat</span> <span class="crayon-i">grid1840_swonly</span><span class="crayon-sy">.</span><span class="crayon-i">rsp</span></div>
<div id="crayon-5cf7fd8d3a526415552138-2" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-v">responseFileVersion</span><span class="crayon-o">=</span><span class="crayon-o">/</span><span class="crayon-i">oracle</span><span class="crayon-o">/</span><span class="crayon-i">install</span><span class="crayon-o">/</span><span class="crayon-i">rspfmt_crsinstall_response_schema_v18</span><span class="crayon-sy">.</span><span class="crayon-cn">0.0</span></div>
<div id="crayon-5cf7fd8d3a526415552138-3" class="crayon-line"><span class="crayon-v">INVENTORY_LOCATION</span><span class="crayon-o">=</span><span class="crayon-o">/</span><span class="crayon-i">u01</span><span class="crayon-o">/</span><span class="crayon-i">app</span><span class="crayon-o">/</span><span class="crayon-i">oraInventory</span></div>
<div id="crayon-5cf7fd8d3a526415552138-4" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-v">option</span><span class="crayon-o">=</span><span class="crayon-i">CRS_SWONLY</span></div>
<div id="crayon-5cf7fd8d3a526415552138-5" class="crayon-line"><span class="crayon-v">ORACLE_BASE</span><span class="crayon-o">=</span><span class="crayon-o">/</span><span class="crayon-i">u01</span><span class="crayon-o">/</span><span class="crayon-i">app</span><span class="crayon-o">/</span><span class="crayon-i">oracle</span></div>
<div id="crayon-5cf7fd8d3a526415552138-6" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-v">OSDBA</span><span class="crayon-o">=</span><span class="crayon-i">dba</span></div>
<div id="crayon-5cf7fd8d3a526415552138-7" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-v">OSASM</span><span class="crayon-o">=</span><span class="crayon-i">asmdba</span></div>
<div id="crayon-5cf7fd8d3a526415552138-8" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-v">scanType</span><span class="crayon-o">=</span><span class="crayon-i">LOCAL_SCAN</span></div>
<div id="crayon-5cf7fd8d3a526415552138-9" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-i">gpnp</span><span class="crayon-sy">.</span><span class="crayon-v">configureGNS</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-10" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-v">autoConfigureClusterNodeVIP</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-11" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-i">gpnp</span><span class="crayon-sy">.</span><span class="crayon-v">gnsOption</span><span class="crayon-o">=</span><span class="crayon-i">CREATE_NEW_GNS</span></div>
<div id="crayon-5cf7fd8d3a526415552138-12" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-v">clusterNodes</span><span class="crayon-o">=</span><span class="crayon-i">server1</span><span class="crayon-sy">,</span><span class="crayon-i">server2</span></div>
<div id="crayon-5cf7fd8d3a526415552138-13" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-v">configureGIMRDataDG</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-14" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-v">useIPMI</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-15" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-v">storageOption</span><span class="crayon-o">=</span><span class="crayon-i">ASM</span></div>
<div id="crayon-5cf7fd8d3a526415552138-16" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asmOnNAS</span><span class="crayon-sy">.</span><span class="crayon-v">configureGIMRDataDG</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-17" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-i">diskGroup</span><span class="crayon-sy">.</span><span class="crayon-v">name</span><span class="crayon-o">=</span><span class="crayon-i">OCRVOT</span></div>
<div id="crayon-5cf7fd8d3a526415552138-18" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-i">diskGroup</span><span class="crayon-sy">.</span><span class="crayon-v">AUSize</span><span class="crayon-o">=</span><span class="crayon-cn">1</span></div>
<div id="crayon-5cf7fd8d3a526415552138-19" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-i">gimrDG</span><span class="crayon-sy">.</span><span class="crayon-v">AUSize</span><span class="crayon-o">=</span><span class="crayon-cn">1</span></div>
<div id="crayon-5cf7fd8d3a526415552138-20" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">asm</span><span class="crayon-sy">.</span><span class="crayon-v">configureAFD</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-21" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-v">configureRHPS</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-22" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-v">ignoreDownNodes</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-23" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-v">managementOption</span><span class="crayon-o">=</span><span class="crayon-i">NONE</span></div>
<div id="crayon-5cf7fd8d3a526415552138-24" class="crayon-line crayon-striped-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">config</span><span class="crayon-sy">.</span><span class="crayon-v">omsPort</span><span class="crayon-o">=</span><span class="crayon-cn">0</span></div>
<div id="crayon-5cf7fd8d3a526415552138-25" class="crayon-line"><span class="crayon-i">oracle</span><span class="crayon-sy">.</span><span class="crayon-i">install</span><span class="crayon-sy">.</span><span class="crayon-i">crs</span><span class="crayon-sy">.</span><span class="crayon-i">rootconfig</span><span class="crayon-sy">.</span><span class="crayon-v">executeRootScript</span><span class="crayon-o">=</span><span class="crayon-i">false</span></div>
<div id="crayon-5cf7fd8d3a526415552138-26" class="crayon-line crayon-striped-line"></div>
<div id="crayon-5cf7fd8d3a526415552138-27" class="crayon-line"><span class="crayon-sy">$</span> <span class="crayon-sy">.</span><span class="crayon-o">/</span><span class="crayon-i">gridSetup</span><span class="crayon-sy">.</span><span class="crayon-i">sh</span> <span class="crayon-o">-</span><span class="crayon-i">silent</span> <span class="crayon-o">-</span><span class="crayon-i">responseFile</span> <span class="crayon-i">grid1840_swonly</span><span class="crayon-sy">.</span><span class="crayon-i">rsp</span> <span class="crayon-v">ORACLE_HOME_NAME</span><span class="crayon-o">=</span><span class="crayon-i">crs1840</span></div>
<div id="crayon-5cf7fd8d3a526415552138-28" class="crayon-line crayon-striped-line"><span class="crayon-i">Launching</span> <span class="crayon-i">Oracle</span> <span class="crayon-i">Grid</span> <span class="crayon-i">Infrastructure</span> <span class="crayon-i">Setup</span> <span class="crayon-i">Wizard</span><span class="crayon-sy">.</span><span class="crayon-sy">.</span><span class="crayon-sy">.</span></div>

Delete and add resource dbfs_ggtxd001 and dbfs_mrc

copied mount scripts (mount_dbfs_ggtxp001.bsh and mount-dbfs_ggtxp001.conf) to /oracle/admin/scripts/ggtxp001

(mount_dbfs_cicm.bsh and mount-dbfs_cicm.conf) to /oracle/admin/scripts/proj/cicm)

Steps

Stop all GG extract and replicat from the directory you are upgrading from
set_ggenv ggtxd002 for example
Configure the new instance ggtxd006 for dbfs_mrct and service ora.dbfsxd01.dbfs_mrct.svc
set_ggenv ggtxd006, and check the target environment to see if its running, if not start the instance in order to check do this: hubhelp xag_stat_gginst ggtxd006


appgold
apex
gicommon
ggsdcommon
ggcommon
crsdbfs
dbcommon
asmcommon
apexcommon
clle_dbfscommon
dbfscommon
dgcommon
qacommon

appgold.ggini - init parameters

cr_dbfs_exeprimdb.ksh - primary
cr_dbfs_exestdy.ksh - standby

dbfs_cr_objs_parm_appgold_fn.ksh
dbfs_cr_tnsname_appgold_fn.ksh

dbfs_cr_mnt_pnt_parm_appgold_fn.ksh
dbfs_svc_parm_appgold_fn.ksh

dbfs_cr_tblspusr_parm_appgold_fn.ksh
crs_add_res_dbfs_parm_appgold_fn.ksh

dbfs_mount_passwd_appgold.ksh

xag_relo_ggtxd003_appgold_parm_fn.ksh
xag_start_ggtxd003_appgold_fn.ksh
xag_stop_ggtxd003_appgold_fn.ksh

mount_dbfs_appgold_.bsh
mount-dbfs_appgold.conf

xag_add_proj_fs_parm_appgold_fn.ksh