Oracle Svr4 Error 48
Contents |
: Fixing the 'ORA-27102: out of memory' Error By Giri Mandalika on Nov 21, 2008 (Crossposting the 2+ year ora-27102: out of memory svr4 error: 22: invalid argument old blog entry from my other blog hosted on blogger.
Ora-27102: Out Of Memory Linux-x86_64 Error: 28: No Space Left On Device
Source URL: http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html) Symptom: As part of a database tuning effort you increase the SGA/PGA sizes; ora-27102 out of memory linux-x86_64 error 12 and Oracle greets with an ORA-27102: out of memory error message. The system had enough free memory to serve the needs of Oracle. SQL> startup ora-27102 out of memory oracle 11g ORA-27102: out of memory SVR4 Error: 22: Invalid argument Diagnosis $ oerr ORA 27102 27102, 00000, "out of memory" // \*Cause: Out of memory // \*Action: Consult the trace file for details Not so helpful. Let's look the alert log for some clues. % tail -2 alert.log WARNING: EINVAL creating segment of size
Ora-27102: Out Of Memory Solaris-amd64 Error: 22: Invalid Argument
0x000000028a006000 fix shm parameters in /etc/system or equivalent Oracle is trying to create a 10G shared memory segment (depends on SGA/PGA sizes), but operating system (Solaris in this example) responded with an invalid argument (EINVAL) error message. There is a little hint about setting shm parameters in /etc/system. Prior to Solaris 10, shmsys:shminfo_shmmax parameter has to be set in /etc/system with maximum memory segment value that can be created. 8M is the default value on Solaris 9 and prior versions; where as 1/4th of the physical memory is the default on Solaris 10 and later. On a Solaris 10 (or later) system, it can be verified as shown below: % prtconf | grep Mem Memory size: 32760 Megabytes % id -p uid=59008(oracle) gid=10001(dba) projid=3(default) % prctl -n project.max-shm-memory -i project 3 project: 3: default NAME PRIVILEGE VALUE FLAG ACTION RECIPIENT project.max-shm-memory privileged 7.84GB - deny - system 16.0EB max deny - Now it is clear that t
Archive Auto Service Request (ASR) All System Admin Articles All Systems Topics Cool Threads Did you Know DST End of Notices FAQ Hands-On Labs linux-x86_64 error: 12: cannot allocate memory High Performance Computing Interoperability Jet Toolkit Oracle ACES for Systems Oracle ora-27102 out of memory solaris 11 on Dell Patches Security Software in Silicon Software Stacks Solaris Developer Solaris HowTo Solaris Studio IDE Topics
Project.max-shm-memory Solaris 10
Sysadmin Days System Admin Docs Upgrade VM Server for SPARC Submit Content | Check BigAdmin Bucks This content is submitted by a BigAdmin user. It has not been reviewed https://blogs.oracle.com/mandalika/entry/oracle_on_solaris_10_fixing for technical accuracy by Sun Microsystems, though it may have been lightly edited to improve readability. If you find an error or would like to comment on the article, please contact the submitter or use the comment field at the bottom of the article. Community submissions may not follow Sun trademark guidelines. For information on Sun trademarks, http://www.oracle.com/technetwork/systems/performance/zone-resource-control-jsp-138965.html please see http://www.sun.com/suntrademarks/. Zone Resource Control in the Solaris 10 08/07 OS Victor Feng, May 2008 Starting with the Solaris 10 08/07 Operating System, we can set up resource control for zones directly. For example, we can set up the number of CPUs that a zone can use or a range for the number of CPUs. We can also set up how much memory there is for a zone, including physical, swap, and locked memory. This article provides a few resource control tips that might help.1. Use cpu-shares to control zone computing resources. Although the Solaris 10 08/07 OS allows you to specify how many CPUs can be used in a zone, sometimes this does not work out well. For example, I use dedicated-cpu for three zones in an 8-core Sun Fire T2000 server. Each zone has 4-20 specified for ncpus with a different importance value. However, when the system is fully utilized, the importance value does not always play its role. Sometimes, a zone with a lower importa
Metalink, [edit]which is now up to date for 10gR2[/edit]. 1) AUDIT_FILE_DEST is not writable http://laurentschneider.com/wordpress/2007/12/how-to-resolve-ora-09925.html $ env _=/usr/bin/env ORACLE_SID=FOO TERM=dtterm ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_3 PWD=/u01/app/oracle/product/10.2.0/db_3 $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: http://dbaforums.org/oracle/index.php?showtopic=20888 2: No such file or directory Additional information: 9925 $ grep -i audit_file_dest $ORACLE_HOME/dbs/*$ORACLE_SID.ora audit_file_dest=/bar $ ls -lad /bar /bar not found $ su - root's Password: out of # mkdir /bar # exit $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 9925 $ su - root's Password: # chown oracle /bar # exit $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL> startup quiet nomount ORACLE instance started. out of memory SQL> shutdown abort ORACLE instance shut down. 2) $ORACLE_BASE/admin/$ORACLE_SID/adump exists and is not writable ❗ $ ls -lad $ORACLE_BASE/admin/$ORACLE_SID/adump drwxr-xr-x 2 root dba .../admin/FOO/adump $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 17 09:02:29 2007 Copyright (c) 1982, 2006, Oracle.All Rights Reserved. ERROR: ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 9925 ORA-09925: Unable to create audit trail file IBM AIX RISC System/6000 Error: 13: Permission denied Additional information: 9925 SP2-0751: Unable to connect to Oracle.Exiting SQL*Plus $ su - root's Password: # chown oracle /bar/admin/FOO/adump $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 17 09:02:48 2007 Copyright (c) 1982, 2006, Oracle.All Rights Reserved. Connected to an idle instance. SQL> quit 3) $ORACLE_HOME/rdbms/audit is not writable $ cat $ORACLE_HOME/dbs/init$ORACLE_SID.ora db_name=FOO $ $ORACLE_HOME/bin/sqlplus -L "/ as sysdba" SQL*Plus: Release 10.2.0.3.0 - Production on Mon Dec 17 08:48:09 2007 Copyright (c) 1