Re: Two instances out of one ORACLE_HOME (Windows 2008 R2 Server)
- From: Subodh Deshpande <deshpande.subodh@xxxxxxxxx>
- To: usn@xxxxxxxxx
- Date: Fri, 27 Aug 2010 13:35:43 +0530
Martin,
You can have as many as SID configured and running on your single host,
provided there is suffcient memory.
have you checked the environement variables, default SID is set what value,
did you checked the services in service panel of the the sids..whats their
status it should be either automatic or manual, started
you should be able to start the first one you configured I suppose...
did you configured the listener and tnsentries proprely..for default oracle
home with one sid usually there is no problem
tnsping abc
tnsping zyz
they should resolve other wise you will get sqlnet.ora file error
mostly for the second one you are facing the problem
set you ahve configured two sids abc and xyz
then go to command prompt set ORACLE_SID=XYZ
sqlplus /nolog
conn sys as sysdba -> (if this does not work then try conn sys@xyz as
sysdba, provided you have proper tns entires)
startup file_name
thanks!
Subodh
On 27 August 2010 12:43, Martin Klier <usn@xxxxxxxxx> wrote:
> Good CEST morning.
>
> I try to run two instances out of one oracle_home on a Windows 2008R2
> server (bad OS, but not my choice).
>
> Problems are, that all databases are using the DIAG directory (crates a
> new subdir with the correct SID anyway) configured by the instance that
> has been configured last. And the second instance fails with ugly
> semaphore errors. I think they try to use the same ressource for the
> same reason they use the same DIAG dir.
>
>
>
> Fri Aug 27 08:30:30 2010
> RECO started with pid=15, OS id=4896
> Fri Aug 27 08:30:30 2010
> MMON started with pid=16, OS id=5104
> starting up 1 dispatcher(s) for network address
> '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
> starting up 1 shared server(s) ...
> ORACLE_BASE from environment = D:\app\oracle
> Fri Aug 27 08:30:30 2010
> alter database mount exclusive
> ORA-09341: scumnt: Datenbank kann nicht mit MOUNT angeschlossen werden
> OSD-04400: Interne Semaphore für Prozess kann nicht abgerufen werden
> O/S-Error: (OS 183) Eine Datei kann nicht erstellt werden, wenn sie
> bereits vorhanden ist.
> ORA-1102 signalled during: alter database mount exclusive...
>
>
>
>
> My questions are: I have no ORACLE_SID configured on system level. How
> does the box determine the oracle_sid used for a process in services.msc?
>
> Second: After establishing the instances with DBCA, everything was well,
> the insatnces did run simultanously. After stopping/starting both
> services, the mess described above happened. Do I have a wrong setup
> somehow?
>
> I want to use one oracle_home, because I want to avoid different patch
> levels and messing around with setting/changing ORACLE_HOME all the time.
>
> Thanks in advance!
> Martin
> --
> Usn's IT Blog for Linux, Oracle, Asterisk
> http://www.usn-it.de
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>
--
==============================
DO NOT FORGET TO SMILE TODAY
==============================
Other related posts:
