Re: oracle database control in 10g

On Mon, 24 Oct 2005 16:45:47 -0400, G Dahler interested us by writing:

> Is there a way to manage more than one database instance on a single host
> with oracle database 10G R2 STANDARD EDITION ONE out of the box ?
>
> The database control web application is OK, but it looks like you can only
> manage a single database instance with it.
>

Design intent.

> Installing OEM Grid Control is a bit overkill (you need a third instance for
> the repository I thing, and you also seems to need oracle database
> ENTERPRISE edition) for a standard edition one setup.
>

Separate the management of individual instances by using different ports. One EM DB Control = one instance by design intent!

You are right that Grid may seem overkill at this time. However, consider that the DBA should possibly have a DB for internal DBA use on a separate machine and all of a sudden you have that third instance. There are literally hundreds of reason for that DBAs database.

> Other than command line utilities, what tools does oracle provide for people
> running the standard edition one version of the database ?
>

You can also fire up the old OEM from Oracle9i - it's on the Client CD.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***