Using DBI 1.20, DBD:Oracle 1.12, perl 5.6.1 on RedHat 7.2 connecting to
Oracle 8.0.4 on a UnixWare 7 machine with an Oracle 8.1.7 client, I'm
getting: Unable to connect to Oracle (ORA-12545: Connect failed because
target host or object does not exist (DBD ERROR: OCIServerAttach))
errors on some of the tests. I can tnsping the db and can get in via
sqlplus.
I have DBD:Oracle working successfully using the same test file and
versions of DBD & DBI on a SUSE 7.2 machine, a RedHat 7.1 machine and a
RedHat 6.2 machine so suspect that the RedHat 7.2 OS is the problem.
It's a new machine and has a default load so maybe I did not enable some
protocol or process that defaulted to enabled on the other platforms.
I'm not getting any linking errors that I can see. After all the
failures due to the error above, I get this:
***********************************************
Oraperl emulation interface version 1.41
DBD::Oracle 1.12 using OCI8 by Tim Bunce
DBI 1.20 by Tim Bunce
Data sources:
dbi:Oracle:extproc_connection_data
dbi:Oracle:wg80
Connecting
to 'wg80' (from command line, else uses ORACLE_SID or TWO_TASK -
recommended)
as 'prod/xxx' (via ORACLE_USERID env var or default - recommend
name/passwd@dbname)
(ORACLE_SID='wg80', TWO_TASK='')
Testing internal row fetch overhead.
50000 fetches: 0 wallclock secs ( 0.15 usr + 0.00 sys = 0.15 CPU)
50000 per clock second, 333333 per cpu second
Fields: 6
Names: 'NUM_T' 'DATE_T' 'CHAR_T' 'ROWID_T'
'RAW_T' 'NULL_T'
Lengths: 134 76 31 21 3 1
OraTypes: 2 12 1 104 23 1
SQLTypes: 8 9 12 -9104 -2 12
Scale: 0 0 0 0 0 0
Precision: 126 75 30 20 2 0
Nullable: 1 1 1 1 1 1
Est row width: 46
Data rows:
fetch: '7.2', '15-MAR-02', 'PROD', 'AAAACsAABAAAAGiAAA', '7D', undef
******************************************
Which looks to me like it's actually getting into my db.
My env variables include:
ORACLE_SID=wg80
LD_LIBRARY_PATH=/home/oracle/OraHome1/lib
ORAHOME=/home/oracle
ORACLE_HOME=/home/oracle/OraHome1
ORASID=wg80
My tnsnames file has this entry (all on one line which was necessary in
order to get sqlplus to work):
wg80 =(DESCRIPTION =(ADDRESS = (PROTOCOL= TCP)(Host= 172.16.3.33)(Port=
1521))(CONNECT_DATA = (SID = wg80)) )
I've been reading lists and README files for the past two days and can't
see what I'm missing. Just in case, I chmod'd $ORACLE_HOME and
tnsnames.ora to 755 and that didn't help.
Has anyone else faced and overcome this problem?
Stephanie Adams
