Hi
I am not able to connect to Oracle, can some one help me.
Details of environment:
OS Windows XP
perl 5.6.1 build 633
Database version 9.2.0.3 located on a remote server



Thanks in Advance..
Shivakumar V

code
use Carp;
use DBI;
use DBD::Oracle;


BEGIN { DBI->trace(9);
$dbh = DBI->connect("DBI:Oracleb",'user','passw',{RaiseError=>0})
or confess "Failed to connect to Db $! \n";


Trace o/p here

C:\>perl -w tst.cgi
Unrecognized escape \o passed through at tst.cgi line 9.
Unrecognized escape \o passed through at tst.cgi line 9.
Name "main::dbh" used only once: possible typo at tst.cgi line 17.
DBI 1.37-ithread dispatch trace level set to 9
-> DBI->connect(DBI:OracleERIVEDB, mas, ****, HASH(0x183f0f8))
-> DBI->install_driver(Oracle) for MSWin32 perl=5.006001 pid=1892 ruid=0 eui
d=0
install_driver: DBD::Oracle version 1.06 loaded from C:/Perl/site/lib/DBD
/Oracle.pm
New DBI::dr (for DBD::Oracle::dr, parent=, id=)
dbih_setup_handle(DBI::dr=HASH(0x1b67110)=>DBI::dr =HASH(0x1af7a24), DBD::Ora
cle::dr, 0, Null!)
dbih_make_com(Null!, 00000000, DBD::Oracle::dr, 84, 00000000) thr#0183F388
dbih_setup_attrib(DBI::dr=HASH(0x1af7a24), Err, Null!) SCALAR(0x1b0d900) (al
ready defined)
dbih_setup_attrib(DBI::dr=HASH(0x1af7a24), State, Null!) SCALAR(0x1b672fc) (
already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1af7a24), Errstr, Null!) SCALAR(0x1b0d924)
(already defined)
dbih_setup_attrib(DBI::dr=HASH(0x1af7a24), TraceLevel, Null!) 0 (already def
ined)
dbih_setup_attrib(DBI::dr=HASH(0x1af7a24), FetchHashKeyName, Null!) 'NAME' (
already defined)
<- install_driver= DBI::dr=HASH(0x1b67110)
>> connect DISPATCH (DBI::dr=HASH(0x1b67110) rc2/3 @5 g0 ima1 pid#1892)
at C:/Perl/site/lib/DBI.pm line 582
-> connect for DBD::Oracle::dr (DBI::dr=HASH(0x1b67110)~0x1af7a24 'DERIVEDB'
'mas' **** HASH(0x1af64d8)) thr#0183F388
>> debug DISPATCH (DBI::dr=HASH(0x1af7a24) rc1/3 @1 g0 ima5 pid#1892)
at C:/Perl/site/lib/DBD/Oracle.pm line 90
1 -> debug in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x1af7a24)~INNE
R) thr#0183F388
1 <- debug= 9 at C:/Perl/site/lib/DBD/Oracle.pm line 90
>> trace_msg DISPATCH (DBI::dr=HASH(0x1af7a24) rc1/3 @2 g0 ima5 pid#1892)
at C:/Perl/site/lib/DBD/Oracle.pm line 97
1 -> trace_msg in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x1af7a24)~
INNER 'Trying to fetch ORACLE_HOME and ORACLE_SID from the registry.
') thr#0183F388
Trying to fetch ORACLE_HOME and ORACLE_SID from the registry.
1 <- trace_msg= 1 at C:/Perl/site/lib/DBD/Oracle.pm line 97
Use of uninitialized value in concatenation (.) or string at C:/Perl/site/lib/DB
D/Oracle.pm line 125.
>> trace_msg DISPATCH (DBI::dr=HASH(0x1af7a24) rc1/3 @2 g0 ima5 pid#1892)
at C:/Perl/site/lib/DBD/Oracle.pm line 125
1 -> trace_msg in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x1af7a24)~
INNER 'Found @ D:\oracle\ora92.
') thr#0183F388
Found @ D:\oracle\ora92.
1 <- trace_msg= 1 at C:/Perl/site/lib/DBD/Oracle.pm line 125
New DBI::db (for DBD::Oracle::db, parent=DBI::dr=HASH(0x1af7a24), id=)
dbih_setup_handle(DBI::db=HASH(0x1af79f4)=>DBI::db =HASH(0x1af6544), DBD::Ora
cle::db, 1b6a4b4, Null!)
dbih_make_com(DBI::dr=HASH(0x1af7a24), 01B275BC, DBD::Oracle::db, 676, 00000
000) thr#0183F388
dbih_setup_attrib(DBI::db=HASH(0x1af6544), Err, DBI::dr=HASH(0x1af7a24)) SCA
LAR(0x1b64258) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1af6544), State, DBI::dr=HASH(0x1af7a24)) S
CALAR(0x1b642b8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1af6544), Errstr, DBI::dr=HASH(0x1af7a24))
SCALAR(0x1b64288) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1af6544), TraceLevel, DBI::dr=HASH(0x1af7a2
4)) 0 (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1af6544), FetchHashKeyName, DBI::dr=HASH(0x
1af7a24)) 'NAME' (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1af6544), HandleError, DBI::dr=HASH(0x1af7a
24)) undef (not defined)
Environment variables:
ALLUSERSPROFILE=C:\Documents and Settings\All Users
ANT_HOME=D:\CVS_Views\ant
APPDATA=C:\Documents and Settings\venkatappa\Application Data
ClassPath=C:\Program Files\Rational\Rational Test 7
CommonProgramFiles=C:\Program Files\Common Files
COMPUTERNAME=CHURU
ComSpec=C:\WINDOWS\system32\cmd.exe
CVSROOT=server:venkatappa@cvsin:/cvsroot
HOMEDRIVE=C:
HOMEPATH=\Documents and Settings\venkatappa
JAVA_HOME=C:\jdk1.3.1_02
LOGONSERVER=\\PANIPAT
NUMBER_OF_PROCESSORS=1
OS=Windows_NT
Path=C:\mysql\bin;C:\Perl\bin\;C:\jdk1.3.1_02\bin; C:\oracle\ora817\bin;C
:\Program Files\Oracle\jre\1.1.7\bin;C:\Perl\bin\;C:\WINDOWS \system32;C:\WINDOWS
;C:\WINDOWS\System32\Wbem;C:\Program Files\Rational\common;C:\Program Files\GNU\
WinCvs 1.3;D:\CVS_Views\ant\bin;C:\Program Files\doxygen\bin;C:\Program Files\cv
snt;C:\SecureCRT 3.0;C:\PROGRA~1\CVSFOR~1;C:\Program Files\CVS for NT
PATHEXT=.COM;.EXE;.BAT;.CMD;.VBS;.VBE;.JS;.JSE;.WS F;.WSH
PROCESSOR_ARCHITECTURE=x86
PROCESSOR_IDENTIFIER=x86 Family 15 Model 2 Stepping 7, GenuineIntel
PROCESSOR_LEVEL=15
PROCESSOR_REVISION=0207
ProgramFiles=C:\Program Files
PROMPT=$P$G
SESSIONNAME=Console
SystemDrive=C:
SystemRoot=C:\WINDOWS
TEMP=C:\DOCUME~1\VENKAT~1\LOCALS~1\Temp
TMP=C:\DOCUME~1\VENKAT~1\LOCALS~1\Temp
USERDOMAIN=INTEGRALPAO
USERNAME=venkatappa
USERPROFILE=C:\Documents and Settings\venkatappa
VIM=C:\Vim
windir=C:\WINDOWS
<- connect= undef at C:/Perl/site/lib/DBI.pm line 582
>> errstr DISPATCH (DBI::dr=HASH(0x1b67110) rc2/3 @1 g0 ima4 pid#1892)
at C:/Perl/site/lib/DBI.pm line 584
-> errstr in DBD::_::common for DBD::Oracle::dr (DBI::dr=HASH(0x1b67110)~0x1
af7a24) thr#0183F388
<- errstr= undef at C:/Perl/site/lib/DBI.pm line 584
Use of uninitialized value in concatenation (.) or string at C:/Perl/site/lib/DB
I.pm line 584.
DBI connect('DERIVEDB','mas',...) failed:
DBI connect('DERIVEDB','mas',...) failed: at tst.cgi line 17
>> DESTROY DISPATCH (DBI::db=HASH(0x1af79f4) rc1/1 @1 g0 ima4 pid#1892)
at C:/Perl/site/lib/DBI.pm line 639 via tst.cgi line 17
<> DESTROY ignored for outer handle DBI::db=HASH(0x1af79f4) (inner DBI::db=H
ASH(0x1af6544))
>> DESTROY DISPATCH (DBI::db=HASH(0x1af6544) rc1/1 @1 g0 ima4 pid#1892)
at C:/Perl/site/lib/DBI.pm line 639 via tst.cgi line 17
-> DESTROY for DBD::Oracle::db (DBI::db=HASH(0x1af6544)~INNER) thr#0183F388
DESTROY for DBI::db=HASH(0x1af6544) ignored - handle not initialised
<- DESTROY= undef at C:/Perl/site/lib/DBI.pm line 639 via tst.cgi line 17
DESTROY (dbih_clearcom) (dbh 0x1af79f4 0x1b548a8, com 0x22f9f6c, imp DBD::Or
acle::db):
FLAGS 0x11: COMSET Warn
PARENT DBI::dr=HASH(0x1af7a24)
KIDS 0 (0 Active)
IMP_DATA undef
dbih_clearcom 0x1af79f4 (com 0x22f9f6c, type 2) done.

Failed to connect to Db
-- DBI::END
>> disconnect_all DISPATCH (DBI::dr=HASH(0x1b67110) rc1/3 @1 g0 ima801 pid#1
892) at C:/Perl/site/lib/DBI.pm line 649 via tst.cgi line 0
-> disconnect_all for DBD::Oracle::dr (DBI::dr=HASH(0x1b67110)~0x1af7a24) th
r#0183F388
<- disconnect_all= '' at C:/Perl/site/lib/DBI.pm line 649 via tst.cgi line 0

! >> DESTROY DISPATCH (DBI::dr=HASH(0x1af7a24) rc1/1 @1 g0 ima4 pid#1892)
during global destruction
! -> DESTROY for DBD::Oracle::dr (DBI::dr=HASH(0x1af7a24)~INNER) thr#0183F388
! <- DESTROY= (not implemented) during global destruction
DESTROY (dbih_clearcom) (drh 0x1b67110 0x1b548f4, com 0x1b275bc, imp DBD::Or
acle::dr):
FLAGS 0x215: COMSET Active Warn AutoCommit
PARENT undef
KIDS 0 (0 Active)
IMP_DATA undef
dbih_clearcom 0x1b67110 (com 0x1b275bc, type 1) done.

! >> DESTROY DISPATCH (DBI::dr=HASH(0x1b67110) rc1/1 @1 g0 ima4 pid#1892)
during global destruction
! <> DESTROY for DBI::dr=HASH(0x1b67110) ignored (inner handle gone)

C:\>