Then it is permissions. -----Original Message----- From: DBA FARMASA [mailto:[EMAIL PROTECTED] Sent: Monday, December 19, 2005 9:46 AM To: [email protected] Subject: RES: Oracle 10g + Linux RHEL 4 + Perl + DBI = OCIEnvNlsCreate Error (!?!?)
>> -----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. This electronic message transmission is a PRIVATE communication which contains information which may be confidential or privileged. The information is intended to be for the use of the individual or entity named above. If you are not the intended recipient, please be aware that any disclosure, copying, distribution 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.
