Home » RDBMS Server » Server Administration » NT - Multiple instances - v8.0.5
NT - Multiple instances - v8.0.5 [message #369333] Thu, 17 August 2000 15:57 Go to next message
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 #369334 is a reply to message #369333] Thu, 17 August 2000 16:09 Go to previous messageGo to next message
William Webb
Messages: 3
Registered: August 2000
Junior Member
Why not just use different users that have exclusive rights to their own tablespaces/schemas?
Re: NT - Multiple instances - v8.0.5 [message #369340 is a reply to message #369333] Fri, 18 August 2000 09:51 Go to previous messageGo to next message
-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 Go to previous message
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.
Previous Topic: UNIX versus NT,
Next Topic: blobs
Goto Forum:
  


Current Time: Tue Oct 20 10:16:57 CDT 2020