Re: Can one instance start different databases

rsurabhi_at_ocean.st.usm.edu (Rajeshwar Rao Surabhi) writes:

> Here is my question. I have three instances namely Rose, Prod and
>Orcl. The datbases i have are product, oracle and rose. I know that we can
>start a particular database say product with two diff instances say rose
>and prod. Can we start two different databases with one instance. If so
>please explain the steps.
> Is the dbname in init.ora parameter file is compulsory or
>optional. If it is compulsory can we have multiple dbnames so that we can
>start 2 different databases with the same instance. i,e dbname=product.
>In next line dbname=oracle in initrose.ora file.

An instance can only start one database. A database can be opened by more than one instance (parallel server).

Note that a database being opened by more than one instance that does not involve parallel server is called database corruption. I've seen this happen on NT - I would guess that UNIX's db file locking is good enough to prevent it on that platform.

-- 
/(o\ Nathan D. Hughes
\o)/ nhughes_at_umich.edu