Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: error 472

RE: error 472

From: April Wells <awells_at_csedge.com>
Date: Fri, 22 Nov 2002 10:19:19 -0800
Message-ID: <F001.0050984D.20021122101919@fatcity.com> 





There is nothing vaguely resembling anything helpful in either the core dump
or the PMON file.  That is where the boat load of metalink docs say to
start, but there is nothing in there that is in any way indicative of what
is going on.



Driving me nuts!  There is no real commonality in when it crashes.  



April Wells


Oracle DBA 


Great spirits have always encountered violent opposition from mediocre minds


-- Albert Einstein






-----Original Message-----



Sent: Friday, November 22, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L




Did you look in the PMON trace file? Does anything appear there that might
shed some light on the problem?



RF



Robert G. Freeman - Oracle OCP


Oracle Database Architect


CSX Midtier Database Administration


Author of several Oracle books you can find on Amazon.com!



Londo Mollari: Ah, arrogance and stupidity all in the same package. How
efficient of you. 



 





-----Original Message-----



Sent: Friday, November 22, 2002 11:59 AM
To: Multiple recipients of list ORACLE-L




I have cloned an 8.1.7.0 database from another instance (clone doc from
metalink for Apps) on AIX 4.3.3.  I don't THINK this is connected to the
clone or (directly) to apps.



Since I brought the database back up after the clone successfully, it keeps
crashing with <pick a process> terminating instance due to error 472 



It comes back when I start it.



The interval between startup and crash appears arbitrary.



What can be accomplished while the database is up is logical stuff... I can
run apps jobs, I can update and select from tables, I can do ddl, I can
manually log switch.



Metalink has BOAT LOADS of docs on this happening, but I haven't found
anything that I am permitted to see that has a resolution.  I have an Itar,
but that is not yet yielding any information.



Has anyone seen similar problems, and (if so) IS there a resolution?



Thanks in advance for any advice


ajw



April Wells


Oracle DBA 


Great spirits have always encountered violent opposition from mediocre minds


-- Albert Einstein








begin 666 InterScan_Disclaimer.txt


M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&-O;6UU;FEC871I

M;VXL(&EN8VQU9&EN9R!A='1A8VAM96YT<RP@:7,@<W1R:6-T;'D_at_8V]N9FED
M96YT:6%L(&%N9"!F;W(@=&AE(&EN=&5N9&5D('5S92!O9B!T:&4_at_861D<F5S

M<V5E(&]N;'D[(&ET(&UA>2!A;'-O(&-O;G1A:6X@<')O<')I971A<GDL('!R
M:6-E('-E;G-I=&EV92P@;W(@;&5G86QL>2!P<FEV:6QE9V5D(&EN9F]R;6%T
M:6]N+B!.;W1I8V4@:7,@:&5R96)Y(&=I=F5N('1H870_at_86YY(&1I<V-L;W-U


M<F4L(&1I<W1R:6)U=&EO;BP_at_9&ES<V5M:6YA=&EO;BP@=7-E+"!O<B!C;W!Y
M:6YG(&]F('1H92!I;F9O<FUA=&EO;B!B>2!A;GEO;F4@;W1H97(@=&AA;B!T
M:&4@:6YT96YD960@<F5C:7!I96YT(&ES('-T<FEC=&QY('!R;VAI8FET960@
M86YD(&UA>2!B92!I;&QE9V%L+B!)9B!Y;W4@:&%V92!R96-E:79E9"!T:&ES

M(&-O;6UU;FEC871I;VX@:6X_at_97)R;W(L('!L96%S92!N;W1I9GD@=&AE('-E
M;F1E<B!I;6UE9&EA=&5L>2!B>2!R97!L>2!E+6UA:6PL(&1E;&5T92!T:&ES
M(&-O;6UU;FEC871I;VXL(&%N9"!D97-T<F]Y(&%L;"!C;W!I97,N( T*#0I#
M;W)P;W)A=&4_at_4WES=&5M<RP_at_26YC+B!H87,@=&%K96X@<F5A<V]N86)L92!P


M<F5C875T:6]N<R!T;R!E;G-U<F4@=&AA="!A;GD_at_871T86-H;65N="!T;R!T
M:&ES(&4M;6%I;"!H87,@8F5E;B!S=V5P="!F;W(@=FER=7-E<RX_at_5V4@<W!E
M8VEF:6-A;&QY(&1I<V-L86EM(&%L;"!L:6%B:6QI='D_at_86YD('=I;&P_at_86-C

M97!T(&YO(')E<W!O;G-I8FEL:71Y(&9O<B!A;GD_at_9&%M86=E('-U<W1A:6YE
M9"!A<R!A(')E<W5L="!O9B!S;V9T=V%R92!V:7)U<V5S(&%N9"!A9'9I<V4@
M>6]U('1O(&-A<G)Y(&]U="!Y;W5R(&]W;B!V:7)U<R!C:&5C:W,@8F5F;W)E
M(&]P96YI;F<@86YY(&%T=&%C:&UE;G0N#0H-"E1H92!I;F9O<FUA=&EO;B!C
M;VYT86EN960@:6X@=&AI<R!C;VUM=6YI8V%T:6]N+"!I;F-L=61I;F<@871T
M86-H;65N=',L(&ES('-T<FEC=&QY(&-O;F9I9&5N=&EA;"!A;F0_at_9F]R('1H
M92!I;G1E;F1E9"!U<V4@;V8@=&AE(&%D9')E<W-E92!O;FQY.R!I="!M87D@


M86QS;R!C;VYT86EN('!R;W!R:65T87)Y+"!P<FEC92!S96YS:71I=F4L(&]R
M(&QE9V%L;'D@<')I=FEL96=E9"!I;F9O<FUA=&EO;BX_at_3F]T:6-E(&ES(&AE

M<F5B>2!G:79E;B!T:&%T(&%N>2!D:7-C;&]S=7)E+"!D:7-T<FEB=71I;VXL
M(&1I<W-E;6EN871I;VXL('5S92P@;W(@8V]P>6EN9R!O9B!T:&4@:6YF;W)M
M871I;VX_at_8GD@86YY;VYE(&]T:&5R('1H86X@=&AE(&EN=&5N9&5D(')E8VEP


M:65N="!I<R!S=')I8W1L>2!P<F]H:6)I=&5D(&%N9"!M87D_at_8F4@:6QL96=A
M;"X_at_268@>6]U(&AA=F4@<F5C96EV960@=&AI<R!C;VUM=6YI8V%T:6]N(&EN
M(&5R<F]R+"!P;&5A<V4@;F]T:69Y('1H92!S96YD97(@:6UM961I871E;'D@
M8GD@<F5P;'D_at_92UM86EL+"!D96QE=&4@=&AI<R!C;VUM=6YI8V%T:6]N+"!A
M;F0_at_9&5S=')O>2!A;&P_at_8V]P:65S+B -"@T*0V]R<&]R871E(%-Y<W1E;7,L
M($EN8RX@:&%S('1A:V5N(')E87-O;F%B;&4@<')E8V%U=&EO;G,@=&\@96YS
M=7)E('1H870_at_86YY(&%T=&%C:&UE;G0@=&\@=&AI<R!E+6UA:6P@:&%S(&)E
M96X@<W=E<'0_at_9F]R('9I<G5S97,N(%=E('-P96-I9FEC86QL>2!D:7-C;&%I

M;2!A;&P@;&EA8FEL:71Y(&%N9"!W:6QL(&%C8V5P="!N;R!R97-P;VYS:6)I
M;&ET>2!F;W(@86YY(&1A;6%G92!S=7-T86EN960_at_87,@82!R97-U;'0@;V8@
M<V]F='=A<F4@=FER=7-E<R!A;F0_at_861V:7-E('EO=2!T;R!C87)R>2!O=70@


M>6]U<B!O=VX@=FER=7,@8VAE8VMS(&)E9F]R92!O<&5N:6YG(&%N>2!A='1A


-8VAM96YT+@T*#0H-"@  




end




-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 



Author: April Wells


  INET: awells_at_csedge.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 



Author: Freeman, Robert


  INET: Robert_Freeman_at_csx.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 



Please see the official ORACLE-L FAQ: http://www.orafaq.com


-- 



Author: April Wells


  INET: awells_at_csedge.com


Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services


---------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message


to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Fri Nov 22 2002 - 12:19:19 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US