DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: abnormal termination of instance

  1. #1
    Join Date
    Jun 2000
    Posts
    104
    hello,
    this is the extract of alertlog.
    SNP0: terminating instance due to error 472
    Instance terminated by SNP0, pid = 190
    whats this error all about?

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    if one background process dies then the whole database will go down ad this is what is happening with your database since snp0 is one of processes that manages scheduled jobs

  3. #3
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi,
    Do you have any alert log files or trace .trc files generated and can u post it.

  4. #4
    Join Date
    Jun 2000
    Posts
    104
    but I donot have any scheduled jobs and raghu I posted the extracts of alertlog do U need any trace files.

  5. #5
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi,
    If u have any trace file generated with SNP,just post it and if you mention the operation system and which version of oracle u r using it will be greatful.

  6. #6
    Join Date
    Jun 2000
    Posts
    104
    DBW0: terminating instance due to error 472
    Instance terminated by DBW0, pid = 94
    Shutting down instance (abort)
    License high water mark = 17
    this error came now twice in aday db shutdown occured due to bg process, what might be the cause.

  7. #7
    Join Date
    Jun 2000
    Posts
    104
    hello,
    this is a trace file generated by pmon,no files were generated by snp or dbw0 processes.
    Dump file E:\ORACLE\admin\ORTELAPP\bdump\ortelappPMON.TRC
    Thu Nov 09 09:48:44 2000
    ORACLE V8.1.5.0.0 - Production vsnsta=0
    vsnsql=d vsnxtr=3
    Windows NT V4.0, OS V5.101, CPU type 586
    Oracle8i Release 8.1.5.0.0 - Production
    With the Java option
    PL/SQL Release 8.1.5.0.0 - Production
    Windows NT V4.0, OS V5.101, CPU type 586
    Instance name: ortelapp

    Redo thread mounted by this instance: 0 <none>

    Oracle process number: 3

    Windows thread id: 153, image: ORACLE.EXE


    *** SESSION ID:(2.1) 2000.11.09.09.48.44.000
    kvotenlg: epc_init failed. EPC error: 191

    i have oracle 8.1.5 on win NT-4.0.


  8. #8
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    If you have oracle_trace_enable=TRUE in init.ora file, but you do not have files *.dat in the Oraclehome/otrace/admin/

    try out like this

    1)If you want to disable OTRACE, make sure in init.ora file you set

    oracle_trace_enable = FALSE

    You can also verify that files

    collect.dat, facility.dat and regid.dat are removed from dir-ry
    ORACLE_HOME/otrace/admin.

    (2) if you want to enable OTRACE, make sure in init.ora file you set

    oracle_trace_enable = TRUE.

    Also, the following command executed in ORACLE_HOME/otrace/admin dir-ry will create (re-create) the *.dat files needed for this utility:

    ORACLE_HOME/otrace/admin> otrccref



  9. #9
    Join Date
    Jun 2000
    Posts
    104
    Dump file E:\ORACLE\admin\ORTELAPP\udump\ORA00127.TRC
    Tue Nov 14 17:36:46 2000
    ORACLE V8.1.5.0.0 - Production vsnsta=0
    vsnsql=d vsnxtr=3
    Windows NT V4.0, OS V5.101, CPU type 586
    Oracle8i Release 8.1.5.0.0 - Production
    With the Java option
    PL/SQL Release 8.1.5.0.0 - Production
    Windows NT V4.0, OS V5.101, CPU type 586
    Instance name: ortelapp

    Redo thread mounted by this instance: 1

    Oracle process number: 17

    Windows thread id: 127, image: ORACLE.EXE


    *** SESSION ID:(11.12) 2000.11.14.17.36.46.390
    kvotenlg: epc_init failed. EPC error: 95
    Dump file E:\ORACLE\admin\ORTELAPP\udump\ORA00127.TRC
    Tue Nov 14 17:38:53 2000
    ORACLE V8.1.5.0.0 - Production vsnsta=0
    vsnsql=d vsnxtr=3
    Windows NT V4.0, OS V5.101, CPU type 586
    Oracle8i Release 8.1.5.0.0 - Production
    With the Java option
    PL/SQL Release 8.1.5.0.0 - Production
    Windows NT V4.0, OS V5.101, CPU type 586
    Instance name: ortelapp

    Redo thread mounted by this instance: 1

    Oracle process number: 19

    Windows thread id: 127, image: ORACLE.EXE


    *** 2000.11.14.17.38.53.531
    *** SESSION ID:(16.13) 2000.11.14.17.38.53.531
    kvotenlg: epc_init failed. EPC error: 95
    *** 2000.11.14.17.39.59.531
    FATAL ERROR IN TWO-TASK SERVER: error = 12571
    *** 2000.11.14.17.39.59.531
    ksedmp: internal or fatal error
    ----- Call Stack Trace -----
    calling call entry argument values in hex
    location type point (? means dubious value)
    -------------------- -------- -------------------- ----------------------------
    _ksedmp+a5 CALLrel _ksedst+0
    041E4EC
    _opitsk+f68 CALLrel _ksedmp+0 2
    _opiino+50c CALLrel _opitsk+0 0
    _opiodr+4ce CALLreg 00000000 3C 4
    3041FBF8
    _opidrv+380 CALLrel _opiodr+0 3C 4
    3041FBF8
    0
    _sou2o+19 CALLrel _opidrv+0
    _opimai+110 CALLrel _sou2o+0
    _OracleThreadStart@4+48c CALLrel _opimai+0 2
    3041FE78
    77F04EE5 CALLreg 00000000
    ----- Argument/Register Address Dump -----
    Argument/Register addr=3041e4ec. Dump of memory from 0x3041E4AC to 0x3041E5EC
    3041E4A0 00023A81 00000000 00000002 65522198 00000033
    3041E4C0 00000000 0000003B 00000213 00000000 00000000 00000000 00000000 0000001D
    3041E4E0 001B1898 3041E4FC 00418404 00C936B4 00C936B4 00C936B4 00C936BC 00C936B4
    3041E500 00C936B4 00C936B4 00C936B4 00C936BC 001B1898 00000000 00000000 00000000
    3041E520 001B1898 3041E5D4 004191E0 3041E538 0000001C 00000000 2A2A2A0A 30303220
    3041E540 31312E30 2E34312E 332E3731 39352E39 32332D25 2D252073 25207338 7332332D
    3041E560 30470020 00000001 00002F78 0000311B 34303320 37454631 25200038 7332332D
    3041E580 342D2520 00000A73 30470030 655221B0 00000033 00000000 001B1898 0046CA19
    3041E5A0 00000000 00000000 00000000 3041FFEC 00000000 3041FE78 00000000 00000001
    3041E5C0 00000001 00000000 3041DD34 00000003 3041E5F8 0046823A 3041E510 00000000
    3041E5E0 0000311B 001B4350 00000000
    Argument/Register addr=3041fbf8. Dump of memory from 0x3041FBB8 to 0x3041FCF8
    3041FBA0 77F1C823 3041FBEC
    3041FBC0 001F0003 30474350 002EB760 00000000 00000000 00000000 0000004C 3041FBCC
    3041FBE0 00000000 00000000 00000000 00000418 3041FC10 77F1C7A6 3041FD87 FFFFFFFF
    3041FC00 00000000 00000001 00000000 3041FE78 0040100D 3041FFB8 00402F81 00000002
    3041FC20 3041FE78 00129E94 00000010 0012A014 001B7020 00000000 00000000 00000000
    3041FC40 00000000 00000000 00000000 00000000 00000000 00000000 44414853 00000000
    3041FC60 00000000 00000002 00FFD358 00000000 00000428 00000000 00000000 00000000
    3041FC80 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    Repeat 2 times
    3041FCE0 00000000 00000000 00000000 00000000 77B27081 77B20000
    Argument/Register addr=3041fe78. Dump of memory from 0x3041FE38 to 0x3041FF78
    3041FE20 FFFFFFFF 3041FE54
    3041FE40 77F8882F 00400000 00131DDC 00400000 74FF7B39 3041FE9C 77F64027 00400000
    3041FE60 00000001 00000009 3041FE78 00131DDC 7FFDF000 74FF7B39 3041FD78 3041FD87
    3041FE80 3041FE3C 3041FE6C 3041FF0C 61726F2A 77617073 65725F6E 5F796C70 6574726F
    3041FEA0 7070616C 3732315F 0000002A 3041FF1C 00000000 77F6125B 77FA5560 77F61261
    3041FEC0 3041FF30 00000010 0012A014 00000000 00000000 00000000 00000000 00000000
    3041FEE0 00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000
    3041FF00 00000000 3041FEC0 00000000 FFFFFFFF 77F91FA4 77F9D0E8 FFFFFFFF 00000000
    3041FF20 77F76387 77F7638F 3041FF30 00000001 00010017 00000000 00000000 00000000
    3041FF40 00000000 00004001 00000000 00000000 F0420DE0 00000000 E115C638 801A3F49
    3041FF60 F0420DE0 F0420E98 00000000 00000088 C0502000 C0503F1C
    ----- End of Call Stack Trace -----
    ===================================================
    Files currently opened by this process:
    ===================================================
    PROCESS STATE
    -------------
    Process global information:
    process: 1c26b384, call: 0, xact: 0, curses: 0, usrses: 1c2cea14
    ----------------------------------------
    SO: 1c26b384, type: 1, owner: 0, flag: INIT/-/-/0x00
    (process) Oracle pid=19, calls cur/top: 0/1c3d486c, flag: (0) -
    int error: 0, call error: 0, sess error: 0, txn error 0
    (post info) last post received: 0 0 6
    last post received-location: ksusig
    last process to post me: 1c26b384 1 0
    last post sent: 1089 8 8
    last post sent-location: ksupsc
    last process posted by me: 1c268194 1 6
    (latch info) wait_event=0 bits=0
    Process Group: DEFAULT, pseudo proc: 1c2c3888
    O/S info: user: SYSTEM, term: APPSERVER, ospid: 127
    OSD pid info: 127
    ----------------------------------------
    SO: 1c2cea14, type: 3, owner: 1c26b384, flag: INIT/-/-/0x00
    (session) trans: 0, creator: 1c26b384, flag: (8000041) USR/- -/-/-/-/-/-
    DID: 0001-0013-00000002, short-term DID: 0000-0000-00000000
    txn branch: 0
    oct: 0, prv: 0, user: 0/SYS
    O/S info: user: Administrator, term: APPSERVER, ospid: 89:170, machine: ORTEL\APPSERVER
    program: svrmgrl.exe
    last wait for 'SQL*Net break/reset to client' seq=122 wait_time=-1
    driver id=42455100, break?=1, =0
    ----------------------------------------
    SO: 19871d54, type: 33, owner: 1c2cea14, flag: INIT/-/-/0x00
    LIBRARY OBJECT LOCK: lock=19871d54 handle=178f4c6c mode=N
    call pin=19872ca4 session pin=0
    user=1c2cea14 session=1c2cea14 count=1 flags=CBB/[02] savepoint=3
    LIBRARY OBJECT HANDLE: handle=178f4c6c
    name=SYS.DATABASE
    hash=aea96fa0 timestamp=12-31-4712 23:59:59
    namespace=EVNT flags=TIM/SML/[02000000]
    kkkk-dddd-llll=0000-0009-0009 lock=N pin=0 latch=1
    lwt=178f4c84[178f4c84,178f4c84] ltm=178f4c8c[178f4c8c,178f4c8c]
    pwt=178f4c9c[178f4c9c,178f4c9c] ptm=178f4cf4[178f4cf4,178f4cf4]
    ref=178f4c74[178f4c74,178f4c74]
    LIBRARY OBJECT: object=178f49f4
    type=? flags=EXS/LOC[0005] pflags= [00] status=VALD load=0
    DATA BLOCKS:
    data# heap pointer status pins change
    ----- -------- -------- ------ ---- ------
    0 178f4bfc 178f4ad8 I/-/A 0 NONE
    3 178f4a88 178f4718 I/-/A 0 NONE
    ----------------------------------------
    SO: 1c4e115c, type: 9, owner: 1c26b384, flag: INIT/-/-/0x00
    (broadcast handle) flag: (2) ACTIVE SUBSCRIBER, owner: 1c26b384,
    event: 25, last message event: 25, messages read: 0
    channel: (1c4e1f8c) system events broadcast channel
    scope: 101, event: 25, last mesage event: 0,
    publishers/subscribers: 0/8,
    messages published: 0
    ----------------------------------------
    SO: 1c3d486c, type: 2, owner: 1c26b384, flag: INIT/-/-/0x00
    (call) sess: cur 1c2cea14, rec 0, usr 1c2cea14; depth: 0
    END OF PROCESS STATE

    this is the trace file generated.
    and again this lgwr process failed with this entry in alertlog.
    LGWR: terminating instance due to error 472
    Instance terminated by LGWR, pid = 153


  10. #10
    Join Date
    Mar 2000
    Location
    india
    Posts
    54
    Hi,
    Have you u checked the things which I posted earlier.

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