Uncategorized | IT Remote

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

monitor_fgl.ksh

#!/bin/ksh

###########################################################################################################                                         #############
# DBA TEAM   - initial version
# 03/18/2019 - Made it dynamic to pick the FGL home
###########################################################################################################                                         #############
##set -x
#
# This job will monitor foglight and attempt to restart it if it
# is not running. It will send email notification.
# REL_2
#  Envir.
. $HOME/.profile > /dev/null
if [ -a .kshrc ]; then
   . ./.kshrc
fi

export OS=$(uname)
BASE=$(dirname $0)
## LOGDIR="/oracle/dba/output/generic"
dte=`date +%Y%m%d`
HOST=`hostname -s`
## logf=${LOGDIR}/${HOST}_Foglight_Stat_${dte}.log
logf=/tmp/${HOST}_Foglight_Stat_${dte}_$$.log

# SENDER_EMAIL_ID="dg.Adminemail_baci_oracle_dba@test.com"
## FGL_STATE=/oracle/dba/foglight/fgl_5/state/default

find / -type d \( -name proc -o -name banktools -o -name efs -o -name dbacl -o -name run -o -name ".efs" -o                                          -name home -o -name vol \) -prune -o -name "fgl_5" -print 2>&1 | grep -v "Permission denied" > /tmp/fog_te                                         st_$$.lst

for i in `cat /tmp/fog_test_$$.lst`
do
FGL_OWNER=`ls -ld $i |cut -d " " -f 3`
if [ "$FGL_OWNER" = "$USER" ]
then
export FGL_HOME=$i
fi
done

if [ $? -ne 0 ]; then
echo "Not able to identify the FGL home - Please Investigate"
exit 1
fi

if [ -z $FGL_HOME ]; then
echo "Not able to identify the FGL home - Please Investigate"
exit 1
fi

FGL_STATE=$FGL_HOME/../../foglight/fgl_5/state/default

MAILDATE=$(date '+%m%d%Y_%H%M')
TOA="test.com"
EMAIL="dg.oracle_hosting_services_-_non_exa@${TOA}"
#MESSAGE="Foglight Not Running - Attempt to Restart Failed"
#MESSAGE="Foglight Was Not Running - Restarted"
MSG_SUBJECT="Test email with file"

#send_mail () {
#   if [ "$OS" == "Linux" ]; then
#    if [ `uname -r | cut -d. -f3 | cut -d- -f1` -le 18 ]; then
#     (echo $MESSAGE ) | mail -s "$HOST - $MSG_SUBJECT" $EMAIL -- -f $SENDER_EMAIL_ID
#    else
#     (echo $MESSAGE) |  mailx -s "$HOST - $MSG_SUBJECT" -r $SENDER_EMAIL_ID $EMAIL
#    fi
#   else
#    (echo $MESSAGE ) | mailx -s "$HOST - $MSGTEXT" -r $SENDER_EMAIL_ID $EMAIL
#   fi
#}

if [ -r $FGL_STATE/.*.pid ]; then
cat `ls $FGL_STATE/.*.pid|tail -1` > /tmp/fgl_pcheck_$$.lst
FGL_PID=`cat /tmp/fgl_pcheck_$$.lst`
## FGL_PID=`cat $FGL_STATE/.*.pid`
## ps -ef | grep $FGL_PID | grep -v grep | grep -i fog > /dev/null
if [ $? -ne 0 ]; then
printf "Foglight not running PID = $FGL_PID \n" >>${logf} 2>> ${logf}
printf "Restarting ........................ \n" >>${logf} 2>> ${logf}
$FGL_HOME/bin/fglam -Xint -d >>${logf} 2>> ${logf}
sleep 60
FGL_PID=`cat $FGL_STATE/.*.pid`
ps -ef | grep $FGL_PID | grep -v grep > /dev/null
if [ $? -ne 0 ]; then
#    MESSAGE="Foglight Not Running - Attempt to Restart Failed - Please Investigate"
#    MSG_SUBJECT="Foglight Restart Failed"
#send_mail
echo "Foglight Not Running - Attempt to Restart Failed - Please Investigate"
exit 1
else
echo "Foglight Was Not Running - Restarted Successfully"
#    MSG_SUBJECT="Foglight Restarted"
#send_mail
fi
else
printf "Foglight is running PID = $FGL_PID \n" >>${logf} 2>> ${logf}
fi
else
printf "Foglight not running .............. \n"  >>${logf} 2>> ${logf}
printf "Restarting ........................ \n"  >>${logf} 2>> ${logf}
$FGL_HOME/bin/fglam -Xint -d  >>${logf} 2>> ${logf}
sleep 60
FGL_PID=`cat $FGL_STATE/.*.pid`
ps -ef | grep $FGL_PID | grep -v grep > /dev/null
if [ $? -ne 0 ]; then
#  MESSAGE="Foglight Not Running - Attempt to Restart Failed - Please Investigate"
#  MSG_SUBJECT="Foglight Restart Failed"
echo "Foglight Not Running - Attempt to Restart Failed - Please Investigate"
exit 1
#send_mail
else
#  MESSAGE="Foglight Was Not Running - Restarted Successfully"
echo "Foglight Was Not Running - Restarted Successfully"
MSG_SUBJECT="Foglight Restarted"
#send_mail
fi
fi
#
exit

Use the search and put in the DB you are looking for, it should come back with the CDB and PDB

ITRemote

Ready for Action?