Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: can't create database

Re: can't create database

From: Schwerdtfeger, <schwerdtfeger_at_softconcept.net>
Date: Wed, 12 Mar 2003 07:19:53 -0800
Message-ID: <F001.00567847.20030312071953@fatcity.com>


Am Mit, 2003-03-12 um 10.28 schrieb Christoph Schwerdtfeger:
> Am Die, 2003-03-11 um 19.47 schrieb Alan Davey:
> > I had the same error message on NT with Oracle 9.2 recently.
> >
> > The first problem was that the init_sid.ora file was created a directory different from where the db create scripts were looking for it. The second problem was that one of the init parameters was for Enterprise Edition and I was installing Standard Edition.
> >
> > Both problems resulted in the message of 'not connected to oracle'.
> >
> > Come to think of it, I don't think I've ever had a version of the DB Creation wizard work without getting some error.
> > --
> >
> > Alan Davey
> > adavey_at_competitrack.com
> > 718-482-4200 x106
> >
> >
> > On 3/11/2003 12:44 PM, Stahlke, Mark <mstahlke_at_denvernewspaperagency.com> wrote:
> > >RE: LMT monitoring
> > >Is this on Linux?
> > >If yes, then it sounds like you need to install the glibc stubs patch.
> > >If no, then I don't know what the problem might be.
> > >
> > >-----Original Message-----
> > >From: Milen Pankov [mailto:m_pankov_at_hotmail.com]
> > >Sent: Tuesday, March 11, 2003 10:00 AM
> > >To: Multiple recipients of list ORACLE-L
> > >Subject: can't create database
> > >
> > >
> > >can't create a database with oracle 8.1.7.
> > >the installation went fine, but when i start dbassist on the 2% of
> > >the
> > >database creation it tels me:
> > >"not connected to oracle".
> > >any ideas?
> > >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
>
> Hi there.
>
> I have a similiar problem with Oracle 9.2.0.1.0 under Linux (Debian,
> Woody, Kernel 2.4.20-686-smp).
> The installation worked fine - at least no error message was shown,
> but when I start the dbca to create a database, I get an ORA-03113.
> I've searched over the internet (newsgroups and webpages), but I didn't
> find a solution for my problem.
> I searched for the libc-patch, but I think it's deprecated for Oracle
> 9i.
> Many ppl said, like you, I just should generate the scripts with the
> wizard and create the database manually, so I did - or at least I tried.
>
> So, I just wanted to test, if the login works, but it didn't.
> Is startet "sqlplus /nolog" and tried "connect SYS/change_on_install as
> SYSDBA" ("conn / as SYSDBA" has the same effect, ORACLE_SID set as said
> in the script) and I get:
>
> Connected to an idle instance.
>
> Ok, I think this is just normal and I tried to start the database using
> "startup nomount pfile="Correct path to init.ora";
>
> And then, all I get is an ORA-03113: end-of-file on communication
> channel
>
> If I try to do a "conn /" afterwards, I get
> ORA-01034: ORACLE not available
> ORA-27101: shared memory realm does not exist
> Linux Error: 2: No such file or directory
>
> Any suggestions, what could be wrong? I installed the Enterprise
> Version, so it can't be an Enterprise setting ... it has to be a problem
> in the "init.ora", right?
>
> System specs if required:
> Pentium II, 800 (2x - multi processor)
> 1024MB RAM
> 4GB Swap
> 19GB diskspace free
> Debian Linux (woody)
> Kernel 2.4.20-686-smp
>
> Any help would be appreciated.
>
> --
> Christoph Schwerdtfeger <schwerdtfeger_at_softconcept.net>
>
> SoftConcept GmbH
> Borriesstrasse 35
> D-32257 Bünde
>
> Tel: (05223) 4970-20
> E-Mail: schwerdtfeger_at_softconcept.net
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.net

Ok, I just deinstalled Oracle 9i and installed 8.1.7 which ran - after applying the patch - without any problems ... dunno why. Maybe I should try to apply the 8.1.7-glibc patch to the 9i?

-- 
Christoph Schwerdtfeger <schwerdtfeger_at_softconcept.net>

SoftConcept GmbH
Borriesstrasse 35
D-32257 Bünde

Tel:    (05223) 4970-20
E-Mail: schwerdtfeger_at_softconcept.net

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Schwerdtfeger, "Christop
  INET: schwerdtfeger_at_softconcept.net

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
Received on Wed Mar 12 2003 - 09:19:53 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US