running scripts for multiple instances [message #59048] |
Sat, 25 October 2003 15:45 |
bechir
Messages: 23 Registered: November 2001
|
Junior Member |
|
|
Hi,
I'm installing Oracle9i on red hat9. I need to create 4 instances (dev,test,qa and prod). Do I need to run catalog.sql and catproc.sql scripts for each instance?
|
|
|
|
|
|
Re: MAXINSTANCES variable for multiple instances [message #59060 is a reply to message #59059] |
Sun, 26 October 2003 09:53 |
bechir
Messages: 23 Registered: November 2001
|
Junior Member |
|
|
Thiru,
thanks for your answers.
should I set the MAXINSTANCES variable value in the CREATE DATABASE statement for dev,test and qa to 3? This because dev, test and qa databases/instances will be on the same server and they will be open at the same time.
Bechir
|
|
|
Re: MAXINSTANCES variable for multiple instances [message #59061 is a reply to message #59060] |
Sun, 26 October 2003 11:02 |
Thiru
Messages: 1089 Registered: May 2002
|
Senior Member |
|
|
Bechir,
MAXINSTANCES determines the maximum numner of Instances that can mount and open THAT PARTICULAR DATABASE. This is applicable in Parallel Server/RAC environment,where multiple instances can operate on a single database.
The default value is OS dependent. If you dont think that you will ever have RAC in your environment,you can leave it to the default(it can still support multiple instances when the default > 1) . If you are thinking of moving to RAC later, then set this value to the maximum number of instances that will access this database.
Its not a function of the number of databases on a single server.
-Thiru
|
|
|
|