1

BANNER


Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
Production PL/SQL Release 11.2.0.2.0 - Production CORE 11.2.0.2.0
Production TNS for 64-bit Windows: Version 11.2.0.2.0 - Production
NLSRTL Version 11.2.0.2.0 - Production Windows Server 2008 R2
Enterprise
6.00 GB RAM 64-bit operating system

Current memory settings

*.memory_max_target=1536M
*.memory_target=1024M

When I try to increase the memory_max_target to 2.5 GB I get the below error on startup

ORA-27102: out of memory OSD-00022: additional error information O/S-Error: (OS 1450) Insufficient system resources exist to complete the requested

SQL> startup pfile='C:\oracle\app\product\11.2.0\dbhome_1\database\INITorcl.ORA';

Could some one shed some light.

1 Answer 1

1

How much real memory free does Windows task manager show, before you start up Oracle? If less than 2.5 GB, that's the problem. You can try increasing memory_max_target slowly from its current value, say in 256 MB increments, until it errors again, then I'd back it off by maybe 512 MB to give some headroom.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.