[SOLVED]Installing OTRS with Oracle

[franklinfarias]

Hello everybody!
I'm having problems installing OTRS (Linux-CentOS) with Oracle 10g (External).
I installed the packages from Oracle:
oracle-instantclient11.1-basic
oracle-sqlplus-instantclient11.1
instantclient11.1-oracle-devel
I set the environment variables: ORACLE_HOME, PATH and LD_LIBRARY_PATH.
I configured the file tnsnames.ora in $ ORACLE_HOME/network/admin.
Also install the DBD:: Oracle by CPAN.
I tested access to the Oracle database by sqlplus: sqlplus 'user/pwd@tns'. Getting access to the database normally.
I tested access to OTRS by Oracle, through "otrs.CheckDB.pm"

Code: Select all

Trying to connect to database
             DSN: DBI:Oracle:sid=trn;host=10.16.10.10;port=1521;
             DatabaseUser: otrs

             It looks Ok!

The problem is when I try to access the address is http://localhost/otrs/index.pl get the following error:

Software error:

install_driver(Oracle) failed: Can't load '/usr/lib64/perl5/site_perl/5.8.8/x86_64-linux-thread-multi/auto/DBD/Oracle/Oracle.so' for module DBD::Oracle: libocci.so.11.1: cannot open shared object file: No such file or directory at /usr/lib64/perl5/5.8.8/x86_64-linux-thread-multi/DynaLoader.pm line 230.
at (eval 196) line 3
Compilation failed in require at (eval 196) line 3.
Perhaps a required shared library or dll isn't installed where expected
at /opt/otrs//Kernel/System/DB.pm line 210

What can be? There is something to do with driver I am using?

Franklin Farias
OTRS-CentOS-Oracle10g

[renee]

Compare the environment variables of the user called the script on commandline and the user that runs OTRS. Check the permissions for the files, too. Do you have several Perl versions installed (system perl and an own compiled perl)?

[franklinfarias]

Hello renee.
I checked the environment variables and is ok.
I changed the file permissions, but still did not work.
I have the 5.8.8 version of Perl installed only. Is there another command I can run back to other versions of Perl?

[ferrosti]

Can you please do a

Code: Select all

su otrs -c <path_to_otrs_bin_dir>otrs.CheckDB.pl

In case it works also try the same above with your webserver user

Code: Select all

su <webserver_user> -c <path_to_otrs_bin_dir>otrs.CheckDB.pl

What does it say?

Is everything fine running

Code: Select all

<path_to_otrs_bin_dir>otrs.CheckModules.pl

[franklinfarias]

And installed a new server as follows:
- So I entered CPAN (perl-MCPAN-e shell) and downloaded the package DBD:: Oracle, just downloaded;
- Oracle clients installed: oracle-instantclient11.1-basic-xx.xxxx-x.i386.rpm, instantclient11.1-oracle-sqlplus-xx.xxxx x.i386.rpm-and-oracle-devel-instantclient11.1 xx.xxxx-x.i386.rpm, respectively;
- Set the Oracle environment variables: export ORACLE_HOME, PATH, and LD_LIBRARY_PATH ORACLE_USERID;
- Configure the tnsnames.ora;
- I entered the CPAN download directory, where you downloaded the package DBD:: Oracle and ran the commands:
# Perl MakeFile.pl
# make
# Make test
# Make install
Following these steps could access the OTRS with Oracle.
Thank you!
----pt-BR-----
Instalei e um novo servidor da seguinte maneira:
- Entrei em modo CPAN (perl -MCPAN -e shell) e baixei o pacote DBD::Oracle, somente baixei;
- Instalei os clientes Oracle: oracle-instantclient11.1-basic-xx.xxxx-x.i386.rpm, oracle-instantclient11.1-sqlplus-xx.xxxx-x.i386.rpm e oracle-instantclient11.1-devel-xx.xxxx-x.i386.rpm, respectivamente;
- Configurei as variáveis de ambiente do Oracle: export ORACLE_HOME, PATH, LD_LIBRARY_PATH e ORACLE_USERID;
- Configurei o tnsnames.ora;
- Entrei no diretório de download do CPAN, onde baixou o pacote DBD::Oracle e executei o comandos:
# perl MakeFile.pl
# make
# make test
# make install
Seguindo estes passos consegui acessar o OTRS com Oracle.
Obrigado!!!