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
