Já tinha testado e... NADA
ORA-28500: conexão do ORACLE com um sistema não Oracle retornou esta
mensagem:
server does not support SSL, but SSL was required
{08001,NativeErr = 101}
ORA-02063: precedendo 3 lines a partir de PG_LINK
28500. 00000 - "connection from ORACLE to a non-Oracle system returned
this message:"
*Cause: The cause is explained in the forwarded message.
*Action: See the non-Oracle system's documentation of the forwarded
message.
Erro na linha: 1 Coluna: 27
Em 24 de outubro de 2016 09:42, Flavio Henrique Araque Gurgel <
[email protected]> escreveu:
>
>
> Em seg, 24 de out de 2016 às 14:21, Luiz Carlos L. Nogueira Jr. <
> [email protected]> escreveu:
>
>> odbcinst.ini
>>
>> [PostgreSQL64]
>> Description = ODBC for PostgreSQL
>> Driver = /usr/lib/psqlodbc.so
>> Setup = /usr/lib/libodbcpsqlS.so
>> Driver64 = /usr/pgsql-9.3/lib/psqlodbc.so
>> Setup64 = /usr/lib64/libodbcpsqlS.so
>> FileUsage = 1
>>
>>
>> odbc.ini
>> [PG_LINK]
>> Description = PG_LINK
>> Driver = PostgreSQL64
>> Trace = No
>> TraceFil = /tmp/odbc.log
>> Database = pje_jud1g_p
>> Servername = 192.168.252.37
>> Username = user_dblink
>> #Port = 5432
>> ReadOnly = Yes
>> #Servername = 192.168.252.43 <-aqui é do bouncer onde deu problema
>> #Port = 6432
>>
>
> Adicione a opção:
> Sslmode = require
>
> E veja se resolve seu problema.
>
> []s
> Flavio Gurgel
>
>
> _______________________________________________
> 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