problem connecting to an oracle server (9i) from a freebsd os

From: Vaida Bogdan <vaida.bogdan_at_gmail.com>
Date: Mon, 23 Oct 2006 18:12:10 +0300
Message-ID: <12848a3b0610230812tb959cfcjbf2409354a20175d@mail.gmail.com>

Hi, I have FreeBSD 6.1 and I'm trying to connect to an oracle server.

Host A: FreeBSD client
Host B: oracle server 9i
Port B: 1521

SID: info.uvt

I tried:
- linux-oracle-instantclient-sqlplus

and
- p5-DBD-Oracle

Problems:

1. linux-oracle-instantclient-sqlplus (for 10.x)
   - from the description I don't need an ORACLE_HOME and other environment
   vars
   - it seems the client is for oracle 10.x and not 9i (I don't know if it will
   work)
   - I can't specify the host in the commandline
   

Running /compat/linux/usr/lib/oracle/10.2.0.2.20060331/client/bin/sqlplus shows blank (no output, pressing keys doesn't give me anything). If I export ORACLE_HOME="/compat/.../client/", running sqlplus gives me: SP2-1503: Unable to initialize Oracle call interface SP2-0152: ORACLE may not be functioning properly

Where should I go from here? How can I add a remote_host parameter to sqlplus

2) p5-DBD-Oracle
I've written a short perl script with the following outcome: "
use DBI;
my $dbh = DBI->connect('dbi:Oracle:host=hostb;sid=info.uvt;port=1521','scott/tiger','')||die "$DBI::errstr";
$dbh->disconnect;
"
the result:
DBI connect() failed: Error while trying to retrieve text for error ORA-01019 (DBD: login failed, probably a symptom of a deeper problem) at line 2

Any ideeas/solutions?

Thanks in advance,
  Bogdan

--
http://www.freelists.org/webpage/oracle-l

Received on Mon Oct 23 2006 - 10:12:10 CDT