Yeah...i found that one yesterday. I validated the structure of individual mv's that I attempted to resfresh on their own. They all validated fine but the refreshes never completed. The other bugs have to do with chained rows. I could see this for 1 or 2 mv's but not 5 or 6 (that I've tested individually) or more. Anyways, the database will no longer start so I can't get into it. Since there are other production databases on the machine, a reboot isn't something I can just do. My tar has been 'immediate response required' for the last 5 hours with no updates. Very very frustrating. Thank you for the suggestion though. -----Original Message----- From: Bobak, Mark [mailto:Mark.Bobak@xxxxxxxxxxxxxxx] Sent: Friday, May 21, 2004 9:47 AM To: oracle-l@xxxxxxxxxxxxx Subject: RE: very odd problem....oracle support has been no help so far. Chris, If you check the ORA-600 lookup on MetaLink, Doc ID 153788.1, it will point you to Doc ID 39399.1 for ORI[6731] and Doc ID 29616.1 for = ORI[17090]. Both docs have some useful info. Hope it helps, -Mark -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of Chris Stephens Sent: Friday, May 21, 2004 10:40 AM To: oracle-l@xxxxxxxxxxxxx Subject: very odd problem....oracle support has been no help so far. 8.1.7.2 on HP 11 Two days ago we had a problem with our san that crashed a few of our databases. I was told failed drives but I don't know how to validate = that and communication on the issue has been sketchy. Everything seems to be fine except for one database. It is a reporting database that contains replicated data from a remote site. =20 The refresh of the materialized views is scheduled for every 2 hours. = When the job runs we receive a 600 error with the following arguments: ORA-00600: internal error code, arguments: [6731], [1], [0], [3], [], = [], [], [] ORA-00600: internal error code, arguments: [17090], [], [], [], [], [], = [], [] ORA-12012: error on auto execute of job 41 ORA-12008: error in snapshot refresh path And it gets worse. I tried shutting down the database with 'shutdown immediate'...nothing. 'Shutdown abort'..ok. Startup returns: SQL> conn / as sysdba Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 87521768 bytes Fixed Size 104936 bytes Variable Size 38092800 bytes Database Buffers 49152000 bytes Redo Buffers 172032 bytes ORA-01102: cannot mount database in EXCLUSIVE mode SQL> I then shutdown abort and ps -ef | grep SID. There are several = processes out there. I try to kill -9 them but they won't go away. =20 Sysadmins can't kill the processes either. We reboot the machine, = processes are gone. Startup the database. Run the refresh.....it 'hangs' for = hours and hours. Shutdown the database after trying to figure out what is = going on (possibly rollback from crash?...but no) and the try to restart but receive the same unable to mount error with associated processes. The = other weird thing is that the majority of datafiles in the database have not = been touched or updated by oracle in some time. =20 I don't know what to do. I opened a tar from oracle but have received no help so far. Anyone have any ideas? Thanks chris ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html ----------------------------------------------------------------- ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------