Related to Oracle ORA-27102 out of memory, OS 1455 Windows Server 2012 R2 when starting up Oracle prior to creating a database
I have a scripted install of oracle db which works on 2 of 3 machines. The machine where it currently fails has 16GB ram, but this script has worked on other machines with as little as 4GB ram and even in virtual environments.
All machines are:
Windows Server 2012 R2 Standard
64-bit OS, x64-based processor
On machine where the scripted install does not work:
PageFile Size - 2432 MB
16GB RAM (15.9 GB usable)
On machine where the scripted install does work:
PageFile Size - 4864 MB
32GB RAM (31.9 GB usable)
On the machine where it does not work oracle starts to eat up lots of memory while running this command:
....
Connected to an idle instance.
SQL> spool D:\Installers\app_template\CreateDB.log append
SQL> startup nomount pfile="D:\Installers\app_template\init.ora";
ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete.
as seen in the screen shots below in chronological order:
It takes up all the memory, then dumps a couple GB, then tries to take is again as you can see in the last screenshot above. Then it eventually fails.
Not sure why the installation is taking up so much memory, is this expected behavior?
I would like to fix this without manual install because we are trying to use this for automating the performance testing of our product.
init.ora
##############################################################################
# Copyright (c) 1991, 2001, 2002 by Oracle Corporation
##############################################################################
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# Cursors and Library Cache
###########################################
open_cursors=10000
###########################################
# Database Identification
###########################################
db_domain=""
db_name=dcd
###########################################
# File Configuration
###########################################
control_files=("D:\Oracle\oradata\dcd\control01.ctl", "D:\Oracle\oradata\dcd\control02.ctl")
###########################################
# Miscellaneous
###########################################
compatible=11.2.0.0.0
diagnostic_dest=D:\Oracle
###########################################
# Processes and Sessions
###########################################
processes=1000
sessions=1105
###########################################
# SGA Memory
###########################################
sga_target=3000000000
###########################################
# Security and Auditing
###########################################
audit_file_dest=D:\Oracle\admin\dcd\adump
audit_trail=db
remote_login_passwordfile=EXCLUSIVE
###########################################
# Sort, Hash Joins, Bitmap Indexes
###########################################
pga_aggregate_target=671088640
###########################################
# System Managed Undo and Rollback Segments
###########################################
undo_tablespace=UNDOTBS1