Return-Path: <oracle-l-bounce@freelists.org>
Delivered-To: 2-oracle-l@orafaq.com
Received: (qmail 8551 invoked from network); 19 Sep 2007 13:39:58 -0500
Received: from freelists-180.iquest.net (HELO turing.freelists.org) (206.53.239.180)
  by 69.64.49.119 with SMTP; 19 Sep 2007 13:39:57 -0500
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0B72775DE11;
 Wed, 19 Sep 2007 14:39:57 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 29356-09; Wed, 19 Sep 2007 14:39:56 -0400 (EDT)
Received: from turing (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 7748475DFD8;
 Wed, 19 Sep 2007 14:39:56 -0400 (EDT)
Received: with ECARTIS (v1.0.0; list oracle-l); Wed, 19 Sep 2007 13:54:56 -0400 (EDT)
Received: from localhost (localhost [127.0.0.1])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id A9A2275D716
 for <oracle-l@freelists.org>; Wed, 19 Sep 2007 13:54:56 -0400 (EDT)
Received: from turing.freelists.org ([127.0.0.1])
 by localhost (turing.freelists.org [127.0.0.1]) (amavisd-new, port 10024)
 with ESMTP id 20622-10 for <oracle-l@freelists.org>;
 Wed, 19 Sep 2007 13:54:56 -0400 (EDT)
Received: from wa-out-1112.google.com (wa-out-1112.google.com [209.85.146.182])
 by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 6D31B75D3D2
 for <oracle-l@freelists.org>; Wed, 19 Sep 2007 13:54:56 -0400 (EDT)
Received: by wa-out-1112.google.com with SMTP id k22so344358waf
        for <oracle-l@freelists.org>; Wed, 19 Sep 2007 10:54:56 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
        d=gmail.com; s=beta;
        h=domainkey-signature:received:received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        bh=ztE6OrAkmdMu1yxWj6nY+QDv3YT7i7Q9jxSVurxUngw=;
        b=jFMhARVz4ERnSgf5dnmggFgnS+TTdVd5iMxIEAd10TS4UU2HrVVoNSHzLiCrolvpE+dR7MU5PMh6qtJ7WsroQwDHAjRL6fM996L6CTLAufUH8HswR/eetB3aIlmdpDB3hhcfmftxS/G4bWGM2XQlaz0LPwbTubZdRiBUKbQ+wsY=
DomainKey-Signature: a=rsa-sha1; c=nofws;
        d=gmail.com; s=beta;
        h=received:message-id:date:from:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references;
        b=StENatBmq8FPuhJk5oZkpYpxNKmkZR5w5aTz2+LfeCxisCvKMPxvYBCJ1a2io2eIEBEWin2+r3RVPoDqvA1Ea/imXWR3j/ALc1dL9ICN22g4k8fzizVqGSANk0Su0hM3yEzG2UAFi+AFRbd+2ZtdAu5i9FRVa5lF8gTXTXPjwSg=
Received: by 10.114.135.1 with SMTP id i1mr192492wad.1190224496179;
        Wed, 19 Sep 2007 10:54:56 -0700 (PDT)
Received: by 10.114.127.13 with HTTP; Wed, 19 Sep 2007 10:54:56 -0700 (PDT)
Message-ID: <7765c8970709191054wd91772fl8836935af260cdab@mail.gmail.com>
Date: Wed, 19 Sep 2007 18:54:56 +0100
From: "Niall Litchfield" <niall.litchfield@gmail.com>
To: ryan_gaffuri@comcast.net, oracle-l@freelists.org
Subject: Re: fixing a bad oracle install
In-Reply-To: <091920071500.8838.46F13997000F3630000022862200751150079D9A00000E09A1020E979D@comcast.net>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1
Content-Disposition: inline
References: <091920071500.8838.46F13997000F3630000022862200751150079D9A00000E09A1020E979D@comcast.net>
X-archive-position: 1711
X-ecartis-version: Ecartis v1.0.0
Sender: oracle-l-bounce@freelists.org
Errors-to: oracle-l-bounce@freelists.org
X-original-sender: niall.litchfield@gmail.com
Precedence: normal
Reply-to: niall.litchfield@gmail.com
List-help: <mailto:ecartis@freelists.org?Subject=help>
List-unsubscribe: <oracle-l-request@freelists.org?Subject=unsubscribe>
List-software: Ecartis version 1.0.0
List-Id: oracle-l <oracle-l.freelists.org>
X-List-ID: oracle-l <oracle-l.freelists.org>
List-subscribe: <oracle-l-request@freelists.org?Subject=subscribe>
List-owner: <mailto:steve.adams@ixora.com.au>
List-post: <mailto:oracle-l@freelists.org>
List-archive: <http://www.freelists.org/archives/oracle-l>
X-list: oracle-l
X-Virus-Scanned: Debian amavisd-new at localhost.localdomain

How on earth did you export a database that was down?

On 19/09/2007, ryan_gaffuri@comcast.net <ryan_gaffuri@comcast.net> wrote:
> We were hitting shared memory errors. Googled it and this is common when an
> Oracle install is wrong. I looked into it and the kernel parameters were
> never set(I didnt do the install). This is in Redhat 5.0 with Oracle
> 10.2.0.1. Set the kernetl parameters and stepped through the install to make
> sure ulimit, etc... was correct. Started up the DB and got the same error.
>
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux-x86_64 Error: 2: No such file or directory
>
> So I shut the DB down. did an export for a quick backup(its just development
> data). Uninstaled the software and then reinstalled.
>
> started up the DB and had the same problem. I had to make a new database and
> import the data to it to start over. I am ok for now, but for future
> reference, is any DB created with a bad install hosed and I have to make a
> new DB? The new DB works fine so far with the imported data.
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>


-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info
--
http://www.freelists.org/webpage/oracle-l


