Hi all
As a background, I'm quite familiar with Oracle and mostly know my way with Linux, too, but I've no experience on PERL nor RT before. What I'm trying to do is install RT 3.8.8 on Oracle Linux 5.5 and configure it to use an existing remote Oracle 10g database. I've used this installation document http://requesttracker.wikia.com/wiki/CentOS5InstallPlusSome as my guideline, with minor differences in versions etc, and the biggest difference probably is trying to use Oracle DB instead of MySQL, as that's my and the company's clear preference. README.Oracle says "You don't need to create anything beforehead." It seems to be partly true as there should be nothing that needs to be created in the database before installing RT. But for using remote database it seems that Oracle client setup needs to be done on the RT host. Unfortunately I haven't found instructions for that, so I've been trying to figure out the steps myself. So far I've tried several Oracle client configurations. Each time I've prepared the environment so that I could successfully tnsping the target database and connect using sqlplus. However, no success with make fixdeps yet: - First tried a light Oracle client version, Oracle Instant Client v10.1 and 11.2 (11g chosen because it installs more cleanly on Oracle Linux 5.5). Failed with missing .mk files. - Then I tried with normal Oracle Client 11.2 with same problem. - Then I figured out from the error messages that more Oracle SW is needed and found out that to get suitable .mk files installes I must install either whole Oracle database locally or install Oracle demo stuff. - So I installed Oracle DB demo stuff in the Instant Client home first. The .mk problem disappeared, but still it didn't look good because of several errors. - I decided to try the same with standard Oracle 11.2 client home. Again, .mk problem disappeared, but still make fixdeps is unable to connect to the target Oracle database. This time the output starting from the error is as follows: === ... t/10general.t ........... Bailout called. Further testing stopped: Unable to connect to Oracle (ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin)) DBI connect('','scott/tiger',...) failed: ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin) at t/10general.t line 22 FAILED--Further testing stopped: Unable to connect to Oracle (ORA-24327: need explicit attach before authenticating a user (DBD ERROR: OCISessionBegin)) make[1]: *** [test_dynamic] Error 255 make[1]: Leaving directory `/root/.cpan/build/DBD-Oracle-1.27-5tgtqm' PYTHIAN/DBD-Oracle-1.27.tar.gz /usr/bin/make test -- NOT OK //hint// to see the cpan-testers results for installing this module, try: reports PYTHIAN/DBD-Oracle-1.27.tar.gz Running make install make test had returned bad status, won't install without force SMTP dependencies: Net::SMTP ...found STANDALONE dependencies: Net::Server ...found HTTP::Server::Simple >= 0.34 ...found HTTP::Server::Simple::Mason >= 0.09 ...found SOME DEPENDENCIES WERE MISSING. ORACLE missing dependencies: DBD::Oracle ...MISSING Can't locate DBD/Oracle.pm in @INC (@INC contains: /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/site_perl/5.8.8 /usr/lib/perl5/site_perl /usr/lib/perl5/vendor_perl/5.8.8/i386-linux-thread-multi /usr/lib/perl5/vendor_perl/5.8.8 /usr/lib/perl5/vendor_perl /usr/lib/perl5/5.8.8/i386-linux-thread-multi /usr/lib/perl5/5.8.8 /opt/rt3/rt-3.8.8) make: *** [fixdeps] Error 1 === 1. Any suggestions what to try next? There's a hint above that I don't know how to apply. I probably should know some PERL basics. 2. There's probably a way to install DBD::Oracle manually somehow. Could it solve my problem? Can anyone assist / provide steps required to do it? 3. Btw, I've executed these installation steps (and basically all setup tasks before except Oracle client installation) as root in /etc/rt3/rt-3.8.8: ./configure make testdeps PERL_MM_USE_DEFAULT=1 make fixdeps Is it ok or does it cause problems? Should I create some other account and use it? Regards, Tapio Tirkkola [email protected]
