Áú»¢¶Ä²©

12 ????? ??? ?????? ?? Oracle

????? ?????

???? ?? ???? ?????? ?????? ??? ?????? ?? Oracle ? ????? ??????? ??? ??? ??????? ???? Áú»¢¶Ä²©, ??????, ?????.

????? ??? ??????

??? ?????? ????? ????? ??? ?????? zabbix ?? ????? ????? ??? ?? ?????? ????? ???????? ??? ?????? ?????? ORCL ?????? ???? ??? ??????? ???? ?? Oracle. Áú»¢¶Ä²© ???? ??? ?????? ?? Unicode ?? ????? ?????? ????? ?????? 'UTF8'. ???? ??? ??????:

 sqlplus> ??? ?????, ??? ???? v$nls_parameters ???? ?????='NLS_CHARACTERSET' ?? ?????='NLS_NCHAR_CHARACTERSET';

??? ??? ?? ??? ???????:

 shell> cd /path/to/zabbix-sources/database/oracle
        shell> sqlplus zabbix/password@oracle_host/ORCL
        sqlplus> @schema.sql
        # ???? ??? ?? ??? ???? ??? ?????? ???? ?????? Áú»¢¶Ä²©
        sqlplus> @images.sql
        sqlplus> @data.sql

????? ?????

Áú»¢¶Ä²© ???? ???? ????? ?? ???? ????? (????? ?????):

• ????? ??
• ?? ????? ???

??????? ?? ????? ????? ???? ??? Áú»¢¶Ä²© ?-Proxy Áú»¢¶Ä²© ???? ?????? ????? ??????. ??????? ?????? ???? ???? ???????? ?? DBHost, DBUser, DBName ?-DBPassword. ? ???? ??????? ?????? ???? ?-frontend: $DB["SERVER"], $DB["PORT"], $DB["DATABASE"], $DB["USER"], $DB["PASSWORD"].

Áú»¢¶Ä²© ????? ?????? ?????? ?????? ???:

 {DBUser/DBPassword[@<connect_identifier>]}

???? ????? ?? <connect_identifier> ????? ?? "Net ?? ?????" ?? "????? ??".

 @[[//]????[:????]/<??_?????> | <net_service_name>]

????? ??

Easy Connect ????? ???????? ????? ??? ?????? ???? ???????:

• ???? - ?? ????? ?? ????? ?-IP ?? ???? ??? ??? ??????? (????? DBHost ????? ??????).
• ???? - ????? ?????? ???? ??? ??????? (????? DBPort ????? ??????; ?? ?? ?????, ????? ????? ????? 1521 ???? ??????).
• <service_name> - ?? ?????? ?? ??? ??????? ???? ???? access (????? DBName ????? ??????).

?????:

??????? ?? ??? ?????? ??????? ????? ?????? ?? ???? ?? ?-proxy (zabbix_server.conf ?-zabbix_proxy.conf):

 DBHost=???? ?????
        DBPort=1521
        DBUser=?? ?????? ???
        DBName=ORCL
        DBPassword=?????? ???

?????? ????? ?????? Áú»¢¶Ä²© ?????? ?????:

 DBUser/DBPassword@DBHost:DBPort/DBName

????? ????? ????? ?? Áú»¢¶Ä²©, ???? ?? ???????? ???????? ??? ???? ????? DB ?? ??? ??????:

• ???? ??? ??????: localhost
• ????? ??? ??????: 1521
• ?? ??? ???????: ORCL
• ?????: ?? ?????? ???
• ?????: ?????? ???

???????, ???? ?????? ??????? ??? ?????? ????? ???? (zabbix.conf.php):

 $DB["TYPE"] = 'ORACLE';
        $DB["SERVER"] = '???? ?????';
        $DB["PORT"] = '1521';
        $DB["DATABASE"] = 'ORCL';
        $DB["USER"] = '?? ?????? ???';
        $DB["PASSWORD"] = '?????? ???';

?? ????? ???

??? Áú»¢¶Ä²© 5.4.0 ???? ?????? ?????? ??????? net ?? ??????.

<net_service_name> ??? ?? ???? ?????? ????? ?????? ?????.

?? ??? ?????? ??? ?????? ?????? ?????, ????? ?? ?? ?????? ?? ??? ????? tnsnames.ora ?????? ???? ?- ??? ??? ??????? ??????? ?????. ???? ???? ????? ????? ??????? ????? ?? ?????? ?? ?????? ?? ???? tnsnames.ora ?????? ?????? TNS_ADMIN. ????? ????? ?????? ?? ????? tnsnames.ora ???:

 $ORACLE_HOME/network/admin/

????? ????? ????? tnsnames.ora:

 ORCL =
          (????? =
            (????? = (???????? = TCP)(???? = ???? ?????)(???? = 1521))
            (CONNECT_DATA =
              (??? = ??????)
              (SERVICE_NAME = ORCL)
            )
          )

??? ?????? ??????? ?? ????? ???? ?????? "Net Service Name". ????, ????? ???? ?????????? ?????:

• ???? ????? ??? DBHost ????? ?? DBName ?????:

 DBHost=
        DBName=ORCL

• ???? ?? ??? ???????? ????? ?? ????? ?????:

 DBHost=
        DBName=

????? ????, ?? ?????? ?? ????? ?????? TWO_TAKS. ?? ????? ?? ????? ????? ?? ????? Oracle ?????? (?? ?????). ???? ?????? ?????, ????? ????? ???? ??????? ????? ?? ??? ??????? ????? Oracle ????? ????? ?????. ?????? ??? ????? ?????? ?-Linux ?-UNIX ????. ????? ?????? ?????? LOCAL ???? Microsoft Windows.

?????:

????? ???? ?????? ??????? Net Service Name ?????? ?-ORCL ?????? ????? ???. ??????? ?? ??? ?????? ??????? ????? ?????? ?? ???? ?? ?-proxy (zabbix_server.conf ?-zabbix_proxy.conf):

 DBHost=
        #DBPort=
        DBUser=?? ?????? ???
        DBName=ORCL
        DBPassword=?????? ???

????? ????? ????? ?? Áú»¢¶Ä²©, ???? ?? ???????? ???????? ??? ???? ????? DB ?? ??? ??????:

• ???? ??? ??????:
• ????? ??? ??????: 0
• ?? ??? ???????: ORCL
• ?????: ?? ?????? ???
• ?????: ?????? ???

???????, ???? ?????? ??????? ??? ?????? ????? ???? (zabbix.conf.php):

 $DB["TYPE"] = 'ORACLE';
        $DB["SERVER"] = '';
        $DB["PORT"] = '0';
        $DB["DATABASE"] = 'ORCL';
        $DB["USER"] = '?? ?????? ???';
        $DB["PASSWORD"] = '?????? ???';

?????? ????? ?????? Áú»¢¶Ä²© ?????? ?????:

 DBUser/DBPassword@ORCL

????? ??????

??? ???? ?? ????????, ??? ???? ????? ?? ???? ????? ?-nclob ?-nvarchar2, ??? ????? ??????.