Re: oracle 10GR2 EM console how to set up

From: <fitzjarrell_at_cox.net>
Date: 10 Aug 2006 09:06:28 -0700
Message-ID: <1155225988.669863.321930@b28g2000cwb.googlegroups.com>

Teresa wrote:
> Hello
>
> I have installed oracle 10GR2 on solaris 5.8 and when I created the
> database I used a script, therefore the sysman schema was not created
> and I don't have the nice GUI interface http://host:1158/em/console
>
> Is there a way of adding this now to the database? If so how to do it?
>
> Many thanks!
> Teresa

You should have an $ORACLE_HOME/sysman/admin/emdrep/sql/emreposrec.sql script which takes the following parameters:

$ORACLE_HOME
SYSMAN
<sysman password>

Connect as sys as sysdba and execute the script; you'll likely need to unlock the SYSMAN account before it can be used:

alter user sysman account unlock;

You should then be able to start the service/daemon and get your webpage working.

David Fitzjarrell Received on Thu Aug 10 2006 - 11:06:28 CDT