My Oracle Support Banner

Error: The Maximum Number Of Available Id's (32767) For Lwp's Is Reached - When Using DG4Sybase and Shared Pool Connections (Doc ID 1265644.1)

Last updated on JULY 16, 2019

Applies to:

Oracle Database - Enterprise Edition - Version to [Release 11.1 to 11.2]
Oracle Database Gateway for Sybase - Version to [Release 11.1 to 11.2]
Information in this document applies to any platform.


Using Database Gateway for Sybase (DG4Sybase) from sessions using a connection pool the following error is  received after 32767 executions -

ORA-28500: connection from ORACLE to a non-Oracle system returned this message:
[Database gateway for SYBASE]The maximum number of available id's (32767) for LWP's is reached. Deallocate dynamic SQL statements to free ids.
ORA-02063: preceding 2 lines from SYBLINK


To view full details, sign in with your My Oracle Support account.

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

In this Document

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.