My Oracle Support Banner

RDBPROD: UTL_E_INSUFFICIENT_MEMORY When Connecting Using SQL/Services (Doc ID 120120.1)

Last updated on OCTOBER 27, 2017

Applies to:

Oracle SQL/Services for Rdb on OpenVMS - Version 7.1 and later
HP OpenVMS Alpha
HP OpenVMS Itanium
HP OpenVMS VAX

Symptoms

You connect from a PC with ODBC to an Rdb database on OpenVMS and the connection fails.  The following error messages are found in the dispatcher log file:

------------EVENT BEGIN:  EVENT_LOG at Mon Aug 21 2011 15:48:02.830-------------
%SQLSRV-I-EVENT_LOG, event logged at line 284 in file DISP.C;1                  
%SQLSRV-W-EXCEPTION_RAISE, Exception raised: utl_e_insufficient_memory          
%SQLSRV-I-CONNECTNAME, Connect : CONNECT_0000370                                
%SQLSRV-I-CONNECTSTATE, Connect state: 1                                        
%SQLSRV-I-NODENAME, Node : 10.0.41.108                                          
------------EVENT END  :  EVENT_LOG at Mon Aug 21 2011 15:48:02.831-------------

The important error message in this case is the UTL_E_INSUFFICIENT_MEMORY.

You can find the log files for the server and the dispatcher by doing:

$ MCR SQLSRV_MANAGE73
SQLSRV> CONNECT SERVER;
Connecting to server ...
Connected
SQLSRV> SHOW SERVER;
    Server Version:      7.3
    Server Platform:     HP OpenVMS Alpha
    Max Shared Mem Size: 2000 Kb
    Config file:         SYS$SYSROOT:[SYSMGR]SQLSRV_CONFIG_FILE.DAT;2
    Log path:            SYS$MANAGER:
    Dump path:           SYS$MANAGER:
    Proc start time:     <none>
    Proc shut time:      <none>
    Network Ports:                                     (State)   (Protocol)
      DECnet  object   SQLSRV_SERVER                   Running   Native
      TCP/IP  port     2199                            Running   Native
    Current shared memory usage:
      Allocation unit:      65536 bytes
      Total memory:       2031616 bytes ( 31 units)
      Free memory:        1703936 bytes ( 26 units)
      Partly allocated:    262144 bytes (  4 units)
    Log File:            SYS$SYSROOT:[SYSMGR]SQS_NLVMS2_SQLSRV_MON_00.LOG;
    Dump File:           SYS$SYSROOT:[SYSMGR]SQS_NLVMS2_SQLSRV_71.DMP;

SQLSRV> SHOW DISPATCHER;
Dispatcher SQLSRV_DISP
    State:                     RUNNING
    Autostart:                 on
    Max connects:              100 clients
    Idle User Timeout:         <none>
    Max client buffer size:    5000 bytes
    Network Ports:                                     (State)   (Protocol)
      IPX/SPX port     0x84b1                          Inactive  SQL/Services
      DECnet  object   81                              Running   SQL/Services
      TCP/IP  port     118                             Running   SQL/Services
    Log File:                  SYS$SYSROOT:[SYSMGR]SQS_NLVMS2_SQLSRV_DIS003.LOG;
    Dump File:                 SYS$SYSROOT:[SYSMGR]SQS_NLVMS2_SQLSRV_DIS003.DMP;

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.