cd $ORACLE_HOME/dbs
vi init+ASM.ora
*.asm_diskgroups='DG_001'
*.asm_diskstring='AFD:*'
*.asm_power_limit=1
*.diagnostic_dest='/var/log/oracle'
*.instance_type='asm'
*.large_pool_size=12M
*.remote_login_passwordfile='EXCLUSIVE'
su -
mkdir /var/log/oracle
chmod 775 /var/log/oracle
chown oracle. /var/log/oracle
●cssdを自動起動にする（しなくてもいつのまにか自動起動になる）
●リソース起動
[grid@dbb01 dbs]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE dbb01 STABLE
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
--------------------------------------------------------------------------------
[grid@dbb01 dbs]$ crsctl start resource -all
CRS-5702: Resource 'ora.LISTENER.lsnr' is already running on 'dbb01'
CRS-5702: Resource 'ora.driver.afd' is already running on 'dbb01'
CRS-5702: Resource 'ora.evmd' is already running on 'dbb01'
CRS-2501: Resource 'ora.ons' is disabled
CRS-2672: Attempting to start 'ora.cssd' on 'dbb01'
CRS-2672: Attempting to start 'ora.diskmon' on 'dbb01'
CRS-2676: Start of 'ora.diskmon' on 'dbb01' succeeded
CRS-2676: Start of 'ora.cssd' on 'dbb01' succeeded
CRS-4000: Command Start failed, or completed with errors.
[grid@dbb01 dbs]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE dbb01 STABLE
ora.ons
OFFLINE OFFLINE dbb01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE dbb01 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE dbb01 STABLE
ora.evmd
1 ONLINE ONLINE dbb01 STABLE
--------------------------------------------------------------------------------
この辺り、順序がなぞ。
●ASMを追加
[grid@dbb01 ~]$ srvctl add asm -l LISTENER -d 'AFD:*' -p '/u01/app/grid/product/12.1.0/grid/dbs/spfile+ASM.ora'
[grid@dbb01 ~]$ srvctl config asm
ASM home: <CRS home>
Password file:
ASM listener: LISTENER
Spfile: /u01/app/grid/product/12.1
ASM diskgroup discovery string: AFD:*
●アイドルインスタンスに接続
[grid@dbb01 dbs]$ sqlplus / as sysasm
SQL*Plus: Release 12.1.0.2.0 Production on 土 8月 5 02:47:47 2017
Copyright (c) 1982, 2014, Oracle. All rights reserved.
アイドル・インスタンスに接続しました。
SQL> startup nomount
ASMインスタンスが起動されました
Total System Global Area 1140850688 bytes
Fixed Size 2933400 bytes
Variable Size 1112751464 bytes
ASM Cache 25165824 bytes
SQL>
●SPFILE作成
SQL> create spfile='/u01/app/grid/product/12.1.0/grid/dbs/spfile+ASM.ora' from pfile;
ファイルが作成されました。
SQL>quit
●ディスクグループ作成
[grid@dbb01 ~]$ sqlplus / as sysasm
アイドル・インスタンスに接続しました。
SQL> startup nomount
ASMインスタンスが起動されました
Total System Global Area 1140850688 bytes
Fixed Size 2933400 bytes
Variable Size 1112751464 bytes
ASM Cache 25165824 bytes
SQL> select * from v$asm_diskgroup;
no rows selected
SQL> create diskgroup DG_001 external redundancy disk 'AFD:DG_001' attribute 'au_size'='4M','compatible.asm' = '12.1.0.2','COMPATIBLE.RDBMS' = '12.1.0.2';
Diskgroup created.
SQL> create diskgroup DG_002 external redundancy disk 'AFD:DG_002' attribute 'au_size'='4M','compatible.asm' = '12.1.0.2','COMPATIBLE.RDBMS' = '12.1.0.2';
Diskgroup created.
SQL> select * from v$asm_diskgroup;
SQL> col COMPATIBILITY format a10
SQL> col DATABASE_COMPATIBILITY format a10
SQL> col NAME format a10
SQL> set linesize 1000
SQL> select GROUP_NUMBER,NAME,SECTOR_SIZE,BLOCK_SIZE,ALLOCATION_UNIT_SIZE,TOTAL_MB,COMPATIBILITY,DATABASE_COMPATIBILITY from v$asm_diskgroup;
GROUP_NUMBER NAME SECTOR_SIZE BLOCK_SIZE ALLOCATION_UNIT_SIZE TOTAL_MB COMPATIBIL DATABASE_C
------------ ---------- ----------- ---------- -------------------- ---------- ---------- ----------
2 DG_002 512 4096 4194304 5116 10.1.0.0.0 10.1.0.0.0
1 DG_001 512 4096 4194304 20476 10.1.0.0.0 10.1.0.0.0
[grid@dbb01 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DG_001.dg
ONLINE ONLINE dbb01 STABLE
ora.DG_002.dg
ONLINE ONLINE dbb01 STABLE
ora.LISTENER.lsnr
ONLINE ONLINE dbb01 STABLE
ora.asm
ONLINE ONLINE dbb01 STABLE
ora.ons
ONLINE ONLINE dbb01 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
1 ONLINE ONLINE dbb01 STABLE
ora.diskmon
1 OFFLINE OFFLINE STABLE
ora.driver.afd
1 ONLINE ONLINE dbb01 STABLE
ora.evmd
1 ONLINE ONLINE dbb01 STABLE
--------------------------------------------------------------------------------
[grid@dbb01 ~]$ srvctl config listener -l LISTENER
Name: LISTENER
Type: Database Listener
Home: /u01/app/grid/product/12.1.0/grid
End points: TCP:1521
Listener is enabled.
[grid@dbb01 ~]$ srvctl config asm -a
ASM home: <CRS home>
Password file:
ASM listener: LISTENER
Spfile: /u01/app/grid/product/12.1.0/grid/dbs/spfile+ASM.ora
ASM diskgroup discovery string: AFD:*
ASM is enabled.
ASM is individually enabled on nodes:
ASM is individually disabled on nodes:
●ONSの自動再起動設定
srvctl enable ons
●cluvfy
su - grid
[grid@dbb01 ~]$ cluvfy stage -pre hacfg
●リスナーのADR設定
cd /u01/app/grid/product/12.1.0/grid/network/admin/
vi listener.ora
ADR_BASE_LISTENER=/var/log/oracle
DIAG_ADR_ENABLED_LISTENER=on
#下の設定をする意味はdoc_id 1599387.1?
#DIAG_ADR_ENABLED_LISTENER=off
#LOG_DIRECTORY_LISTENER=/var/log/oracle/diag/tnslsnr/dbb01/listener/trace
#LOG_FILE_LISTENER=listener.log
#TRACE_DIRECTORY_LISTENER=/var/log/oracle/diag/tnslsnr/dbb01/listener/trace
#TRACE_FILE_LISTENER=listener.trc
#TRACE_FILELEN_LISTENER=10240
#TRACE_FILENO_LISTENER=3
vi sqlnet.ora
TCP.CONNECT_TIMEOUT=0
●リスナー再起動（reloadではだめでした）
lsnrctl stop LISTENER
lsnrctl start LISTENER
#mkdir -p /var/log/oracle/diag/tnslsnr/dbb01/listener/trace
lsnrctl show log_directory
lsnrctl show log_file
lsnrctl show trc_directory
lsnrctl show trc_file
tail /var/log/oracle/diag/tnslsnr/dbb01/listener/trace/listener.log