-
ORA-00470: LGWR process terminated with error
Hi
My development instance keeps on crashing periodically, i am adding new tablespaces and its been failing every hour or so with :
Errors in file /export/oradmin/DSSDVLP/bdump/dssdvlp_pmon_4162.trc:
ORA-00470: LGWR process terminated with error
Thu Feb 14 16:52:29 2008
PMON: terminating instance due to error 470
Instance terminated by PMON, pid = 4162
Thu Feb 14 16:54:51 2008
Here is the output of /var/log/messages
Feb 14 16:52:28 idisoradev kernel: cpu 0 hot: low 32, high 96, batch 16
Feb 14 16:52:28 idisoradev kernel: cpu 0 cold: low 0, high 32, batch 16
Feb 14 16:52:28 idisoradev kernel: cpu 1 hot: low 32, high 96, batch 16
Feb 14 16:52:28 idisoradev kernel: cpu 1 cold: low 0, high 32, batch 16
Feb 14 16:52:28 idisoradev kernel: HighMem per-cpu:
Feb 14 16:52:29 idisoradev kernel: cpu 0 hot: low 32, high 96, batch 16
Feb 14 16:52:31 idisoradev kernel: cpu 0 cold: low 0, high 32, batch 16
Feb 14 16:52:32 idisoradev kernel: cpu 1 hot: low 32, high 96, batch 16
Feb 14 16:52:32 idisoradev kernel: cpu 1 cold: low 0, high 32, batch 16
Feb 14 16:52:34 idisoradev kernel:
Feb 14 16:52:35 idisoradev kernel: Free pages: 15000kB (1600kB HighMem)
Feb 14 16:52:35 idisoradev kernel: Active:61127 inactive:1442545 dirty:136137 writeback:198311 unstable:0 free:3750 slab:44508 mapped:59619 pagetables:2118
Feb 14 16:52:37 idisoradev kernel: DMA free:12568kB min:16kB low:32kB high:48kB active:0kB inactive:0kB present:16384kB pages_scanned:10871 all_unreclaimable? yes
Feb 14 16:52:38 idisoradev kernel: protections[]: 0 0 0
Feb 14 16:52:38 idisoradev kernel: Normal free:832kB min:928kB low:1856kB high:2784kB active:5212kB inactive:653864kB present:901120kB pages_scanned:944493 all_unreclaimable? yes
Feb 14 16:52:39 idisoradev kernel: protections[]: 0 0 0
Feb 14 16:52:41 idisoradev kernel: HighMem free:1600kB min:512kB low:1024kB high:1536kB active:239296kB inactive:5116316kB present:6029312kB pages_scanned:0 all_unreclaimable? no
Feb 14 16:52:43 idisoradev kernel: protections[]: 0 0 0
Feb 14 16:52:48 idisoradev kernel: DMA: 4*4kB 3*8kB 3*16kB 4*32kB 3*64kB 1*128kB 1*256kB 1*512kB 1*1024kB 1*2048kB 2*4096kB = 12568kB
Feb 14 16:52:48 idisoradev kernel: Normal: 32*4kB 88*8kB 0*16kB 0*32kB 0*64kB 0*128kB 0*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 832kB
Feb 14 16:52:48 idisoradev kernel: HighMem: 4*4kB 4*8kB 29*16kB 10*32kB 6*64kB 1*128kB 1*256kB 0*512kB 0*1024kB 0*2048kB 0*4096kB = 1600kB
Feb 14 16:52:49 idisoradev kernel: Swap cache: add 70112, delete 67668, find 10724/12928, race 0+0
Feb 14 16:52:49 idisoradev kernel: 0 bounce buffer pages
Feb 14 16:52:49 idisoradev kernel: Free swap: 9921116kB
Feb 14 16:52:50 idisoradev kernel: 1736704 pages of RAM
Feb 14 16:52:51 idisoradev kernel: 1343436 pages of HIGHMEM
Feb 14 16:52:52 idisoradev kernel: 178948 reserved pages
Feb 14 16:52:53 idisoradev kernel: 1566187 pages shared
Feb 14 16:52:53 idisoradev kernel: 2444 pages swap cached
Feb 14 16:52:53 idisoradev kernel: Out of Memory: Killed process 4172 (oracle).
Milind
-----------------------------
www.milinds.com
My Private World on the Web !
-
This is an O/S issue, not a database issue and adding tablespaces has nothing to do neither with the issue nor with the solution.
You are probably short of memory and/or short of swap space.
Start by adding swap space, memory if you can.
Check your Oracle memory setup, probably is too much for the memory you have in your box.
Check which programs are eating your memory out.
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.
-
$ulimit -a
core file size (blocks, -c) 0
data seg size (kbytes, -d) unlimited
file size (blocks, -f) unlimited
pending signals (-i) 1024
max locked memory (kbytes, -l) 32
max memory size (kbytes, -m) unlimited
open files (-n) 1024
pipe size (512 bytes, -p) 8
POSIX message queues (bytes, -q) 819200
stack size (kbytes, -s) 10240
cpu time (seconds, -t) unlimited
max user processes (-u) 2047
virtual memory (kbytes, -v) unlimited
file locks (-x) unlimited
$ free -m
total used free shared buffers cached
Mem: 6084 6061 23 0 52 5358
-/+ buffers/cache: 650 5434
Swap: 9813 235 9577
Milind
-----------------------------
www.milinds.com
My Private World on the Web !
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|