O ldd esta ok, como posso achar os diretorios de pesquisa do Perl? B-)
Aldrey Galindo-2 wrote: > > Pode ser também algum problema que o SO não consegui encontrar a > 'libclntsh.so.10.1'. Você pode executar '$ ldd > /usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so'. > Se ele der 'not found' nele, então é isso. Aí você pode informar ao SO > em '/etc/ld.so.conf' ou '/etc/ld.so.conf.d/oracle.conf', aí dentro do > arquivo você coloca o caminho da lib (ex: '/opt/oracle-versao/lib'). > > Abraços, > Aldrey Galindo > > 2009/1/28 <[email protected]>: >> >> Oi pessoal, o trecho chave da mensagem de erro é esse: >> libclntsh.so.10.1: cannot open shared object file >> >> O driver do oracle DBD::Oracle não ta conseguindo carregar essa >> biblioteca libclntsh.so.10.1 >> esse arquivo deve existir uma vezq eu se conseguiu instalar o >> DBD::Oracle, mas talvez não esteja em um diretório de pesquisa do perl >> >> >> >> >> On Wed, 28 Jan 2009 10:56:45 -0200, "Dickson S. Guedes" >> <[email protected]> wrote: >>> javaone escreveu: >>>> Ola, apos instalar o dbi link tento rodar um pequeno script de teste >>>> mas >>> o >>>> seguinte erro é retornado: >>>> >>>> dbhab_teste=# \i dbi_teste_ora.sql >>>> SELECT dbi_link.make_accessor_functions( >>>> 'dbi:Oracle:sid=veides2;host=172.25.136.85'::dbi_link.data_source, >>>> 'abc'::text, >>>> 'def'::text, >>>> '--- >>>> AutoCommit: 1 >>>> RaiseError: 1 >>>> '::dbi_link.yaml, >>>> NULL::dbi_link.yaml, >>>> NULL::text, >>>> NULL::text, >>>> 'veides2'::text >>>> ); >>>> psql:dbi_teste_ora.sql:13: NOTA: Setting bail in %_SHARED hash. at >>>> line >>> 25. >>>> >>>> CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()" >>>> psql:dbi_teste_ora.sql:13: NOTA: Setting quote_literal in %_SHARED >>> hash. at >>>> line 25. >>>> >>>> CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()" >>>> psql:dbi_teste_ora.sql:13: NOTA: Setting get_connection_info in >>> %_SHARED >>>> hash. at line 25. >>>> >>>> CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()" >>>> psql:dbi_teste_ora.sql:13: NOTA: Setting quote_ident in %_SHARED hash. >>> at >>>> line 25. >>>> >>>> CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()" >>>> psql:dbi_teste_ora.sql:13: NOTA: Setting get_dbh in %_SHARED hash. at >>> line >>>> 25. >>>> >>>> CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()" >>>> psql:dbi_teste_ora.sql:13: NOTA: Setting remote_exec_dbh in %_SHARED >>> hash. >>>> at line 25. >>>> >>>> CONTEXTO: comando SQL "SELECT dbi_link.dbi_link_init()" >>>> psql:dbi_teste_ora.sql:13: NOTA: SELECT dbi_link.set_up_connection( >>>> 'dbi:Oracle:sid=veides2;host=172.25.136.85', >>>> 'abc', >>>> 'def', >>>> '--- >>>> AutoCommit: 1 >>>> RaiseError: 1 >>>> ', >>>> NULL, >>>> NULL, >>>> NULL, >>>> 'veides2' >>>> ) >>>> >>>> psql:dbi_teste_ora.sql:13: NOTA: SELECT count(*) AS "driver_there" >>>> FROM dbi_link.available_drivers() >>>> WHERE available_drivers = 'dbi:Oracle:sid=veides2;host=172.25.136.85' >>>> >>>> CONTEXTO: comando SQL "SELECT dbi_link.set_up_connection( >>>> 'dbi:Oracle:sid=veides2;host=172.25.136.85', >>>> 'abc', >>>> 'def', >>>> '--- >>>> AutoCommit: 1 >>>> RaiseError: 1 >>>> ', >>>> NULL, >>>> NULL, >>>> NULL, >>>> 'veides2' >>>> ) >>>> " >>>> psql:dbi_teste_ora.sql:13: ERRO: error from Perl function >>>> "make_accessor_functions": error from Perl function >>>> "set_up_connection": >>>> install_driver(Oracle) failed: Can't load >>>> >>> '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' >>>> for module DBD::Oracle: libclntsh.so.10.1: cannot open shared object >>> file: >>>> Arquivo ou diretório não encontrado at >>>> /usr/lib/perl5/5.8.8/i386-linux-thread-multi/DynaLoader.pm line 230. >>>> at line 3 >>>> Compilation failed in require at line 3. >>>> Perhaps a required shared library or dll isn't installed where expected >>>> at line 37 at line 35. >>>> >>>> O que pode ser? >>>> >>> >>> >>> O arquivo : >>> '/usr/lib/perl5/site_perl/5.8.8/i386-linux-thread-multi/auto/DBD/Oracle/Oracle.so' >>> >>> Existe? >>> >>> >> >> _______________________________________________ >> pgbr-geral mailing list >> [email protected] >> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral >> > _______________________________________________ > pgbr-geral mailing list > [email protected] > https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral > > -- View this message in context: http://www.nabble.com/Problema-com-DBI-Link-tp21692375p21731930.html Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com. _______________________________________________ pgbr-geral mailing list [email protected] https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
