Friday, March 25, 2011

ORA-27102: out of memory when DBCA -createDatabase

[oracle@xxx zone:xx]~/Install/solaris.sparc64_11gR2_database/database$ $ORACLE_HOME/bin/dbca -silent -createDatabase -templateName General_Purpose.dbc -gdbName $SID -sid $SID -sysPassword $PASSWORD -systemPassword $PASSWORD -sysmanPassword $PASSWORD -dbsnmpPassword $PASSWORD -emConfiguration LOCAL -storageType FS -datafileJarLocation $ORACLE_HOME/assistants/dbca/templates -characterset WE8ISO8859P1 -obfuscatedPasswords false -sampleSchema false -oratabLocation /var/opt/oracle/oratab
Copying database files
1% complete
2% complete
4% complete
100% complete
Look at the log file "/u01/app/oracle/cfgtoollogs/dbca/XX01/XX01.log" for further details.
[oracle@xxx zone:xx]~/Install/solaris.sparc64_11gR2_database/database$ less /u01/app/oracle/cfgtoollogs/dbca/XX01/XX01.log
Copying database files
DBCA_PROGRESS : 1%
DBCA_PROGRESS : 2%
ORA-27102: out of memory

DBCA_PROGRESS : 4%
ORA-01034: ORACLE not available

ORA-01034: ORACLE not available

DBCA_PROGRESS : 100%


solution
add more memory and reexecute dbca:

check: prctl -n project.max-shm-memory -i process $$
add more: projmod -sK "project.max-shm-memory=(privileged,16G,deny)" user.oracle

No comments:

Post a Comment