RE: very odd problem....oracle support has been no help so far.

From: Ruth Gramolini <rgramolini_at_tax.state.vt.us>
Date: Fri, 21 May 2004 11:48:15 -0400
Message-ID: <003101c43f4b$0798ad80$8459699f@vttaxnet.tax.state.vt.us>

Has anyone done anything to your password file? I know this sounds too simple, but that EXCLUSIVE error is a password file error. In 9i having a password file error causes other weird manifestations.

Just the thot,
Ruth

-----Original Message-----

  From: oracle-l-bounce_at_freelists.org
  [mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Chris Stephens   Sent: Friday, May 21, 2004 10:40 AM
  To: oracle-l_at_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.   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.

  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.

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_at_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_at_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
-----------------------------------------------------------------

Received on Fri May 21 2004 - 10:45:19 CDT