Re: Urgent/desperat: Multiple Instances

As far as the third database is concerned, it may seem obvious, but have you checked that the first two databases don't refer to that file in some way !

Since it is often easiest to create a new database by copying the init.ora, create database scripts, etc. associated with one database and then renaming the dbname, data files, etc. its an easy mistake to make.

Jan M. Stankovsky wrote in message <34ED415F.FDABE55C_at_ifs.univie.ac.at>...
>I'm trying to create multiple Database and to start multiple instances
>with ORacle 734 under SOlaris 2.5.1.
>At installation I've created the database oracle73 (sid : oracle73).
>After that i've tried to create with the Oracle Installer the
>databse michip (sid:michip).
>
>I cant start both of them with dbstart or svrmgrl.
>I can start oracle73 with dbstart and i have to use svrmgrl (after
>setting ORACLE_SID
>to michip ) to start michip.
> Not everybody can use both databases. oracle7(the oracleowener) can use
>michip but not oracle73 , me as a normal user can use oracle73 but not
>iistest [both get the errormessages:
>
>ERROR: ORA-01034: ORACLE not available
>ORA-07429: smsgsg: shmget() failed to get segment.
>SVR4 Error: 2: No such file or directory
>
>I've check all permissions but it appears to be allright)
>
>
>After creating a third database (iistest;sid iistest) I cant even start
>this one with svrmgrl i get:
>ORA-00205: error in identifying control file
>'/usr/local2/Oracle734/oradata/iistest/control01.ctl'
>ORA-09782: sfifi: another instance has the same database mounted.
>
>How is it done with multiple instance/database. What could cause these
>problems.
>
>thanks
>
>
>
>
>--
>____________________________ __________________________________
>Ing. Jan M. STANKOVSKY ][ +1 406-23-67-15
>University of Vienna ][ +1 403-73-43
>Dep. of Informationssystems ][ jan_at_ifs.univie.ac.at
>1010 Vienna ][ http://www.ifs.univie.ac.at/~jan
>____________________________][__________________________________
Received on Sat Feb 21 1998 - 00:00:00 CST