dbaplusplus_at_hotmail.com wrote:
> ricforduk_at_yahoo.co.uk wrote:
>> Check the file database\oradim.log
>
>
> I do not see any file oradim.log.
>
> When I look in alert.log, it has following message related to AQ when
> shutdown immediate was done:
>
> Sun Aug 13 05:00:24 2006
> Job queue slave processes stopped
> Sun Aug 13 05:00:24 2006
> Errors in file
> e:\oracle\dev\product\10.1.0\admin\itgdev\udump\itgdev_ora_3032.trc:
> ORA-01089: immediate shutdown in progress - no operations are permitted
> ORA-06512: at "SYS.DBMS_AQ", line 577
> ORA-06512: at "SYSMAN.EMD_NOTIFICATION", line 492
> ORA-06512: at line 1
>
>
> Trace file ha slot of cryptic information.
>
>
> I am still looking whether there is a way to uspply one's own shudtown
> script from Oracle Service. Will contact metalink support.
Seems to clearly indicate AQ is being used. Likely by a background
process. If this is 10.2.0.2.0 are you finding a large number of large
trace files being written to BDUMP?
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Aug 14 2006 - 10:50:44 CDT
