Re: one instance can hv how many database?

lkw wrote:
>
> u mean normally ppl hv two database in one server is always running two
> oracle instances?

Yes. That's two sets of datafiles with system and userdata, two sets of system processes for filewriting, system monitoring etc and two sets of memory areas. If you only need two copies of user data (say one for development and one for testing) then they can be stored in one database. They would be owned by different users (schema owners) and referenced like this:

schema_owner_name.tablename

OR if the connected user is the schema owner you only need the tablename.

> for solaris system, how to create a new instance?

use the 'CREATE DATABASE' command in a script along with commands to add /configure all the requisite components. Or the database configuration assistant can build the script for you or actually create the db directly for you.

currently i hv one
> instance with one database running already.
> and, is there any limit for number of instances to be created?
>
> <sybrandb_at_my-deja.com> wrote in message news:91puvm$kad$1_at_nnrp1.deja.com...
> > In article <91prel$pif$1_at_violet.singnet.com.sg>,
> > "lkw" <lkw_at_axiomatique.com> wrote:
> > > hi all,
> > >
> > > currently i hv one oracle instance running and one database name DB01
 is
> > > mounted to it.
> > > izzit possible to create another database DB02 and mounted to the same
> > > instance?
> > > or i need a second instance for the second database DB02? if yes, how
 to run
> > > the second instance?
> > >
> > > thanks. yr help would be greatly appreciated.
> > >
> > > lkw.
> > >
> > >
> > It is not possible to have a second database on any instance.
> > (refer to Oracle Concepts)
> > Yes you need a second instance. However, you probably just want to have
> > different schemas in one database.
> > As the creation of an instance is platform dependent, you need to refer
> > to your getting started manual as to how to create it.
> >
> > Hth,
> >
> >
> >
> > --
> > Sybrand Bakker, Oracle DBA
> >
> > All standard disclaimers apply
> > ------------------------------------------------------------------------
> >
> >
> > Sent via Deja.com
> > http://www.deja.com/

-- 
"No man is happy without a delusion of
 some kind. Delusions are as necessary to
 our happiness as realities."