[otrs] Problem with Otrs and Oracle

11 Feb 2009

      Hi to all.

I successfully installed OTRS 2.1.7 on openSUSE 10.3 and MySql. (Linux svrhd
2.6.22.19-0.2-default #1 SMP 2008-12-18 10:17:03 +0100 i686 i686 i386
GNU/Linux)

Now I'm trying to make Otrs work with Oracle, for database consolidation
purpouse.

I installed Oracle client and DBD::Oracle. Running bin/CheckDB.pl says "It
looks Ok!".

When I try to open the application from the web browser (index.pl) I get
this error:

ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Wed Feb 11 18:02:40 2009

Message: ERROR OCIEnvNlsCreate. Check ORACLE_HOME (Linux) env var  or PATH
(Windows) and or NLS settings, permissions, etc.

Traceback (3105):

   Module: Kernel::System::DB::new (v1.57) Line: 172

   Module: Kernel::System::Web::InterfaceAgent::Run (v1.17.2.1) Line: 145

   Module:
ModPerl::ROOT::ModPerl::Registry::opt_otrs_bin_cgi_2dbin_index_2epl::handler
(v) Line: 47

   Module: (eval) (v1.81) Line: 204

   Module: ModPerl::RegistryCooker::run (v1.81) Line: 204

   Module: ModPerl::RegistryCooker::default_handler (v1.81) Line: 170

   Module: ModPerl::Registry::handler (v1.99) Line: 31

This is the content of Config.pl

    # ---------------------------------------------------- #

    # ---------------------------------------------------- #

    #                                                      #

    #         Start of your own config options!!!          #

    #                                                      #

    # ---------------------------------------------------- #

    # ---------------------------------------------------- #

    $ENV{ORACLE_HOME} = '/opt/oracle/product/10.2.0/client_1';

    $ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';

    $ENV{NLS_LANG} = 'GERMAN_GERMANY.UTF8';

    $ENV{ORACLE_BASE}='/opt/oracle/product';

    $ENV{ORACLE_HOME}='/opt/oracle/product/10.2.0/client_1';

    $ENV{LD_LIBRARY_PATH}='/opt/oracle/product/10.2.0/client_1/lib';

    $ENV{ORACLE_SID}='REDB';

    # ---------------------------------------------------- #

    # database settings                                    #

    # ---------------------------------------------------- #

    # DatabaseHost

    # (The database host.)

    $Self->{'DatabaseHost'} = '172.25.43.11';

    # Database

    # (The database name.)

    $Self->{'Database'} = 'REDB';

    # DatabaseUser

    # (The database user.)

    $Self->{'DatabaseUser'} = 'otrs';

    # DatabasePw

    # (The password of database user. You also can use bin/CryptPassword.pl

    # for crypted passwords.)

    $Self->{'DatabasePw'} = 'otrs1234';

    # DatabaseDSN

    # (The database DSN for MySQL ==> more: "man DBD::mysql")

    #$Self->{DatabaseDSN} =
"DBI:mysql:database=$Self->{Database};host=$Self->{DatabaseHost};";

    # (The database DSN for Oracle ==> more: "man DBD::oracle")

     $Self->{DatabaseDSN} =
"DBI:Oracle:sid=$Self->{Database};host=$Self->{DatabaseHost};port=1521;";

I tought about an environment problem, so I added the following lines in
/etc/environment, but nothing changed:

ORACLE_BASE=/opt/oracle/product

ORACLE_HOME=/opt/oracle/product/10.2.0/client_1

LD_LIBRARY_PATH=/opt/oracle/product/10.2.0/client_1/lib

ORACLE_SID=REDB

NLS_DATE_FORMAT='YYYY-MM-DD HH24:MI:SS'

NLS_LANG="GERMAN_GERMANY.UTF8"

Any suggestions?

Thanks

Gianni

[otrs] Problem with Otrs and Oracle

Gianni Bracali