From oracle-l-bounce@freelists.org Wed May 5 04:31:24 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i459Us313634 for ; Wed, 5 May 2004 04:31:04 -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 i459Ui613606 for ; Wed, 5 May 2004 04:30:54 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6CDE072CDFB; Wed, 5 May 2004 04:21:39 -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 27450-06; Wed, 5 May 2004 04:21:39 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 38C2872CDF4; Wed, 5 May 2004 04:21:38 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 05 May 2004 04:20:20 -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 10FAA72CBB8 for ; Wed, 5 May 2004 04:20: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 23159-79 for ; Wed, 5 May 2004 04:20:19 -0500 (EST) Received: from bristol24.audit-commission.gov.uk (mailhost.audit-commission.gov.uk [193.128.236.210]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D639872CBAD for ; Wed, 5 May 2004 04:20:18 -0500 (EST) Received: from bristol44.audit-commission.gov.uk (bristol44.audit-commission.gov.uk) by bristol24.audit-commission.gov.uk (Content Technologies SMTPRS 4.3.6) with ESMTP id for ; Wed, 5 May 2004 10:33:57 +0100 Received: from bristol43.audit-commission.gov.uk ([172.17.1.15]) by bristol44.audit-commission.gov.uk with Microsoft SMTPSVC (5.0.2195.6713); Wed, 5 May 2004 10:33:52 +0100 X-MimeOLE: Produced By Microsoft Exchange V6.0.6487.1 content-class: urn:content-classes:message MIME-Version: 1.0 Content-type: text/plain Subject: More spfile goodness Date: Wed, 5 May 2004 10:33:52 +0100 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: More spfile goodness Thread-Index: AcQyhBQI/jdCwmDqQBGf+33DxerUcg== From: "Niall Litchfield" To: X-OriginalArrivalTime: 05 May 2004 09:33:52.0906 (UTC) FILETIME=[14313EA0:01C43284] X-Virus-Scanned: by amavisd-new at freelists.org Content-Transfer-Encoding: 8bit X-archive-position: 4412 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: n-litchfield@audit-commission.gov.uk Precedence: normal Reply-To: oracle-l@freelists.org X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 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 SQL> create pfile from spfile; create pfile from spfile * ERROR at line 1: ORA-00600: internal error code, arguments: [733], [538970160], [pga heap], [], [], [], [], [] The 733 argument shows that is essentially an out of memory condition, the second argument is the amount of memory in bytes requested! This is apparently due to a corrupt spfile - per support. Niall Litchfield Oracle DBA Audit Commission +44 117 975 7805 ********************************************************************** 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 ---------------------------------------------------------------- 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 -----------------------------------------------------------------