How To Avoid ORA-04030/ORA-12500 In 32-bit Windows Environment [Video]
(Doc ID 373602.1)
Last updated on JUNE 09, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 9.0.1.0 and later Oracle Database Cloud Schema Service - Version N/A and later Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later Oracle Cloud Infrastructure - Database Service - Version N/A and later Oracle Database Cloud Exadata Service - Version N/A and later Microsoft Windows (32-bit)
This Note is applicable to any 32-bit Windows release capable of running Oracle.
Symptoms
You are encountering ORA-04030 or ORA/TNS-12500 in the 32-bit Windows environment. It is assumed that your server machine has less than 16GB of physical RAM, and that both the /3GB and /PAE switches have been set in the BOOT.INI file (see <Note 225349.1> to understand why this is significant).
This document is intended as an adjunct to the excellent information in:
<Note 225349.1> Using Address Windowing Extensions (AWE) or VLM on Windows <Note 46001.1> Oracle Database and the Windows NT memory architecture <Note 46053.1> Windows NT Memory Architecture Overview
and it is assumed that these Notes have been read.
The purpose of this article is to go into further detail with respect to the spread of memory usage in a 32-bit Windows environment, in the hope that errors such as ORA-4030 and ORA/TNS-12500 may be avoided or reduced.
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!