I'm sure that someone will correct me if I'm wrong but:
The database is the physical datafiles laid out on the storage devices -
hard disks;
The instance is the logical constructions (SGA) that exist, hopefully, in
RAM;
The services are the NT operating system equivalent of UNIX processes which
run the Oracle engine against the instance to access the database.
In theory, an instance could be used to access multiple databases; however,
in practice, DBAs set up one instance that will be used to access one
database (and no other database).
Also, databases could, in theory, be accessed from multiple instances;
however, in practice, DBAs set up a database to be accessed from only one
instance (and no other instance).
Microsoft NT sets up the service so that it executes against one, given
instance. However, NT will allow multiple services.
So, you can have two databases, two instances, and two services on the same
NT server. You'll also need two listeners and two services to run those
listeners.
You'll probably need to read the manuals for the exact details.
Nirmal Kumar
Muthu Kumaran To: Multiple recipients of list ORACLE-L
<NIRMALK@qtel <[EMAIL PROTECTED]>
.com.qa> cc:
Sent by: Subject: Two Instances at one oracle
Server
root@fatcity.
com
09/19/2001
03:55 AM
Please
respond to
ORACLE-L
Guru's
In my test oracle server, i created two different database with SID
'orclsvr' and 'ora817'.
Is't possisle to create two oracle database instances on the same server?.
Presently am able to create only one instance at a time either for the sid
'orclsvr' or 'ora817'.
Oracle Server 817 on Win NT4 based.
Regards,
Nirmal.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Nirmal Kumar Muthu Kumaran
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
