On 14 November 2017 at 17:00, Roy Kaldung wrote:

Hi Amey,

...

On Nov 14, 2017, at 10:38 AM, Amey Abhyankar wrote:

I tried to search relevant documents/guide on how to connect OTRS to Oracle12c DB installed on a separate system but unable to find any.

First step is to prepare the system as an Oracle client. Usually the Instant Client is sufficient. Install the client with header files, DBD::Oracle needs to be build via cpan. You Oracle DBA should be able to do this. Everything else is described in the OTRS manual.

Thanks. On last step the HTML doc asks to edit = Kernel/Config.pm to provide ORACLE_HOME Where to find this this dir? I am using Cent OS 6.8 [64bit] After locating Config.pm, I got several dir's as follows = ------------------------------------------------------------------------- [root@otrs oracle]# locate Config.pm /usr/lib64/perl5/Config.pm /usr/lib64/perl5/Encode/Config.pm /usr/share/automake-1.11/Automake/Config.pm /usr/share/perl5/CPAN/HandleConfig.pm /usr/share/perl5/CPANPLUS/Config.pm /usr/share/perl5/ExtUtils/MakeMaker/Config.pm /usr/share/perl5/Log/Message/Config.pm /usr/share/perl5/Module/Build/Config.pm /usr/share/perl5/Net/Config.pm /usr/share/perl5/vendor_perl/HTTP/Config.pm [root@otrs oracle]# locate Kernel /etc/libreport/events/report_Kerneloops.xml /usr/include/c++/4.4.4/java/awt/image/Kernel.h ------------------------------------------------------------------------- Regards, Amey.

- Roy

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs

On 22 November 2017 at 12:02, Renee B wrote:

Am 22.11.2017 um 07:01 schrieb Amey Abhyankar:

...

Thanks.

On last step the HTML doc asks to edit = Kernel/Config.pm to provide ORACLE_HOME

Where to find this this dir?

It's /Kernel/Config.pm

So, if you have installed OTRS in /opt/otrs, it's /opt/otrs/Kernel/Config.pm

Thanks Renee for the update. I thought 1st I need to prepare Oracle drivers & then install OTRS software on the same system = http://doc.otrs.com/doc/manual/admin/5.0/en/html/installation.html#installat... Is it fine if I proceed with OTRS 5.0.24 installation now [using RPM package] or I need to roll back & do the OTRS installation 1st & then compile Oracle drivers? Thanks & Regards, Amey.

Kind regards, Renée

-- Perl / OTRS development: http://perl-services.de OTRS AddOn repository: http://opar.perl-services.de

--------------------------------------------------------------------- OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/mailman/listinfo/otrs