Re: ora-1102

From: Anthony Hogan <anon_at_spain.es>
Date: Wed, 24 Oct 2001 11:24:41 +0100
Message-ID: <3BD696E9.6D7DE2D5@spain.es>

To add to Sybrand Bakker's remarks:
If you set the SID to a length >4 characters on windows e.g. xxxxdev & xxxprod
then Oracle will throw ora-1102 on 2nd instance startup due to the 8,3 DOS naming
limitation.
In this scenario starting up with the correct init file depends on which instance
you startup first.

hth
Anthony Hogan
hogananthony_at_hotmail.com

Sybrand Bakker wrote:
>
> "Andreas Lommel" <anlommel_at_gmx.de> wrote in message
> news:3bd5691a.23288426_at_news.btx.dtag.de...
> > I have 2 instances on my oracle 8-server. When I start the second
> > instance there is a error ora-1102 cannot mount in exclusive mode.
> > What is the result ?
>
> You either didn't change the ORACLE_SID before starting the second instance
> or you screwed up your setup
>
> Regards,
>
> Sybrand Bakker
> Senior Oracle DBA
Received on Wed Oct 24 2001 - 05:24:41 CDT