New diagonistic tool is introduced in 11g. Using which we can gather all the information relevant to an issue and upload to oracle or investigate by yourself.
adrci is executable in $ORACLE_HOME/bin location
$ adrci ADRCI: Release 11.1.0.7.0 - Production on Mon Jul 26 04:08:33 2010 Copyright (c) 1982, 2007, Oracle. All rights reserved. ADR base = "/opt/apps/oracle" adrci> adrci> show home ADR Homes: diag/rdbms/db1 diag/rdbms/db2 diag/rdbms/db3 diag/rdbms/db4 diag/tnslsnr/hostname/listener_bor3rep adrci> set homepath diag/rdbms/db1 adrci> show problem ==> this will report the problem recently poped up in the db. ************************************************************************* PROBLEM_ID          PROBLEM_KEY                                                LAST_INCIDENT       LASTINC_TIME -------------------- ----------------------------------------------------------- -------------------- ---------------------------------------- 3                   ORA 7445 [_memset()+120]                                   32093               2010-07-25 18:01:06.962092 -04:00 4                   ORA 7445 [_doprnt()+44]                                    32077               2010-07-25 18:01:03.642031 -04:00 2                   ORA 4030                                                   32270               2010-07-25 18:01:00.837604 -04:00 1                   ORA 7445 [ioc_pin_shared_executable_object()+952]          28842               2010-06-05 22:39:34.757161 -04:00 4 rows fetched If you want to diagonise 4030 error, then adrci> ips pack problem 2 in /tmp Generated package 3 in file /tmp/ORA4030_20100726041042_COM_1.zip, mode complete
Upload the trace file to oracle or use it for investigation. Has all the information relevant to 4030 error.
convert this post to pdf.