Oracle, Troubleshooting

ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

hello,

problem : ORA-27102: out of memory Linux-x86_64 Error: 28: No space left on device

 

Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 981795
Additional information: -1
ORA-31693: Table data object "EBDYSLIVE"."VeriTarihcesi":"SYS_P726" failed to load/unload and is being skipped due to error:
ORA-31644: unable to position to block number 842047 in dump file "/oracle/export/EBDYS/expebdys_04.dmp"
ORA-19502: write error on file "/oracle/export/EBDYS/expebdys_04.dmp", block number 842047 (block size=4096)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 842047
Additional information: -1
ORA-31693: Table data object "EBDYSLIVE"."VeriTarihcesi":"SYS_P787" failed to load/unload and is being skipped due to error:
ORA-31644: unable to position to block number 981855 in dump file "/oracle/export/EBDYS/expebdys_03.dmp"
ORA-19502: write error on file "/oracle/export/EBDYS/expebdys_03.dmp", block number 981855 (block size=4096)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 981855
Additional information: -1
ORA-39126: Worker unexpected fatal error in KUPW$WORKER.MAIN [TABLE_DATA:"SYSMAN"."MGMT_METRICS_1HOUR"]
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 10568
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 3425
ORA-24795: Illegal ROLLBACK attempt made
ORA-24795: Illegal ROLLBACK attempt made
ORA-06512: at "SYS.KUPW$WORKER", line 16524
ORA-19502: write error on file "/oracle/export/EBDYS/expebdys_02.dmp", block number 1006207 (block size=4096)
ORA-27072: File I/O error
Linux-x86_64 Error: 28: No space left on device
Additional information: 4
Additional information: 1006207
Additional information: -1

solutions :

Solution:

Check the page size:
#getconf PAGE_SIZE
4096

Calculate proper value for shmall:

The value of shmall should be:

Shmall=total size of the SGAs on the system/page size.

Let’s assume the size of the SGA is 16GB in the system then it would be 1024 * 1024 * 1024 * 16 / 4096 = 4194304

Change shmall in /etc/sysctl.conf
vi /etc/sysctl.conf   

kernel.shmall = 4194304

Apply the changes:

# sysctl -p  

check shmall value after change
# sysctl -A | grep shmall

 

Advertisements
Standard

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s