Installation with Oracle and Server 2008

[bitethebullet6]

Hello Everyone,
First time installing this so I hope that I am not missing anything easy. I will start with the basics. I am starting with 2 installations of Windows Server 2008 Enterprise. We will call it Server A(Database) and Server B Web/App server.
I have the OTRS database installed in the Oracle database using the scrips provided. That is working fine and I can connect to it from server B so I know that it isn't the firewall or anything blocking it. I have used the windows provided installer to install OTRS. I didn't do the second part web install because that is the database portion and that is already set up on my second server. I have gone through many installations of Perl and different scripts but i have one error.

install_driver(Oracle) failed: Attempt to reload DBD/Oracle.pm aborted.
Compilation failed in require at (eval 169) line 3.
at C:/OTRS/OTRS//Kernel/System/DB.pm line 210

So I am stuck I don't know where to go from here. I am looking to do some testing with this because it is open source, and might be a good fit for my companies system. If not I will have to look into something else, I wish there was more Oracle support it is right on the specs page.

[jojo]

you need to install a DBD::Oracle Driver for PERL

[bitethebullet6]

I think I have done that, I installed oracleXE client on the machine then went to,
cpan>install DBI
cpan>install DBD::Oracle
it usually throws an error so I tried cpan> force install DBD::Oracle but it still throws an error?

Appending installation info to C:\OTRS\StrawberryPerl\perl\lib/perllocal.pod
PYTHIAN/DBD-Oracle-1.27.tar.gz
C:\OTRS\StrawberryPerl\c\bin\dmake.exe install UNINST=1 -- OK
Failed during this command:
PYTHIAN/DBD-Oracle-1.27.tar.gz : make_test FAILED but failure ign
ored because 'force' in effect

So I am not sure what the problem is.

[bitethebullet6]

OK, so I got though that error but have one more issue. When I go to login to the main page it doesn't throw that oracle error it throws:

Backend ERROR: OTRS-CGI-10 Perl: 5.12.2 OS: MSWin32 Time: Sun Feb 20 21:47:23 2011
Message: ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin)
Traceback (1776):
Module: Kernel::System::DB::new (v1.127) Line: 181
Module: Kernel::System::Web::InterfaceAgent::Run (v1.58) Line: 140
Module: ModPerl::ROOT::ModPerl::Registry::C_3a_OTRS_OTRS_bin_cgi_2dbin_index_2epl::handler (unknown version) Line: 45
Module: (eval) (v1.89) Line: 204
Module: ModPerl::RegistryCooker::run (v1.89) Line: 204
Module: ModPerl::RegistryCooker::default_handler (v1.89) Line: 170
Module: ModPerl::Registry::handler (v1.99) Line: 31
I can connect to the database using sqlplus but not sure what this error could mean. Any Ideas?

[veeracoomar]

Dear All,
I am also facing the same issue. is there any resolution.
Regards,
Kumar

[crythias]

Start here and see if it makes sense (it may not, specifically, with Windows, but it's *possible* the context might be the same: set the Environment variables in Windows)
http://www.nntp.perl.org/group/perl.dbi ... 35625.html
http://www.orafaq.com/wiki/TWO_TASK