Oracle Tips/Questions and Answers:

Question: I exported the old version dump file into the new 10g release file and since then
I have problem with my EM. I can not use my http://myserver:port/em
I get the following error messages when I start it.
To start:
/u01/app/oracle >emctl start dbconsole
Oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0 
Copyright (c) 1996, 2005 Oracle Corporation. All rights reserved.
http://HRMS2:1158/em/console/aboutApplication
ps: unknown output format: -o cmd
ps: illegal option -- -
ps: unknown output format: -o ls
usage: ps [ -aAdeflcjLPy ] [ -o format ] [ -t termlist ]
[ -u userlist ] [ -U userlist ] [ -G grouplist ]
[ -p proclist ] [ -g pgrplist ] [ -s sidlist ]
'format' is one or more of:
user ruser group rgroup uid ruid gid rgid pid ppid pgid sid taskid
pri opri pcpu pmem vsz rss osz nice class time etime stime
f s c lwp nlwp psr tty addr wchan fname comm args projid project pset
Starting Oracle Enterprise Manager 10g Database Control .................... 
started. 
------------------------------------------------------------------
Logs are generated in directory 
/u01/oracle/product/10.2.0/HRMS2_budget/sysman/log 

Please help:

You have two problems:
the following message is due to bug:
ps: unknown output format: -o cmd
ps: illegal option -- -
ps: unknown output format: -o ls
usage: ps [ -aAdeflcjLPy ] [ -o format ] [ -t termlist ]
[ -u userlist ] [ -U userlist ] [ -G grouplist ]
[ -p proclist ] [ -g pgrplist ] [ -s sidlist ]
'format' is one or more of:
user ruser group rgroup uid ruid gid rgid pid ppid pgid sid taskid
pri opri pcpu pmem vsz rss osz nice class time etime stime
f s c lwp nlwp psr tty addr wchan fname comm args projid project pset

to fix it:
Go to the $ORACLE_HOME\<yourservername>.<yourdatabaseinstancename>
There is a file called emctl.pid.
Delete the file.

The other problem is your duplicate record in the EM repository.
You have to drop and recreate the DBconsole.

How to Drop, Create and Recreate DBconsole in Database R2.
To drop and create configuration files and repository run:
% emca -config dbcontrol db -repos recreate

/u01/app/oracle >emca -config dbcontrol db -repos recreate 

STARTED EMCA at Dec 21, 2006 8:22:42 AM
EM Configuration Assistant, Version 10.2.0.1.0 Production
Copyright (c) 2003, 2005, Oracle. All rights reserved.

Enter the following information:
Database SID: <YourSID>
Database Control is already configured for the database <YourSID>
You have chosen to configure Database Control for managing the database <YourSID>
This will remove the existing configuration and the default settings and perform a fresh configuration
Do you wish to continue? [yes(Y)/no(N)]: Y
Listener port number: YourPort# - 1521
Password for SYS user: SysPassword
Password for DBSNMP user: DBSNMP-Password
Password for SYSMAN user: SysmanPassword
Email address for notifications (optional): YourEmail
Outgoing Mail (SMTP) server for notifications (optional): YourOutgoingMail
-----------------------------------------------------------------

You have specified the following settings
Database ORACLE_HOME ................ /u01/oracle/product/10.2.0
Database hostname ................ servername
Listener port number ................ 1521
Database SID ................ <yoursid>
Email address for notifications ............... john@iselfschooling.com
Outgoing Mail (SMTP) server for notifications ............... YourOutgoingMail

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: Y
Dec 21, 2006 8:25:52 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/oracle/product/10.2.0/cfgtoollogs/emca/budget/emca_2006-12-21_08-22-41-AM.log.
Dec 21, 2006 8:25:55 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Dec 21, 2006 8:26:03 AM oracle.sysman.emcp.EMReposConfig dropRepository
INFO: Dropping the EM repository (this may take a while) ...
Dec 21, 2006 8:29:13 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Dec 21, 2006 8:29:13 AM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Dec 21, 2006 8:35:00 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Dec 21, 2006 8:35:06 AM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for HRMS2
Dec 21, 2006 8:35:51 AM oracle.sysman.emcp.EMConfig perform
SEVERE: Cannot start Database Control. The following ports are already in use: [Database Control HTTP port:1158 EM agent port:3938 RMI port for Database Control:5521].
Refer to the log file at /u01/oracle/product/10.2.0/cfgtoollogs/emca/budget/emca_2006-12-21_08-22-41-AM.log for more details.
Could not complete the configuration. Refer to the log file at /u01/oracle/product/10.2.0/cfgtoollogs/emca/budget/emca_2006-12-21_08-22-41-AM.log for more details.

Then stop and start your dbconsole:
# emctl stop dbconsole
# emctl start dbconsole