Cannot Start Oracle Database after Shutdown

Posted on

Question :

I have install oracle with oracle asm on oracle linux 6.4 and it work correctly .
After shutdown abort , i can not start database at all .
can any one help me ?

SQL*Plus: Release Production on Sun Sep 6 14:14:30 2015

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Enter user-name: sys as sysdba
Enter password:
Connected to an idle instance.

SQL> startup
ORA-27137: unable to allocate large pages to create a shared memory segment
Linux-x86_64 Error: 1: Operation not permitted
Additional information: 201326592
Additional information: 1

[grid@localhost ~]$ asmcmd
ASMCMD> startup
ORA-01081: cannot start already-running ORACLE - shut it down first
[root@localhost ~]#  grep Huge /proc/meminfo
AnonHugePages:    100352 kB
HugePages_Total:       0
HugePages_Free:        0
HugePages_Rsvd:        0
HugePages_Surp:        0
Hugepagesize:       2048 kB

Answer :

$ oerr ora 27137
27137, 00000, "unable to allocate large pages to create a shared memory segment"
// *Cause: Parameter USE_LARGE_PAGES set to only, but large pages were not
//         configured properly
// *Action: Check alert file for more information

Your output shows hugepages were not configured, but the database is configured to use only large pages (use_large_pages=only), hence it can not start.

Configure the required amount of pages by setting the vm.nr_hugepages in /etc/sysctl.conf, the appropriate memlock limit in /etc/security/limits.conf, then reboot and start the database.

Configuring HugePages on Linux

If you do not need hugepages, simply edit the parameter file of the database, and unset the use_large_pages parameter.

Leave a Reply

Your email address will not be published. Required fields are marked *