Re: ORA-03114: not connected to Oracle (...during Oracle8.1.7 install)

From: Tom <trenfro_at_i-55.com>
Date: Tue, 20 Aug 2002 19:59:44 -0500
Message-ID: <ajuodp$q8b$1@news.datasync.com>

leszek wrote:

> Hello,
>
> I'm installing Oracle 8.1.7 on Solaris. During the last phase of the
> install I've got an error saying that it's not connected to Oracle:
> "ORA-03114: not connected to Oracle"
>
> The only options that I have on the popup window is "Ignore or Abort".
>
> I'm new to Oracle and I don't want to run again the database setup
> (very time consuming). Please let me know what should I do...
>
> Any help is greatly apprieciated,
> Leszek

If for some reason the database can't start, you will receive that error upon running the database creation part of the installation. On Solaris, with 8i, the install guide specifies shared memory (shm) and semaphore (sem) kernel params that are much too low. Try increasing them, especially the SHMMNI and SHMSEG parameters. I think we bumped them both up by a factor of 10 to get Oracle to start.

Once it's started, run the dbassist program to create the database.

HTH -Tom Received on Tue Aug 20 2002 - 19:59:44 CDT