Oracle backend

[max]

As I have an Oracle 10g, I use the Easy Connect Syntax, instead of annoying with tnsnames.ora.
For that, I've modified the db.inc.php :
case "ORACLE":
$DB_LINK_DATABASE = $DB_SERVER.':'.$DB_PORT.'/'.$DB_DATABASE;
$DB = OCILogon($DB_USER, $DB_PASSWORD, $DB_LINK_DATABASE);
if(!$DB)
{
$error = "Error connecting to database";
$result = false;
}
break;


And it works !

I really encourage those who have the Oracle connection problems with the PHPfrontends to follow this Oracle note :

http://www.oracle.com/technology/pub/notes/technote_php_instant.html

Bye !

[pc99096]

anyone having performance problems with oracle backend?
some reports take more than 30 seconds to display.
same environment with another zabbix server and mysql backend db takes 1-2 seconds.
zabbix 2.2.1, centos, standard apache+php+oci8