ORA-28511 Connecting Oracle To MySQL Via DG4ODBC and Errors ORA-27300, ORA-27301, ORA-27302 in the Alert Log (Doc ID 1493449.1)

Last updated on OCTOBER 09, 2012

Applies to:

Oracle Server - Enterprise Edition - Version 11.1.0.6 to 11.2.0.3 [Release 11.1 to 11.2]
Information in this document applies to any platform.

Symptoms

After configuring Oracle Database Gateway for ODBC (DG4ODBC) 11.2.0.1 to connect to a MySQL 5.1 database, a select gives the following error:

SQL> select varcharcol, dump("varcharcol",16) from "hello_world"@myodbc5;
select varcharcol, dump("varcharcol",16) from "hello_world"@myodbc5
  *
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=999.99.98.197)(PORT=1522))(CONNECT
_DATA=(SID=myodbc5)))
ORA-02063: preceding line from MYODBC5
Process ID: 9026
Session ID: 73 Serial number: 1571

 
The same command from the MySQL database works successfully -

SQL> select varcharcol, hex(varcharcol) from hello_world;
+---------------------------------------------------+-----------------------------------------------------------------------------------------------------+
| varcharcol | hex(varcharcol) |
+---------------------------------------------------+-----------------------------------------------------------------------------------------------------+
| Hello World! | 48656C6C6F20576F726C6421 |
+---------------------------------------------------+-----------------------------------------------------------------------------------------------------+
SQLRowCount returns 1
1 rows fetched

 

The Oracle RDBMS alert log shows the following messages -

Tue Aug 21 10:39:13 2012
Process startup failed, error stack:
Errors in file /u01/app/oracle/diag/rdbms/gateway/GATEWAY/trace/GATEWAY_psp0_2328.trc:
ORA-27300: OS system dependent operation:fork failed with status: 12
ORA-27301: OS failure message: Not enough space
ORA-27302: failure occurred at: skgpspawn3
Tue Aug 21 10:39:14 2012
Process m000 died, see its trace file
Tue Aug 21 10:54:15 2012
Process startup failed, error stack:
Errors in file /u01/app/oracle/diag/rdbms/gateway/GATEWAY/trace/GATEWAY_psp0_2328.trc:
ORA-27300: OS system dependent operation:fork failed with status: 11
ORA-27301: OS failure message: Resource temporarily unavailable
ORA-27302: failure occurred at: skgpspawn5
Tue Aug 21 10:54:16 2012
Process m000 died, see its trace file
Tue Aug 21 10:58:39 2012
HS:  Lost RPC connection to remote Agent...
HS:  ... Agent SID = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.27.98.197)(PORT=1521))(CONNECT_DATA=(SID=myodbc5))), NCR status = -2147385341
Tue Aug 21 11:01:43 2012
HS:  Lost RPC connection to remote Agent...
HS:  ... Agent SID = (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.27.98.197)(PORT=1521))(CONNECT_DATA=(SID=myodbc5))), NCR status = -2147385341

 

 

Note the OS error messages - ORA-27300, ORA-27301 and ORA-27302


A truss trace shows the following -

24162/1: sigaction(SIGSEGV, 0xFFFFFFFF7FFD2620, 0x00000000) = 0
24162/1:    Incurred fault #6, FLTBOUNDS  %pc = 0xFFFFFFFF7D4E8850
24162/1:      siginfo: SIGSEGV SEGV_MAPERR addr=0x100149FF8
24162/1:    Received signal #11, SIGSEGV [caught]
24162/1:      siginfo: SIGSEGV SEGV_MAPERR addr=0x100149FF8
24162/1: lwp_sigmask(SIG_SETMASK, 0xFFBFFCFF, 0x0000FFF7) = 0xFFBFFEFF [0x0000FFFF]
24162/1: setcontext(0xFFFFFFFF7FFD18C0)
24162/1: sigaction(SIGBUS, 0xFFFFFFFF7FFD2620, 0x00000000) = 0
24162/1: sigaction(SIGSEGV, 0xFFFFFFFF7FFD2620, 0x00000000) = 0
24162/1: lwp_sigmask(SIG_SETMASK, 0x9FBEF057, 0x0000FFF7) = 0xFFBFFEFF [0x0000FFFF]
24162/1: lwp_sigmask(SIG_SETMASK, 0xFFBFF8FF, 0x0000FFF7) = 0xFFBFFEFF [0x0000FFFF]
24162/1: sigaction(SIGBUS, 0x00000000, 0xFFFFFFFF7E7D55A8) = 0
24162/1: sigaction(SIGBUS, 0xFFFFFFFF7FFD2620, 0x00000000) = 0
24162/1: sigaction(SIGSEGV, 0x00000000, 0xFFFFFFFF7E7D5588) = 0
24162/1: sigaction(SIGSEGV, 0xFFFFFFFF7FFD2620, 0x00000000) = 0
24162/1:    Incurred fault #6, FLTBOUNDS  %pc = 0xFFFFFFFF7D4E8850
24162/1:      siginfo: SIGSEGV SEGV_MAPERR addr=0x100149FFC
24162/1:    Received signal #11, SIGSEGV [caught]
24162/1:      siginfo: SIGSEGV SEGV_MAPERR addr=0x100149FFC
24162/1: lwp_sigmask(SIG_SETMASK, 0xFFBFFCFF, 0x0000FFF7) = 0xFFBFFEFF [0x0000FFFF]

 


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms