Solaris 10 Sparc lost RPC connection to heterogeneous remote agent

3898041

    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

      • 1. Re: Solaris 10 Sparc lost RPC connection to heterogeneous remote agent
        Jim-D

        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 Getting Started  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 Solaris 10  - so the right experts can see your question.

        Thanks and good luck!

        MOSC Move.png