http://www.emigar.com/wiki/api.php?action=feedcontributions&feedformat=atom&user=Ernesto 2026-05-06T11:06:19Z Contributi dell'utente MediaWiki 1.39.0 http://www.emigar.com/wiki/index.php?title=Oracle_Grid_Infrastructure_Tips&diff=5307 2015-11-16T16:52:47Z

<p>Ernesto: /* Oracle Listener aggiuntivi */</p> <hr /> <div>==Grid Infratructure 12c==<br /> <br /> ===Oracle Listener aggiuntivi===<br /> <br /> come grid:<br /> cp -p $ORACLE_HOME/crs/demo/coldfailover/act_listener.pl $ORACLE_HOME/crs/public/<br /> <br /> crsctl<br /> <br /> ===Gestire applicazione generica===<br /> 1) creare un indirizzo IP Virtuale:<br /> [root@server ~]# appvipcfg create -network=1 -ip=172.16.1.4 -vipname=app.miaapp01.vip -user root<br /> [root@server ~]# crsctl start res app.miaapp01.vip<br /> [root@server ~]# crsctl modify resource &quot;app.miaapp01.vip&quot; -attr &quot;AUTO_START=1&quot;<br /> [root@server ~]# crsctl modify resource app.n1bpel-p05a.vip -attr &quot;ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x'&quot;<br /> 2) creare risorsa<br /> [root@server ~]#<br /> <br /> ===Oracle ASM Cluster Filesystem===<br /> <br /> Per creare un cluster filesystem (testato con GI 12.1.0.2):<br /> grid@server:~$ echo 'ALTER DISKGROUP DATA ADD VOLUME MIOVOL01 SIZE 10G;' | sqlplus '/ as sysasm'<br /> <br /> in alternativa si può fare da asmcmd:<br /> grid@server:~$ asmcmd volcreate -G DATA -s 10G MIOVOL01<br /> <br /> Formattare il device:<br /> grid@server:~$ mkfs -t acfs -n &quot;MIOVOL01&quot; /dev/asm/miovol01-21<br /> <br /> Da utente root:<br /> root@server:~# srvctl add volume -volume MIOVOL01 -diskgroup DATA -device /dev/asm/miovol01-21<br /> root@server:~# /sbin/acfsutil registry -a -n node1,node2 /dev/asm/miovol01-21 /MIOVOL01<br /> root@server:~# /bin/mount -t acfs /dev/asm/miovol01-21 /MIOVOL01<br /> <br /> Per resize, da utente grid:<br /> grid@server:~$ acfsutil info fs /MIOVOL01<br /> grid@server:~$ acfsutil size +1024M /MIOVOL01<br /> <br /> <br /> [[Categoria: Database]]</div>

Ernesto http://www.emigar.com/wiki/index.php?title=Oracle_Grid_Infrastructure_Tips&diff=5306 2015-11-16T16:52:17Z

<p>Ernesto: /* Oracle Listener aggiuntivi */</p> <hr /> <div>==Grid Infratructure 12c==<br /> <br /> ===Oracle Listener aggiuntivi===<br /> <br /> come grid:<br /> cp -p $ORACLE_HOME/crs/demo/coldfailover/act_listener.pl $ORACLE_HOME/crs/public//<br /> <br /> crsctl<br /> <br /> ===Gestire applicazione generica===<br /> 1) creare un indirizzo IP Virtuale:<br /> [root@server ~]# appvipcfg create -network=1 -ip=172.16.1.4 -vipname=app.miaapp01.vip -user root<br /> [root@server ~]# crsctl start res app.miaapp01.vip<br /> [root@server ~]# crsctl modify resource &quot;app.miaapp01.vip&quot; -attr &quot;AUTO_START=1&quot;<br /> [root@server ~]# crsctl modify resource app.n1bpel-p05a.vip -attr &quot;ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x'&quot;<br /> 2) creare risorsa<br /> [root@server ~]#<br /> <br /> ===Oracle ASM Cluster Filesystem===<br /> <br /> Per creare un cluster filesystem (testato con GI 12.1.0.2):<br /> grid@server:~$ echo 'ALTER DISKGROUP DATA ADD VOLUME MIOVOL01 SIZE 10G;' | sqlplus '/ as sysasm'<br /> <br /> in alternativa si può fare da asmcmd:<br /> grid@server:~$ asmcmd volcreate -G DATA -s 10G MIOVOL01<br /> <br /> Formattare il device:<br /> grid@server:~$ mkfs -t acfs -n &quot;MIOVOL01&quot; /dev/asm/miovol01-21<br /> <br /> Da utente root:<br /> root@server:~# srvctl add volume -volume MIOVOL01 -diskgroup DATA -device /dev/asm/miovol01-21<br /> root@server:~# /sbin/acfsutil registry -a -n node1,node2 /dev/asm/miovol01-21 /MIOVOL01<br /> root@server:~# /bin/mount -t acfs /dev/asm/miovol01-21 /MIOVOL01<br /> <br /> Per resize, da utente grid:<br /> grid@server:~$ acfsutil info fs /MIOVOL01<br /> grid@server:~$ acfsutil size +1024M /MIOVOL01<br /> <br /> <br /> [[Categoria: Database]]</div>

Ernesto http://www.emigar.com/wiki/index.php?title=Utente:Ernesto&diff=5305 2015-11-16T16:50:50Z

<p>Ernesto: </p> <hr /> <div>aa<br /> bb</div>

Ernesto