NT - Multiple instances - v8.0.5 [message #369333] |
Thu, 17 August 2000 15:57 |
Michael
Messages: 61 Registered: October 1999
|
Member |
|
|
Has anyone had success in putting multiple Oracle databases on one NT box? I have a couple small applications that could easy use one box -- if only Oracle would better support it and I could work through the multiple home issues.
Many thanks in advance !
|
|
|
|
Re: NT - Multiple instances - v8.0.5 [message #369340 is a reply to message #369333] |
Fri, 18 August 2000 09:51 |
-sven
Messages: 11 Registered: August 2000
|
Junior Member |
|
|
It is possible to have more than one Oracle instance running on an NT server, but unless separate instances are really required, I think Mr. Webb's suggestion of implementing the two databases as separate schemas within a single instance is usually a better way to go.
|
|
|
Re: NT - Multiple instances - v8.0.5 [message #369351 is a reply to message #369333] |
Wed, 23 August 2000 03:01 |
Tuncay
Messages: 1 Registered: August 2000
|
Junior Member |
|
|
I have 2 separate instances working on the same Oracle 8.1.5 NT box. I just create an instance (NT sevice) with ORADIM, startup instance with NOMOUNT and create the database. To have 2 instance online at the same time you set the current (active) instance by 'set oracle_sid=<sid_name> before you startup database with SVRMGRL. Then you start the listener and connect from 2 instances at he same time. There is nothing to do with multiple home issues, because it is for two separate oracle products on the same platform (Oracle 7 & 8). Multiple instances for the same product are hold at the same oracle home.
|
|
|