Upgrading Dbconsole / Dbcontrol after a database upgrade if using the ODA ( Oracle Database Appliance)

Asset ID:	1-72-1616299.1
Update Date:	2014-01-23
Keywords:

Solution Type Problem Resolution Sure

Solution 1616299.1 : Upgrading Dbconsole / Dbcontrol after a database upgrade if using the ODA ( Oracle Database Appliance)

Applies to:

Oracle Database Appliance Software - Version 2.1.0.1 to 2.8.0.0 [Release 2.1 to 2.8]
Oracle Database Appliance - Version All Versions to All Versions [Release All Releases]
Oracle Database Appliance X3-2 - Version All Versions and later
Enterprise Manager for Oracle Database - Version 12.1.0.1.0 and later
Information in this document applies to any platform.

Symptoms

DBconsole aka DBcontrol no longer works after upgrading your RDBMS on the Oracle database appliance

Changes

You have recently upgraded the RDBMS version into a new RDBMS Oracle Home

Cause

Not migrating the DBConsole Binaries along with the RDBMS

Solution

NOTE: As of 12c Dbconsole aka Dbcontrol has been replaced by a new tool - Oracle EM Express

From Where is Database Control (dbconsole) in the 12.1.0.1 (12c) Database? (<Document 1568985.1>)

Database Control (dbconsole) no longer exists in the 12c database. Instead it has been replaced by Oracle Enterprise Manager Database Express (Oracle EM Express)
For information on the de-support of Oracle Enterprise Manager Database Control.

See http://docs.oracle.com/cd/E16655_01/server.121/e17642/deprecated.htm#UPGRD60005

Oracle Enterprise Manager Database Express (EM Express) is a web management product which is built into the Oracle database
Oracle EM Express does not require installation or any special management
For information on EM Express (finding the URL/Accessing the home page etc.)

See:- http://docs.oracle.com/cd/E16655_01/server.121/e17643/em_manage.htm#ADMQS031

From How To Manually Upgrade DBConsole Configuration After Database Upgrade (<Document 1293264.1>)

1. There is no need to drop and recreate the dbconsole after database upgrade. (although this is an option )

2. Ensure that the following dbconsole configuration files exists in OLD ORACLE HOME from where the database was upgraded:

<OLD_ORACLE_HOME>/<hostname_SID> directory

<OLD_ORACLE_HOME>/oc4j/j2ee/OC4J_DBConsole_<hostname_SID> directory

3. Once the database is upgraded to NEW ORACLE HOME, to upgrade the dbconsole, execute the following command from NEW ORACLE HOME:

<NEW_ORACLE_HOME>/bin> emca -upgrade db

When prompted for the ORACLE_HOME, enter the OLD_ORACLE_HOME location where the configuration files are existing (as verified in Step 2).

The emca -upgrade db command will upgrade the dbconsole configuration files from OLD ORACLE HOME to NEW ORACLE HOME and will upgrade the repository version in the SYSMAN schema.

*For more information on the upgrades you can refer to RDBMS generic upgrade documentation

From How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g (<Document 278100.1>)

Delete DB Control Objects:

Option A.1. Delete DB Control Configuration Files using EMCA
Option A.2. Delete DB Control Configuration Files Manually
Option A.3. Delete DB Control Repository Objects using RepManager
Option A.4. Delete DB Control Repository Objects Manually
Option A.5. Delete DB Control Configuration Files and Repository Objects using EMCA

Create DB Control Objects

Option 1. Create the DB Control Configuration Files
Option 2. Create the DB Control Repository Objects and Configuration Files

*See the note for specifics

References

<NOTE:1516557.1> - Complete Checklist for Upgrading to Oracle Database 12c Release 1 using DBUA
<NOTE:1568985.1> - Where is Database Control (dbconsole) in the 12.1.0.1 (12c) Database?
<NOTE:278100.1> - How To Drop, Create And Recreate the Database Control (DB Control) Release 10g and 11g
<NOTE:1293264.1> - How To Manually Upgrade DBConsole Configuration After Database Upgrade
<NOTE:578011.1> - How to manage DB Control 11.x for RAC Database with emca

Attachments

This solution has no attachment