Re: Oracle Enterprise Data Repository - Help!

The OEM repository is really just a special schema in any database. Like the RMAN repository, you can put it anywhere it's convenient. I prefer to create a 'DBAs only' instance on a totally separate machine and put the DBAs stuff there including OEM, RMAN, my version of workflow, etc. (Basic specs - 512M memory, 8G disk & processor speed > Intel Pentium 500 or equiv in a non-intel world .... my Sparc-266 Ultra5 limps a bit for this!)

Remember, the big parts of OEM are a) Console, b) optional Management Serer, c) Repository and d) Intelligent [sic] Agents. There are 2 main ways to use OEM - 1) directly against the database/instance in question and 2) using the OMS as a centralized access point. Case 1 & 2 are not mutually exclusive.

In case 1 ) the first time the console accesses the instance it will create a respoitory in that instance automatically. Thereafter you can do most of the management using this variant if you want, but there are limitations (IIRC, such as no jobs, no paging, etc.)

In case 2) you decide which database & instance will host the respository for all the managed instances; you fire up the OMS and when you access the OMS from the console the repository will be created automatically. The OMS and the Agents will work together to collect all the relevant information into the centralized respository independant of how many consoles are connected to the OMS.

Since this centralized repository will grow over time, and it contains all the job & event details, I really prefer to put this on it's own (properly administered) machine and instance available exclusively for the DBAs. This machine could be a workstation or a small server. Either way, if there are multiple DBAs this could become a heavily loaded machine. One suggestion might be start with an unused workstation and migrate to a server if load demands.

HTH
/Hans

amani wrote:

> Hi there,
>
> Can anyone give me advice on what i need to do to set up the data
> repository for oracle enterprise? I'm afraid i am something of a
> novice to this and for various reasons have been given this.
>
> I have four databases at the moment and my tnsnames.ora is configured
> as i can use the visual studio with no problems. I just can't seem to
> get my head around this repository thing, can it be set up on a
> workstation or does it need to be a server? Any help would be
> appreciated..... I'm not familiar with most of this stuff.
>
> Thanks
>
> amani
Received on Thu Jun 26 2003 - 10:58:47 CDT