FAQ
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:

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

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 23, '06 at 3:12p
activeOct 23, '06 at 3:12p
posts1
users1
websiteoracle.com

1 user in discussion

Vaida Bogdan: 1 post

People

Translate

site design / logo © 2022 Grokbase