OraFAQ Forum: Windows » Oracle DB out of memory error

Home » Infrastructure » Windows » Oracle DB out of memory error (Oracle 11g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Oracle DB out of memory error [message #565445]

Tue, 04 September 2012 08:21

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.

Report message to a moderator

Re: Oracle DB out of memory error [message #565449 is a reply to message #565445]

Tue, 04 September 2012 08:39

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Oracle DB out of memory error [message #565450 is a reply to message #565449]

Tue, 04 September 2012 09:19

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.

Report message to a moderator

Re: Oracle DB out of memory error [message #565459 is a reply to message #565450]

Tue, 04 September 2012 10:34

Michel Cadot
Messages: 68641
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

Report message to a moderator

Re: Oracle DB out of memory error [message #565508 is a reply to message #565459]

Tue, 04 September 2012 20:03

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.

Report message to a moderator

Previous Topic:	Passing values/arguments to a batch file
Next Topic:	MS Project to Oracle Database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 15:13:58 CDT 2024