Running into a problem starting up Oracle. This is being done on:
Windows Server 2012 R2 Standard edition. 64-bit Operating System, x64-based processor. This server has 32 GB of RAM.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64 bit installed (used automated scripts for the installation and also tried via manual install).
A windows batch file is being used to create a database. It is connecting to SYS as SYSDBA and then issues the following (prior to the CREATE DATABASE command):
startup nomount pfile="D:\...\init.ora";
This is the command that Oracle ends up running out of memory. The init.ora file looks like this:
###########################################
# Cache and I/O
###########################################
db_block_size=8192
###########################################
# Cursors and Library Cache
###########################################
open_cursors=10000
###########################################
# Database Identification
###########################################
db_domain=""
db_name=xyz
###########################################
# File Configuration
###########################################
control_files=("D:\...\control01.ctl", "D:\...\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:\...\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
The SGA target is 3G. When Oracle runs it continues to grow in memory. The oracle.exe continues to grow unit it is using close to 30G (viewing through TaskManager) and then it starts paging memory out. Pagefile continues to grow past 40G. Eventually get the out of memory error. Windows is configured for "Automatically manage paging file size for all drives".
Same type of scripts/setup was performed successfully on a similar computer except it only had 16GB of memory.
If I put a bogus parameter in the init.ora file then the startup completes (looks like Oracle ignores the init.ora file if it finds something in it that doesn't make sense).
Any ideas on what might be going on?
Thanks