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?
Printable View
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?
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
Hi,
Do you have any alert log files or trace .trc files generated and can u post it.
but I donot have any scheduled jobs and raghu I posted the extracts of alertlog do U need any trace files.
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.
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.
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
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.
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
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
Hi,
Have you u checked the things which I posted earlier.
hi,
my parameter oracle trace enable is true.and in otrace\admin also I have some files facility.dat and collect.dat,do u need any one of them,in certain interval the bg proceses are dying.snp0,dbw0,lgwr,these process r dying,what's the prob?
anybody pl help.