Category Archives: Uncategorized

Adding an environment file

In order to keep consistency I have an environment file that I can use to set variables that I use


# Set history
set -o vi

# Setup my aliases
alias rspdir='cd /manh/oracle_crs/product/18.1.0/crs_1a/install/response'
alias rspdev='cd /ora01/Oracle_SW/fd_response_files'
alias admscr='cd /oracle/admin/scripts'
alias dir='ls -la|grep ^d'
alias lincom='cd /oracle/admin/scripts/linuxcommon'
alias gicom='cd /oracle/admin/scripts/gicommon'
alias sw='cd /ora01/Oracle_SW'
alias orainv='cd /manh/app/oraInventory'
alias orainvlog='cd /manh/app/oraInventory/logs'
alias crshome='cd /manh/oracle_crs/product/18.1.0/crs_1a'

# User specific environment and startup programs

PATH=$PATH:$HOME/.local/bin:$HOME/bin

#export DB_HOME=/manh/3rdparty/swtools/18.0.0/oracle
#export GI_HOME=/manh/3rdparty/swtools/18.0.0/grid

export GI_HOME=/manh/oracle_crs/product/18.1.0/crs_1a
# export DB_HOME=/manh/oracle/product/18.4.0/db_1a

#export ORACLE_BASE=/manh/3rdparty/swtools/oracle
# export ORACLE_HOME=$DB_HOME
#export ORACLE_SID=fadmanh1
# export PATH=$DB_HOME/bin:$DB_HOME/OPatch:$PATH

alias uldir='cd /manh/3rdparty/swtools/oracle_sw'
alias ora01='cd /ora01/Oracle_SW'

Oracle19c New Features

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

GRID Response File 18c

<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>