instead of having 1 instance per db on one server you can have n schemas on one instance.

DB2 --> Oracle
--- ------
DB1 User1
DB2 User2
. .
. .
. .
DBn Usern

Every objects in a schema are isolated from another one.

Mathieu


-----Message d'origine-----
De : Glenn 9 Martin
[mailto:db2udbdba-ezmlmshield-x20786641.[Email address protected]
Envoyé : jeudi 27 janvier 2005 11:06
À : LazyDBA Discussion
Objet : RE: How to create multiple SID's in oracle 8i


I think the following may be helpful.

As has been said, without RAC there is one database per instance. After
installing the Oracle software, you create instances, databases etc
separately. The real point I would like to make is that it's important to
structure and name your directories properly, and the following document
should be useful:

http://www.ss64.com/orasyntax/ofa.html


---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
website: http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


DB2 & UDB email list listserv db2-l LazyDBA home page