>> -----Original Message----- >> From: DBA FARMASA [mailto:[EMAIL PROTECTED] >> Sent: Wednesday, December 14, 2005 11:47 AM >> To: [email protected] >> 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' => '[EMAIL PROTECTED]', >> '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' => '<ADDRESS>Apache/1.3.34 >> Server at suporte.farmasa.local Port 80</ADDRESS> ', >> '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:[EMAIL PROTECTED] > Enviada em: quarta-feira, 14 de dezembro de 2005 17:25 > Para: DBA FARMASA; [email protected] > Assunto: RE: Oracle 10g + Linux RHEL 4 + Perl + DBI = > OCIEnvNlsCreate Error (!?!?) > > > I googled and found this: > > http://www.google.com/search?q=ERROR+OCIEnvNlsCreate&sourceid= > 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.
