Error: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc[..]

Hi OTRS peoples, I am getting the following error from OTRS when I load it up in a browser: ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Mon Mar 5 16:34:01 2007 Message: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. Traceback (14104): Module: Kernel::System::DB::new (v1.57) Line: 172 Module: Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 145 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47 We have checked and the otrs user has all the necessary Oracle env settings ie ORACLE_HOME, ORACLE_BASE, LD_LIBRARY_PATH, however it doesn't seem to like something. Anyone able to assist? -- Andrew Bergman Systems Administrator Microlistics Pty Ltd Direct: +61 3 8329 2050 Mobile: +61 411 706 713 Fax: +61 3 9326 7588 e-mail: andrew.bergman@microlistics.com.au -------------------------------------- "It is the way of the world, Baldrick - the abused always kick downwards. I am annoyed, and so I kick the cat... the cat pounces on the mouse, and finally, the mouse bites you on the behind."

I would investigate the perl modules to make sure you can connect to a database with apache and mod_perl. Have you tried that? -Andy -----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Andrew Bergman Sent: Monday, March 05, 2007 12:39 AM To: otrs@otrs.org Subject: [otrs] Error: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc[..] Hi OTRS peoples, I am getting the following error from OTRS when I load it up in a browser: ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Mon Mar 5 16:34:01 2007 Message: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc. Traceback (14104): Module: Kernel::System::DB::new (v1.57) Line: 172 Module: Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 145 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47 We have checked and the otrs user has all the necessary Oracle env settings ie ORACLE_HOME, ORACLE_BASE, LD_LIBRARY_PATH, however it doesn't seem to like something. Anyone able to assist? -- Andrew Bergman Systems Administrator Microlistics Pty Ltd Direct: +61 3 8329 2050 Mobile: +61 411 706 713 Fax: +61 3 9326 7588 e-mail: andrew.bergman@microlistics.com.au -------------------------------------- "It is the way of the world, Baldrick - the abused always kick downwards. I am annoyed, and so I kick the cat... the cat pounces on the mouse, and finally, the mouse bites you on the behind." _______________________________________________ OTRS mailing list: otrs - Webpage: http://otrs.org/ Archive: http://lists.otrs.org/pipermail/otrs To unsubscribe: http://lists.otrs.org/cgi-bin/listinfo/otrs Support orr consulting for your OTRS system? => http://www.otrs.com/

Cheers for the reply Andy, I would test that if I knew how. I am quite new to all this. Andy Andy Lubel wrote:
I would investigate the perl modules to make sure you can connect to a database with apache and mod_perl. Have you tried that?
-Andy
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Andrew Bergman Sent: Monday, March 05, 2007 12:39 AM To: otrs@otrs.org Subject: [otrs] Error: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc[..]
Hi OTRS peoples,
I am getting the following error from OTRS when I load it up in a browser:
ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Mon Mar 5 16:34:01 2007
Message: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc.
Traceback (14104): Module: Kernel::System::DB::new (v1.57) Line: 172 Module: Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 145 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47
We have checked and the otrs user has all the necessary Oracle env settings ie ORACLE_HOME, ORACLE_BASE, LD_LIBRARY_PATH, however it doesn't seem to like something.
Anyone able to assist?
-- Andrew Bergman Systems Administrator Microlistics Pty Ltd Direct: +61 3 8329 2050 Mobile: +61 411 706 713 Fax: +61 3 9326 7588 e-mail: andrew.bergman@microlistics.com.au -------------------------------------- "It is the way of the world, Baldrick - the abused always kick downwards. I am annoyed, and so I kick the cat... the cat pounces on the mouse, and finally, the mouse bites you on the behind."

Do you run this system (the web server) on windows or linux? If its linux
could you paste a 'uname -a' output?
did you remember doing this (without error)?
#perl -MCPAN -e shell
#install DBD::Oracle
On 3/5/07 5:41 PM, "Andrew Bergman"
Cheers for the reply Andy,
I would test that if I knew how. I am quite new to all this.
Andy
Andy Lubel wrote:
I would investigate the perl modules to make sure you can connect to a database with apache and mod_perl. Have you tried that?
-Andy
-----Original Message----- From: otrs-bounces@otrs.org [mailto:otrs-bounces@otrs.org] On Behalf Of Andrew Bergman Sent: Monday, March 05, 2007 12:39 AM To: otrs@otrs.org Subject: [otrs] Error: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc[..]
Hi OTRS peoples,
I am getting the following error from OTRS when I load it up in a browser:
ERROR: OTRS-CGI-10 Perl: 5.8.5 OS: linux Time: Mon Mar 5 16:34:01 2007
Message: ERROR OCIEnvNlsCreate. Check ORACLE_HOME env var, NLS settings, permissions, etc.
Traceback (14104): Module: Kernel::System::DB::new (v1.57) Line: 172 Module: Kernel::System::Web::InterfaceAgent::Run (v1.17) Line: 145 Module: /opt/otrs/bin/cgi-bin/index.pl (v1.81) Line: 47
We have checked and the otrs user has all the necessary Oracle env settings ie ORACLE_HOME, ORACLE_BASE, LD_LIBRARY_PATH, however it doesn't seem to like something.
Anyone able to assist?
--
participants (2)
-
Andrew Bergman
-
Andy Lubel