DevOps, CI/CD and Automation

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Solaris 10 Sparc lost RPC connection to heterogeneous remote agent

3898041Feb 26 2019 — edited Mar 7 2019

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;

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

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

| 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"