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
