problem connecting to an oracle server (9i) from a freebsd os
- From: "Vaida Bogdan" <vaida.bogdan@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 23 Oct 2006 18:12:10 +0300
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
Other related posts:
- » problem connecting to an oracle server (9i) from a freebsd os
