ORA-27102: out of memory [message #396628] |
Tue, 07 April 2009 06:53 |
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 #396633 is a reply to message #396628] |
Tue, 07 April 2009 07:00 |
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 #396639 is a reply to message #396628] |
Tue, 07 April 2009 07:06 |
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 #398519 is a reply to message #396639] |
Thu, 16 April 2009 09:10 |
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 #398700 is a reply to message #398521] |
Fri, 17 April 2009 03:12 |
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;
|
|
|