very odd problem....oracle support has been no help so far. 2004-05-21 - By Chris Stephens
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@(protected)]
Sent: Friday, May 21, 2004 9:47 AM
To: oracle-l@(protected)
Subject: RE: very odd problem....oracle support has been no help so far.
Chris,
If you check the ORA-600 (See ORA-600.ora-code.com) 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@(protected)
[mailto:oracle-l-bounce@(protected)]On Behalf Of Chris Stephens
Sent: Friday, May 21, 2004 10:40 AM
To: oracle-l@(protected)
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 (See ORA-00600.ora-code.com): internal error code, arguments: [6731], [1], [0], [3], [], =
[],
[], []
ORA-00600 (See ORA-00600.ora-code.com): internal error code, arguments: [17090], [], [], [], [], [], =
[],
[]
ORA-12012 (See ORA-12012.ora-code.com): error on auto execute of job 41
ORA-12008 (See ORA-12008.ora-code.com): 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 (See ORA-01102.ora-code.com): 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@(protected)
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@(protected)
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@(protected)
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
-- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- ---- --
|
|
