Re: Two Instances at one oracle Server

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_at_qtel        <ORACLE-L_at_fatcity.com>                        
    
                    .com.qa>             cc:                                           
    
                    Sent by:             Subject:     Two Instances at one oracle 
Server   
                    root_at_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: NIRMALK_at_qtel.com.qa

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: ListGuru_at_fatcity.com (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: tday6_at_csc.com

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: ListGuru_at_fatcity.com (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).