Orabbix - Revision history

Admin: Reverted edits by Admin (talk) to last revision by Jason

2025-10-14T09:55:30Z

Reverted edits by Admin (talk) to last revision by Jason

2015-10-19T07:57:40Z

2014-01-06T07:16:07Z

‎How to Use Orabbix/FAQ

2014-01-06T07:15:49Z

‎How to Use Orabbix/FAQ

2013-07-08T10:13:00Z

2013-07-08T09:32:29Z

2012-02-16T14:51:35Z

‎Steps for Installation

2012-02-16T14:50:54Z

‎Steps for Installation

2011-10-28T14:15:54Z

‎How to Use Orabbix/FAQ

2011-10-28T14:15:43Z

‎How to Use Orabbix/FAQ

@@ Line 3: / Line 3: @@
 =Authors=
 ''Andrea Dalle Vacche'' <br>
 =Download & Installation Instructions=

@@ Line 411: / Line 411: @@
 If you have two host RAC1 and RAC2 and one instance RACINST<br>
 you should write the connection string as follow:<br>
-   RACINST.Url=jdbcoracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC1.EXAMPLE.COM) \
+   RACINST.Url=jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC1.EXAMPLE.COM) \
    (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2.EXAMPLE.COM)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=RACINST)))

@@ Line 411: / Line 411: @@
 If you have two host RAC1 and RAC2 and one instance RACINST<br>
 you should write the connection string as follow:<br>
-   RACINST.Url=jdbcracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC1.EXAMPLE.COM) \
+   RACINST.Url=jdbcoracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=RAC1.EXAMPLE.COM) \
    (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=RAC2.EXAMPLE.COM)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=RACINST)))

@@ Line 1: / Line 1: @@
-=''ORABBIX''=
+=ORABBIX=
 [[File:orabbix_logo.png]]
-=''Authors''=
+=Authors=
 ''Andrea Dalle Vacche'' <br>
 ''Jason Chatfield''
-=''Download & Installation Instructions''=
+=Download & Installation Instructions=
-=''About Orabbix''=
+=About Orabbix=
 ==Product Description==
 Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics.<br>
@@ Line 14: / Line 14: @@
 [[Image:Orabbix_architecture.png|frame|none|alt=Orabbix Architecture|Fig. 1 - Orabbix Architecture]]
-==''What can it monitor?''==
+==What can it monitor?==
 Below are some examples of what Orabbix is capable of monitoring:
 * DB Version (i.e. Validity of package)<br>

@@ Line 1: / Line 1: @@
-='''ORABBIX'''=
+=''ORABBIX''=
 [[File:orabbix_logo.png]]
-='''Authors'''=
+=''Authors''=
 ''Andrea Dalle Vacche'' <br>
 ''Jason Chatfield''
-='''Download & Installation Instructions'''=
+=''Download & Installation Instructions''=
-='''About Orabbix'''=
+=''About Orabbix''=
 ==Product Description==
 Orabbix is a plugin designed to work with Zabbix Enterprise Monitor to provide multi-tiered monitoring, performance and availability reporting and measurement for Oracle Databases, along with server performance metrics.<br>
@@ Line 14: / Line 14: @@
 [[Image:Orabbix_architecture.png|frame|none|alt=Orabbix Architecture|Fig. 1 - Orabbix Architecture]]
-=='''What can it monitor?'''==
+==''What can it monitor?''==
 Below are some examples of what Orabbix is capable of monitoring:
 * DB Version (i.e. Validity of package)<br>
@@ Line 43: / Line 43: @@
 ==Orabbix Author==
-'''Andrea Dalle Vacche:''' http://www.smartmarmot.com
+''Andrea Dalle Vacche:'' http://www.smartmarmot.com
 =History=

← Older revision		Revision as of 14:51, 16 February 2012
Line 114:		Line 114:


−	* '''NOTE''' if you need an User (ZABBIX) for Orabbix with the minimum grants available~~. You~~ can use the following script:	+	* '''NOTE''' if you need an User (ZABBIX) for Orabbix with the minimum grants available, you can use the following script:

	CREATE USER ZABBIX		CREATE USER ZABBIX

← Older revision		Revision as of 14:50, 16 February 2012
Line 112:		Line 112:
	GRANT UNLIMITED TABLESPACE TO ZABBIX;		GRANT UNLIMITED TABLESPACE TO ZABBIX;
	GRANT SELECT ANY DICTIONARY TO ZABBIX;		GRANT SELECT ANY DICTIONARY TO ZABBIX;
		+
		+
		+	* '''NOTE''' if you need an User (ZABBIX) for Orabbix with the minimum grants available. You can use the following script:
		+
		+	CREATE USER ZABBIX
		+	IDENTIFIED BY <REPLACE WITH PASSWORD>
		+	DEFAULT TABLESPACE USERS
		+	TEMPORARY TABLESPACE TEMP
		+	PROFILE DEFAULT
		+	ACCOUNT UNLOCK;
		+	GRANT ALTER SESSION TO ZABBIX;
		+	GRANT CREATE SESSION TO ZABBIX;
		+	GRANT CONNECT TO ZABBIX;
		+	ALTER USER ZABBIX DEFAULT ROLE ALL;
		+	GRANT SELECT ON V_$INSTANCE TO ZABBIX;
		+	GRANT SELECT ON DBA_USERS TO ZABBIX;
		+	GRANT SELECT ON V_$LOG_HISTORY TO ZABBIX;
		+	GRANT SELECT ON V_$PARAMETER TO ZABBIX;
		+	GRANT SELECT ON SYS.DBA_AUDIT_SESSION TO ZABBIX;
		+	GRANT SELECT ON V_$LOCK TO ZABBIX;
		+	GRANT SELECT ON DBA_REGISTRY TO ZABBIX;
		+	GRANT SELECT ON V_$LIBRARYCACHE TO ZABBIX;
		+	GRANT SELECT ON V_$SYSSTAT TO ZABBIX;
		+	GRANT SELECT ON V_$PARAMETER TO ZABBIX;
		+	GRANT SELECT ON V_$LATCH TO ZABBIX;
		+	GRANT SELECT ON V_$PGASTAT TO ZABBIX;
		+	GRANT SELECT ON V_$SGASTAT TO ZABBIX;
		+	GRANT SELECT ON V_$LIBRARYCACHE TO ZABBIX;
		+	GRANT SELECT ON V_$PROCESS TO ZABBIX;
		+	GRANT SELECT ON DBA_DATA_FILES TO ZABBIX;
		+	GRANT SELECT ON DBA_TEMP_FILES TO ZABBIX;
		+	GRANT SELECT ON DBA_FREE_SPACE TO ZABBIX;
		+	GRANT SELECT ON V_$SYSTEM_EVENT TO ZABBIX;