Re: Newbie Q: Having difficulty mounting, opening DB other than initial one created during install.

In article <850bul$1hi$1_at_paxfeed.eni.net>,   "Alan Frush" <alanfrush_at_tcisolutions.com> wrote:
> I am using Oracle 8.0.5 on my NT desk top and am trying to open =
> databases I created to run some create DB scripts. I receive a Ora =
> 01102 error unable to open database in exclusive mode. I created
these =
> DB's using the database assistant. The test DB I created during
install =
> I can open just fine. Does anyone have any insight into what might be
=
> causing this problem?
>
> My thanks in advance for any info.

It sounds like you have two databases. I'm assuming you are opening one, then trying to open the other (within your scripts)? Have you changed the oracle sid in the script? That is, when you open the first instance, the $ORACLE_SID is set to test1 [whatever your first instance name is]. You then must set the oracle sid to the next instance you wish to open. You can do this by running 'set ORACLE_SID=foo' where foo represents the name of your second instance.

Cheers,
GC

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Jan 06 2000 - 12:09:56 CST