OTRS scheduler not working with oracle

Moderator: crythias

Locked
dushyantmdave
Znuny newbie
Posts: 36
Joined: 05 Jan 2013, 14:21
Znuny Version: 3.2.1
Real Name: Dushyant
Company: Elitecore Technologies
Location: India
Contact:

OTRS scheduler not working with oracle

Post by dushyantmdave »

Hi,

I got error when starting scheduler:
/opt/otrs/bin/otrs.Scheduler.pl -a start
DBD::Oracle::db disconnect failed: ORA-03113: end-of-file on communication channel
Process ID: 0
Session ID: 125 Serial number: 30 (DBD ERROR: OCISessionEnd) at /opt/otrs/Kernel/System/DB.pm line 301.
Thanks,
Dushyant Dave
9825018647
dushyantmdave
Znuny newbie
Posts: 36
Joined: 05 Jan 2013, 14:21
Znuny Version: 3.2.1
Real Name: Dushyant
Company: Elitecore Technologies
Location: India
Contact:

Re: OTRS scheduler not working with oracle

Post by dushyantmdave »

My env variables as below and I am able to use OTRS portal

===.bash_profile
export ORACLE_BASE=/u01/app/oracle/
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=otrs
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=/u01/app/oracle/product/11.2.0/dbhome_1/lib
export HOME_OTRS=/opt/otrs
export ORACLE_USERID="otrs/otrs@otrs"
export TWO_TASK='//localhost:1521/otrs'

=======apache2-perl-startup.pl
$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
$ENV{NLS_LANG} = "AMERICAN_AMERICA.UTF8";
use DBD::Oracle ();
use Kernel::System::DB::oracle;

=========Config.pm
$Self->{DatabaseHost} = 'localhost';
$Self->{Database} = 'otrs';
$Self->{DatabaseUser} = 'otrs';
$Self->{DatabasePw} = 'otrs';
$Self->{DatabaseDSN} = "DBI:Oracle:sid=$Self->{Database};host=$Self->{DatabaseHost};port=1521;";
$ENV{ORACLE_HOME} = '/u01/app/oracle/product/11.2.0/dbhome_1';
$ENV{NLS_DATE_FORMAT} = 'YYYY-MM-DD HH24:MI:SS';
$ENV{NLS_LANG} = 'AMERICAN_AMERICA.utf8';
Thanks,
Dushyant Dave
9825018647
memmy
Znuny newbie
Posts: 3
Joined: 26 Jan 2014, 12:13
Znuny Version: OTRS v3.3
Real Name: Mohamed Mahmoud
Company: Zamil Steel Egypt

Re: OTRS scheduler not working with oracle

Post by memmy »

hello

Did you solve this problem??
because i have the same problem and i can't find a solution anywhere

please advice..

Regards,
Locked