RE: error 472

Ora-472 is a very non-specific PMON error. You've probably already worked through this with support using a TAR, but if you still are having problems and wanted to post the following it would help:

The stack trace from your pmon traces (they'll either be in bdump or udump, and by stack trace I mean just the section of the trace near the beginning with lines like this:
----- Call Stack Trace -----

calling              call     entry                argument values in hex      
location             type     point                (? means dubious value)     
-------------------- -------- -------------------- ----------------------------
ssexhd   +  256      ????     ksedst               1D15 ? 0 ? A ? 0 ?
ssexhd   +    8      ????     ssexhd               7F7F8678 ? 4011CA78 ?
                                                   4011E170 ? 4011CAE8 ?
Adr: 0xC01D072C      ????     Adr: 0xC020FE10      7F7F82C0 ? 55 ? 400FE9A0 ?
                                                   400F4B38 ?
nioqrc   +  596      ????     Adr: 0xC01D072C      7F7F82C0 ? 55 ? 400FE9A0 ?
                                                   400F4B38 ?
nioqrc   +    8      ????     nioqrc               400EF530 ? 47 ? 7F7F6B44 ?

The version of the RDBMS, OS, etc.

Regards,
Chris Gait

On 22 Nov 2002 at 10:19, April Wells wrote:

Date sent:      	Fri, 22 Nov 2002 10:19:18 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-
L_at_fatcity.com>
Send reply to:  	ORACLE-L_at_fatcity.com
Organization:   	Fat City Network Services, San Diego, California

> 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).
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: cjgait_at_earthlink.net

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).