Ora 27102 Error
Contents |
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 linux
ORA-27102: outOra-27102 Out Of Memory Solaris
of memory tips Oracle Error Tips by Stephanie F. First solution by Mircea Vutcovici I got the ORA-27102 ora-27102 out of memory solaris 11 error upon instance startup: SQL> 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
Ora-27102 Out Of Memory Linux-x86_64 Error 12
and here was the error: shmget(0x37ed6a3c, 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: ora-27102 out of memory windows 28: No space left on device" The Oracle 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
and receive notifications of new posts by email. Join 4,587 other followers Follow Pavan DBA's Blog on WordPress.com Visitor Count hit counter Categories Admin (49)
Ora-27102 Out Of Memory Oracle 11g
Enterprise Manager (4) Bkp n Recovery (15) cloning (4) Certification (3) Dataguard
Linux-x86_64 Error: 12: Cannot Allocate Memory
(6) export/import/Datapump (11) Freshers (1) General (22) Installation (5) Interview Questions (1) RMAN, backup n recovery (1) Jobs ora 27102 out of memory oracle 11g windows (1,700) Networking with Oracle (5) Perf Tuning (1) RAC (1) RMAN (8) Scripts (73) Administration (33) backup and recovery (9) Dataguard (2) Performance Tuning (28) RAC (1) Training (23) upgradation http://www.dba-oracle.com/t_ora_27102_out_of_memory.htm (10) User management (3) Vote your opinion… Take Our Poll TechMaster Training TechMaster Training My Facebook Page My Facebook Page My Tweets Installing 12c (12 1 0 2) on OEL 7 2 fb.me/62LUdmy27 1dayago 12c Installation video on Oracle Linux 7.2 fb.me/5K9eOxGMr 1dayago TechMaster announcing Oracle RAC DBA online training by Raj New batch starting from 1st Nov 2016 @ https://pavandba.com/2010/08/12/how-to-resolve-ora-27102-error/ 6 PM IST Demo... fb.me/Wt9AOv6B 1dayago Follow @pavandba My DBA links 4shared Akadia Asktom Website Database Journal DBA Oracle DBA Pool DBA Support DBA Village Devshed IXORA My Oracle Support Orabyte Oracle articles Oracle Base Oracle DBA Online Oracle Forums ORACLE RAC SIG ORAFAQ Orakhoj Oraperf Scribd Searchoracle Techtarget Statspack Analyzer Other DBA Blogs All Things Oracle Aman's Blog Arup Nanda's blog Dmitry's Blog Gavin Soorma's blog Hemanth Jonathan Lewis Julian Dyke's blog Kamran Kevin's blog Mario's Blog Rafi's blog Richard foote Satish Blog Sudhakar Blog Tanelpoder's blog Tom Kyte's blog Uwe Hesse Blog « Industry / Domain Consultant (SME) Hiring : Employee Referral Broadcast inCSC walkin for java professionals incapgemini » how to resolve ORA-27102error? Posted by Pavan DBA on August 12, 2010 Good day friends… Its been long time that i posted a technical article and reason is am busy with my new project KT. yesterday when i am doing RMAN cloning to a different server to get a schema which is dropped, i got a peculiar error. i will post the steps to follow on ho
FunctionsPL/SQLORA ERRORBugsScriptsToolsMySQLLinuxOtherContact ORA-27102: out of memory Linux-x86_64 Error: 28: http://www.nazmulhuda.info/ora-27102-out-of-memory-linux-x86_64-error-28-no-space-left-on-device No space left on device ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on deviceSolution: Check the page size: #getconf PAGE_SIZE 4096 out of Calculate proper value for shmall: The value of shmall should be: Shmall=total size of the SGAs on the system/page size. Let’s assume the size out of memory of the SGA is 16GB in the system then it would be 1024 * 1024 * 1024 * 16 / 4096 = 4194304 Change shmall in /etc/sysctl.conf vi /etc/sysctl.conf kernel.shmall = 4194304 Apply the changes: # sysctl -p check shmall value after change # sysctl -A | grep shmall Start the database # su - oracle # sqlplus sys as sysdba SQL> startup Comments Sign in|Recent Site Activity|Report Abuse|Print Page|Powered By Google Sites