Код:
# 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
#
Тоже самое, если ORACLE_HOME -> linux-oracle-instantclient-basic
Я что-то упустил или оно просто уже не взлетит?