12c R1 RAC : 10. DB 생성 후 패치

export ORACLE_BASE=/u01/app/oracle
export GRID_HOME=/u01/app/12.1.0/grid
export DB_HOME=$ORACLE_BASE/product/12.1.0/db_1
# mkdir -p /u01/app/oracle/cfgtoollogs/sqlpatch/26925263/21857460
# chown -R grid:oinstall /u01/app/oracle/cfgtoollogs/sqlpatch
# chmod -R 775 /u01/app/oracle/cfgtoollogs

$GRID_HOME/bin/crsctl stat res -t

cd $GRID_HOME
OPatch/opatch version
mv OPatch OPatch.old
cp -r /media/sf_oracle/OPatch .
chown -R grid:oinstall OPatch
ll | grep OPatch
OPatch/opatch version

cd $DB_HOME
OPatch/opatch version
mv OPatch OPatch.old
cp -r /media/sf_oracle/OPatch .
chown -R oracle:oinstall OPatch
ll | grep OPatch
OPatch/opatch version

$GRID_HOME/OPatch/opatch lsinventory

$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26910974
$GRID_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26983807
vi /tmp/patch_list_gihome.txt
# cat /tmp/patch_list_gihome.txt
$GRID_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_gihome.txt

$DB_HOME/OPatch/opatch lsinventory

$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925263
$DB_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir /media/sf_oracle/27010930/26925218
vi /tmp/patch_list_dbhome.txt
# cat /tmp/patch_list_dbhome.txt
$DB_HOME/OPatch/opatch prereq CheckSystemSpace -phBaseFile /tmp/patch_list_dbhome.txt

SELECT name, open_mode FROM v$pdbs;
ALTER PLUGGABLE DATABASE ALL OPEN;
SELECT name, open_mode FROM v$pdbs;

opatchauto apply /media/sf_oracle/27010930

export ORACLE_SID=-MGMTDB
sqlplus / as sysdba

SELECT instance_name FROM v$instance;
SELECT name, open_mode FROM v$pdbs;

cd $ORACLE_HOME/OPatch
datapatch -verbose

SELECT patch_id, version, action, status, action_time FROM dba_registry_sqlpatch;

SELECT name, open_mode FROM v$pdbs;
ALTER PLUGGABLE DATABASE ALL OPEN;
SELECT name, open_mode FROM v$pdbs;

cd $ORACLE_HOME/OPatch
datapatch -verbose

SELECT patch_id, version, action, status, action_time FROM dba_registry_sqlpatch;