Re: ORA-27146

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Mon, 4 Feb 2002 22:38:30 +0100
Message-ID: <u5u18ntllsr65e@corp.supernews.com>

"Cameron Abbott" <cvabbott_at_altavista.com> wrote in message news:a3mp75$293$1_at_bcarh8ab.ca.nortel.com...
> Hi,
>
> I am trying to create a databse on a server that already has one database
> created on it. I have created a new init.ora file for the new DB and
> changed the Oracle SID to the new DB. When I try to do a startup nomount
I
> receive an oracle error ORA-27146 post/wait initialization failed. Can
> someone point me in the direction of problem. I don't think it is a
problem
> with the Oracle installation because I already have one DB running on this
> machine, a SUN server with Oracle 8.1.5.
>
> Thanks
> Cameron
>
>

One of the reasons for this errors you have defined an insufficient number of semaphores (so the problem is you already have a DB) the number of semaphores should equal 2 * (the sum of the processes parameter of all instances) + 5 * the number of instances. These semaphores are acquired at startup.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address

Received on Mon Feb 04 2002 - 15:38:30 CST