From oracle-l-bounce@freelists.org Fri May 21 09:52:27 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i4LEq0r15499 for ; Fri, 21 May 2004 09:52:10 -0500 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id i4LEpo615480 for ; Fri, 21 May 2004 09:52:00 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 04F9A72C978; Fri, 21 May 2004 09:40:19 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14109-32; Fri, 21 May 2004 09:40:18 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2C1C172C635; Fri, 21 May 2004 09:40:18 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Fri, 21 May 2004 09:39:01 -0500 (EST) X-Original-To: oracle-l@freelists.org Delivered-To: oracle-l@freelists.org Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 3CE7472C8CD for ; Fri, 21 May 2004 09:39:00 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 14068-02 for ; Fri, 21 May 2004 09:38:59 -0500 (EST) Received: from smtpgate.vicr.com (smtpgate.vicr.com [207.141.187.5]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id C8D0C72C731 for ; Fri, 21 May 2004 09:38:57 -0500 (EST) Received: from 25exch1.vicorpower.vicr.com ([172.20.20.30]) by exchgate.vicorpower.vicr.com with Microsoft SMTPSVC(5.0.2195.6713); Fri, 21 May 2004 10:55:18 -0400 X-MimeOLE: Produced By Microsoft Exchange V6.0.6249.0 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Subject: RE: very odd problem....oracle support has been no help so far. Date: Fri, 21 May 2004 10:55:17 -0400 Message-ID: <4001DEAF7DF9BD498B58B45051FBEA650146C2C6@25exch1.vicorpower.vicr.com> X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: very odd problem....oracle support has been no help so far. Thread-Index: AcQ/QadEtJqdw/pqQYKWA2utBywTMgAAb1OQ From: "Goulet, Dick" To: X-OriginalArrivalTime: 21 May 2004 14:55:18.0083 (UTC) FILETIME=[A1A9B930:01C43F43] X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 1056 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: DGoulet@vicr.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Chris, Two things come to mind, 1) What are the permissions on the database files? Has their ownership = and/or group changed? 2) Try getting the sysadmins to run an fuser command on the files when = the database is known to be down. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -----Original Message----- From: Chris Stephens [mailto:ChrisStephens@affina.com] Sent: Friday, May 21, 2004 10:40 AM To: oracle-l@freelists.org 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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://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@freelists.org put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/ FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------