Re: DBD-Oracle-1.21 installation issue

Looks from that one it cannot find you listener.

Set the TNS_ADMIN value to the directory that has your TNASNAMES.ORA file

cheers

Ejaz wrote:
Dear John,

Many thanks for your reply,


But I cannot insert the values in the database, when ever I am trying through my radius profiile which we are using for authentications,

When i tried to connect manually its ok,

# sqllus xxxx/cxxx@sxxx

SQL*Plus: Release 10.2.0.1.0 - Production on Tue Jul 15 09:51:53 2008

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production

SQL> quit

Here is the message in my radius logs, when i tried to connect from radius,

, 212.119.67.21, 4475130
Mon Jul 14 17:08:06 2008: ERR: Could not connect to SQL database with DBI->connect dbi:Oracle:sunb, cybrad, cybrad: ORA-12154: TNS:could not resolve the connect identifier specified (DBD ERROR: OCIServerAttach)
Mon Jul 14 17:08:06 2008: ERR: Could not connect to any SQL database. Request is ignored. Backing off for 600 seconds
Mon Jul 14 17:08


Regards
Ejaz ----- Original Message ----- From: "John Scoles" <byterock@xxxxxxxxxxx>
To: "Ej" <ejazrom@xxxxxxxxxxx>; <dbi-users@xxxxxxxx>
Sent: Saturday, July 12, 2008 10:24 PM
Subject: RE: DBD-Oracle-1.21 installation issue



Looks like it installed just fine your need to set the 'ORACLE_USERID' to a valid user on your DB for the test to work or create a use called Scott with a pw tiger on your DB (This I would not do as every hacker knows this PW ad USer id)

To: dbi-users@xxxxxxxx
From: ejazrom@xxxxxxxxxxx
Subject: DBD-Oracle-1.21 installation issue
Date: Sat, 12 Jul 2008 04:22:57 -0700
CC: mejaz@xxxxxxxxxxxxxx

HI all.

Iam trying to install DBD-Oracle-5.1 on soalris 10_x86 and Oracle
10g,
I got the following error message while running " make test" Please
any suggestion would highly appreciated,


t/31lob.................DBI connect('','scott/tiger',...) failed:
ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
nchar_test_lib.pl line 156
You tried to plan twice! Second plan at t/31lob.t line 16
# Looks like your test died before it could output anything.
t/
31lob.................dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-9
Failed 9/9 tests, 0.00% okay
t/32xmltype.............ok 1/4DBI connect('','scott/tiger',...)
failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach)
at t/32xmltype.t line 26
# Looks like you planned 4 tests but only ran 1.
# Looks like your test died just after 1.
t/
32xmltype.............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-4
Failed 3/4 tests, 25.00% okay
t/34pres_lobs...........DBI connect('','scott/tiger',...) failed:
ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
34pres_lobs.t line 31
# Looks like your test died before it could output anything.
t/
34pres_lobs...........dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 1-11
Failed 11/11 tests, 0.00% okay
t/40ph_type.............DBI connect('','scott/tiger',...) failed:
ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
40ph_type.t line 29
Unable to connect to Oracle (ORA-12546: TNS:permission denied (DBD
ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/50cursor..............Unable to connect to Oracle as scott/tiger
(ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/51scroll..............ok 1/33DBI connect('','scott/tiger',...)
failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach)
at t/51scroll.t line 26
# Looks like you planned 33 tests but only ran 1.
# Looks like your test died just after 1.
t/
51scroll..............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-33
Failed 32/33 tests, 3.03% okay
t/55nested..............Unable to connect to Oracle as scott/tiger
(ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/56embbeded............ok 1/5DBI connect('','scott/tiger',...)
failed: ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach)
at t/56embbeded.t line 28
# Looks like you planned 5 tests but only ran 1.
# Looks like your test died just after 1.
t/
56embbeded............dubious
Test returned status 255 (wstat 65280, 0xff00)
DIED. FAILED tests 2-5
Failed 4/5 tests, 20.00% okay
t/60reauth..............ORACLE_USERID_2 not defined. Tests skipped.
skipped
all skipped: no reason given
t/70meta................Unable to connect to Oracle as scott/tiger
(ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach))
Tests skipped.
skipped
all skipped: no reason given
t/80ora_charset.........DBI connect('','scott/tiger',...) failed:
ORA-12546: TNS:permission denied (DBD ERROR: OCIServerAttach) at t/
80ora_charset.t line 118
skipped
all skipped: Not connected to oracle
Failed Test Stat Wstat Total Fail Failed List of Failed
-------------------------------------------------------------------------------
t/10general.t 255 65280 33 66 200.00% 1-33
t/26exe_array.t 255 65280 14 26 185.71% 2-14
t/28array_bind.t 255 65280 15 30 200.00% 1-15
t/30long.t 255 65280 470 940 200.00% 1-470
t/31lob.t 255 65280 9 18 200.00% 1-9
t/32xmltype.t 255 65280 4 6 150.00% 2-4
t/34pres_lobs.t 255 65280 11 22 200.00% 1-11
t/51scroll.t 255 65280 33 64 193.94% 2-33
t/56embbeded.t 255 65280 5 8 160.00% 2-5
17 tests and 9 subtests skipped.
Failed 9/28 test scripts, 67.86% okay. 590/608 subtests failed, 2.96%
okay.
make: *** [test_dynamic] Error 29


_________________________________________________________________


.

Relevant Pages

  • DBD-Oracle-1.21 installation issue
    ... Iam trying to install DBD-Oracle-5.1 on soalris 10_x86 and Oracle ... I got the following error message while running " make test" Please ... Failed 3/4 tests, 25.00% okay ... all skipped: no reason given ...
    (perl.dbi.users)
  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... DBD Oracle 1.20 ORA-24334 Error ... Database character set is not Unicode ... Failed 1/82 tests, 98.78% okay ...
    (perl.dbi.users)
  • DBD::Oracle 1.19 tests core against Oracle 10.2.0.1 - Solaris build
    ... I'm trying to get DBD::Oracle to work on Solaris 9 but I'm getting core ... Configuring DBD::Oracle for perl 5.008008 on solaris ... Oracle version 10.2.0.1 ... Failed 13/14 tests, 7.14% okay ...
    (perl.dbi.users)
  • Re: DBD Oracle 1.20 ORA-24334 Error
    ... the status after having connected to Oracle ... Failed 2/33 tests, 93.94% okay ... Database character set is not Unicode ...
    (perl.dbi.users)
  • Re: "why"
    ... asking what makes it okay for B to be driving so fast. ... For what purpose, reason, or cause; ... justification, or motive: ... "What law allows you to do this?" ...
    (alt.usage.english)