Oracle Out Of Memory Error 10g
Contents |
: Fixing the 'ORA-27102: out of memory' Error By Giri Mandalika on Nov 21, 2008 (Crossposting the 2+ year old blog entry from my ora-27102 out of memory linux other blog hosted on blogger. Source URL: http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html) Symptom: As part of ora-27102 out of memory solaris a database tuning effort you increase the SGA/PGA sizes; and Oracle greets with an ORA-27102: out of ora-27102 out of memory linux-x86_64 error 12 memory error message. The system had enough free memory to serve the needs of Oracle. SQL> startup ORA-27102: out of memory SVR4 Error: 22: Invalid argument Diagnosis $ oerr ora-27102 out of memory solaris 11 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 0x000000028a006000 fix shm parameters in /etc/system or equivalent Oracle is trying to create a 10G shared memory
Ora-27102 Out Of Memory Windows
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 the system is using the default value of 8G in this scenario, where as the application (Oracle) is trying to create a memory segment (10G) larger than 8G. Hence the failure. So, the solution
SQL TuningSecurityOracle UNIXOracle LinuxMonitoringRemote supportRemote plansRemote servicesApplication Server ApplicationsOracle FormsOracle PortalApp UpgradesSQL ServerOracle ConceptsSoftware SupportRemote Support Development Implementation Consulting StaffConsulting PricesHelp Wanted! Oracle PostersOracle Books Oracle Scripts Ion Excel-DB Don Burleson Blog
Ora-27102 Out Of Memory Oracle 11g
ORA-27102: out of memory tips project.max-shm-memory solaris 11 Oracle Error Tips by Stephanie F. First solution by Mircea Vutcovici I got the ORA-27102 error upon instance startup: SQL> linux-x86_64 error: 12: cannot allocate memory startup ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device My OS is Red Hat Linux (RHEL 5.4 x64), and I?ve traced the sqlplus process and here was the error: shmget(0x37ed6a3c, https://blogs.oracle.com/mandalika/entry/oracle_on_solaris_10_fixing 1243611136, IPC_CREAT|IPC_EXCL|SHM_HUGETLB|0600) = -1 ENOSPC (No space left on device)The solution was to increase kernel.shmall from 2097152 (as it is in the install doc for oracle 10h and oracle 11g) to 4194304. Probably is better to leave the RHEL5 default which is 4294967296The issue is documented online: ?Upon startup of Linux database get ORA-27102: out of memory Linux-X86_64 Error: 28: No space left on device" The Oracle http://www.dba-oracle.com/t_ora_27102_out_of_memory.htm docs note this on the ORA-27102 error: ORA-27102: out of memory Cause: Out of memory Action: Consult the trace file for details On the Oracle DBA-Forums, a user posts that he has been confronted by ORA-27102. He is unsure how to resolve this error because the database had previously worked, and ORA-27102 seemed particularly strange because he assumed he had plenty of storage on his machine. The error details were as follows: C:\Oracle\ora92\bin>SQLPLUS /NOLOG SQL*Plus: Release 9.2.0.5.0 - Production on Wed Mar 22 15:59:00 2006 Copyright - 1982, 2002, Oracle Corporation. All rights reserved. SQL> conn / as sysdba Connected to an idle instance. SQL> startup pfile=H:\Oracle\Database\pfile\initGOLDMINE.ORA ORA-27102: out of memory OSD-00029: Message 29 not found; product=RDBMS; facility=SOSD O/S-Error: (OS 8) Not enough storage is available to process this command. My OS is windows XP oracle version 9.2.0.5 I have NOT set LOCK_SGA in init.ora file. The resolution for ORA-27102 came when the user "reduced sga_max_size from 1.8g to 1g. restarted db and it is open now" but they were still unsure whether there could be more SGA than 2g in Windows XP, and what the OS limitation was. A replier answered the question in full by offering this informat
[message #565445] Tue, 04 September 2012 08:21 abirami.thirunavukkarasu Messages: 28Registered: August 2012 Location: Bangalore Junior Member Hi I am not http://www.orafaq.com/forum/t/183802/ a DBA. But i need your help in resolving the follwing issue - My database is working fine till y.day. But today when I try to connect as http://www.oracleracexpert.com/2009/08/ora-27102-out-of-memory-on-linux-unable.html sysdba i get the following error- let me know how to resolve the same C:\Users\Administrator>set ORACLE_SID=sha C:\Users\Administrator>sqlplus '/ as sysdba' SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep out of 4 05:11:14 2012 Copyright (c) 1982, 2010, Oracle. All rights reserved. Enter password: Connected to an idle instance. SQL> startup mount 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 Please advise. Report message to a moderator Re: Oracle out of memory DB out of memory error [message #565449 is a reply to message #565445] Tue, 04 September 2012 08:39 Michel Cadot Messages: 63912Registered: March 2007 Location: Nanterre, France, http://... Senior MemberAccount Moderator ORA-27102: out of memory *Cause: Out of memory *Action: Consult the trace file for details Quote:O/S-Error: (OS 1455) The paging file is too small for this operation to complete Increase the swap or decrease the memory parameters you gave. Quote:till y.day Please completly write the words. Regards Michel Report message to a moderator Re: Oracle DB out of memory error [message #565450 is a reply to message #565449] Tue, 04 September 2012 09:19 abirami.thirunavukkarasu Messages: 28Registered: August 2012 Location: Bangalore Junior Member Sure Michel will not follow any shotcuts. But could you please tell me how to increase the swap or decrease the parameters . I had gone through few sites. But was not able to follow PRACTICALLY. I was not able to login into the databse itself. So cou
Guard Architecture Understand Oracle Real Application Cluster Understand the Power of Oracle RMAN - Page 47 Migrate Non-ASM Database to ASM Using RMAN Modifying the VIP Address or VIP Hostname in RAC Duplicate RAC Database Using RMAN Categories 12C New Features (12) Active DataGuard (1) Administration (33) Agile Patch (3) alert.log errors (12) Analysis Office (1) Articles/Best Practices (19) ASM (14) Audit (2) Backup/Recovery (14) BOXI (3) Certification (6) Clone (1) Cloud (5) Control file (1) Corruption/Recovery (4) Data Pump (6) Database Replay (1) Database Upgrade (5) DataGuard (2) DB Security (2) DBUA (3) diagnostic Tools (2) Documentation (1) Downloads/Tools (8) Duplicate Database (4) Dynamic Tiering (3) EM Grid Control (7) Essbase (3) Event Viewer (1) Export/Import (7) Flash Recovery Area (3) Free Training (2) GoldenGate (4) HA100 (1) HA200 (1) HANA (2) HANA SPS07 (2) Heterogeneous (5) High Availability (15) Hyperion Errors (3) InnoDB (1) Installation (6) Java Error (4) JDBC Driver (3) License (2) Linux Admin (3) Linux-Errors (7) Load Balancer (1) Migrate (3) Migration (4) MOPatch (2) Multitenant (7) MySQL Access (1) MySQL Admin (7) MySQL Backup/Restore (1) MySQL Errors (5) OCR - VOTE (8) ODBC (6) OEM Agent (1) OLAP Connection (1) Opatch (6) Ora-Errors (33) Oracle 10g (27) Oracle 10g New Feat (7) Oracle 11g (34) Oracle 11g New Feat (14) Oracle 12C (20) Oracle 8i (5) Oracle 9i (11) Oracle ACE (1) Oracle Agile (7) Oracle APEX (1) Oracle Beta Program (1) Oracle BI (1) Oracle E-Business Suite (1) Oracle Hyperion (3) Oracle In-Memory (3) Oracle OpenWorld (2) Oracle RAC (5) Oracle Support (4) OUI (4) Packt Publishing (2) Patch/Bug Fix (14) Performance (1) PL/SQL (6) Planning (2) Pluggable Database (7) PSU (1) RAC Admin (17) RAC-Errors (7) RCONFIG (1) Redo Log (6) Replication (2) RMAN Backup (25) RMAN Recovery (29) RMAN-ERROR (6) SAML (1) SAP (14) SAP Basis (6) SAP HANA (14) SAP HANA Client (2) SAP HANA Shine (2) SAP HANA Studio (6) SAP Note (1) Security (3) Smart Data Access (1) Smart View (2) Spfile and Pfile (6) SQL (10) SQLException (1) SQLNET (2) SSL (1) SSO (2) Standby (1) STARTUP (2) Storage (1) SYBASE (1) T-CODE (1) tabadmin (2) Tableau Desktop (1) Tableau Server (1) Tableau Server 9.1.2 (1) Tableau Server 9.1.3 (2) TAF (3) TNS Errors (2) Tools (2) Trace File (5) Transportable TBS (3) Tuning