Configure Software Only installed GI - denis-kol4ev/OraDBA GitHub Wiki

For Grid Infrastructure 12.1 and 12.2

How to use ASMCA in silent mode to configure ASM for a stand-alone server (Doc ID 1068788.1)

Configure Grid Infrastructure install for a stand-alone server by running roothas.pl

As root user :

/opt/oracle/grid12c/perl/bin/perl -I /opt/oracle/grid12c/perl/lib -I /opt/oracle/grid12c/crs/install /opt/oracle/grid12c/crs/install/roothas.pl

As oracle user (Grid Infrastructure owner) :

/opt/oracle/grid/12.1.0/bin/asmca -silent -configureASM -sysAsmPassword xxx -asmsnmpPassword xxx -diskString '/dev/oracleasm/disks/*' -diskGroupName DATA -diskList '/dev/oracleasm/disks/DATA01' -redundancy EXTERNAL -diskGroupName FRA -diskList '/dev/oracleasm/disks/FRA01' -redundancy EXTERNAL

/opt/oracle/grid12c/12.2.0.1/bin/asmca -silent -configureASM -sysAsmPassword xxx -asmsnmpPassword xxx -diskString '/dev/oracleasm/disks/*' -diskGroupName DATA -diskList '/dev/oracleasm/disks/DATA01','/dev/oracleasm/disks/DATA02','/dev/oracleasm/disks/DATA03' -redundancy EXTERNAL -diskGroupName FRA -diskList '/dev/oracleasm/disks/FRA01','/dev/oracleasm/disks/FRA02' -redundancy EXTERNAL

For Grid Infrastructure 19.3

As root user :

/opt/oracle/grid/19c/19.3.0.0.0/perl/bin/perl -I/opt/oracle/grid/19c/19.3.0.0.0/perl/lib -I/opt/oracle/grid/19c/19.3.0.0.0/crs/install /opt/oracle/grid/19c/19.3.0.0.0/crs/install/roothas.pl

As oracle user (Grid Infrastructure owner) :

Syntax with simultaneous creation of two or more groups fall with error below on 19.3 and 19.7, but the same syntax work correctly on 12.1 and 12.2

/opt/oracle/grid/19c/19.3.0.0.0/bin/asmca -silent -configureASM -sysAsmPassword xxx -asmsnmpPassword xxx -diskString '/dev/oracleasm/disks/*' -diskGroupName DATA -diskList '/dev/oracleasm/disks/DATA1' -redundancy EXTERNAL -diskGroupName FRA -diskList '/dev/oracleasm/disks/FRA1' -redundancy EXTERNAL

[FATAL] [DBT-30073] Disk groups should be specified

Workaround: configure ASM with single group, after that create additional groups if required.

/opt/oracle/grid/19c/19.3.0.0.0/bin/asmca -silent -configureASM -sysAsmPassword xxx -asmsnmpPassword xxx -diskString '/dev/oracleasm/disks/*' -diskGroupName DATA -diskList '/dev/oracleasm/disks/DATA01','/dev/oracleasm/disks/DATA02','/dev/oracleasm/disks/DATA03' -redundancy EXTERNAL 

SQL> 

create diskgroup REDO external redundancy disk '/dev/oracleasm/disks/REDO01';
create diskgroup FRA external redundancy disk '/dev/oracleasm/disks/FRA01';

If you want specify failuregroups

/opt/grid19c/19.0.0.0/bin/asmca -silent -configureASM -sysAsmPassword xxx -asmsnmpPassword xxx -diskString '/dev/oracleasm/disks/*' -diskGroupName DATA -disk '/dev/oracleasm/disks/DATA01' -diskName DATA01 -failuregroup FG0 -disk '/dev/oracleasm/disks/DATA06' -diskName DATA06 -failuregroup FG1  -redundancy NORMAL

SQL> 
create diskgroup FRA normal redundancy failgroup FG0 disk '/dev/oracleasm/disks/FRA01' name FRA01 failgroup FG1 disk '/dev/oracleasm/disks/FRA02' name FRA02;
alter diskgroup FRA add failgroup FG2 disk '/dev/oracleasm/disks/FRA03' name FRA03 failgroup FG3 disk '/dev/oracleasm/disks/FRA04' name FRA04;

Reducing the number of ASM audit files

. oraenv
crsctl status resource ora.asm -p | egrep "^CHECK_INTERVAL"
CHECK_INTERVAL=1 

crsctl modify resource ora.asm -init -attr CHECK_INTERVAL=120

crsctl status resource ora.asm -p | egrep "^CHECK_INTERVAL"
CHECK_INTERVAL=120

Update compatible.asm and compatible.rdbms parameters

Обновляем параметры compatible.asm и compatible.rdbms чтобы увеличить лимит создаваемых файлов.

В дальнейшем это поможет избежать ошибок вида

ORA-01237: cannot extend datafile 7
ORA-01110: data file 7: '+DATA/arcedi/arc_edi_data.dbf'
ORA-17505: ksfdrsz:1 Failed to resize file to size 2147614720 blocks
ORA-15095: reached maximum ASM file size (16384 GB) for this disk group

https://docs.oracle.com/en/database/oracle/oracle-database/19/ostmg/diskgroup-compatibility.html#GUID-AE540604-92D9-4CFE-A40E-BF4486163772

Table 4-5 Maximum Oracle ASM file sizes for disk groups with AU_SIZE set to 1 MB

. oraenv <<<+ASM
sqlplus / as sysasm

set linesize 100
set pagesize 999
col disk_group format a10
col attribute format a20
col value format a20

select d.NAME as disk_group, a.NAME as attribute, a.VALUE
  from v$asm_diskgroup d, v$asm_attribute a
 where d.GROUP_NUMBER = a.GROUP_NUMBER
   and a.NAME like 'compatible%';

alter diskgroup DATA set attribute 'compatible.asm'='19.0.0.0.0';
alter diskgroup DATA set attribute 'compatible.rdbms'='12.1.0.0.0';

alter diskgroup FRA set attribute 'compatible.asm'='19.0.0.0.0';
alter diskgroup FRA set attribute 'compatible.rdbms'='12.1.0.0.0';

Повторно выполняем запрос, убеждаемся что параметры обновлены.

Так же запись об успешном изменении параметров должна присутствовать в логе ASM.