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

Yes...that would take a day or so.

-----Original Message-----
From: Khedr, Waleed [mailto:Waleed.Khedr@xxxxxxx] 
Sent: Friday, May 21, 2004 9:45 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: RE: very odd problem....oracle support has been no help so far.

Is it too much work to drop/recreate these MV's?

Waleed

-----Original Message-----
From: Chris Stephens [mailto:ChrisStephens@xxxxxxxxxx]
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 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@xxxxxxxxxxxxx
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@xxxxxxxxxxxxx
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
-----------------------------------------------------------------

Other related posts: