Obrigado por responder, sim o arquivo existe
Dickson S. Guedes-2 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? > > -- > Dickson S. Guedes > Administrador de Banco de Dados > Confesol - Projeto Colmeia > Florianopolis, SC, Brasil > (48) 3322-1185, ramal: 26 > > _______________________________________________ > 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-tp21692375p21707256.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
