Re: oracle 10GR2 EM console how to set up

From: Brian Peasland <dba_at_nospam.peasland.net>
Date: Thu, 10 Aug 2006 16:36:41 GMT
Message-ID: <J3sJH6.I2B@igsrsparc2.er.usgs.gov>

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
>

The following shows how I used the emca utility to create the repository for me and set up the http daemon.

Enjoy!
Brian

emca -config dbcontrol db -repos create

STARTED EMCA at May 25, 2006 2:53:55 PM
EM Configuration Assistant, Version 10.2.0.1.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: orcl
Listener port number: 1521
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional): dba_at_acme.com Outgoing Mail (SMTP) server for notifications (optional): smtp.acme.com

You have specified the following settings

Database ORACLE_HOME ................ /home/oracle/10.2.0

Database hostname ................ db_server
Listener port number ................ 1521
Database SID ................ orcl

Email address for notifications ............... dba_at_acme.com Outgoing Mail (SMTP) server for notifications ............... smtp.acme.com

Do you wish to continue? [yes(Y)/no(N)]: Y May 25, 2006 2:54:44 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /home/oracle/10.2.0/cfgtoollogs/emca/frccd/emca_2006-05-25_02-53-55-PM.log. May 25, 2006 2:54:48 PM oracle.sysman.emcp.EMReposConfig createRepository INFO: Creating the EM repository (this may take a while) ... May 25, 2006 2:57:07 PM oracle.sysman.emcp.EMReposConfig invoke INFO: Repository successfully created
May 25, 2006 2:57:11 PM oracle.sysman.emcp.util.DBControlUtil startOMS INFO: Starting Database Control (this may take a while) ... May 25, 2006 2:58:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully May 25, 2006 2:58:49 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is http://db_server:5502/em <<<<<<<<<<<
Enterprise Manager configuration completed successfully FINISHED EMCA at May 25, 2006 2:58:49 PM

-- 
===================================================================

Brian Peasland
dba_at_nospam.peasland.net
http://www.peasland.net

Remove the "nospam." from the email address to email me.


"I can give it to you cheap, quick, and good.
Now pick two out of the three" - Unknown

Received on Thu Aug 10 2006 - 11:36:41 CDT