Re: ORACLE installation - instance - database

1. Usually complexity and expense. From the product description at http://www.oracle.com/ip/deploy/database/8i/index.html?ops.html

Oracle Parallel Server is a robust database server extension that uses Operating System Clustering technology to provide scalability for database applications in a highly available environment. Oracle Parallel Server greatly enhances the scalability and high-availability capabilities of Oracle8i by combining the benefits of cluster scalability and availability with single system management capabilities.

2. No. An Oracle instance is the set of processes and memory structures that manage an Oracle database. What applications access an Oracle database is another question entirely. This information can be found in the Oracle Concepts manual available at technet.oracle.com

--
Niall Litchfield
Oracle DBA
Audit Commission UK



"Kevin" <mccarthy_at_CRD.GE.COM> wrote in message
news:taalmu7mrbna5_at_corp.supernews.com...


> Looking for insight on the below.

> 1)  Why don't most people run OPS?  Complexity, timing, cost?  Info link

> to OPS?

> 2)  Is it correct to say that an Oracle Instance is comprised of selected

> set of applications from an Oracle Suite of Applications (i.e. 11i) that

> interacts with 1 Oracle Database?  and What if you want to add an

> application module later on?

>

> Finally, can anyone provide info or links to documents that provide high

> level information on what an Oracle Instance is, key requirements to go

> through to properly setup, define (flexfields, categories, ...),

> structures?

>

> Niall Litchfield wrote:

> >

> >

> > Strictly the relationship is many to 1. many instances *can* manage one

> > database. This requires OPS. A database is a set of files. an instance

 is a


> > set of memory structures and processes.

> >

> > Having said that most people don't run OPS. So in general Sybrands

 statement


> > is correct.

> >

> >

> > --

> > Niall Litchfield

> > Oracle DBA

> > Audit Commission UK

> > "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message

> > news:ta6dr8q4qc1qcd_at_beta-news.demon.nl...

> > > Relationship between instance and database is 1 to 1.

> > > One instance will manage only one database

> > > You can create multiple instances on one server and whether or not you

 use


> > > multiple different versions of Oracle doesn't really matter. Of

 course,
 when


> > > you are using only one version of Oracle, it should be installed only

 once.


> > > The questions you are asking betray you must be from a sqlserver

 background.


> > > In Oracle a database definitely isn't the same as in sqlserver. In

 Oracle


> > > you should equate a sqlserver database with an Oracle schema.

> > >

> > > These issues are discussed in further detail in the Oracle concepts

 manual,


> > > which is online at http://technet.oracle.com

> > >

> > >

> > > Hth,

> > >

> > > Sybrand Bakker, Oracle DBA

> > >

> > > "Happy" <allan_at_livvy80.freeserve.co.uk> wrote in message

> > > news:97ubhr$ise$1_at_news8.svr.pol.co.uk...

> > > > Can anybody please tell me the relationship between installations,

 instances


> > > > and databases?

> > > > Is it 1 to 1 to 1?

> > > > Or can multiple databases be created from a single installation or

 instance?


> > > > Is an instance the same as an installation?

> > > > Is a database the same as an instance?

> > > > What defines them?

> > > >

> > > > ORACLE talk about a 'database system' comprising more than one

 database.
 Do


> > > > they mean

> > > > databases that have been created on the same node from different

> > > > installations?

> > > >

> > > > Thanks in advance

> > > > Allan

> > > >

> > > >

> > >

> > >

> >

> >

>

>

> --

> Posted via CNET Help.com

> http://www.help.com/