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.
OTRS scheduler not working with oracle
Moderator: crythias
-
- 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
Thanks,
Dushyant Dave
9825018647
Dushyant Dave
9825018647
-
- 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
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';
===.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
Dushyant Dave
9825018647
-
- 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
hello
Did you solve this problem??
because i have the same problem and i can't find a solution anywhere
please advice..
Regards,
Did you solve this problem??
because i have the same problem and i can't find a solution anywhere
please advice..
Regards,