Tuesday, March 2, 2010

ORA-27102 and Solaris

Issue:

SQL> startup;
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
SQL> exit
Disconnected
$ ps -ef |grep pmon
  oracle   674   633   0 11:38:38 pts/1       0:00 grep pmon
$
Solution:
# prctl -n project.max-shm-memory -r -v 10G -i project 3
# su - oracle
Sun Microsystems Inc.   SunOS 5.10      Generic January 2005
$ . ./env_db.sh
bash-3.00$ sqlplus / as sysdba
SQL*Plus: Release 10.2.0.4.0 - Production on Fri Sep 4 19:50:20 2009
Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.
Connected to an idle instance.
SQL> startup;
ORACLE instance started.
Total System Global Area  612368384 bytes
Fixed Size                  2042528 bytes
Variable Size             171971936 bytes
Database Buffers          432013312 bytes
Redo Buffers                6340608 bytes
Database mounted.
Database opened.
For details see: http://technopark02.blogspot.com/2006/09/solaris-10oracle-fixing-ora-27102-out.html
  Thanks and Regards
        Saptarshi
================================= What-else we tried ==================================================
_____________________________________________
From:     Biswas, Saptarshi 
Sent:    Friday, September 04, 2009 2:05 PM
To:    Saravana, Kasthuri
Cc:    P R, Praveen
Subject:    RE: Oracle Migration for XYZ Bank.
Hold on. Let me see what else we can do..
  Thanks and Regards
        Saptarshi
_____________________________________________
From:     Saravana, Kasthuri 
Sent:    Friday, September 04, 2009 12:23 PM
To:    P R, Praveen
Cc:    Biswas, Saptarshi
Subject:    RE: Oracle Migration for XYZ Bank.
Hi,
555.554.150.152 server is having only 2GB memory.
If we need to increse the memory then we need increase the ram size physically.
Regards
Saravana
_____________________________________________
From:     P R, Praveen 
Sent:    Friday, September 04, 2009 12:13 PM
To:    Saravana, Kasthuri
Cc:    Biswas, Saptarshi
Subject:    RE: Oracle Migration for XYZ Bank.
Still same issue
SQL> startup;
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
SQL> exit
Disconnected
$ ps -ef |grep pmon
  oracle   674   633   0 11:38:38 pts/1       0:00 grep pmon
$
_____________________________________________
From:     Saravana, Kasthuri 
Sent:    Friday, September 04, 2009 12:12 PM
To:    P R, Praveen
Cc:    Biswas, Saptarshi
Subject:    RE: Oracle Migration for XYZ Bank.
Praveen,
555.554.150.152 server is having 2Gb ram.
I have configure the swao memoery to 6GB.
Pls check.
Regards
Saravana
_____________________________________________
From:     P R, Praveen 
Sent:    Friday, September 04, 2009 11:27 AM
To:    Saravana, Kasthuri
Cc:    Biswas, Saptarshi
Subject:    RE: Oracle Migration for XYZ Bank.
Saravana,
Am not able to start the db Please look into this
SQL> startup;
ORA-27102: out of memory
SVR4 Error: 22: Invalid argument
Rgds,
Praveen
___

No comments:

Post a Comment