Internal Error Code Arguments 17090
we had a problem with our san that crashed a few of ourdatabases. I was told failed drives but I don't know how to validate thatand communication on the issue has been sketchy.Everything seems to be fine except for one database. It is a reportingdatabase that contains replicated data from a remote site.The refresh of the materialized views is scheduled for every 2 hours. Whenthe 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 41ORA-12008: error in snapshot refresh pathAnd it gets worse. I tried shutting down the database with 'shutdownimmediate'...nothing. 'Shutdown abort'..ok. Startup returns:SQL> conn / as sysdbaConnected to an idle instance.SQL> startupORACLE instance started.Total System Global Area 87521768 bytesFixed Size 104936 bytesVariable Size 38092800 bytesDatabase Buffers 49152000 bytesRedo Buffers 172032 bytesORA-01102: cannot mount database in EXCLUSIVE modeSQL>I then shutdown abort and ps -ef | grep SID. There are several processesout there. I try to kill -9 them but they won't go away.Sysadmins can't kill the processes either. We reboot the machine, processesare gone. Startup the database. Run the refresh.....it 'hangs' for hoursand hours. Shutdown the database after trying to figure out what is goingon (possibly rollback from crash?...but no) and the try to restart butreceive the same unable to mount error with associated processes. The otherweird thing is that the majority of datafiles in the database have not beentouched 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?ThankschrisPlease see the official ORACLE-L FAQ: http://www.orafaq.comTo unsubscribe send email to: oracle-l-request_at_freelists.orgput '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 reply Tweet Search Discussions Search All Groups oracle-l 26 respon
One NodePart-I Shutdown All Running OracleInstance Copy files from one Linux machine toanother LISTENER: Not all endpointsregistered EXPDP failed after upgrade from 11.2.0.1 to11.2.0.3 $ORACLE_HOME/bin/oracle executable file permission issue inRAC ABOUT ASH Categories 11g RAC (4) Data Guard (2) EXPDP (1) Operating System (2) Performance Tuning (1) SQL Scripts (4) General Scripts (2) SQL Tuning Scripts (2) SQL Tuning (1) http://grokbase.com/t/freelists.org/oracle-l/045na5qgn6/very-odd-problem-oracle-support-has-been-no-help-so-far Uncategorized (2) $ORACLE_HOME/bin/oracle executable file permission issue inRAC Posted: June 20, 2013 in 11g RAC 1 Problem Description: - One of our client has requested to enable TAF as the database running in 2-Node 11.2.0.3 RAC but before to make changes on live we have decided to perform proper testing https://oakinoracle.wordpress.com/2013/06/20/caution-when-non-cluster-database-home-running-in-cluster-environment/ in test box but unfortunately client test database running in single instance mode so we decided to install 11.2.0.3 RAC and create a replica of existing test database in cluster environment. Everything went smooth, we have successfully installed Grid binaries, configured ASM diskgroup, Installed cluster database binaries and we were at the final stage to creating replica of test database but we stuck at this point due to some problem in accessing ASM storage. We faced below error when we try to take image copy backup of test database for creating replica database in cluster environment. { RMAN> backup as copy database format ‘+data2’; RMAN Error:- RMAN-00571: =========================================================== RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS =============== RMAN-00571: =========================================================== RMAN-03009: failure of backup command on ORA_DISK_1 channel at 06/20/2013 10:50:23 RMAN-10038: database session for channel ORA_DISK_1 terminated unexpectedly } Even we tried to create a tablespace just to check ASM storage acces
Date: Wed, 23 Apr 2003 07:36:41 -0800 Message-ID: