●12.1.0.2にはASMFDにバグがあるので、Database Proactive Bundle Patchを適用したいが、
OPatchのバージョンを上げないとパッチを適用できないようなので、
OPatchのバージョンを上げる。
su -
. /home/grid/.bash_profile
cd /u01/app/grid/product/12.1.0/grid/
mv OPatch bk_OPatch
unzip /media/sf_fornewpc64/for_rac12c/opatch_12.2.0.1.9/p6880880_122010_Linux-x86-64.zip
chmod 755 OPatch
chown -R grid. OPatch/
su - grid
opatch lsinventory
opatch version
●12.1.0.2にはASMFDにバグがあるので、Database Proactive Bundle Patchを適用
su -
. /home/grid/.bash_profile
cd /tmp
unzip /media/sf_fornewpc64/for_rac12c/12102_dbbp/p26022196_121020_Linux-x86-64.zip
chown -R grid. 26022196
↑必要
※/tmp/26022196はreadonlyだとうまくいかないのかも、もしくはこの前にマシン再起動が必要かも
export GI_HOME=$ORACLE_HOME
opatchauto apply /tmp/26022196 -oh $GI_HOME
echo $?
ここでバックアップした。
●OHASの構成（だと思う）
su -
/u01/app/grid/product/12.1.0/grid/perl/bin/perl -I /u01/app/grid/product/12.1.0/grid/perl/lib -I /u01/app/grid/product/12.1.0/grid/crs/install /u01/app/grid/product/12.1.0/grid/crs/install/roothas.pl
↑1行
echo $?
●ノードリスト更新？
su - grid
cd /u01/app/grid/product/12.1.0/grid/oui/bin
[grid@dbb01 bin]$ ./runInstaller -updateNodeList ORACLE_HOME=$ORACLE_HOME -defaultHomeName CLUSTER_NODES= CRS=TRUE
Starting Oracle Universal Installer...
Checking swap space: must be greater than 500 MB. Actual 5119 MB Passed
The inventory pointer is located at /etc/oraInst.loc
'UpdateNodeList' was successful.
[root@dbb01 ~]# su - grid
最終ログイン: 2017/08/01 (火) 21:05:47 JST
[grid@dbb01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE dbb01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.evmd
1 ONLINE ONLINE dbb01 STABLE
--------------------------------------------------------------------------------
●OHASの停止
[grid@dbb01 dbs]$ crsctl stop has
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 'dbb01'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'dbb01'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'dbb01' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'dbb01'
CRS-2677: Stop of 'ora.evmd' on 'dbb01' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 'dbb01' has completed
CRS-4133: Oracle High Availability Services has been stopped.
●ASMFDの構成
su -
. /home/grid/.bash_profile
[root@dbb01 ~]# asmcmd afd_configure
Connected to an idle instance.
AFD-627: AFD distribution files found.
AFD-636: Installing requested AFD software.
AFD-637: Loading installed AFD drivers.
AFD-9321: Creating udev for AFD.
AFD-9323: Creating module dependencies - this may take some time.
AFD-9154: Loading 'oracleafd.ko' driver.
AFD-649: Verifying AFD devices.
AFD-9156: Detecting control device '/dev/oracleafd/admin'.
AFD-638: AFD installation correctness verified.
Modifying resource dependencies - this may take some time.
[root@dbb01 ~]# echo $?
0
●ASMFDの状態表示
[root@dbb01 ~]# asmcmd afd_state
Connected to an idle instance.
ASMCMD-9526: The AFD state is 'LOADED' and filtering is 'DISABLED' on host 'dbb01.dbbdomain'
●OHASの起動
su - grid
[grid@dbb01 dbs]$ crsctl start has
[grid@dbb01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.ons
OFFLINE OFFLINE dbb01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 OFFLINE OFFLINE STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE dbb01 STABLE
ora.evmd
1 ONLINE ONLINE dbb01 STABLE
--------------------------------------------------------------------------------
●diskstring設定
[grid@dbb01 ~]$ asmcmd afd_dsset '/dev/sd*'
Connected to an idle instance.
[grid@dbb01 ~]$ asmcmd afd_dsget
Connected to an idle instance.
AFD discovery string: /dev/sd*
↓rootで実行してもいいらしい。
[grid@dbb01 dbs]$ asmcmd afd_label DG_001 /dev/sdb1
Connected to an idle instance.
[grid@dbb01 dbs]$ asmcmd afd_label DG_002 /dev/sdc1
Connected to an idle instance.
[grid@dbb01 dbs]$ asmcmd afd_scan
Connected to an idle instance.
●指定されたディスク・パスでOracle ASMフィルタ・ドライバ・フィルタリング・モードを設定する
[grid@dbb01 dbs]$ asmcmd afd_filter -e /dev/sdb1
Connected to an idle instance.
[grid@dbb01 dbs]$ asmcmd afd_filter -e /dev/sdc1
Connected to an idle instance.
[grid@dbb01 dbs]$ asmcmd afd_lsdsk
Connected to an idle instance.
--------------------------------------------------------------------------------
Label Filtering Path
================================================================================
DG_001 ENABLED /dev/sdb1
DG_002 ENABLED /dev/sdc1