Describe désert/Zabbix/with-oracle here.

Oracle 19c

SQL> CREATE PLUGGABLE DATABASE zabbix ADMIN USER zabbix IDENTIFIED by zabbix;

Pluggable database created.


SQL> COLUMN pdb_name FORMAT A20

SELECT pdb_name, status
FROM   dba_pdbs
ORDER BY pdb_name;SQL> SQL>   2    3

PDB_NAME             STATUS
-------------------- ----------
PDB$SEED             NORMAL
PDB1                 NORMAL
ZABBIX               NEW



SQL> COLUMN name FORMAT A20

SELECT name, open_mode
FROM   v$pdbs
ORDER BY name;SQL> SQL>   2    3

NAME                 OPEN_MODE
-------------------- ----------
PDB$SEED             READ ONLY
PDB1                 MOUNTED
ZABBIX               MOUNTED

SQL> CREATE USER zabbix IDENTIFIED BY zabbix CONTAINER=CURRENT;

User created.

SQL> grant create session,create table to zabbix;

Grant succeeded.

SQL> grant unlimited tablespace to zabbix;

Grant succeeded.


SQL> conn sys/oracle@localhost:1521/zabbix as sysdba;
Connected.
SQL> select instance_name,status from v$instance;

INSTANCE_NAME    STATUS
---------------- ------------
orcl             OPEN

SQL> show pdbs;

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         4 ZABBIX                         READ WRITE NO
SQL>

zabbix

zabbix<2021-08-29 18:59:41> ~/zabbix-5.4.3

$ ./configure --with-gnutls --with-ssh --enable-server --enable-agent --enable-ipv6 --with-net-snmp --with-libcurl --with-openipmi --with-oracle=/oracle/app/oracle/product/19.3.0 --with-ldap --with-libxml2 --with-libcurl --with-libmodbus

php

root@zabbix:~/php-7.4.23# ./configure --with-apxs2 -prefix=/usr --sysconfdir=/etc --localstatedir=/var --datadir=/usr/share/php --mandir=/usr/share/man --with-config-file-path=/etc --with-config-file-scan-dir=/etc/php.d  --with-zlib --enable-bcmath  --with-bz2 --with-sodium --enable-soap --with-libedit --with-curl --enable-gd --with-mhash -enable-pcntl  -enable-sysvshm -enable-sysvmsg  --without-pdo-sqlite --without-sqlite3 --enable-exif --with-ffi --with-snmp --enable-fpm --with-oci8=/oracle/ --with-pdo-oci=/oracle --enable-sigchild --enable-bcmath --enable-mbstring --with-xsl --with-ldap

désert/Zabbix/with-oracle (last edited 2021-08-29 11:00:14 by localhost)