Re: Basic Oracle Concepts

1) No, it is not. One database means one instance, means one set of
services.
What you propose makes it impossible to run multiple databases *at the
same time* using one instance. Running two databases at the same time
requires 2 instances.
Evidently you know sqlserver. A sqlserver database is more or less the
same as an Oracle *schema*.

2) Multiple Oracle Homes are created during installation. Multiple
Oracle Homes are typically used for
a) multiple different major releases of the same software
b) multiple different Oracle products

You would never ever create one home for each database, because the 2
homes will share exactly *nothing*, and you will run into an
administration nightmare.
I admit we administrate a server where Oracle India installed Oracle 3
times on a single server in this fashion. The installations sucks!


As said before: you will rarely create multiple databases, because
usually a different schema will do. If you setup your security
appropiately, different schema's are completely separated. In your
proposed configuration you are simply going to waste resources.

--
Sybrand Bakker
Senior Oracle DBA

.

Relevant Pages

  • Re: Multiple databases - best performance scenario
    ... My company has the need to manage data for multiple customers. ... Multiple small physical servers connected to SAN ... When I'm using the word database ... You might consider checking licensing costs at the oracle store ...
    (comp.databases.oracle.server)
  • Re: Access and Linked tables to Oracle
    ... The initial Access database was created in Access 2000. ... database on multiple machines with similar results in all cases. ... We are using the Oracle ODBC drivers for the database connectivity. ... is really slow if the primary key gets created on that table ...
    (microsoft.public.access.tablesdbdesign)
  • Re: relink oracle linked tables in code
    ... to the way Access can have a control named "cboxGetStuff" on multiple forms. ... must be distinguished by owner name and database name in certain contexts. ... But my oracle db contains only 1 table with that name. ...
    (microsoft.public.access.modulesdaovba)
  • Re: Basic Oracle Concepts
    ... A sqlserver database is more or less the ... > 2) Multiple Oracle Homes are created during installation. ...
    (comp.databases.oracle.misc)
  • Re: What so special about PostgreSQL and other RDBMS?
    ... That's exactly the link the licence agreement for the database points to when it ... comes to what wecan expect for paying support. ... > "Oracle may provide additional releases or versions of its programs ... If the requirements are volatile I'd do a long term contract detailing what ...
    (comp.lang.php)