Home » Infrastructure » Windows » Oracle DB out of memory error (Oracle 11g)
Oracle DB out of memory error [message #565445] Tue, 04 September 2012 08:21 Go to next message
abirami.thirunavukkarasu
Messages: 28
Registered: August 2012
Location: Bangalore
Junior Member
Hi I am not a DBA.

But i need your help in resolving the follwing issue -

My database is working fine till y.day. But today when I try to connect as sysdba i get the following error- let me know how to resolve the same

C:\Users\Administrator>set ORACLE_SID=sha

C:\Users\Administrator>sqlplus '/ as sysdba'
SQL*Plus: Release 11.2.0.1.0 Production on Tue Sep 4 05:11:14 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Enter password:
Connected to an idle instance.
SQL> startup mount

ORA-27102: out of memory
OSD-00026: additional error information
O/S-Error: (OS 1455) The paging file is too small for this operation to complete

Please advise.
Re: Oracle DB out of memory error [message #565449 is a reply to message #565445] Tue, 04 September 2012 08:39 Go to previous messageGo to next message
Michel Cadot
Messages: 57602
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ORA-27102: out of memory
 *Cause: Out of memory
 *Action: Consult the trace file for details


Quote:
O/S-Error: (OS 1455) The paging file is too small for this operation to complete


Increase the swap or decrease the memory parameters you gave.

Quote:
till y.day


Please completly write the words.

Regards
Michel
Re: Oracle DB out of memory error [message #565450 is a reply to message #565449] Tue, 04 September 2012 09:19 Go to previous messageGo to next message
abirami.thirunavukkarasu
Messages: 28
Registered: August 2012
Location: Bangalore
Junior Member
Sure Michel will not follow any shotcuts.

But could you please tell me how to increase the swap or decrease the parameters .

I had gone through few sites. But was not able to follow PRACTICALLY.

I was not able to login into the databse itself. So could you please let me know, how to do the same.
Re: Oracle DB out of memory error [message #565459 is a reply to message #565450] Tue, 04 September 2012 10:34 Go to previous messageGo to next message
Michel Cadot
Messages: 57602
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
But could you please tell me how to increase the swap


This is a Windows question and it depends on your Windows version.
Ask your sysadmin.

Quote:
decrease the parameters


Open your init.ora, or if you use a spfile create a pfile from the spfile (see CREATE SPFILE command in Database SQL Reference, you don't need to start the database to do so) and decrease the memory related parameters (see, *size*, *target*, *memory*).

Regards
Michel
Re: Oracle DB out of memory error [message #565508 is a reply to message #565459] Tue, 04 September 2012 20:03 Go to previous message
abirami.thirunavukkarasu
Messages: 28
Registered: August 2012
Location: Bangalore
Junior Member
Thanks Michel.

We had requested admin guys to resolve the RAM issue and they increased the RAM size. Now the DB is working fine.

Thanks for your input as always.
This thread can be closed.
Previous Topic: Passing values/arguments to a batch file
Next Topic: MS Project to Oracle Database
Goto Forum:
  


Current Time: Wed Apr 16 14:33:06 CDT 2014

Total time taken to generate the page: 0.05846 seconds