Hi,
I am still having issues with this. I have followed the instructions in
the readme.txt closely but get the following when running the
makefile.pl command:
Installing on a MSWin32, Ver#5.1
Using Oracle in D:/oracle/instantclient_11_1
DEFINE _SQLPLUS_RELEASE = "1101000700" (CHAR)
Oracle version 11.1.0.7 (11.1)
Using OCI directory 'sdk'
Checking for functioning wait.ph
System: perl5.008008
Compiler: gcc -s -O2 -s -O2 -DWIN32 -DHAVE_DES_FCRYPT
-DPERL_IMPLICIT_CONTEX
T -DPERL_IMPLICIT_SYS -fno-strict-aliasing -DPERL_MSVCRT_READFIX
Linker: not found
Sysliblist:
Checking if your kit is complete...
Warning: the following files are missing in your kit:
META.yml
Please inform the author.
... Detected uninstalled Perl. Trying to continue.
Have D:\OTRS\Perl\perl\lib\Config.pm expected
C:\strawberry\perl\lib\Config.pm
Note (probably harmless): No library found for -lmsvcrt
Note (probably harmless): No library found for -lmoldname
Note (probably harmless): No library found for -lkernel32
Note (probably harmless): No library found for -luser32
Note (probably harmless): No library found for -lgdi32
Note (probably harmless): No library found for -lwinspool
Note (probably harmless): No library found for -lcomdlg32
Note (probably harmless): No library found for -ladvapi32
Note (probably harmless): No library found for -lshell32
Note (probably harmless): No library found for -lole32
Note (probably harmless): No library found for -loleaut32
Note (probably harmless): No library found for -lnetapi32
Note (probably harmless): No library found for -luuid
Note (probably harmless): No library found for -lws2_32
Note (probably harmless): No library found for -lmpr
Note (probably harmless): No library found for -lwinmm
Note (probably harmless): No library found for -lversion
Note (probably harmless): No library found for -lodbc32
Note (probably harmless): No library found for -lodbccp32
LD_RUN_PATH=D:/oracle/instantclient_11_1/lib:D:/oracle/instantclient_11_
1/rdbms/
lib
Using DBD::Oracle 1.22.
Using DBD::Oracle 1.22.
Using DBI 1.607 (for perl 5.008008 on MSWin32-x86-multi-thread)
installed in D:/
OTRS/Perl/perl/site/lib/auto/DBI/
Writing Makefile for DBD::Oracle
Your assistance is appreciated.
Sajit
-----Original Message-----
From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of
Michiel Beijen
Sent: 19 December 2008 02:02 PM
To: User questions and discussions about OTRS.
Subject: Re: [otrs] Oracle drivers
Sajit,
Apparently, you use Windows. Did you also use the Windows installer for
OTRS?
In that case, you are using Strawberry Perl. In the default
distribution DBD::Oracle is /not/ included.
This means you'll have to install this yourself. To do that you can
use either cpan or ppm. Just go to a console window, enter the
commands cpan or ppm and follow instructions. You can consult the
perldocs for more information.
DBD::Oracle is just a wrapper around the 'normal' Oracle client, so
you need to install that as well (if it is not yet present on your
machine). You can use Oracle Instant Client, which is a LOT easier to
install than the old 'regular' client.
Here are some notes on DBD::Oracle and Strawberry that might be of use
for you. This article also has a link to the place on the Oracle site
where you can download the Instant Client.
[http://win32.perl.org/wiki/index.php?title=Install_DBD::Oracle_on_Straw
berry_Perl]
Kind regards,
--
Michiel Beijen
Software Consultant
+31 6 - 457 42 418
Bee Free IT + http://beefreeit.nl
2008/12/19 Sajit Kalidas
Hi,
I am getting the following error when trying to connect to the oracle database.
install_driver(Oracle) failed: Can't locate DBD/Oracle.pm in @INC (@INC contains: ../../ C:/OTRS/otrs/bin/cgi-bin/../../Kernel/cpan-lib C:/OTRS/otrs/bin/cgi-bin/../.. C:/OTRS/Perl/perl/lib C:/OTRS/Perl/perl/site/lib . C:/OTRS/otrs/bin/cgi-bin/../.. C:/OTRS/otrs/bin/cgi-bin/../../Kernel/cpan-lib) at (eval 23) line 3.
Perhaps the DBD::Oracle perl module hasn't been fully installed,
or perhaps the capitalisation of 'Oracle' isn't right.
Available drivers: DBM, ExampleP, File, Gofer, Proxy, SQLite, Sponge, mysql.
at C:/OTRS/otrs/bin/cgi-bin/../../Kernel/System/DB.pm line 216
IF have made the following changes in the config.pm:
$Self->{'DatabaseHost'} = 'dev';
$Self->{'Database'} = 'dev';
$Self->{'DatabaseUser'} = 'otrs';
$Self->{'DatabasePw'} = 'pass';
$Self->{DatabaseDSN} =
"DBI:Oracle:sid=$Self->{Database};host=$Self->{DatabaseHost};port=1521;" ;
I have installed on windows using the windows installer package.
Where can
I find the Oracle drivers?
Any suggestions please.
Thanks
Sajit
________________________________ This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal ________________________________ _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs
_______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs ##################################################################################### This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal #####################################################################################