Error Message Ora-27102 Out Of Memory
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 other blog hosted on blogger. Source URL: http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html) Symptom: As
Ora 27102 Out Of Memory Linux X86_64 Error 12 Cannot Allocate Memory
part of a database tuning effort you increase the SGA/PGA sizes; and Oracle greets ora 27102 out of memory windows with an ORA-27102: out of memory error message. The system had enough free memory to serve the needs of ora 27102 out of memory solaris Oracle. SQL> startup 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
Ora 27102 Out Of Memory Solaris 11g
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 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
Ora 27102 Out Of Memory Solaris 11
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 is to configure the system with a value large enough for the shared segment being created, so Oracle succeeds in starting up the database instance. On Solaris 9 and prior releases, it can be done by adding the following line to /etc/system, followed by a reboot for the system to pick up the new value. set shminfo_shmmax = 0x000000028a0
adding a new instance to an already running installation, or tuning the SGA/PGA sizes on Solaris 10, and you find you get the following on starting that instance: On the screen ... SQL> startup ORA-27102: out ora 01034 oracle not available ora 27102 out of memory of memory SVR4 Error: 22: Invalid argument ... and in the Oracle alert
Ora-27102 Out Of Memory Linux
log ... Error : EINVAL creating segment of size 0x000000009f000000 fix shm parameters in /etc/system or equivalent ... DON'T call ora-27102 out of memory linux-x86_64 error 12 Oracle. You're likely to experience one or all of the following... You may be referred to Metalink Article 399895.1 and told to implement the workaround stated within. DON'T. This defeats the whole point https://blogs.oracle.com/mandalika/entry/oracle_on_solaris_10_fixing of using projects as the workaround just changes things on a system wide basis instead of resolving the actual project configuration issue. There's also no guarantee this method will work in later updates of Solaris 10 as the functionality has technically been obsoleted by projects. You may be told this is a known bug, Oracle bug ID 5237047 - Incorrect system requirements for Solaris 10, and https://lildude.co.uk/howto-fix-ora-27102-out-of-memory-error is actually a bug in Solaris 10. You'll probably be told to implement the changes in the above Metalink document. As above: DON'T. You may even be told this is a known limitation in Solaris 10 in that you can't have a shared memory segment of more than 6GB, and once again referred to the workaround in the above Metalink document. As above: DON'T. Believe it or not, I heard all three of these in one conference call this weekend and from what I can tell this is probably due to a complete misunderstanding of how projects work in Solaris 10 (ie a lack of knowledge) or due to some very bad documentation in Oracle's bug/call system. However, this post isn't all about what not to do, but rather how you go about resolving this issue. In short, you need to change the shared memory allocation for the particular project assigned to your Oracle user or group, depending on which you've chosen to implement. There is loads of information on setting up projects on docs.sun.com and Sunsolve, but if you're looking for information specific to Oracle and this error, then check out this post in M
and SafetyAsset NetworkAsset Operations and MaintenanceCommerceOverviewSubscription Billing https://scn.sap.com/thread/1629713 and Revenue ManagementMaster Data Management for CommerceOmnichannel https://www.scribd.com/document/83880365/Oracle-on-Solaris-10-Fixing-the-ORA-27102-Out-of-Memory-Error CommerceFinanceOverviewAccounting and Financial CloseCollaborative Finance OperationsEnterprise Risk and ComplianceFinancial Planning and AnalysisTreasury and Financial Risk ManagementHuman ResourcesOverviewCore Human Resources and PayrollHuman Capital AnalyticsTalent ManagementTime and Attendance ManagementManufacturingOverviewManufacturing NetworkManufacturing OperationsResponsive ManufacturingMarketingOverviewMarket out of with Speed and AgilityUnique Customer ExperiencesReal-Time Customer InsightsR&D/EngineeringOverviewDesign NetworkDesign OrchestrationProject and Portfolio ManagementSalesOverviewCollaborative Quote to CashSales Force AutomationSales Performance ManagementSelling Through Contact CentersServiceOverviewEfficient Field Service ManagementOmnichannel Customer ServiceTransparent Service Process and OperationsSourcing and ProcurementOverviewContingent Workforce ManagementDirect ProcurementSelf-Service out of memory ProcurementServices ProcurementStrategic Sourcing and Supplier ManagementSupply ChainOverviewDemand ManagementDemand NetworkLogistics NetworkManufacturing Planning and SchedulingResponse NetworkResponse and Supply ManagementSales, Inventory, and Operations PlanningTransportation ManagementWarehouse ManagementSustainabilityOverviewEnvironment, Health, and SafetyProduct Safety and Stewardship NetworkBrowse by IndustryAerospace and DefenseAutomotiveBankingChemicalsConsumer ProductsDefense and SecurityEngineering, Construction, and OperationsHealthcareHigh TechHigher Education and ResearchIndustrial Machinery and ComponentsInsuranceLife SciencesMediaMill ProductsMiningOil and GasProfessional ServicesPublic SectorRetailSports and EntertainmentTelecommunicationsTravel and TransportationUtilitiesWholesale DistributionBrowse Platform and TechnologyAnalyticsOverviewBusiness IntelligencePredictive AnalyticsGovernance, Risk, and ComplianceEnterprise Performance ManagementApplication Platform and InfrastructureOverviewApplication PlatformContent and CollaborationInterface ManagementProcess Management and IntegrationData ManagementOverviewBig Data on HadoopData WarehousingDatabase ManagementEnterprise Information ManagementIT ManagementOverviewApplication Lifecycle ManagementIT Infrastructure ManagementSecurity SoftwareOverviewApplication and IT Infrastructure SecurityIdentity, Access and Authentication ManagementBrowse by ProductAnalyticsContent and CollaborationCustomer Relationship ManagementData ManagementEnterprise ManagementFinancial
allUploadSign inJoinBooksAudiobooksComicsSheet MusicOracle on Solaris 10 Fixing the ORA-27102 Out of Memory' ErrorUploaded by Ram AvtarOracle DatabaseOracle Corporation596 viewsDownloadEmbedSee MoreCopyright: Attribution Non-Commercial (BY-NC)List price: $0.00Download as PDF, TXT or read online from ScribdFlag for inappropriate content You're Reading a Free Preview Pages 2 to 10 are not shown in this preview. Buy the Full Version Documents similar to Oracle on Solaris 10 Fixing the ORA-27102 Out of Memory' ErrorOracle Generic Migration Version 1Rms 1323 Cfasimpg11gR2 Upgrade CompanionFlex FieldsSchedulesCrescent Steel and Allied Products Ebs Case StudyForms PersonalizationsOracle TrainingR11.5 IProcurement IGFndload ExamplesA Mesnaads asd sadThe Oracle SRDemo Sample Application1z0-216-exam-study-guide-321296.pdfApplication Adapters Guide for Oracle Data IntegratorOracle Zendcon Php 2009dd_s06_l02How to Start R12Oracle UpgradeFedora 15Instalação Apex BD - Oracle Application Server Mod_plsql e Glassfish1+SoaOracle DBA on Unix and LinuxTcaAPM for Oracle RMANLes18.pdfsapnote_0000618868Apex 11g Configuration GuideD16814GC20_TOCBooks similar to Oracle on Solaris 10 Fixing the ORA-27102 Out of Memory' ErrorOracle 11g R1/R2 Real Application Clusters EssentialsEJB 3.0 Database Persistence with Oracle Fusion Middleware 11gOracle Information Integration, Migration, and ConsolidationOracle Database Security Interview Questions, Answers, and ExplanationsOracle GoldenGate 12c Implementer's GuideOracle Database Programming using Java and Web ServicesRelational Database SystemsOracle Data Warehouse Tuning for 10gHow To Start A Profitable Authority Blog In Under One HourWordPress CompleteMongoDB for Java DevelopersHow to Start and Own Your WordPress Blog ~ Made EasyBloggerBlogging Just for WritersWordPress 3 CompleteBlog, Inc.SQL For MySQLSolutions for Networked DatabasesBlogging For Self-PublishersCoreOS EssentialsHow to Start a Home Decor BlogjQuery UI CookbookCATIA V5 Tips and TricksWordPress from A to WThe Essential Beginner's Guide to Working With BloggersHow to make a review websiteLearning Cassandra for AdministratorsInstant UbuntuIBM Lotus Notes and Domino 8.5.3SQL for eServer i5 and iSeriesBooks about Oracle DatabaseOracle Database 12c Backup and Recovery Survival GuideOracle SQLOracle Advanced PL/SQL Developer Professional GuideOracle Fusion Applications Administra