From oracle-l-bounce@freelists.org Tue Jul 13 22:10:00 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i6E39jW04495 for ; Tue, 13 Jul 2004 22:09:55 -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 i6E39Y604482 for ; Tue, 13 Jul 2004 22:09:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 643DB72CBE2; Tue, 13 Jul 2004 21:49:59 -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 14070-45; Tue, 13 Jul 2004 21:49:59 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 51BF772CC88; Tue, 13 Jul 2004 21:49:53 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 13 Jul 2004 21:48:21 -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 A8F7B72C360 for ; Tue, 13 Jul 2004 21:48:20 -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 14070-03 for ; Tue, 13 Jul 2004 21:48:20 -0500 (EST) Received: from web41508.mail.yahoo.com (web41508.mail.yahoo.com [66.218.93.91]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with SMTP id 2EF3872C808 for ; Tue, 13 Jul 2004 21:48:20 -0500 (EST) Message-ID: <20040714031309.30420.qmail@web41508.mail.yahoo.com> Received: from [193.32.3.82] by web41508.mail.yahoo.com via HTTP; Tue, 13 Jul 2004 20:13:09 PDT Date: Tue, 13 Jul 2004 20:13:09 -0700 (PDT) From: K Gopalakrishnan Subject: Re: Can't open database To: oracle-l@freelists.org In-Reply-To: MIME-Version: 1.0 Content-type: text/plain; charset=us-ascii X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 5037 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: kaygopal@yahoo.com Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Riv: OERI-2662 is raised when there is a SCN Mis-match between block-SCN and current-SCN. You can bump the SCN globally to a higher number and open the database. I suggest you contact Oracle Support before venturning in to this. --- Rivaldi Bahar wrote: > Yes, ora-600[2662] when 'alter database open resetlogs' > after put undocumented parameter in init.ora. > > Thanks. > > -riv- > > On Tue, 13 Jul 2004 06:56:15 -0700 (PDT) > K Gopalakrishnan wrote: > >Hi, > > > >Can you post the errors? Are you getting ORA-600[2662]? > > > > ===== Have a nice day !! ------------------------------------------------------------ Best Regards, K Gopalakrishnan, Co-Author: Oracle Wait Interface: Oracle Press 2004. http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/ __________________________________ Do you Yahoo!? Yahoo! Mail is new and improved - Check it out! http://promotions.yahoo.com/new_mail ---------------------------------------------------------------- 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 -----------------------------------------------------------------