Re: ORA-3114: not connected to ORACLE on DB creation

As others have said , most likely pre-install stuff not done.

But, there is also a thorough note in Metalink on 3114 on the server for less likely (I think) stuff. For example, the shared memory or semaphores may not be getting "freed up" from previous "tries at install" or if there is an existing db you thought was completely shutdown (but still has shared memory and/or semaphores in use).

--

  "Matt Darcy" <matt_at_darcy.demon.co.uk> wrote in message news:b9gr2g$dns$1_at_hercules.btinternet.com...   Hi all,

  I am trying to install Oracle 8.1.7 on HPUX11

  All goes well until I get to the database creation section of the install, where I get a
  ORA-3114: not connected to ORACLE error

  I have searched through metalink and found this article which is the same as my problem but on Solaris.

  Problem Description

  During a new installation of 8.1.7, while Oracle Database Configuration

  Assistant was running, in the Initializing database stage, about 82% complete,

  you receive the following error:

     ORA-3114: not connected to ORACLE

  Even running DBASSIST standalone after exiting the Installer, you still get the

  same error at the same point.

  Solution Description

  Increase the value of the kernel parameters semmsl and semmns to

  allow for an additional 150 processes.      

  Explanation

  The Solaris installation guide says to use the following kernel parameters:

    set semsys:seminfo semmsl=100

    set semsys:seminfo semmns=200

  The default database created by dbassist has a processes parameter of 150.

  You can recalculate your semaphores to allow for 150 processes or if this

  is the only instance the following /etc/system lines would be correct:

    set semsys:seminfo semmsl=160

    set semsys:seminfo semmns=310

  References

  Additional Search Words

  database configuration assistant dbassist install ora-3114

  The problem is there kernel paramters are solaris only, what is the HPUX version of these parameters, or is there a different fix for HPUX.

  Thanks,

  Matt

--
Received on Fri May 09 2003 - 23:48:55 CEST