Re: [suse-oracle] Database creation fails

From: Hartmut Berghoff (h.berghoff@gmx.de)
Date: Sat Oct 05 2002 - 14:28:20 CEST

  • Next message: Hartmut Berghoff: "Re: [suse-oracle] Assistants ORA8i" 
    Message-ID: <3D9EDAE4.4040103@gmx.de>
Date: Sat, 05 Oct 2002 14:28:20 +0200
From: Hartmut Berghoff <h.berghoff@gmx.de>
Subject: Re: [suse-oracle] Database creation fails

    Hello Thomas,

    Create databse command expects as standard location for the initfiles the
    ORACLE_HOME/dbs. The starterdatabase creation tool however has stored it
    under $ORCLE_BASE/admin/db-name/pfile, but with that it didn't start. So I
    place my initfiles in the last mentioned location (create the
    .../admin/db-name directory with owner oracle:oinstall) and create a link
    for each one under the 1st location.

    Reff, Thomas wrote:

    > Hi,
    >
    > the creation of the first Database on our new SuSE SLES 7 Server fails with
    > the following error:
    >
    > oracle@sope10:/orabase > ORACLE_SID=AK05
    > oracle@sope10:/orabase > export ORACLE_SID
    > oracle@sope10:/orabase > sqlplus /nolog
    >
    > SQL*Plus: Release 8.1.7.0.0 - Production on Sa Okt 5 14:00:00 2002
    >
    > (c) Copyright 2000 Oracle Corporation. All rights reserved.
    >
    > SQL> connect sys/oracle as sysdba
    > Connected to an idle instance.
    > SQL> startup nomount pfile = "/orabase/admin/AK05/pfile/initAK05.ora"

    Is AK05 SID and DB-name (DB-name from initak05.ora)?
    IS /orabase your installtion directory?

    > ORA-24323: value not allowed
    > ORA-03113: end-of-file on communication channel
    > SQL>

    Have you checked all parameters of your initak05.ora?

    I don't now, wether ORACLE allows AK05 or needs ak05. I allway use lower case.

    If that doesn't matter is your SID in the initAK05.ora also written in capitals?

    >
    > The "orarun.rpm" is installed, serveral Patches too.
    > Does anybody has an idea?
    >
    > Thanks in advance,
    >
    > Thomas Reff
    >
    > SOPTIM AG
    > Heinrich-Held-Straße 33
    > D-45133 Essen
    >
    > Telefon: +49 201 / 8 42 10-0
    > Fax: +49 201 / 8 42 10-18
    >
    > mailto:reff@soptim.de
    > http://www.soptim.de
    >
    >

    If you like, I can send you my initbedv.ora. You modify paramteters to your
    need. Place it as I did and try startup nomount (no need for pfile=...). -
    Of course ORACLE_SID set to your value (ak05).

    Hartmut

    >
    > ---------------------------------------------------------------------
    > To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    > For additional commands, e-mail: suse-oracle-help@suse.com
    > Please see http://www.suse.com/oracle/ before posting
    >
    >
    >

    ---------------------------------------------------------------------
    To unsubscribe, e-mail: suse-oracle-unsubscribe@suse.com
    For additional commands, e-mail: suse-oracle-help@suse.com
    Please see http://www.suse.com/oracle/ before posting

    This archive was generated by hypermail 2.1.4 : Sat Oct 05 2002 - 14:28:52 CEST