Re: Sutdy Q3: How to Create a Repository Database Easily?

Comments embedded

Hth,

Sybrand Bakker, Oracle DBA

"Dino Hsu" <dino1_at_ms1.hinet.net> wrote in message news:8plmap$dhdi1$1_at_ID-41926.news.cis.dfn.de...
> Dear all,
>
> It was 2 months ago when I studied Getting Started. I remember that a
> repository database is needed to manage many Oracle databases and servers.
> However, this repository database cannot share the server with other
 managed
> databases; in other words, I need a dedicated server for the repository
> purpose, it's gonna be too much for me. Is there a way to create a
> repository database on a server where other databases have already
existed?

Sure no problem, as long as it a separate instance and you have sufficient memory available. Usually the system tablespace shouldn't need to be bigger than say 50M

> Furthermore, I am not too sure about how necessary it is to create a
> repository database, nor the connection between a console and a repository
> database.
>

If you install OEM in a database used for other purposes you will be facing a catch-22 situation, as you can't shutdown the database by means of OEM, where OEM is living in. If you do so, OEM will become inaccessible.

> I used to see a Oracle admin demonstration, there is a map on the computer
> screen, icons of servers and databases are distributed all over the map.
> Those are not just icons, the DBA can click on them and do their
 management
> jobs. Can anyone tell an easy way to see that screen myself, so that I can
> get started with OEM.
>

The map is a 'gadget' only. You *really* don't need it, honestly. If you configure OEM normally by having it discover the services on the various nodes, it will provide you with a hierarchical tree of nodes, databases and so on, with *exactly*, I repeat: *exactly* the same functionality.
> Thanks in advance.
> Dino
>
>
>
Received on Tue Sep 12 2000 - 12:44:20 CDT