Tuesday 1 June 2010

Configure EM db control - after upgrading from 10.2.0 to 11.2.0

In this post will explain the issues to configure dbcontrol of 11.2.0 database of 11i applications.

While i am trying to configure db control after upgrading from database 10.2.0 to 11.2.0 having some issues and errors. I have been used dbua for up-gradation of my existing database, but didn't chosen the option of configure dbconsole.

$emca -config dbcontrol db -repos recreate

i am getting the following error

May 31, 2010 12:01:26 PM oracle.sysman.emcp.EMReposConfig invoke
SEVERE: Error dropping the repository
May 31, 2010 12:01:26 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Refer to the log file at /app/oracle/ajidb/cfgtoollogs/emca/AJI/emca_repos_drop_.log for more details.
May 31, 2010 12:01:26 PM oracle.sysman.emcp.EMConfig perform
SEVERE: Error dropping the repository
Refer to the log file at /app/oracle/ajidb/cfgtoollogs/emca/AJI/emca_2010_05_31_12_00_49.log for more details.
May 31, 2010 12:01:26 PM oracle.sysman.emcp.EMConfig perform
CONFIG: Stack Trace:
oracle.sysman.emcp.exception.EMConfigException: Error dropping the repository
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:218)
at oracle.sysman.emcp.EMReposConfig.invoke(EMReposConfig.java:157)
at oracle.sysman.emcp.EMConfig.perform(EMConfig.java:253)
at oracle.sysman.emcp.EMConfigAssistant.invokeEMCA(EMConfigAssistant.java:589)
at oracle.sysman.emcp.EMConfigAssistant.performConfiguration(EMConfigAssistant.java:1448)
at oracle.sysman.emcp.EMConfigAssistant.statusMain(EMConfigAssistant.java:573)
at oracle.sysman.emcp.EMConfigAssistant.main(EMConfigAssistant.java:521)
May 31, 2010 12:01:26 PM oracle.sysman.emcp.EMConfig restoreOuiLoc
CONFIG: Restoring oracle.installer.oui_loc to /app/oracle/ajidb/11.2.0/oui

Finally I have decided to create password file under New ORACLE_HOME

$orapwd file=$ORACLE_HOME/dbs/orapwSID.ora password=MyPassword force=y

Then changed password of both dbsnmp and sysman using

sqlplus /as sysdba
SQL>alter user sysman identified by MyPassword;
SQL>alter user dbsnmp identified by MyPassword;

Again run the same command,which was given earlier

$emca -config dbcontrol db -repos recreate


INFO: Repository successfully dropped
INFO: Repository successfully created
May 31, 2010 12:35:51 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...

INFO: >>>>>>>>>>> The Database Control URL is https://aji.apps.local:1158/em <<<<<<<<<<<
May 31, 2010 12:39:15 PM oracle.sysman.emcp.EMDBPostConfig invoke

Enterprise Manager configuration completed successfully
FINISHED EMCA at May 31, 2010 12:39:15 PM

Cheers!!

Related Posts by Categories



No comments: