Oracle Enterprise Manager 12.1.0.2.0 to 12.1.0.3.0 Upgrade with 12.1.0.1.0 Database

As promised, the upgrade steps for a single instance OMS are detailed below. My pre-upgrade environment:
Host: OEM 6.3 64bit
OMS: 12.1.0.2.0

Repository: 12.1.0.1.0
How pretentious. Of course I know what I’m doing!!

[oracle@spoon config]$ emctl config emkey -copy_to_repos_from_file -repos_host spoon.song -repos_port 1521 -repos_sid monster -repos_user sysman -emkey_file /u01/app/oracle/middelware/oms/sysman/config/emkey.ora
Oracle Enterprise Manager Cloud Control 12c Release 2 
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Enter Admin User’s Password :
Enter Enterprise Manager Root (SYSMAN) Password :
The EMKey has been copied to the Management Repository. This operation will cause the EMKey to become unsecure.
After the required operation has been completed, secure the EMKey by running “emctl config emkey -remove_from_repos”.

[oracle@spoon config]$ . oraenv
ORACLE_SID = [OEM] ? monster
The Oracle base for ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1 is /u01/app/oracle
[oracle@spoon config]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Mon Jul 1 12:40:51 2013
Copyright (c) 1982, 2009, Oracle.  All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> grant execute on dbms_random to dbsnmp;
Grant succeeded.
SQL> ALTER DATABASE ADD LOGFILE SIZE 300M;
SQL> ALTER DATABASE ADD LOGFILE SIZE 300M;
SQL> ALTER DATABASE ADD LOGFILE SIZE 300M;

ORACLE_SID = [monster] ? OEM
The Oracle base for ORACLE_HOME=/u01/app/oracle/middelware/oms is /u01/app/oracle
[oracle@spoon config]$ emctl stop oms
Oracle Enterprise Manager Cloud Control 12c Release 2 
Copyright (c) 1996, 2012 Oracle Corporation.  All rights reserved.
Stopping WebTier…
WebTier Successfully Stopped
Stopping Oracle Management Server…
Oracle Management Server Successfully Stopped
Oracle Management Server is Down

A Cup of Tea

And Tomb Raider 2013 later

[root@spoon ~]# /u01/app/oracle/12.1.0.3/middleware/oms/allroot.sh
Starting to execute allroot.sh ………
Starting to execute /u01/app/oracle/12.1.0.3/middleware/oms/root.sh ……
Running Oracle 11g root.sh script…
The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/12.1.0.3/middleware/oms
Enter the full pathname of the local bin directory: [/usr/local/bin]:
The file “dbhome” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “oraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
The file “coraenv” already exists in /usr/local/bin.  Overwrite it? (y/n)
[n]:
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
/etc exist
/u01/app/oracle/12.1.0.3/middleware/oms
Finished execution of  /u01/app/oracle/12.1.0.3/middleware/oms/root.sh ……

After logging into OMS, I can see there are targets in “Unknown” status.

It seems the agent did not start correctly. That is excepted because, according to the documentation
Management Agents, including the central agent installed on the Oracle Management Service (OMS) host, are not upgraded automatically while upgrading to Enterprise Manager Cloud Control 12c Release 3 (12.1.0.3). Ensure that you upgrade the central agent installed on the OMS host immediately after upgrading the old OMS to 12.1.0.3.
Let’s proceed with the upgrade.

First, ensure that you have the latest Agent Software available.

Submit it!

Presumably because the “oracle” user doesn’t have sudo access.

Progress!

I made sure the agent has the latest Oracle Database (12.1.0.4.0) plugin.
[oracle@spoon bin]$ ./emctl listplugins agent
Oracle Enterprise Manager Cloud Control 12c Release 3 
Copyright (c) 1996, 2013 Oracle Corporation.  All rights reserved.
—————————————————————
oracle.fmw.gg       12.1.0.1.0 /u01/app/oracle/agent/plugins/oracle.fmw.gg.agent.plugin_12.1.0.1.0
oracle.sysman.beacon 12.1.0.3.0 /u01/app/oracle/agent/plugins/oracle.sysman.beacon.agent.plugin_12.1.0.3.0
oracle.sysman.emas  12.1.0.4.0 /u01/app/oracle/agent/plugins/oracle.sysman.emas.agent.plugin_12.1.0.4.0
oracle.sysman.emrep 12.1.0.3.0 /u01/app/oracle/agent/plugins/oracle.sysman.emrep.agent.plugin_12.1.0.3.0
oracle.sysman.db    12.1.0.4.0 /u01/app/oracle/agent/plugins/oracle.sysman.db.agent.plugin_12.1.0.4.0
oracle.sysman.oh    12.1.0.3.0 /u01/app/oracle/agent/plugins/oracle.sysman.oh.agent.plugin_12.1.0.3.0
oracle.sysman.csa   12.1.0.3.0 /u01/app/oracle/agent/plugins/oracle.sysman.csa.agent.plugin_12.1.0.3.0
Before we starting having fun, we need to do house cleaning.

Nice!

Advertisements

2 comments

  1. Anonymous · · Reply

    Nice “And Tomb Raider 2013 later” 🙂

    Eric
    Good info!

  2. I'm glad you liked it Eric 🙂

    Cheers!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Musings

Things I see and learn!

Thoughts from James H. Lui

If you Care a Little More, Things Happen. Bees can be dangerous. Always wear protective clothing when approaching or dealing with bees. Do not approach or handle bees without proper instruction and training.

bdt's oracle blog

Sharing experience (by Bertrand Drouvot)

Frits Hoogland Weblog

IT Technology; Oracle, linux, TCP/IP and other stuff I find interesting

Vishal desai's Oracle Blog

Just another WordPress.com weblog

%d bloggers like this: