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
