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/[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> To: "Ej" <[EMAIL PROTECTED]>; <[email protected]> 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: [email protected] > From: [EMAIL PROTECTED] > Subject: DBD-Oracle-1.21 installation issue > Date: Sat, 12 Jul 2008 04:22:57 -0700 > CC: [EMAIL PROTECTED] > > 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 > _________________________________________________________________
