Oracle Grid Infrastructure Tips

Grid Infratructure 12c

Oracle Listener aggiuntivi

come grid:

cp -p $ORACLE_HOME/crs/demo/coldfailover/act_listener.pl $ORACLE_HOME/crs/public/

crsctl

Gestire applicazione generica

1) creare un indirizzo IP Virtuale:

[root@server ~]# appvipcfg create -network=1 -ip=172.16.1.4 -vipname=app.miaapp01.vip -user root
[root@server ~]# crsctl start res app.miaapp01.vip
[root@server ~]# crsctl modify resource "app.miaapp01.vip" -attr "AUTO_START=1"
[root@server ~]# crsctl modify resource app.n1bpel-p05a.vip -attr "ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x'"

2) creare risorsa

[root@server ~]#

Oracle ASM Cluster Filesystem

Per creare un cluster filesystem (testato con GI 12.1.0.2):

grid@server:~$ echo 'ALTER DISKGROUP DATA ADD VOLUME MIOVOL01 SIZE 10G;' | sqlplus '/ as sysasm'

in alternativa si può fare da asmcmd:

grid@server:~$ asmcmd volcreate -G DATA -s 10G MIOVOL01

Formattare il device:

grid@server:~$ mkfs -t acfs -n "MIOVOL01" /dev/asm/miovol01-21

Da utente root:

root@server:~# srvctl add volume -volume MIOVOL01 -diskgroup DATA -device /dev/asm/miovol01-21
root@server:~# /sbin/acfsutil registry -a -n node1,node2 /dev/asm/miovol01-21 /MIOVOL01
root@server:~# /bin/mount -t acfs /dev/asm/miovol01-21 /MIOVOL01

Per resize, da utente grid (ma funziona anche da root):

grid@server:~$ acfsutil info fs /MIOVOL01
grid@server:~$ acfsutil size +1024M /MIOVOL01

Per creare volumi più grandi di 4Gb:

 echo "alter diskgroup datap set ATTRIBUTE 'compatible.advm' = '11.2.0.4.0';" | sqlplus '/ as sysasm'