From oracle-l-bounce@freelists.org Wed May 5 10:20:14 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i45FJnI31359 for ; Wed, 5 May 2004 10:19:59 -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 i45FJd631320 for ; Wed, 5 May 2004 10:19:49 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D8DB572C97A; Wed, 5 May 2004 10:09:51 -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 12321-25; Wed, 5 May 2004 10:09:51 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6388172D13D; Wed, 5 May 2004 10:09:48 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 10:08:33 -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 0D9F772CAA7 for ; Wed, 5 May 2004 10:08:15 -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 11843-14 for ; Wed, 5 May 2004 10:08:14 -0500 (EST) Received: from mail.mdw.ac.at (mail.mdw.ac.at [193.170.215.205]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 2D54872CB21 for ; Wed, 5 May 2004 10:08:14 -0500 (EST) Received: from MDW-MTA by mail.mdw.ac.at with Novell_GroupWise; Wed, 05 May 2004 17:18:24 +0200 Message-Id: X-Mailer: Novell GroupWise Internet Agent 6.0.3 Date: Wed, 05 May 2004 17:18:03 +0200 From: "Markus Reger" To: Subject: Antw: More spfile goodness Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit Content-Disposition: inline X-Virus-Scanned: by amavisd-new at freelists.org X-archive-position: 4439 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Reger@mdw.ac.at Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org pls check this out. http://metalink.oracle.com/metalink/plsql/showdoc?db=3DNot&id=3D153788.1 doesn't say a word about corrupt spfile. is a problem with sort_area_size = and might be resolved by some pfile or spfile params. kr=20 >>> n-litchfield@audit-commission.gov.uk 05.05.2004 11:33:52 >>> A while back we had a conversation about the advisability or not of using = spfiles. IIRC what I suggested was sensible if you were going to use them = was that you create a backup first using the create pfile from spfile = command. I ran into this today =20 SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-00600: internal error code, arguments: [733], [538970160], [pga heap], = [], [], [], [], [] =20 The 733 argument shows that is essentially an out of memory condition, the = second argument is the amount of memory in bytes requested!=20 =20 This is apparently due to a corrupt spfile - per support.=20 =20 Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805=20 =20 ********************************************************************** This email contains information intended for the addressee only. It may be confidential and may be the subject of legal and/or professional privilege. Any dissemination, distribution, copyright or use of this communication without prior permission of the sender is strictly prohibited. ********************************************************************** ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com=20 ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@freelists.org=20 put 'unsubscribe' in the subject line. -- Archives are at http://www.freelists.org/archives/oracle-l/=20 FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html=20 ----------------------------------------------------------------- ---------------------------------------------------------------- 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 -----------------------------------------------------------------