ORA-00470: LGWR process terminated with error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: ORA-00470: LGWR process terminated with error

  1. #1
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41

    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 !

  2. #2
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    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.

  3. #3
    Join Date
    Jun 2005
    Location
    Florida
    Posts
    41
    $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
  •  



Click Here to Expand Forum to Full Width