View Full Version : how install multiple instances of Workmanager schema on Windows 2000?

06-11-2004, 04:23 AM
Hi all
Is possible to install multiple instances of workmanager schema(multiple SID) on windows 2000?
In hp-ux is so simple to manage multiple sid.


10-06-2004, 02:32 AM
I tried to do this a little while ago, it is not really possible as when starting the database server, the oracle sid is read from the registry.
Whilst you can create a new database server service, this will always read the hardcoded registry entry.
The only workaround I had was to modify the registry entry for HKEY_LOCAL_MACHINE\SOFTWARE\CoCreate\WorkManager DatabaseServer\CurrentVersion\ORACLE_SID and port in between starting the different services. This is not really a valid solution for a production system though.