Áú»¢¶Ä²©

????? ????? ODBC

????? ?????? ????? ????? ?? ?????? ??????? ????? ??????? ????? ODBC:

1. ??? ????? ????? ????? ODBC ????? ???? Áú»¢¶Ä²© ?? proxy.
2. ????? ????? ????? ??? (?? ?????? ???? ????? ?- ????? Áú»¢¶Ä²©, ????? ????? ???? ????? ?? ???? ?-.xml ?? ?????? ????? - ??? ?????? ???? ?????? ???? ??????).
3. ???? ?? ?????? ?? ?????? ????? ???? ??? ?????.
?? ????? ??????? ???? ?????? ????? ?????-???? (;) ??? ????? ????? ????? ???????? ????????, ??? ????? ODBC ??????. 4. ???? ?? ????? ?????? ?? ?????? ????? ?????? ???? Áú»¢¶Ä²© - ??? ?????? ?????? ?????/????? ??????.

|?????|?????? ????? ????|?????/????? ??????| |--------|----------------|---------------------- --| || {$MSSQL.DSN} - ?? ???? ??????? ?? ?????? (????? ????: <??? ?? ?-DSN ??? ???>)
{$MSSQL.PORT} - ????? ?-TCP ?? Microsoft SQL Server (????? ????: 1433)
{$MSSQL.USER}, {$MSSQL.PASSWORD} - ?????? ??????? ?? Microsoft SQL (????? ????: ?? ?????)|??? ????? Microsoft SQL ?????? ?????? ?????? ?? ??????? ?????: ??? ??? ???; ??? ?? ????? (??? Microsoft SQL ??????).

????? "??? ????? TCP ?? ??????" ????? ??????? ????? {HOST.CONN} ?-{$MSSQL.PORT} ??? ????? ?? ??????? ?? ???? Microsoft SQL.| || {$MYSQL.DSN} - ?? ???? ??????? ?? ?????? (????? ????: <??? ?? ?-DSN ??? ???>)
{$MYSQL.USER}, {$MYSQL.PASSWORD} - ?????? ??????? ?? MySQL ; ?????? ????? ????? ???? (????? ????: ?? ?????)|??? ?????? ?????? ?????? ?????? MySQL ????? ??????, ???:
GANT USAGE,REPLICATION CLIENT,PROCESS,SHOW DATABASES,SHOW VIEW ON %% *.* ?? '<username>'@'%';%%

??? ?????? .| || {$ORACLE.DSN} - ?? ???? ??????? ?? ?????? (????? ????: <??? ?? ?-DSN ??? ???>)
{$ORACLE.PORT} - ????? ?-TCP ?? Oracle DB (????? ????: 1521 )
{$ORACLE.USER}, {$ORACLE.PASSWORD} - ?????? ??????? ?? Oracle (????? ????: ?? ?????)|1. ??? ????? ????? Oracle ??????, ???:
CREATE USER zabbix_mon IDENTIFIED BY <PASSWORD>;
-- ???? ???? ?????? zabbix_mon.
GRANT CONNECT, CREATE SESSION TO zabbix_mon;
GRANT SELECT ON V_$instance TO zabbix_mon;
GRANT SELECT ON V_$database TO zabbix_mon;
GRANT SELECT ON v_$sysmetric TO zabbix_mon;
GRANT SELECT ON v$recovery_file_dest TO zabbix_mon;
GRANT SELECT ON v$active_session_history TO zabbix_mon;
GRANT SELECT ON v$osstat TO zabbix_mon;
GRANT SELECT ON v$restore_point TO<zabbix_mon; br>GRANT SELECT ON v$process TO zabbix_mon;
GRANT SELECT ON v$datafile TO zabbix_mon;
GRANT SELECT ON v$pgastat TO zabbix_mon;
GRANT SELECT ON v$ sgastat TO zabbix_mon;
GRANT SELECT ON v$log TO zabbix_mon;
GRANT SELECT ON v$archive_dest TO zabbix_mon;
GRANT SELECT ON v$asm_diskgroup TO zabbix_mon;
GANT SELECT ON sys.dba_data_files TO zabbix_mon;
GANT SELECT ON DBA_TABLESPACES TO zabbix_mon;
GANT SELECT ON DBA_TABLESPACE_USAGE_METRICS TO zabbix_mon;
GRANT SELECTS TO zabbix_mon;
GRANT SELECTS;
GRANT SELECTS
2. ??? ?-ODBC ????? ?-Oracle ?? ????? ?????? NLS_NUMERIC_CHARACTERS= '.,'

3. ???? ????? ???? ?-odbc.ini:
[$ORACLE.DSN]
Driver = ???? ???? Oracle 19 ODBC
Servername = $ORACLE.DSN
DSN = $ORACLE .DSN

4. ???? ?? ?????? ??????? isql:
isql $TNS_NAME $DB_USER $DB_PASSWORD

5. ???? ?? ??? Áú»¢¶Ä²© ?? Proxy Áú»¢¶Ä²© ???? ????? ?-Oracle ENV. ???? ?? ???? ???? ???: /etc/sysconfig/zabbix-server, ?? ???? ?-proxy: /etc/sysconfig/zabbix-proxy. ???? ??? ???? ?? ?????? ????? ?????:
export ORACLE_HOME=/usr/lib/oracle/19.6/client64
`export PATH=$PATH:$ORACLE_