Re: Setting up a respository for OEM

On Wed, 16 Nov 2005 19:31:49 +0000, Vince Laurent wrote:

> OK... I finally have a window where I can mess with OEM.
> I have a server with a bit of free space I would like to install the
> respository on. My environment is:
>
> HP-UX11i
> Oracle 9.2.0.4
>
> I currently have an oracle database on this server so I would like to
> set up another. Some clarifiction questions for everyone:
>
> Should I have a seperate ORACLE_HOME for this new instance OR would
> that mess up where the oracle binaries/initSID.ora/(others?) are?
>

One Oracle Home can support several database instances. However, realize that an Oracle Home is your 'unit of patch maintenance' and you end up testing and supporting all instances under that home concurrently during a patch.

If I have the disk space, I like to have the OEM repository in a separate Oracle Home.

Note that all of the Oracle University courses for 9i use one ORACLE_HOME and two instances (where multiple instances are uised).

> Will the DBCA add to the /etc/oratab vs removing it?
>

DBCA will do the right thing re: oratab - add or delete as required.

> I have created a oracle user account on the HP box for the new
> database with is not the same as the existing one though both are in
> the dba group. Is that OK?
>

I'd use the same unix userid to own all ORACLE_HOMEs and all Oracle databases - separate userid are going to cause unnecessary permissions grief. Oracle specifically designed the ORACLE_HOME separation to accomodate the need for separating software, instances and databases while maintinaing one owner.

That said, I'd use that second unix userid for all the DBA work. Gets into the habit of not using the Oracle-equivalent to 'root' at the OS level.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting replies guarantees I won't respond. ***