Leslie,
It appears that there is an action occuring on your database at 18:20
each day that needs the tablespace that was deleted. It might be a
scheduled job or an application that is external to the server. try
restoring the tablespace from your backup and see if the errors
continue.
I also would start investigation the reason for the ALTER and DROP
commands.
An ITAR would help speed up the process.
Ron
>>> leslie_y_lu_at_yahoo.com 07/23/02 07:09PM >>>
Hi Ron,
Thank you! Actually the "Dropping TS" only happened
on 7/15. There are no other special actions since
7/15. And after 7/15, the error shows after "alter
database open".
Sorry didn't make it clear.
- Ron Rogers <RROGERS_at_galottery.org> wrote:
> Leslie,
> You say the message appears at 18:20 each day.
> Check and see what jobs
> have been added to the system since 7/15 that would
> effect the database.
> Perhaps an erronious, undocumented action has been
> added that is
> altering your system and dropping a critical
> tablespace.
> Why would you want to drop a tablespace the same
> time every day? Are
> you using partitioning and used the wrong command to
> drop the partition?
> Just a thought.
> Ron
> ROR mô¿ôm
>
> >>> dgoulet_at_vicr.com 07/23/02 04:21PM >>>
> open an iTAR.
>
> ____________________Reply
> Separator____________________
> Author: Leslie Lu <leslie_y_lu_at_yahoo.com>
> Date: 7/23/2002 11:54 AM
>
> Hi all,
>
> I have a 817 db on NT. In the alter log, I have the
> following error since 7/15. (The error repeats
> about
> 30 times.)
>
> Mon Jul 15 16:11:32 2002
> Errors in file
> D:\Oracle\admin\DLYLASTG\udump\ORA01070.TRC:
> ORA-00600: internal error code, arguments: [18062],
> [], [], [], [], [], [], []
>
> The actions before the error were ALTER SYSTEM SET
> global_names=FALSE; and drop a tablespace.
>
> And after 7/15, the same message shows every day
> around 18:20pm.(The error repeats about 30 times.)
>
> in the related trace file, I got:
>
> *** SESSION ID:(12.28226) 2002-07-15 16:15:01.156
> *** 2002-07-15 16:15:01.156
> ksedmp: internal or fatal error
>
> What does this mean and what I should do? The
> metalink doesn't help too much.
>
> Thank you.
>
> Leslie
>
>
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Health - Feel better, live better
> http://health.yahoo.com
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Leslie Lu
> INET: leslie_y_lu_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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: Ron Rogers
> INET: RROGERS_at_galottery.org
>
> Fat City Netw
ork Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
> 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).
Do You Yahoo!?
Yahoo! Health - Feel better, live better
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
INET: leslie_y_lu_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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: Ron Rogers
INET: RROGERS_at_galottery.org
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
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 Wed Jul 24 2002 - 07:23:30 CDT
