BSDPORTAL.RU

# pkg info | grep Oracle
linux-oracle-instantclient-basic-10.2.0.3.20061115_5 Oracle 10 32Bit Linux InstantClient basics for RDBMS 8.1.2+
linux-oracle-instantclient-sqlplus-10.2.0.3.20061115_3 Oracle 10 32 Bit Linux InstantClient SQLPlus for RDBMS 8.1.2+
oracle8-client-0.2.0_1         Oracle 8 client
p5-DBD-Oracle-1.14_5           DBI driver for Oracle RDBMS server

# cat test.pl
use strict;
use DBI;

my $dbh = DBI ->connect
   ( 'DBI:Oracle:host=101.134.11.152;sid=testdb;port=1521', 'zabbix', 'zabbix',
                        {RaiseError => 1,
                         AutoCommit => 0} );;

my $sql = qq{ SELECT banner FROM zabbix.test };

my $sth = $dbh->prepare( $sql );

$sth->execute();

while ( my($banner) = $sth->fetchrow_array) {
        print "Test !";
        print "\n";
}

$dbh->disconnect();

# setenv ORACLE_HOME /usr/local/oracle8-client
# setenv LD_LIBRARY_PATH /usr/local/oracle8-client/lib
# setenv NLS_LANG AMERICAN_CIS.CL8MSWIN1251
# perl test.pl
DBI connect('host=101.134.11.152;sid=testdb;port=1521','zabbix',...) failed: Error while trying to retrieve text for error ORA-01019 (DBD: login failed, probably a symptom of a deeper problem) at test.pl line 4.

# tail sqlnet.log
  Time: 18-DEC-16 13:56:26
  Tracing not turned on.
  Tns error struct:
    nr err code: 12206
    TNS-12206: Message 12206 not found; No message file for product=NETWORK, facility=TNS
    ns main err code: 12545
    TNS-12545: Message 12545 not found; No message file for product=NETWORK, facility=TNS
    ns secondary err code: 12560
    nt main err code: 515
    TNS-00515: Message 515 not found; No message file for product=NETWORK, facility=TNS
#