Home » RDBMS Server » Server Administration » ORA-27102: out of memory (oracle 10.2.0.1)
ORA-27102: out of memory [message #396628] Tue, 07 April 2009 06:53 Go to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
SQL> startup pfile='C:\oracle\database\initORA01.ora'
ORA-27102: out of memory
OSD-00022: additional error information
O/S-Error: (OS 8) Not enough storage is available to process this command.


What needs to do?

Original File

ora01.__db_cache_size=822083584
ora01.__java_pool_size=4194304
ora01.__large_pool_size=4194304
ora01.__shared_pool_size=96468992
ora01.__streams_pool_size=0
*.audit_file_dest='C:/admin/ORA01/adump'
*.background_dump_dest='C:/admin/ORA01/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA01\control01.ctl','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA01\control02.ctl','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA01\control03.ctl'
*.core_dump_dest='C:/admin/ORA01/cdump'
*.db_block_size=8192
*.db_domain='world'
*.db_file_multiblock_read_count=16
*.db_name='ORA01'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA01XDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=311427072
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=934281216
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:/admin/ORA01/udump'


Changed file
ora01.__db_cache_size=1677721600
ora01.__java_pool_size=16777216
ora01.__large_pool_size=16777216
ora01.__shared_pool_size=150994944
ora01.__streams_pool_size=0
*.audit_file_dest='C:/admin/ORA01/adump'
*.background_dump_dest='C:/admin/ORA01/bdump'
*.compatible='10.2.0.1.0'
*.control_files='C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA01\control01.ctl','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA01\control02.ctl','C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORA01\control03.ctl'
*.core_dump_dest='C:/admin/ORA01/cdump'
*.db_block_size=8192
*.db_domain='world'
*.db_file_multiblock_read_count=16
*.db_name='ORA01'
*.dispatchers='(PROTOCOL=TCP) (SERVICE=ORA01XDB)'
*.job_queue_processes=10
*.open_cursors=300
*.pga_aggregate_target=791674880
*.processes=150
*.remote_login_passwordfile='EXCLUSIVE'
*.sga_target=1879048192
*.undo_management='AUTO'
*.undo_tablespace='UNDOTBS1'
*.user_dump_dest='C:/admin/ORA01/udump'


[Updated on: Tue, 07 April 2009 06:57]

Report message to a moderator

Re: ORA-27102: out of memory [message #396630 is a reply to message #396628] Tue, 07 April 2009 06:56 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member

Quote:
ORA-27102: out of memory
Cause: Out of memory
Action: Consult the trace file for details


What's your RAM Size ?

What's Your SGA_MAX_SIZE Size?

Why your increasing 500 MB in PGA ?

What's your sorr_area_size ??

Babu

[Updated on: Tue, 07 April 2009 07:01]

Report message to a moderator

Re: ORA-27102: out of memory [message #396633 is a reply to message #396628] Tue, 07 April 2009 07:00 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
RAM = 3GB.
SGA_MAX_SIZE i did not specified.

Old pfile was working fine.
But i changed only these parameters.
Quote:
ora01.__db_cache_size
ora01.__java_pool_size
ora01.__large_pool_size
ora01.__shared_pool_size
*.pga_aggregate_target
*.sga_target



Do i need to give SGA_MAX_SIZE in pfile?

If yes what could be the size?

[Updated on: Tue, 07 April 2009 07:03]

Report message to a moderator

Re: ORA-27102: out of memory [message #396636 is a reply to message #396633] Tue, 07 April 2009 07:03 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


>>SGA_MAX_SIZE i did not specified.

Try to start your database using old pfile

1/ connect sys user

Quote:
show parameter sga

show parameter pga

show parameter sort


Let us know the above details.

Babu
Re: ORA-27102: out of memory [message #396639 is a reply to message #396628] Tue, 07 April 2009 07:06 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
SQL> startup pfile='C:\oracle\database\oldinitORA01.ora'
ORACLE instance started.

Total System Global Area  935329792 bytes
Fixed Size                  1252280 bytes
Variable Size             104858696 bytes
Database Buffers          822083584 bytes
Redo Buffers                7135232 bytes
Database mounted.
Database opened.
SQL> show parameter sga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
lock_sga                             boolean     FALSE
pre_page_sga                         boolean     FALSE
sga_max_size                         big integer 892M
sga_target                           big integer 892M
SQL> show parameter pga

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
pga_aggregate_target                 big integer 297M
SQL> show parameter sort

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
nls_sort                             string
sort_area_retained_size              integer     0
sort_area_size                       integer     65536
SQL> 
Re: ORA-27102: out of memory [message #396641 is a reply to message #396639] Tue, 07 April 2009 07:12 Go to previous messageGo to next message
babuknb
Messages: 1736
Registered: December 2005
Location: NJ
Senior Member


Good Question.

Your database occpy 900 MB out of your 3G ram.

First you can increase your sga_max_size upto 2.2 G ( 80% Ram Size) and SGA_TARGET is dynamic parameter (Try to increase 1.5G)

After try to increase PGA.

Quote:
PS: The above statements true only for is there is no services running your operating system. For more detail check your task manager

Babu

Re: ORA-27102: out of memory [message #398519 is a reply to message #396639] Thu, 16 April 2009 09:10 Go to previous messageGo to next message
yanyp2009
Messages: 2
Registered: April 2009
Junior Member

sga_max_size
Set shmall equal to shmmax divided by the page size.
FYI: The page size can be seen using the following command:
$ getconf PAGE_SIZE
The "ulimit -l" parameter is not set to allow the amount of memory (sga size) being requested to be locked.
oracle user execute: ulimit -l unlimited
Refer to the "man" page for ulimit l



vi /etc/security/limits.conf
add:
* soft memlock unlimited
* hard memlock unlimited

please check kernel.shmall parameter

cat /etc/sysctl.conf
kernel.core_uses_pid = 1
kernel.shmmax=10737418240
kernel.sem=250 32000 100 128
kernel.shmall=4194304
Re: ORA-27102: out of memory [message #398521 is a reply to message #398519] Thu, 16 April 2009 09:14 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
yanyp2009 wrote on Thu, 16 April 2009 07:10

sga_max_size
Set shmall equal to shmmax divided by the page size.
FYI: The page size can be seen using the following command:
$ getconf PAGE_SIZE
The "ulimit -l" parameter is not set to allow the amount of memory (sga size) being requested to be locked.
oracle user execute: ulimit -l unlimited
Refer to the "man" page for ulimit l



vi /etc/security/limits.conf
add:
* soft memlock unlimited
* hard memlock unlimited

please check kernel.shmall parameter

cat /etc/sysctl.conf
kernel.core_uses_pid = 1
kernel.shmmax=10737418240
kernel.sem=250 32000 100 128
kernel.shmall=4194304



>*.audit_file_dest='C:/admin/ORA01/adump'
How does any of this apply to a Windows system?
Re: ORA-27102: out of memory [message #398700 is a reply to message #398521] Fri, 17 April 2009 03:12 Go to previous message
yanyp2009
Messages: 2
Registered: April 2009
Junior Member
BlackSwan wrote on Thu, 16 April 2009 09:14
yanyp2009 wrote on Thu, 16 April 2009 07:10

sga_max_size
Set shmall equal to shmmax divided by the page size.
FYI: The page size can be seen using the following command:
$ getconf PAGE_SIZE
The "ulimit -l" parameter is not set to allow the amount of memory (sga size) being requested to be locked.
oracle user execute: ulimit -l unlimited
Refer to the "man" page for ulimit l



vi /etc/security/limits.conf
add:
* soft memlock unlimited
* hard memlock unlimited

please check kernel.shmall parameter

cat /etc/sysctl.conf
kernel.core_uses_pid = 1
kernel.shmmax=10737418240
kernel.sem=250 32000 100 128
kernel.shmall=4194304



>*.audit_file_dest='C:/admin/ORA01/adump'
How does any of this apply to a Windows system?


sorry,I should be look carefulness;
Previous Topic: Oracle 8i
Next Topic: How To Apply Patch
Goto Forum:
  


Current Time: Sat Nov 02 12:20:51 CDT 2024