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 JANUARY 18, 2017

Applies to:

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

Symptoms


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

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!


In this Document
Symptoms
Cause
Solution


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.