Amazon Partner

Wednesday 9 March 2016

How to upgrade dbconsole after manual database upgrade without re-creating

Recently i been involved in upgrading the database from 11.2.0.2 to 11.2.0.4 , and client was using dbconsole , I was end up learning something new ( as in past all my client always happen to be using grid control not dbconsole) , specially with upgrade assignments.



When i google arround to see the best practice to dbconsole upgrade, i found some notes on upgrade mostly recommending to deconfig the repository( drop) and create the dbconsole confiugration again.


Here is how you can simply upgrade the dbconsole with single commad (very simple ).


Set env to new  ORACLE_HOME

Pls note ORACLE_HOME for the database to be upgraded is $OLD_ORACLE_HOME .

$emca -upgrade db

STARTED EMCA at Mar 9, 2016 8:47:26 AM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
ORACLE_HOME for the database to be upgraded: /cluster/app/grid/product/11.2.0/db_1/
Database SID: DBSID
Listener port number: 1521
Password for SYS user:

Do you wish to continue? [yes(Y)/no(N)]: Y
Mar 9, 2016 8:53:43 AM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /cluster/app/oracle/cfgtoollogs/emca/bblearn/emca_2016_03_09_08_47_26.log.
Mar 9, 2016 8:53:44 AM oracle.sysman.emcp.util.DBControlUtil stopOMS
INFO: Stopping Database Control (this may take a while) ...
Mar 9, 2016 8:53:48 AM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Mar 9, 2016 8:55:33 AM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Mar 9, 2016 8:55:36 AM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for blerndb2.brunel.ac.uk
Mar 9, 2016 8:55:49 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Mar 9, 2016 8:55:56 AM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Mar 9, 2016 8:55:56 AM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Mar 9, 2016 8:56:03 AM oracle.sysman.emcp.EMDBPostConfig performUpgrade
INFO: Database Control started successfully
Mar 9, 2016 8:56:06 AM oracle.sysman.emcp.EMDBPostConfig performUpgrade
INFO: >>>>>>>>>>> The Database Control URL is https://dbhost1.oraconsultancy.uk:1158/em <<<<<<<<<<<
Mar 9, 2016 8:56:06 AM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /cluster/app/oracle/product/11.2.0.4/db_1/dbhost1_DBSID/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Mar 9, 2016 8:56:06 AM

Happy Learning