ORA-27102 error after increasing memory

I increased the RAM from 2GB to 3GB, but when I try to increase the sga_max_size I get the following error on startup: "ORA-27102: out of memory."

I have an Oracle 10g R2 database that I run on Linux Enterprise Edition 2.4.21-4.ELsmp. I recently increased the RAM from 2GB to 3GB, but when I try to increase the sga_max_size I get the following error on startup: "ORA-27102: out of memory." I modified the kernel parameter shmmax from 2147483648 to 3221225472, but the error still persists. Would you help me please?

If you are running the 64-bit version of Linux and Oracle, then check the SHMALL Kernel setting. It may be set...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please login.

You have exceeded the maximum character limit.

Please provide a Corporate E-mail Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

too low. It should be set to value of SHMMAX divided by the page size. To get your systems page size run the following command.

getconf PAGE_SIZE

If you are not running the 64-bit version, you are getting this error because with the 32-bit version of Oracle, there is a 1.7 Gig SGA memory limitation. There is a way to increase this limitation to 2.7 Gig but you have to lower the base mapped memory address of Oracle and then relink Oracle software. The following metalink document goes into the detail on how to do this but you still will not be able to increase it to 3 Gig: "200266.1 - Increasing Usable Address Space for Oracle on 32-bit Linux."

This was last published in June 2007

Related Q&A from Phillip Bracken

Can I use TKPROF in Oracle 10g?

I have always used TKPROF to do SQL tuning in previous versions of Oracle (7,8 and 9). Can I still use TKPROF in Oracle 10g R2? Continue Reading

How to improve performance of column update

I have a table with 1.5 million records that needs to have a column updated based on a correlated subselect. This update is currently sitting at four... Continue Reading

Select on Oracle table takes hours

A user complains that every time he tries to access a table (select only), it takes more than two hours to get the results. There are no DML ... Continue Reading

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

Meet all of our Oracle Database / Applications experts

View all Oracle Database / Applications questions and answers

SearchDataManagement

GDPR compliance requirements drive new winds of data privacy

Hello, GDPR. May 25 is the witching hour for enforcement of the EU's much-discussed GDPR compliance requirements -- and it's a ...

Six data risk management steps for GDPR compliance

By layering data risk management processes into your data governance framework, you can ensure the personally identifiable ...

AP uses data collaboration platform to spread data journalism

Data journalism reporters need tools that deliver quick context for stories on deadline. A data collaboration platform from ...

SearchBusinessAnalytics

Ten KPI templates for your dashboards

KPIs help companies gauge success, but how do you choose the right metrics to create useful reports? Here you'll find 10 KPI ...

Data visualization process demands smart design, accurate data

Well-designed data visualizations can enable executives to make more-informed business decisions, increasing the potential ROI of...

Seven good data visualization practices for visual integrity

Data visualizations need visual integrity to ensure that the data they present can be interpreted correctly. Follow these design ...

SearchSAP

Inside SAP's digital transformation strategy

In this Q&A, Bertram Schulte, SAP's chief digital officer, discusses the how and why as the company goes through its own internal...

SAP Cloud Platform pushes to break new ground, extend ERP

SAP wants its Cloud Platform to connect ERP systems with new technology like machine learning and IoT, resulting in new processes...

SAP Cloud Platform architecture is glue for new technologies

SAP Cloud Platform has numerous integration tools for linking next-gen technologies like blockchain, machine learning and IoT to ...

SearchSQLServer

Common Data Service for Analytics eases Power BI integration

Integrating data into Power BI for analysis can be a challenge, but Microsoft's Common Data Service for Analytics technology is ...

Power BI Report Server adds new Power BI reporting options

Updates to Power BI Report Server expand the on-premises platform's reporting functionality and increase the number of data ...

Azure Cosmos DB features, pricing morph with new provisioning model

The ability to provision Azure Cosmos DB throughput at the database level could come with pricing sticker shock for some users of...

TheServerSide.com

How to embed Tomcat and Java web apps in an executable JAR

There's nothing magical about packaging Java web apps in an executable JAR file. This tutorials shows you how to embed Tomcat and...

Why we still use Apache Ant tool in Java build and deploys

Plenty of companies still use the Apache Ant tool in Java development cycles and as part of their continuous deployments. Here's ...

Packaging Java programs in the Docker and microservices age

The packaging of Java programs has taken an interesting turn, as the original JAR format becomes a favorite even for Java web ...

SearchDataCenter

Get to know SIEM software basics and benefits

Security information and event management tools give organizations enhanced network management functionality, such as automatic ...

Plexxi buy bolsters HPE composable infrastructure strategy

HPE strengthened its composable infrastructure strategy with the acquisition of Plexxi, a startup that adds a networking element ...

Hadoop cluster configuration best practices streamline workflows

Organizations that deal with a variety of Hadoop configurations can streamline workflows through baseline configuration, tests ...

SearchContentManagement

Five areas to focus on in a SharePoint and GDPR compliance strategy

SharePoint admins need to be ready for the General Data Protection Regulation, too. Expert Reda Chouffani suggests five things to...

Workplace collaboration tool bolsters employee productivity

The benefits of workplace collaboration tools trickle down to employee relationships, company growth, community engagement and ...

New age collaboration tools empower the future of ECM

Document management, file-sharing and ECM platforms might represent 'ancient' 1990s technology, but AI and collaboration tools ...

SearchHRSoftware

Federal HR wants to modernize cybersecurity recruiting, pay

The U.S. Dept. of Homeland Security wants to modernize recruitment and management of its cybersecurity workforce. It is asking ...

Huge potential of video interview software comes with risks

Tech-savvy millennials' advantage over older workers risks ageism, and AI needs work handling emotions and ethnicity. But few ...

How to solve six of the biggest employee retention challenges

Recruiters are enticing workers with new opportunities on an increasingly frequent basis. Give your employees plenty of reasons ...

Why won't TNS listener connect with Oracle Database 11g 32-bit?

Error during RMAN backup

ORA-12801 error while loading seed data

ORA-03297 when trying to resize tablespace

DBMS JOB Configuration error in RAC system

Getting errors when gathering system roots

How to increase SGA_MAX_SIZE in Oracle

Unable to connect to management server

How to resolve ORA-04030 error?

Problems accessing 10g through SQL*Plus and Enterprise Manager