Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

am 14.12.2005 19:46:55 von DBA

Hi fellows.

I'm banging my head on this problem for a month, and posted on London
PM without a good clue. Maybe you folks can help me a little bit more.

I need to connect Best Pratical's RT 3.4.4 to an Oracle 10g Database
running on the same box. I'm using the mod_perl 1.29 and apache 1.3.34,
and running perl 5.8.5.

The RT configuration was easy, and I generated the database structure
using user root (with the proper environment variables set) without a
single annormal incident.

Now, trying to start apache web server, I only get errors like this
one:

------------------------------------------------------------ -----------
$VAR1 = {
'NLS_LANG' => 'AMERICAN_AMERICA.AL32UTF8',
'SCRIPT_NAME' => '',
'SERVER_NAME' => 'suporte.farmasa.local',
'ORACLE_HOME' => '/opt/oracle/software/10.2.0.1',
'NLS_NCHAR' => 'AL32UTF8',
'SERVER_ADMIN' => 'dba@farmasa.com.br',
'HTTP_ACCEPT_ENCODING' => 'gzip, deflate',
'PATH_INFO' => '/',
'HTTP_CONNECTION' => 'Keep-Alive',
'REQUEST_METHOD' => 'GET',
'HTTP_ACCEPT' => '*/*',
'SCRIPT_FILENAME' => '/usr/local/rt/share/html',
'SERVER_SOFTWARE' => 'Apache/1.3.34 (Unix) mod_perl/1.29',
'QUERY_STRING' => '',
'REMOTE_PORT' => '2045',
'HTTP_USER_AGENT' => 'Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.1; SV1; .NET CLR 1.1.4322)',
'SERVER_SIGNATURE' => '

Apache/1.3.34 Server at
suporte.farmasa.local Port 80

',
'SERVER_PORT' => '80',
'ORACLE_SID' => 'DEVEL',
'HTTP_ACCEPT_LANGUAGE' => 'pt-br',
'REMOTE_ADDR' => '192.168.87.175',
'SERVER_PROTOCOL' => 'HTTP/1.1',
'PATH' => '/bin:/usr/bin',
'REQUEST_URI' => '/',
'GATEWAY_INTERFACE' => 'CGI-Perl/1.1',
'SERVER_ADDR' => '192.168.87.20',
'DOCUMENT_ROOT' => '/usr/local/rt/share/html',
'PATH_TRANSLATED' => '/usr/local/rt/share/html/',
'HTTP_HOST' => 'suporte',
'MOD_PERL' => 'mod_perl/1.29'
};
DBI connect('DEVEL','rt',...) failed: ERROR OCIEnvNlsCreate (check
ORACLE_HOME and NLS settings etc.) at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 108
[Fri Dec 9 16:27:29 2005] [error] Connect Failed ERROR OCIEnvNlsCreate
(check ORACLE_HOME and NLS settings etc.)\n at /usr/local/rt/lib/RT.pm
line 176\n
------------------------------------------------------------ -----------

I've arranged so the env variables get Data::Dump()'ed to the STDERR,
so I can register them on logs just before trying to stablish a
connection.

Please help me. I don't know what to try next.
Thanks
--
Luis Campos de Carvalho
DBA Oracle - FARMASA

Esta mensagem tem como destinatario exclusivo a pessoa ou organizacao a que esta dirigida e pode conter informacoes confidenciais que nao podem ser divulgadas. Se voce recebeu esta mensagem por engano, lhe e vetado divulgar, distribuir ou copiar a informacao aqui contida. Ficaremos gratos se voce notificar o erro imediatamente por e-mail ao remetente e apagar esta mensagem de seu sistema. Obrigado pela sua cooperacao.

This e-mail is meant only for the intended recipient of the transmission, and may be a communication privileged by law. If you received this e-mail in error, any review, use, dissemination, distribution or copying of this e-mail is strictly prohibited. Please notify us immediately of the error by return e-mail and please delete this message from your system. Thank you in advance for your cooperation.

RE: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

am 14.12.2005 21:24:32 von Ron.Reidy

I googled and found this:

http://www.google.com/search?q=3DERROR+OCIEnvNlsCreate&sourc eid=3Dmozilla=
-se
arch&start=3D0&start=3D0&ie=3Dutf-8&oe=3Dutf-8&client=3Dfire fox-a&rls=3Do=
rg.mozilla:
en-US:official

Can you run a simple script from the command line as:

1. Yourself?
2. The owner of the Apache software?

Check permissions of $ORACLE_HOME/bin and $ORACLE_HOME/lib

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: DBA FARMASA [mailto:dba@farmasa.com.br]=20
Sent: Wednesday, December 14, 2005 11:47 AM
To: dbi-users@perl.org
Subject: Oracle 10g + Linux RHEL 4 + Perl + DBI =3D OCIEnvNlsCreate =
Error
(!?!?)

Hi fellows.

I'm banging my head on this problem for a month, and posted on London
PM without a good clue. Maybe you folks can help me a little bit more.

I need to connect Best Pratical's RT 3.4.4 to an Oracle 10g Database
running on the same box. I'm using the mod_perl 1.29 and apache 1.3.34,
and running perl 5.8.5.

The RT configuration was easy, and I generated the database structure
using user root (with the proper environment variables set) without a
single annormal incident.

Now, trying to start apache web server, I only get errors like this
one:

------------------------------------------------------------ -----------
$VAR1 =3D {
'NLS_LANG' =3D> 'AMERICAN_AMERICA.AL32UTF8',
'SCRIPT_NAME' =3D> '',
'SERVER_NAME' =3D> 'suporte.farmasa.local',
'ORACLE_HOME' =3D> '/opt/oracle/software/10.2.0.1',
'NLS_NCHAR' =3D> 'AL32UTF8',
'SERVER_ADMIN' =3D> 'dba@farmasa.com.br',
'HTTP_ACCEPT_ENCODING' =3D> 'gzip, deflate',
'PATH_INFO' =3D> '/',
'HTTP_CONNECTION' =3D> 'Keep-Alive',
'REQUEST_METHOD' =3D> 'GET',
'HTTP_ACCEPT' =3D> '*/*',
'SCRIPT_FILENAME' =3D> '/usr/local/rt/share/html',
'SERVER_SOFTWARE' =3D> 'Apache/1.3.34 (Unix) mod_perl/1.29',
'QUERY_STRING' =3D> '',
'REMOTE_PORT' =3D> '2045',
'HTTP_USER_AGENT' =3D> 'Mozilla/4.0 (compatible; MSIE 6.0;
Windows NT 5.1; SV1; .NET CLR 1.1.4322)',
'SERVER_SIGNATURE' =3D> '

Apache/1.3.34 Server at
suporte.farmasa.local Port 80

',
'SERVER_PORT' =3D> '80',
'ORACLE_SID' =3D> 'DEVEL',
'HTTP_ACCEPT_LANGUAGE' =3D> 'pt-br',
'REMOTE_ADDR' =3D> '192.168.87.175',
'SERVER_PROTOCOL' =3D> 'HTTP/1.1',
'PATH' =3D> '/bin:/usr/bin',
'REQUEST_URI' =3D> '/',
'GATEWAY_INTERFACE' =3D> 'CGI-Perl/1.1',
'SERVER_ADDR' =3D> '192.168.87.20',
'DOCUMENT_ROOT' =3D> '/usr/local/rt/share/html',
'PATH_TRANSLATED' =3D> '/usr/local/rt/share/html/',
'HTTP_HOST' =3D> 'suporte',
'MOD_PERL' =3D> 'mod_perl/1.29'
};
DBI connect('DEVEL','rt',...) failed: ERROR OCIEnvNlsCreate (check
ORACLE_HOME and NLS settings etc.) at
/usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm line 108
[Fri Dec 9 16:27:29 2005] [error] Connect Failed ERROR OCIEnvNlsCreate
(check ORACLE_HOME and NLS settings etc.)\n at /usr/local/rt/lib/RT.pm
line 176\n
------------------------------------------------------------ -----------

I've arranged so the env variables get Data::Dump()'ed to the STDERR,
so I can register them on logs just before trying to stablish a
connection.

Please help me. I don't know what to try next.
Thanks
--
Luis Campos de Carvalho
DBA Oracle - FARMASA

Esta mensagem tem como destinatario exclusivo a pessoa ou organizacao a
que esta dirigida e pode conter informacoes confidenciais que nao podem
ser divulgadas. Se voce recebeu esta mensagem por engano, lhe e vetado
divulgar, distribuir ou copiar a informacao aqui contida. Ficaremos
gratos se voce notificar o erro imediatamente por e-mail ao remetente e
apagar esta mensagem de seu sistema. Obrigado pela sua cooperacao.

This e-mail is meant only for the intended recipient of the
transmission, and may be a communication privileged by law. If you
received this e-mail in error, any review, use, dissemination,
distribution or copying of this e-mail is strictly prohibited. Please
notify us immediately of the error by return e-mail and please delete
this message from your system. Thank you in advance for your
cooperation.

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

RES: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

am 19.12.2005 17:45:39 von DBA

>> -----Original Message-----
>> From: DBA FARMASA [mailto:dba@farmasa.com.br]
>> Sent: Wednesday, December 14, 2005 11:47 AM
>> To: dbi-users@perl.org
>> Subject: Oracle 10g + Linux RHEL 4 + Perl + DBI =
>> OCIEnvNlsCreate Error
>> (!?!?)
>>
>>
>> Hi fellows.
>>
>> I'm banging my head on this problem for a month, and posted
>> on London PM without a good clue. Maybe you folks can help me
>> a little bit more.
>>
>> I need to connect Best Pratical's RT 3.4.4 to an Oracle 10g
>> Database running on the same box. I'm using the mod_perl 1.29
>> and apache 1.3.34, and running perl 5.8.5.
>>
>> The RT configuration was easy, and I generated the database
>> structure using user root (with the proper environment
>> variables set) without a single annormal incident.
>>
>> Now, trying to start apache web server, I only get errors like this
>> one:
>>
>> ------------------------------------------------------------ --
>> ---------
>> $VAR1 = {
>> 'NLS_LANG' => 'AMERICAN_AMERICA.AL32UTF8',
>> 'SCRIPT_NAME' => '',
>> 'SERVER_NAME' => 'suporte.farmasa.local',
>> 'ORACLE_HOME' => '/opt/oracle/software/10.2.0.1',
>> 'NLS_NCHAR' => 'AL32UTF8',
>> 'SERVER_ADMIN' => 'dba@farmasa.com.br',
>> 'HTTP_ACCEPT_ENCODING' => 'gzip, deflate',
>> 'PATH_INFO' => '/',
>> 'HTTP_CONNECTION' => 'Keep-Alive',
>> 'REQUEST_METHOD' => 'GET',
>> 'HTTP_ACCEPT' => '*/*',
>> 'SCRIPT_FILENAME' => '/usr/local/rt/share/html',
>> 'SERVER_SOFTWARE' => 'Apache/1.3.34 (Unix) mod_perl/1.29',
>> 'QUERY_STRING' => '',
>> 'REMOTE_PORT' => '2045',
>> 'HTTP_USER_AGENT' => 'Mozilla/4.0 (compatible; MSIE
>> 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)',
>> 'SERVER_SIGNATURE' => '

Apache/1.3.34
>> Server at suporte.farmasa.local Port 80

',
>> 'SERVER_PORT' => '80',
>> 'ORACLE_SID' => 'DEVEL',
>> 'HTTP_ACCEPT_LANGUAGE' => 'pt-br',
>> 'REMOTE_ADDR' => '192.168.87.175',
>> 'SERVER_PROTOCOL' => 'HTTP/1.1',
>> 'PATH' => '/bin:/usr/bin',
>> 'REQUEST_URI' => '/',
>> 'GATEWAY_INTERFACE' => 'CGI-Perl/1.1',
>> 'SERVER_ADDR' => '192.168.87.20',
>> 'DOCUMENT_ROOT' => '/usr/local/rt/share/html',
>> 'PATH_TRANSLATED' => '/usr/local/rt/share/html/',
>> 'HTTP_HOST' => 'suporte',
>> 'MOD_PERL' => 'mod_perl/1.29'
>> };
>> DBI connect('DEVEL','rt',...) failed: ERROR OCIEnvNlsCreate
>> (check ORACLE_HOME and NLS settings etc.) at
>> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm
>> line 108 [Fri Dec 9 16:27:29 2005] [error] Connect Failed
>> ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings
>> etc.)\n at /usr/local/rt/lib/RT.pm line 176\n
>> ------------------------------------------------------------ --
>> ---------
>>
>> I've arranged so the env variables get Data::Dump()'ed to
>> the STDERR, so I can register them on logs just before trying
>> to stablish a connection.
>>
>> Please help me. I don't know what to try next.
>> Thanks
>> --
>> Luis Campos de Carvalho
>> DBA Oracle - FARMASA

> -----Mensagem original-----
> De: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
> Enviada em: quarta-feira, 14 de dezembro de 2005 17:25
> Para: DBA FARMASA; dbi-users@perl.org
> Assunto: RE: Oracle 10g + Linux RHEL 4 + Perl + DBI =
> OCIEnvNlsCreate Error (!?!?)
>
>
> I googled and found this:
>
> http://www.google.com/search?q=ERROR+OCIEnvNlsCreate&sourcei d=
> mozilla-se
> arch&start=0&start=0&ie=utf-8&oe=utf-8&client=firefox-a&rls= or
> g.mozilla:
> en-US:official
>
> Can you run a simple script from the command line as:
>
> 1. Yourself?
> 2. The owner of the Apache software?
>
> Check permissions of $ORACLE_HOME/bin and $ORACLE_HOME/lib
>
> --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.

No, and no. I can't run the same perl script using any other user than
root.
It allways fail with the same message.

--
Luis Campos de Carvalho
DBA Oracle - FARMASA

Esta mensagem tem como destinatario exclusivo a pessoa ou organizacao a que esta dirigida e pode conter informacoes confidenciais que nao podem ser divulgadas. Se voce recebeu esta mensagem por engano, lhe e vetado divulgar, distribuir ou copiar a informacao aqui contida. Ficaremos gratos se voce notificar o erro imediatamente por e-mail ao remetente e apagar esta mensagem de seu sistema. Obrigado pela sua cooperacao.

This e-mail is meant only for the intended recipient of the transmission, and may be a communication privileged by law. If you received this e-mail in error, any review, use, dissemination, distribution or copying of this e-mail is strictly prohibited. Please notify us immediately of the error by return e-mail and please delete this message from your system. Thank you in advance for your cooperation.

RE: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)

am 20.12.2005 00:42:06 von Ron.Reidy

Then it is permissions.

-----Original Message-----
From: DBA FARMASA [mailto:dba@farmasa.com.br]=20
Sent: Monday, December 19, 2005 9:46 AM
To: dbi-users@perl.org
Subject: RES: Oracle 10g + Linux RHEL 4 + Perl + DBI =3D OCIEnvNlsCreate
Error (!?!?)

>> -----Original Message-----
>> From: DBA FARMASA [mailto:dba@farmasa.com.br]
>> Sent: Wednesday, December 14, 2005 11:47 AM
>> To: dbi-users@perl.org
>> Subject: Oracle 10g + Linux RHEL 4 + Perl + DBI =
>> OCIEnvNlsCreate Error
>> (!?!?)
>>=20
>>=20
>> Hi fellows.
>>=20
>> I'm banging my head on this problem for a month, and posted
>> on London PM without a good clue. Maybe you folks can help me=20
>> a little bit more.
>>=20
>> I need to connect Best Pratical's RT 3.4.4 to an Oracle 10g
>> Database running on the same box. I'm using the mod_perl 1.29=20
>> and apache 1.3.34, and running perl 5.8.5.
>>=20
>> The RT configuration was easy, and I generated the database
>> structure using user root (with the proper environment=20
>> variables set) without a single annormal incident.
>>=20
>> Now, trying to start apache web server, I only get errors like this
>> one:
>>=20
>> ------------------------------------------------------------ --
>> ---------
>> $VAR1 =3D {
>> 'NLS_LANG' =3D> 'AMERICAN_AMERICA.AL32UTF8',
>> 'SCRIPT_NAME' =3D> '',
>> 'SERVER_NAME' =3D> 'suporte.farmasa.local',
>> 'ORACLE_HOME' =3D> '/opt/oracle/software/10.2.0.1',
>> 'NLS_NCHAR' =3D> 'AL32UTF8',
>> 'SERVER_ADMIN' =3D> 'dba@farmasa.com.br',
>> 'HTTP_ACCEPT_ENCODING' =3D> 'gzip, deflate',
>> 'PATH_INFO' =3D> '/',
>> 'HTTP_CONNECTION' =3D> 'Keep-Alive',
>> 'REQUEST_METHOD' =3D> 'GET',
>> 'HTTP_ACCEPT' =3D> '*/*',
>> 'SCRIPT_FILENAME' =3D> '/usr/local/rt/share/html',
>> 'SERVER_SOFTWARE' =3D> 'Apache/1.3.34 (Unix) =
mod_perl/1.29',
>> 'QUERY_STRING' =3D> '',
>> 'REMOTE_PORT' =3D> '2045',
>> 'HTTP_USER_AGENT' =3D> 'Mozilla/4.0 (compatible; MSIE
>> 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322)',
>> 'SERVER_SIGNATURE' =3D> '

Apache/1.3.34=20
>> Server at suporte.farmasa.local Port 80

',
>> 'SERVER_PORT' =3D> '80',
>> 'ORACLE_SID' =3D> 'DEVEL',
>> 'HTTP_ACCEPT_LANGUAGE' =3D> 'pt-br',
>> 'REMOTE_ADDR' =3D> '192.168.87.175',
>> 'SERVER_PROTOCOL' =3D> 'HTTP/1.1',
>> 'PATH' =3D> '/bin:/usr/bin',
>> 'REQUEST_URI' =3D> '/',
>> 'GATEWAY_INTERFACE' =3D> 'CGI-Perl/1.1',
>> 'SERVER_ADDR' =3D> '192.168.87.20',
>> 'DOCUMENT_ROOT' =3D> '/usr/local/rt/share/html',
>> 'PATH_TRANSLATED' =3D> '/usr/local/rt/share/html/',
>> 'HTTP_HOST' =3D> 'suporte',
>> 'MOD_PERL' =3D> 'mod_perl/1.29'
>> };
>> DBI connect('DEVEL','rt',...) failed: ERROR OCIEnvNlsCreate=20
>> (check ORACLE_HOME and NLS settings etc.) at=20
>> /usr/lib/perl5/site_perl/5.8.5/DBIx/SearchBuilder/Handle.pm= 20
>> line 108 [Fri Dec 9 16:27:29 2005] [error] Connect Failed=20
>> ERROR OCIEnvNlsCreate (check ORACLE_HOME and NLS settings=20
>> etc.)\n at /usr/local/rt/lib/RT.pm line 176\n
>> ------------------------------------------------------------ --
>> ---------
>>=20
>> I've arranged so the env variables get Data::Dump()'ed to
>> the STDERR, so I can register them on logs just before trying=20
>> to stablish a connection.
>>=20
>> Please help me. I don't know what to try next.
>> Thanks
>> --
>> Luis Campos de Carvalho
>> DBA Oracle - FARMASA

> -----Mensagem original-----
> De: Reidy, Ron [mailto:Ron.Reidy@arraybiopharma.com]
> Enviada em: quarta-feira, 14 de dezembro de 2005 17:25
> Para: DBA FARMASA; dbi-users@perl.org
> Assunto: RE: Oracle 10g + Linux RHEL 4 + Perl + DBI =
> OCIEnvNlsCreate Error (!?!?)
>=20
>=20
> I googled and found this:
>=20
> http://www.google.com/search?q=3DERROR+OCIEnvNlsCreate&sourc eid=3D
> mozilla-se=20
> =
arch&start=3D0&start=3D0&ie=3Dutf-8&oe=3Dutf-8&client=3Dfire fox-a&rls=3Do=
r
> g.mozilla:
> en-US:official
>=20
> Can you run a simple script from the command line as:
>=20
> 1. Yourself?
> 2. The owner of the Apache software?
>=20
> Check permissions of $ORACLE_HOME/bin and $ORACLE_HOME/lib
>=20
> --
> Ron Reidy
> Lead DBA
> Array BioPharma, Inc.

No, and no. I can't run the same perl script using any other user than
root.
It allways fail with the same message.

--
Luis Campos de Carvalho
DBA Oracle - FARMASA

Esta mensagem tem como destinatario exclusivo a pessoa ou organizacao a
que esta dirigida e pode conter informacoes confidenciais que nao podem
ser divulgadas. Se voce recebeu esta mensagem por engano, lhe e vetado
divulgar, distribuir ou copiar a informacao aqui contida. Ficaremos
gratos se voce notificar o erro imediatamente por e-mail ao remetente e
apagar esta mensagem de seu sistema. Obrigado pela sua cooperacao.

This e-mail is meant only for the intended recipient of the
transmission, and may be a communication privileged by law. If you
received this e-mail in error, any review, use, dissemination,
distribution or copying of this e-mail is strictly prohibited. Please
notify us immediately of the error by return e-mail and please delete
this message from your system. Thank you in advance for your
cooperation.

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.