here is some steps to follow:
1- define the time zone in the .bash_profile, em uses that to give graphs for monitoring and visualizing what is going on in the db : CPU, CP wait, network, transactions all in a graph so that you can see the pic points and the queries who consume CPU
2- define your hostname,
I faced this issue specially on windows because when my laptop was connected to the internet, the hostname changed or some problem like that(I need time to explain)
3- drop the repository and build it again
$emca -deconfig dbcontrol db -repos drop
$emca -config dbcontrol db -repos create
export the other environnement variables as well
please let me know if solved
[appltest@ERPTEST config]$ emca -deconfig dbcontrol db -repos drop STARTED EMCA at Aug 29, 2013 5:05:39 PM EM Configuration Assistant, Version 22.214.171.124.0 Production Copyright (c) 2003, 2005, Oracle. All rights reserved. Enter the following information: Database SID: TEST Listener port number: 1528 Password for SYSMAN user: Do you wish to continue? [yes(Y)/no(N)]: Y Aug 29, 2013 5:06:00 PM oracle.sysman.emcp.EMConfig perform INFO: This operation is being logged at /oracle/TEST/db/tech_st/11.1.0/cfgtoollogs/emca/TEST/emca_2013_08_29_17_05_39.log. Aug 29, 2013 5:06:00 PM oracle.sysman.emcp.util.DBControlUtil stopOMS INFO: Stopping Database Control (this may take a while) ... Aug 29, 2013 5:06:01 PM oracle.sysman.emcp.util.PlatformInterface executeCommand WARNING: Error executing /oracle/TEST/db/tech_st/11.1.0/bin/emctl stop dbconsole Aug 29, 2013 5:06:01 PM oracle.sysman.emcp.EMConfig perform SEVERE: Can't find file /oracle/TEST/db/tech_st/11.1.0/ERPTEST.BIL.COM_TEST/sysman/config/emoms.properties Refer to the log file at /oracle/TEST/db/tech_st/11.1.0/cfgtoollogs/emca/TEST/emca_2013_08_29_17_05_39.log for more details. Could not complete the configuration. Refer to the log file at /oracle/TEST/db/tech_st/11.1.0/cfgtoollogs/emca/TEST/emca_2013_08_29_17_05_39.log for more details.
how do i update TZ in .bash_profile.what to set for India kolkata.
1) it's a clone database, just copy emoms.properties file from original database and paste
and recreate repository
2) oui--> upgrade database
3) backup full database, reinstall oracle software, restore/recover database