Oracle Grid Infrastructure Tips - Cronologia

WikiSysop il 08:18, 22 set 2017

2017-09-22T08:18:45Z

← Versione meno recente		Versione delle 08:18, 22 set 2017
Riga 88:		Riga 88:

	[[Categoria: Database]]		[[Categoria: Database]]
			[[Categoria:Oracle]]

WikiSysop: /* Gestire applicazione generica */

2016-10-18T11:43:33Z

Gestire applicazione generica

← Versione meno recente		Versione delle 11:43, 18 ott 2016
Riga 33:		Riga 33:

	crsctl modify resource "app.LISTENER_${SID}.lsnr" -attr "AUTO_START=1"		crsctl modify resource "app.LISTENER_${SID}.lsnr" -attr "AUTO_START=1"

			crsctl setperm resource app.LISTENER_${SID}.lsnr -u user:root:r-x,user:oracle:r-x

			Per visualizzare la configurazione:

			crsctl status resource app.LISTENER_${SID}.lsnr -f


	3) creare risorsa listener (con home rdbms)		3) creare risorsa listener (con home rdbms)

WikiSysop: /* Gestire applicazione generica */

2016-10-18T11:42:40Z

Gestire applicazione generica

← Versione meno recente		Versione delle 11:42, 18 ott 2016
Riga 31:		Riga 31:
	START_DEPENDENCIES='pullup(app.database-${sid}.vip,app.DATABASE_${sid}.db) hard(app.database-${sid}.vip,app.DATABASE_${sid}.db)',		START_DEPENDENCIES='pullup(app.database-${sid}.vip,app.DATABASE_${sid}.db) hard(app.database-${sid}.vip,app.DATABASE_${sid}.db)',
	STOP_DEPENDENCIES='hard(shutdown:app.database-${sid}.vip,app.DATABASE_${sid}.db)'"		STOP_DEPENDENCIES='hard(shutdown:app.database-${sid}.vip,app.DATABASE_${sid}.db)'"

			crsctl modify resource "app.LISTENER_${SID}.lsnr" -attr "AUTO_START=1"

	3) creare risorsa listener (con home rdbms)		3) creare risorsa listener (con home rdbms)

WikiSysop: /* Gestire applicazione generica */

2016-10-18T11:41:28Z

Gestire applicazione generica

← Versione meno recente		Versione delle 11:41, 18 ott 2016
Riga 10:		Riga 10:
	===Gestire applicazione generica===		===Gestire applicazione generica===
	1) creare un indirizzo IP Virtuale:		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 ~]# 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 start res app.miaapp01.vip
	[root@server ~]# crsctl modify resource "app.miaapp01.vip" -attr "AUTO_START=1"		[root@server ~]# crsctl modify resource "app.miaapp01.vip" -attr "AUTO_START=1"
	[root@server ~]# crsctl modify resource app.miaapp01.vip -attr "ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x'"		[root@server ~]# crsctl modify resource app.miaapp01.vip -attr "ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x'"

	2) creare risorsa listener (con home grid)		2) creare risorsa listener (con home grid)

	[root@server ~]#
			[grid@server ~]$ crsctl add resource app.LISTENER_${SID}.lsnr -type generic_application -attr \
			"ACTION_SCRIPT='%CRS_HOME%/crs/public/act_listener_${sid}.sh',
			START_PROGRAM='%CRS_HOME%/crs/public/act_listener_${sid}.sh start',
			STOP_PROGRAM='%CRS_HOME%/crs/public/act_listener_${sid}.sh stop',
			CLEAN_PROGRAM='%CRS_HOME%/crs/public/act_listener_${sid}.sh clean',
			CHECK_PROGRAMS='%CRS_HOME%/crs/public/act_listener_${sid}.sh check',
			ENVIRONMENT_VARS='_USR_ORA_HOME=/app/grid/product/12.1.0/grid,_USR_ORA_LSNR=LISTENER_${SID}',
			PLACEMENT=restricted,
			HOSTING_MEMBERS='node1 node2',
			CHECK_INTERVAL=30,
			RESTART_ATTEMPTS=2,
			START_DEPENDENCIES='pullup(app.database-${sid}.vip,app.DATABASE_${sid}.db) hard(app.database-${sid}.vip,app.DATABASE_${sid}.db)',
			STOP_DEPENDENCIES='hard(shutdown:app.database-${sid}.vip,app.DATABASE_${sid}.db)'"

	3) creare risorsa listener (con home rdbms)		3) creare risorsa listener (con home rdbms)

WikiSysop: /* Gestire applicazione generica */

2016-10-18T11:38:10Z

Gestire applicazione generica

← Versione meno recente		Versione delle 11:38, 18 ott 2016
Riga 34:		Riga 34:
	RESTART_ATTEMPTS=2,		RESTART_ATTEMPTS=2,
	AUTO_START=1"		AUTO_START=1"

			impostare poi le dipendenze:

			crsctl modify resource app.DATABASE_${sid}.db -attr "START_DEPENDENCIES=pullup(app.database-${sid}.vip) hard(app.database-${sid}.vip)"
			crsctl modify resource app.DATABASE_${sid}.db -attr "STOP_DEPENDENCIES=hard(app.database-${sid}.vip)"

	===Oracle ASM Cluster Filesystem===		===Oracle ASM Cluster Filesystem===

WikiSysop: /* Gestire applicazione generica */

2016-10-18T11:35:28Z

Gestire applicazione generica

← Versione meno recente		Versione delle 11:35, 18 ott 2016
Riga 13:		Riga 13:
	[root@server ~]# crsctl start res app.miaapp01.vip		[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.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'"		[root@server ~]# crsctl modify resource app.miaapp01.vip -attr "ACL='owner:root:rwx,pgrp:root:r-x,other::r--,group:oinstall:r-x,user:grid:r-x'"
	2) creare risorsa listener (con home grid)		2) creare risorsa listener (con home grid)
	[root@server ~]#		[root@server ~]#

WikiSysop: /* Gestire applicazione generica */

2016-10-18T11:33:43Z

Gestire applicazione generica

← Versione meno recente		Versione delle 11:33, 18 ott 2016
Riga 21:		Riga 21:
	4) crea risorsa database		4) crea risorsa database

	crsctl add resource app.DATABASE_${sid}.db -type generic_application -attr \		[oracle@server ~]$ crsctl add resource app.DATABASE_${sid}.db -type generic_application -attr \
	"ACTION_SCRIPT='%CRS_HOME%/crs/public/act_database_${sid}.sh',		"ACTION_SCRIPT='%CRS_HOME%/crs/public/act_database_${sid}.sh',
	START_PROGRAM='%CRS_HOME%/crs/public/act_database_${sid}.sh start',		START_PROGRAM='%CRS_HOME%/crs/public/act_database_${sid}.sh start',

WikiSysop: /* Gestire applicazione generica */

2016-10-18T11:33:02Z

Gestire applicazione generica

@@ Riga 14: / Riga 14: @@
  [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'"
-) creare risorsa
+) creare risorsa listener (con home grid)
  [root@server ~]#
 ===Oracle ASM Cluster Filesystem===

WikiSysop: /* Oracle ASM Cluster Filesystem */

2016-05-16T21:44:58Z

Oracle ASM Cluster Filesystem

← Versione meno recente		Versione delle 21:44, 16 mag 2016
Riga 38:		Riga 38:

	Per creare volumi più grandi di 4Gb:		Per creare volumi più grandi di 4Gb:
	echo "alter diskgroup datap set ATTRIBUTE 'compatible.advm' = '11.2.0.4.0';" \| sqlplus '/ as sysasm'		grid@server:~$ echo "alter diskgroup datap set ATTRIBUTE 'compatible.advm' = '11.2.0.4.0';" \| sqlplus '/ as sysasm'

	[[Categoria: Database]]		[[Categoria: Database]]

WikiSysop: /* Oracle ASM Cluster Filesystem */

2016-05-16T20:12:04Z

Oracle ASM Cluster Filesystem

← Versione meno recente		Versione delle 20:12, 16 mag 2016
Riga 37:		Riga 37:
	grid@server:~$ acfsutil size +1024M /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'

	[[Categoria: Database]]		[[Categoria: Database]]