Re: error during oracle shutdown, sometimes, why?

From: Barry P. Grove <grovebg_at_iSTAR.ca>
Date: 1997/05/21
Message-ID: <5ltls8$rr9@news.istar.ca>#1/1

Pui Ming WONG wrote:
>
> Recently i noticed the following error message
> ORA-00600 internal error code arguments: [730],[720],
> [space leak],[],[]
> during the shutdown of our Oracle (7.1.6 )
> But it does not appear sometimes.
> Seems to have heard no users complaining getting errors
> in their Oracle work.
> But this error does not put my mind to rest.
> Is it fatal ? What causes it ?
> --

Hi,

I've found that I got space leaks in 7.1.6 and 7.2.3 after dropping, and recreating tablespaces on the fly usually to gather several of the datafiles back into one. I perform all the usual stuff:

   alter tablespace xxxx offline normal;    drop tablespace xxxx including contents; then from O/S remove the datafiles:

   rm xxxx.dbs
and recreate again

   create tablespace xxxx

     datafile 'xxxx.dbs'
     default storage(....);

Next time I shutdown the database I get an ORA-600 space leak. It doesn't seem to be harmful, but often the shared memory segments and semaphores are left in memory (we're using Digital Unix v3.2c). Rather than rebooting the machine to clear, I can use the ipcrm command to remove these. Oracle can be successfully restarted after that.

Hope this helps....

-- 
Barry P. Grove                          BarrySoft Systems Applications
grovebg_at_iSTAR.ca                        (604)929-5433
Developer, Oracle DBA, Unix Sysadmin    North Vancouver, BC, V7H-2G4

Received on Wed May 21 1997 - 00:00:00 CDT