Em seg, 24 de out de 2016 às 13:13, Luiz Carlos L. Nogueira Jr. <
[email protected]> escreveu:
> Pessoal,
> Instalei o pgbouncer e algumas aplicações minhas que vinham através de
> DBLINKs do Oracle pararam de funcionar.
> Algumas aplicações asp tive que colocar o modo ssl pra poderem funcionar,
> mas com o DBLINK não encontrei algum tipo de opção assim.
>
Isso fica no odbc.ini. Poderia postar o seu?
A versão do driver odbc também importa.
>
> A mensagem de erro abaixo me deixou mais confuso ainda.
>
> Segue trace do oracle com
> Oracle Corporation --- MONDAY OCT 24 2016 07:50:50.425
>
>
> Heterogeneous Agent Release
> 11.2.0.4.0
>
>
>
>
> Oracle Corporation --- MONDAY OCT 24 2016 07:50:50.424
>
> Version 11.2.0.4.0
>
> Entered hgogprd
> HOSGIP for "HS_FDS_TRACE_LEVEL" returned "4"
> Entered hgosdip
> setting HS_OPEN_CURSORS to default of 50
> setting HS_FDS_RECOVERY_ACCOUNT to default of "RECOVER"
> setting HS_FDS_RECOVERY_PWD to default value
> setting HS_FDS_TRANSACTION_LOG to default of HS_TRANSACTION_LOG
> setting HS_IDLE_TIMEOUT to default of 0
> setting HS_FDS_TRANSACTION_ISOLATION to default of "READ_COMMITTED"
> setting HS_NLS_NCHAR to default of "AL32UTF8"
> setting HS_FDS_TIMESTAMP_MAPPING to default of "DATE"
> setting HS_FDS_DATE_MAPPING to default of "DATE"
> setting HS_RPC_FETCH_REBLOCKING to default of "ON"
> setting HS_FDS_FETCH_ROWS to default of "100"
> setting HS_FDS_RESULTSET_SUPPORT to default of "FALSE"
> setting HS_FDS_RSET_RETURN_ROWCOUNT to default of "FALSE"
> setting HS_FDS_PROC_IS_FUNC to default of "FALSE"
> setting HS_FDS_MAP_NCHAR to default of "TRUE"
> setting HS_NLS_DATE_FORMAT to default of "YYYY-MM-DD HH24:MI:SS"
> setting HS_FDS_REPORT_REAL_AS_DOUBLE to default of "FALSE"
> setting HS_LONG_PIECE_TRANSFER_SIZE to default of "65536"
> setting HS_SQL_HANDLE_STMT_REUSE to default of "FALSE"
> setting HS_FDS_QUERY_DRIVER to default of "TRUE"
> setting HS_FDS_SUPPORT_STATISTICS to default of "FALSE"
> setting HS_FDS_QUOTE_IDENTIFIER to default of "TRUE"
> setting HS_KEEP_REMOTE_COLUMN_SIZE to default of "OFF"
> setting HS_FDS_GRAPHIC_TO_MBCS to default of "FALSE"
> setting HS_FDS_MBCS_TO_GRAPHIC to default of "FALSE"
> Default value of 64 assumed for HS_FDS_SQLLEN_INTERPRETATION
> setting HS_CALL_NAME_ISP to
> "gtw$:SQLTables;gtw$:SQLColumns;gtw$:SQLPrimaryKeys;gtw$:SQLForeignKeys;gtw$:SQLProcedures;gtw$:SQLStatistics;gtw$:SQLGetInfo"
> setting HS_FDS_DELAYED_OPEN to default of "TRUE"
> setting HS_FDS_WORKAROUNDS to default of "0"
> Exiting hgosdip, rc=0
> ORACLE_SID is "PG_LINK"
> Product-Info:
> Port Rls/Upd:4/0 PrdStat:0
> Agent:Oracle Database Gateway for ODBC
> Facility:hsa
> Class:ODBC, ClassVsn:11.2.0.4.0_0019, Instance:PG_LINK
> Exiting hgogprd, rc=0
> Entered hgoinit
> HOCXU_COMP_CSET=1
> HOCXU_DRV_CSET=31
> HOCXU_DRV_NCHAR=873
> HOCXU_DB_CSET=178
> HS_LANGUAGE is BRAZILIAN PORTUGUESE_BRAZIL.WE8ISO8859P1
> LANG=en_US.UTF-8
> HOCXU_SEM_VER=112000
> Entered hgolofn at 2016/10/24-07:50:50
> HOSGIP for "HS_FDS_SHAREABLE_NAME" returned
> "/usr/pgsql-9.3/lib/psqlodbcw.so"
> Entered hgolofns at 2016/10/24-07:50:50
> ....
>
> hoaerr:0
> Exiting hgolofns at 2016/10/24-07:50:50
> Exiting hgolofn, rc=0 at 2016/10/24-07:50:50
> HOSGIP for "HS_OPEN_CURSORS" returned "50"
> HOSGIP for "HS_FDS_FETCH_ROWS" returned "100"
> HOSGIP for "HS_LONG_PIECE_TRANSFER_SIZE" returned "65536"
> HOSGIP for "HS_NLS_NUMERIC_CHARACTER" returned ".,"
> HOSGIP for "HS_KEEP_REMOTE_COLUMN_SIZE" returned "OFF"
> HOSGIP for "HS_FDS_DELAYED_OPEN" returned "TRUE"
> HOSGIP for "HS_FDS_WORKAROUNDS" returned "0"
> HOSGIP for "HS_FDS_MBCS_TO_GRAPHIC" returned "FALSE"
> HOSGIP for "HS_FDS_GRAPHIC_TO_MBCS" returned "FALSE"
> Invalid value of 64 given for HS_FDS_SQLLEN_INTERPRETATION
> treat_SQLLEN_as_compiled = 1
> Exiting hgoinit, rc=0 at 2016/10/24-07:50:50
> Entered hgolgon at 2016/10/24-07:50:50
> reco:0, name:user_dblink, tflag:0
> Entered hgosuec at 2016/10/24-07:50:50
> Exiting hgosuec, rc=0 at 2016/10/24-07:50:50
> HOSGIP for "HS_FDS_RECOVERY_ACCOUNT" returned "RECOVER"
> HOSGIP for "HS_FDS_TRANSACTION_LOG" returned "HS_TRANSACTION_LOG"
> HOSGIP for "HS_FDS_TIMESTAMP_MAPPING" returned "DATE"
> HOSGIP for "HS_FDS_DATE_MAPPING" returned "DATE"
> HOSGIP for "HS_FDS_MAP_NCHAR" returned "TRUE"
> HOSGIP for "HS_FDS_RESULTSET_SUPPORT" returned "FALSE"
> HOSGIP for "HS_FDS_RSET_RETURN_ROWCOUNT" returned "FALSE"
> HOSGIP for "HS_FDS_PROC_IS_FUNC" returned "FALSE"
> HOSGIP for "HS_FDS_REPORT_REAL_AS_DOUBLE" returned "FALSE"
> using user_dblink as default value for "HS_FDS_DEFAULT_OWNER"
> HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"
> Entered hgocont at 2016/10/24-07:50:50
> HS_FDS_CONNECT_INFO = "PG_LINK"
> RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"
> Entered hgogenconstr at 2016/10/24-07:50:50
> dsn:PG_LINK, name:user_dblink
> optn:
> Entered hgocip at 2016/10/24-07:50:50
> dsn:PG_LINK
> Exiting hgocip, rc=0 at 2016/10/24-07:50:50
> ##>Connect Parameters (len=50)<##
> ## DSN=PG_LINK;
> #! UID=user_dblink;
> #! PWD=*
> Exiting hgogenconstr, rc=0 at 2016/10/24-07:50:50
> Entered hgopoer at 2016/10/24-07:50:50
> *hgopoer, line 231: got native error 210 and sqlstate 08P01; message
> follows...*
> *ERROR: Unsupported startup parameter: geqo {08P01,NativeErr = 210}*
> Exiting hgopoer, rc=0 at 2016/10/24-07:50:50
> hgocont, line 2831: calling SqlDriverConnect got sqlstate 08P01
> Exiting hgocont, rc=28500 at 2016/10/24-07:50:50 with error ptr
> FILE:hgocont.c LINE:2851 FUNCTION:hgocont() ID:Something other than invalid
> authorization
> Exiting hgolgon, rc=28500 at 2016/10/24-07:50:50 with error ptr
> FILE:hgolgon.c LINE:806 FUNCTION:hgolgon() ID:Calling hgocont
> Entered hgoexit at 2016/10/24-07:50:50
> Exiting hgoexit, rc=0
>
Oracle :p
[]s
Flavio Gurgel
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
