Re: Oracle 8.1.7 - Cannot create Database

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 23 Mar 2002 22:08:40 +0100
Message-ID: <birp9ucbo7esgjh1i1bod9dqujmbhud541@4ax.com>

On Sat, 23 Mar 2002 18:21:47 +0100, Michael Schwarz <michael_schw_at_web.de> wrote:

>Hello.
>
>I've installed Oracle 8.1.7 EE on Debian GNU/Linux 3.0. During the installation
>or later with dbassist, i can't create a database.
>
>This is what comes instead:
>
>"ORA-03113: end-of-file on communication channel"
>
>and
>
>"ORA-03114: not connected to ORACLE"
>
>Any solution for this problem?
>
>Please help.
>
>Michael Schwarz

On Unix this is usually being caused by incorrect semaphore settings and/or incorrect shared memory settings, so that either Oracle can't allocate sufficient semaphores (by default each process takes 2 semaphores) or you have defined your SGA so big, it won't fit in shared memory.
Further details should be available in the alert${ORACLE_SID}.log

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Mar 23 2002 - 15:08:40 CST