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_Strawberry...]
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