Forum Stats

  • 3,783,390 Users
  • 2,254,767 Discussions
  • 7,880,376 Comments

Discussions

Solaris 10 Sparc lost RPC connection to heterogeneous remote agent

3898041
3898041 Member Posts: 1
edited Mar 7, 2019 4:00AM in ODBC

Hi. I have Solaris 10 spark architecture server. I have compiled "unixODBC", postgre-sql-odbc and oracle.

lost RPC connection to heterogeneous remote agent

-bash-3.2$ /nariman/local4/unixODBC/bin/isql -v PG

1) I can execute isql from this server and everything work properly.

+---------------------------------------+

| Connected!                            |

|                                       |

| sql-statement                         |

| help [tablename]                      |

| quit                                  |

|                                       |

+---------------------------------------+

SQL> select * from _own;

+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+

| pin          | name                | surname             | middle_name         | vo             | vo_name           | rol                 | payer_type          |

+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+

| 27KB           | John                | User                | JohnUser            |           | Test     | 3                   | P                   |

+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+---------------------+

SQLRowCount returns 1

1 rows fetched

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

file /nariman/local4/unixODBC/lib/libodbc.so

/nariman/local4/unixODBC/lib/libodbc.so:        ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, not stripped, no debugging information available

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

ldd /nariman/local4/unixODBC/bin/isql

        libodbc.so.2 =>  /nariman/local4/unixODBC/lib/libodbc.so.2

        libthread.so.1 =>        /lib/64/libthread.so.1

        libc.so.1 =>     /lib/64/libc.so.1

        libgcc_s.so.1 =>         /usr/lib/64/libgcc_s.so.1

        libm.so.2 =>     /lib/64/libm.so.2

        /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2

        /platform/sun4v/lib/sparcv9/libc_psr.so.1

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

cat /nariman/etc4/odbc.ini

[PG]

Description     = PG

Driver          = /usr/local/lib/psqlodbcw.so

FileUsage       = 1

cat /nariman/etc4/odbc.ini

[PG]

Description     = PG

Driver          = /usr/local/lib/psqlodbcw.so

FileUsage       = 1

Debug           = 0

CommLog         = 0

Servername = 10.120.43.3

Username = postgres

Port = 5432

Database = yeke

Password = pstg

Protocol            =

ReadOnly            = Yes

RowVersioning       = No

ShowSystemTables    = No

ShowOidColumn       = No

FakeOidIndex        = No

ConnSettings        =

TraceFile               = sql.log

TRACE = ON

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

file /usr/local/lib/psqlodbcw.so

/usr/local/lib/psqlodbcw.so:    ELF 64-bit MSB dynamic lib SPARCV9 Version 1, dynamically linked, not stripped, no debugging information available

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-bash-3.2$ ldd /usr/local/lib/psqlodbcw.so

        libpq.so.5 =>    /usr/lib/64/libpq.so.5

        libpthread.so.1 =>       /lib/64/libpthread.so.1

        libodbcinst.so.2 =>      /nariman/local4/unixODBC/lib/libodbcinst.so.2

        libthread.so.1 =>        /lib/64/libthread.so.1

        libc.so.1 =>     /lib/64/libc.so.1

        libgcc_s.so.1 =>         /usr/lib/64/libgcc_s.so.1

        libnsl.so.1 =>   /lib/64/libnsl.so.1

        libsocket.so.1 =>        /lib/64/libsocket.so.1

        libmp.so.2 =>    /lib/64/libmp.so.2

        libmd.so.1 =>    /lib/64/libmd.so.1

        libscf.so.1 =>   /lib/64/libscf.so.1

        libdoor.so.1 =>  /lib/64/libdoor.so.1

        libuutil.so.1 =>         /lib/64/libuutil.so.1

        libgen.so.1 =>   /lib/64/libgen.so.1

        libm.so.2 =>     /lib/64/libm.so.2

        /lib/sparcv9/../libm/sparcv9/libm_hwcap1.so.2

        /platform/sun4v/lib/sparcv9/libc_psr.so.1

        /platform/sun4v/lib/sparcv9/libmd_psr.so.1

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

cat /u01/app/11.2.0/grid/network/admin/listener.ora

SID_LIST_LISTENER =

     (SID_LIST =

       (SID_DESC =

       (SID_NAME=PG)

         (ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1)

         (ENVS="LD_LIBRARY_PATH=/usr/lib:/usr/local/lib:/home/oracle/app/oracle/product/11.2.0/dbhome_1/lib:/nariman/local4/unixODBC/lib:/usr/local/lib/:/lib/64/:/usr/lib/64")

          (PROGRAM=dg4odbc)

       )

   )

--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-bash-3.2$ lsnrctl status

Service "PG" has 1 instance(s).

  Instance "PG", status UNKNOWN, has 1 handler(s) for this service...

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-bash-3.2$ cat /u01/app/oracle/product/11.2.0/dbhome_1/hs/admin/initPG.ora     

HS_FDS_CONNECT_INFO = PG

HS_FDS_SUPPORT_STATISTICS=FALSE

HS_FDS_TRACE_LEVEL = ON

HS_FDS_SHAREABLE_NAME = /nariman/local4/unixODBC/lib/libodbc.so

HS_LANGUAGE=AMERICAN_AMERICA.AL16UTF16

HS_FDS_TRACE_LEVEL = 4

HS_FDS_CONNECT_PROPERTIES="disableExtendedFetch='true'"

HS_FDS_FETCH_ROWS=1

HS_FDS_SQLLEN_INTERPRETATION=32

HS_NLS_NCHAR = UCS2

set ODBCINI=/nariman/etc4/odbc.ini

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

file /u01/app/oracle/product/11.2.0/dbhome_1/bin/dg4odbc

/u01/app/oracle/product/11.2.0/dbhome_1/bin/dg4odbc:    ELF 64-bit MSB executable SPARCV9 Version 1, dynamically linked, not stripped

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

SQL> select * from "_own"@PG;

select * from "_own"@PG

                     *

ERROR at line 1:

ORA-28511: lost RPC connection to heterogeneous remote agent using SID=ORA-28511: lost RPC connection to heterogeneous remote agent using

SID=(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.110.15.3)(PORT=1521))(CONNECT_DATA=(SID=PG)))

ORA-02063: preceding line from PG

Process ID: 3211

Session ID: 470 Serial number: 21163

----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

-bash-3.2$ cat PG_agt_3213.trc

Oracle Corporation --- TUESDAY   FEB 26 2019 17:54:40.246

Heterogeneous Agent Release

11.2.0.3.0

Oracle Corporation --- TUESDAY   FEB 26 2019 17:54:40.245

    Version 11.2.0.3.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"

HOSGIP returned value of "UCS2" for HS_NLS_NCHAR

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"

HOSGIP returned value of "1" for HS_FDS_FETCH_ROWS

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"

HOSGIP returned value of "FALSE" for HS_FDS_SUPPORT_STATISTICS

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"

HOSGIP returned value of "32" 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"

Product-Info:

  Port Rls/Upd:3/0 PrdStat:0

  Agent:Oracle Database Gateway for ODBC

  Facility:hsa

  Class:ODBC, ClassVsn:11.2.0.3.0_0011, Instance:PG

Exiting hgogprd, rc=0

Entered hgoinit

HOCXU_COMP_CSET=1

HOCXU_DRV_CSET=31

HOCXU_DRV_NCHAR=1000

HOCXU_DB_CSET=873

HS_LANGUAGE is AMERICAN_AMERICA.AL16UTF16

rc=2147471760 attempting to get LANG environment variable.

HOCXU_SEM_VER=112000

Entered hgolofn at 2019/02/26-17:54:40

HOSGIP for "HS_FDS_SHAREABLE_NAME" returned "/nariman/local4/unixODBC/lib/libodbc.so"

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLAllocHandle

symbol_peflctx=0x77715510

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLBindCol

symbol_peflctx=0x77715838

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLBindParameter

symbol_peflctx=0x7771676c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLCancel

symbol_peflctx=0x77719458

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDescribeParam

symbol_peflctx=0x777292e8

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDisconnect

symbol_peflctx=0x77729c18

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLEndTran

symbol_peflctx=0x7772fe8c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLExecute

symbol_peflctx=0x7773244c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLFetch

symbol_peflctx=0x777335b0

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLFreeHandle

symbol_peflctx=0x777367f0

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLFreeStmt

symbol_peflctx=0x77736838

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetData

symbol_peflctx=0x77739b04

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetEnvAttr

symbol_peflctx=0x7773f410

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetFunctions

symbol_peflctx=0x7773fa48

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLMoreResults

symbol_peflctx=0x777435c0

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLNumResultCols

symbol_peflctx=0x77744c18

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLParamData

symbol_peflctx=0x777451e4

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLPutData

symbol_peflctx=0x77748e34

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLRowCount

symbol_peflctx=0x777496bc

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetEnvAttr

symbol_peflctx=0x7774de0c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetDescRec

symbol_peflctx=0x7774d998

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLColAttribute

symbol_peflctx=0x7771aee0

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLColumns

symbol_peflctx=0x7771e160

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLConnect

symbol_peflctx=0x77724f14

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDescribeCol

symbol_peflctx=0x77728618

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLDriverConnect

symbol_peflctx=0x7772b55c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLExecDirect

symbol_peflctx=0x777318c0

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLForeignKeys

symbol_peflctx=0x77734a34

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetConnectAttr

symbol_peflctx=0x77736f70

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDescField

symbol_peflctx=0x7773aa48

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDescRec

symbol_peflctx=0x7773b6a4

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDiagField

symbol_peflctx=0x7773dbf8

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetDiagRec

symbol_peflctx=0x7773ee4c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetInfo

symbol_peflctx=0x7774132c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetStmtAttr

symbol_peflctx=0x77741400

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLGetTypeInfo

symbol_peflctx=0x77742d98

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLPrepare

symbol_peflctx=0x777460f0

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLPrimaryKeys

symbol_peflctx=0x77746b4c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLProcedureColumns

symbol_peflctx=0x7774771c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLProcedures

symbol_peflctx=0x77748378

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetConnectAttr

symbol_peflctx=0x77749bd4

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetStmtAttr

symbol_peflctx=0x7775108c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLSetDescField

symbol_peflctx=0x7774ce8c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLStatistics

symbol_peflctx=0x77754d9c

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Entered hgolofns at 2019/02/26-17:54:40

libname=/nariman/local4/unixODBC/lib/libodbc.so, funcname=SQLTables

symbol_peflctx=0x777567e4

hoaerr:0

Exiting hgolofns at 2019/02/26-17:54:40

Exiting hgolofn, rc=0 at 2019/02/26-17:54:40

HOSGIP for "HS_OPEN_CURSORS" returned "50"

HOSGIP for "HS_FDS_FETCH_ROWS" returned "1"

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"

treat_SQLLEN_as_compiled = 0

Exiting hgoinit, rc=0 at 2019/02/26-17:54:40

Entered hgolgon at 2019/02/26-17:54:40

reco:0, name:postgres, tflag:0

Entered hgosuec at 2019/02/26-17:54:40

Exiting hgosuec, rc=0 at 2019/02/26-17:54:40

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 postgres as default value for "HS_FDS_DEFAULT_OWNER"

HOSGIP for "HS_SQL_HANDLE_STMT_REUSE" returned "FALSE"

Entered hgocont at 2019/02/26-17:54:40

HS_FDS_CONNECT_INFO = "PG"

RC=-1 from HOSGIP for "HS_FDS_CONNECT_STRING"

Entered hgogenconstr at 2019/02/26-17:54:40

dsn:PG, name:postgres

optn:

Entered hgocip at 2019/02/26-17:54:40

dsn:PG

Exiting hgocip, rc=0 at 2019/02/26-17:54:40

##>Connect Parameters (len=27)<##

## DSN=PG;

#! UID=postgres;

#! PWD=*

Exiting hgogenconstr, rc=0 at 2019/02/26-17:54:40

Entered hgolosf at 2019/02/26-17:54:40

ODBC Function-Available-Array 0xFFFE 0x01FF 0xFF00 0xFE7F 0x03FF 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0x0000 0x0000 0x0000 0x0000

                              0x0000 0x0000 0xFE00 0x3B5D

Exiting hgolosf, rc=0 at 2019/02/26-17:54:40

DriverName:psqlodbcw.so, DriverVer:11.00.0000

DBMS Name:PostgreSQL, DBMS Version:11.0.1

Exiting hgocont, rc=0 at 2019/02/26-17:54:40

SQLGetInfo returns Y for SQL_CATALOG_NAME

SQLGetInfo returns 0 for SQL_MAX_CATALOG_NAME_LEN

Exiting hgolgon, rc=0 at 2019/02/26-17:54:40

Entered hgoulcp at 2019/02/26-17:54:40

Entered hgowlst at 2019/02/26-17:54:40

Exiting hgowlst, rc=0 at 2019/02/26-17:54:40

SQLGetInfo returns 0x0 for SQL_OWNER_USAGE

TXN Capable:2, Isolation Option:0x0

SQLGetInfo returns 63 for SQL_MAX_SCHEMA_NAME_LEN

SQLGetInfo returns 63 for SQL_MAX_TABLE_NAME_LEN

SQLGetInfo returns 0 for SQL_MAX_PROCEDURE_NAME_LEN

HOSGIP returned value of "TRUE" for HS_FDS_QUOTE_IDENTIFIER

SQLGetInfo returns " (0x22) for SQL_IDENTIFIER_QUOTE_CHAR

Answers

  • Jim-D
    Jim-D Member Posts: 584 Bronze Crown
    edited Feb 26, 2019 9:40AM

    Welcome!  The Community Feedback space is intended for discussions about the Oracle Community website, not for product-specific questions.

    There are tips on how to find the correct space on the   page, which also has instructions on how to change your display name so you're not just a number.

    In the ACTIONS box on the top right of your post, you should be able to click on "Move", and then specify the correct space - such as   - so the right experts can see your question.

    Thanks and good luck!

    MOSC Move.png