Oracle Template by Zabbix agent 2

[studero]

Hi all,

Steps to reproduce:

1. Add Template Oracle Agent 2 to the client
2. Set user, password, connection

Result:

After apply, I have the following message into the log file on the Zabbix server.

284267:20240925:134102.254 item "svx-ora-16e - co11916e oracle.tbs_max_bytes["HBI1","ACTIVITI"]" became not supported: Preprocessing failed for:
284267:20240925:134105.249 item "svx-ora-16e - co11916e oracle.tbs_max_bytes["HBI1","UNIFR_LIFE"]" became not supported: Preprocessing failed for:
284267:20240925:134918.505 item "svx-ora-16e - co11916e oracle.tbs_max_bytes["HBI1","FAC_APPS"]" became not supported: Preprocessing failed for:
284267:20240925:134921.254 item "svx-ora-16e - co11916e oracle.tbs_max_bytes["HBI1","FAC_PLA"]" became not supported: Preprocessing failed for:
284267:20240925:134927.255 item "svx-ora-16e - co11916e oracle.tbs_max_bytes["HBI1","FAC_APPS_HISTO"]" became not supported: Preprocessing failed for:


And this following error message on the web console:


Preprocessing failed for:
1. Failed: cannot extract value from json by path "$..['FAC_APPS'].status.first()": invalid object format, expected opening character '{' or '[' at: ''

I need help

Regards

Olivier

[mfortes]

Do u apply every privilege necessary on this orac user?

[studero]

Do u apply every privilege necessary on this orac user?

Normally yes, as following:
CREATE USER ZABBIX
IDENTIFIED BY <password>
HTTP DIGEST DISABLE
DEFAULT TABLESPACE USERS
TEMPORARY TABLESPACE TEMP
PROFILE DBA
ACCOUNT UNLOCK;

-- 1 Role for ZABBIX
GRANT CONNECT TO ZABBIX CONTAINER=ALL;
ALTER USER ZABBIX DEFAULT ROLE ALL;

-- 11 System Privileges for ZABBIX
GRANT CREATE SESSION TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY CUBE TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY CUBE BUILD PROCESS TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY CUBE DIMENSION TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY DICTIONARY TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY MEASURE FOLDER TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY MINING MODEL TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY SEQUENCE TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY TABLE TO ZABBIX CONTAINER=ALL;
GRANT SELECT ANY TRANSACTION TO ZABBIX CONTAINER=ALL;
GRANT SET CONTAINER TO ZABBIX CONTAINER=ALL;

-- 25 Object Privileges for ZABBIX
GRANT SELECT ON SYS.DBA_DATA_FILES TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.DBA_FREE_SPACE TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.DBA_SCHEDULER_JOB_LOG TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.DBA_TABLESPACES TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.DBA_TABLESPACE_USAGE_METRICS TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.DBA_TEMP_FILES TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.DBA_USERS TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.GV_$SORT_SEGMENT TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$ACTIVE_SESSION_HISTORY TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$ARCHIVE_DEST TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$ASM_DISKGROUP TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$DATABASE TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$DATAFILE TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$INSTANCE TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$LOG TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$OSSTAT TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$PARAMETER TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$PGASTAT TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$PROCESS TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$RECOVERY_FILE_DEST TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$RESTORE_POINT TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SESSION TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SGASTAT TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SYSMETRIC TO ZABBIX CONTAINER=ALL;
GRANT SELECT ON SYS.V_$SYSTEM_PARAMETER TO ZABBIX CONTAINER=ALL;

-- 1 Container Data Restriction for ZABBIX
ALTER USER ZABBIX
SET CONTAINER_DATA = ALL
CONTAINER = CURRENT;