Oracle Enterprise Manager Cloud Control 12c – Upgrade oem12c from 12.1.0.4.0 (release 4) to 12.1.0.5.0 (release 5)

Upgrade to latest release of Oracle Enterprise Manager 12c – version 12.1.0.5.0 (release).

How to upgrade Oracle Enterprise Manager version 12.1.0.4.0 (release 4) to latest 12.1.0.5.0 (release 5)?

001. Introduction

I use currently an oem release 4, I want to upgrade it to newly release 5.

Entire upgrade is similiar to release 3->4 which I hereby described: http://blog.hakimodo.pl/oracle-enterprise-manager-12c-upgrade-oem12c-from-12-1-0-3-0-release-3-to-12-1-0-4-0-release-4

002. Documentation

001 – Oem12c main page

Links:

OEM download page: http://www.oracle.com/technetwork/oem/enterprise-manager/downloads/index.html

Documentation: http://docs.oracle.com/cd/E24628_01/index.htm

Upgrade guide for OEM release 5: http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/toc.htm

Document how to upgrade release4 to release5: http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/part_upg_12101_PS1.htm#BGBGEGGC

Upgrade guide in graphical mode: http://docs.oracle.com/cd/E24628_01/upgrade.121/e22625/upgrading_12101_PS1_oms.htm#CJAFDJGG

003. Download installation files

002 – Download files

In this example I use Linux x64 RHEL5 – http://www.oracle.com/technetwork/oem/grid-control/downloads/linuxx8664soft-085949.html

		em12105_linux64_disk1.zip (2,392,965,180 bytes) (cksum – 2995791849)
		em12105_linux64_disk2.zip (1,880,746,349 bytes) (cksum – 2206899554)
		em12105_linux64_disk3.zip (3,076,033,575 bytes) (cksum – 1401185042)

WARNING:

unzip -t FILENAME.ZIP

When downloaded, TEST ARCHIVE CONTENT. There is a small chance that archive integrity is broken (file is damaged during download process). Better spend few seconds to test than lose hours to repair during installation.

004. Unpack downloaded files

# unzip em12105_linux64_disk1.zip -d PATH_WHERE_WE_PLACE_INSTALLATION_FILES
unzip em12105_linux64_disk1.zip -d /u01/oms_install
unzip em12105_linux64_disk2.zip -d /u01/oms_install
unzip em12105_linux64_disk3.zip -d /u01/oms_install

005. Preparation to installation

BEFORE INSTALLATION MAKE A FULL BACKUP (database + oms).

Before start:
– verify passwords for database (sys + sysman) and Weblogic (admin)
– backup entire enviroment (oms + database) – or create a snapshot in Virtual Machine if used
– check for free space. Installation calls for about 14 GB needed for upgrade but I have near 15 GB free but first time installation was fault due to no free space on filesystem.
– check database integrity – check for invalid objects
EXAMPLE: Check database for invalid objects

[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.2.0.1.0 Production on N Gru 21 00:52:04 2014
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> 
SQL> select * from dba_objects where status !='VALID';

no rows selected

SQL> exit

006. Installation – first steps

– start database
– shutdown oms instance (if running)
Shutdown oms (if up).

[oracle@localhost ~]$ . oms.env 
[oracle@localhost ~]$ emctl stop oms -all
Oracle Enterprise Manager Cloud Control 12c Release 3 
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
Stopping WebTier...
WebTier Successfully Stopped
Stopping Oracle Management Server...
Node Manager Not Running
Oracle Management Server is Down

– set enviroments variables
– copy emkey.ora to database (examples below – click to expand)

<OMS_HOME>/bin/emctl config emkey -copy_to_repos_from_file -repos_conndesc '"(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<>)(PORT=<>)))(CONNECT_DATA=(SERVICE_NAME=<>)))"' -repos_user <> [-repos_pwd  ] [-admin_pwd ] -emkey_file <emkey file>

Copy emkey.ora to database

[oracle@localhost ~]$ emctl config emkey -copy_to_repos_from_file -repos_conndesc '"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.localdomain)))"' -repos_user sysman -emkey_file /u01/app/oracle/middleware4/oms/sysman/config/emkey.ora

Oracle Enterprise Manager Cloud Control 12c Release 4  
Copyright (c) 1996, 2014 Oracle Corporation.  All rights reserved.
Enter Admin User's Password : xxxxxxxxxxxxxxxxxxx
Enter Enterprise Manager Root (SYSMAN) Password : xxxxxxxxxxxxxxxxxxxx
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@localhost ~]$

Errors that can be spotted:
EXAMPLE: Enviroments are not set correctly:

[oracle@localhost ~]$ emctl config emkey -copy_to_repos_from_file -repos_conndesc '"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.localdomain)))"' -repos_user sysman -emkey_file 
/u01/app/oracle/middleware4/oms/sysman/config/emkey.ora
Environment variable ORACLE_UNQNAME not defined. Please set ORACLE_UNQNAME to database unique name.

EXAMPLE: Enviroments are not set correctly - example 2:

[oracle@localhost ~]$ emctl config emkey -copy_to_repos_from_file -repos_conndesc '"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.localdomain)))"' -repos_user sysman -emkey_file /u01/app/oracle/middleware4/oms/sysman/config/emkey.ora
EM Configuration issue. /u01/app/oracle/product/11.1.0/db_1/localhost.localdomain_orcl not found.

EXAMPLE: Wrong password used - example 3:

[oracle@localhost ~]$ emctl config emkey -copy_to_repos_from_file -repos_conndesc '"(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl.localdomain)))"' -repos_user sysman -emkey_file /u01/app/oracle/middleware/oms/sysman/config/emkey.ora
Oracle Enterprise Manager Cloud Control 12c Release 3 
Copyright (c) 1996, 2013 Oracle Corporation. All rights reserved.
Enter Admin User's Password : 
Enter Enterprise Manager Root (SYSMAN) Password : xxxxxxxxxxxxxxx
Error occurred. Check the log /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log/secure.log

007. Installation

– Point to location where installation files are unpacked:

[oracle@localhost ~]$ cd /media/dysk/oem5/
[oracle@localhost oem5]$ ll
total 8683724
drwxr-xr-x 4 oracle oinstall       4096 Jan 15  2014 bipruntime
drwxr-xr-x 7 oracle oinstall       4096 Jun 11 03:16 install
drwxr-xr-x 4 oracle oinstall       4096 Jun 11 03:15 jdk
drwxrwxr-x 4 oracle oinstall       4096 Jun 11 03:16 libskgxn
drwxr-xr-x 4 oracle oinstall       4096 Jun 11 03:08 oms
drwxr-xr-x 2 oracle oinstall       4096 Jun 11 03:17 plugins
-rw-r--r-- 1 oracle oinstall      65014 Jun 11 07:43 release_notes.pdf
drwxrwxr-x 2 oracle oinstall       4096 Jun 11 03:16 response
-rwxr-xr-x 1 oracle oinstall       5375 Dec 26  2013 runInstaller
drwxr-xr-x 9 oracle oinstall       4096 Jun 11 03:17 stage
drwxrwxr-x 2 oracle oinstall       4096 Jun 11 03:16 wls
-rwxr-xr-x 1 oracle oinstall 1533566101 Jun 11 03:07 WT.zip

– Run installer file:

[oracle@localhost oem5]$ ./runInstaller 
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 400 MB.   Actual 20968 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 3999 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2015-07-11_12-47-34PM. Please wait ...

008. Installation in graphical mode

Description of every image is located below it.

003 – Uncheck option

Un-check “I wish to receive …”

Confirm selection

Skip connetion to MOS

Skip connection to MOS (if You using offline enviroment)

Check for all Passed

Check or all “Passed” status

One system upgrade

Select “Upgrade an existing Enterprise Manager System”
“One System Upgrade”
And mark detected middleware home.

New location for middleware

Enter location for a NEW ONE LOCATION of middleware path (will be created during upgrade process)

Enter passwords

enter sys password
enter sysman password
confirm backup

Warning

Small info will be displayed. In my case (upgrade 12.1.0.4.0 to 12.1.0.5.0) there are no steps needed.
Installation will hang for a while and next will display some warnings.

Confirm selection

Confirm.

Another warning

Another window with warning…

List of upgraded plugins

Info about plugins upgraded

Select additional plugins

Select additional plugins if needed

Enter new location for OMS

Enter weblogic password
Enter path for NEW LOCATION of OMS Base Location (will be created)

Last step

Last step – summary before we start installation process

Installation started…

Few seconds later – installer is started.
You can click on “View Log” – outer window will be displayed with installation progress.

Log output window

Info window with installation output (one log window for entire installation progress)

Long time used (screen 1/2)

Longest installation process (screen 1/2):
– “Applying the required oneoff patches” – take a few minutes to complete

Long time used (screen 2/2)

Longest installation process (screen 2/2):
“Configuration assistant “Repository Upgrade” in progress” – that is the loooongest part.
It looks like something has hung – but be patient and wait until completion.
Percentage bar is stopped for a while and inside output window only INFO is displayed constantly…

Run script as root

At the end of installation process you will be asked to run script with root privileges.
Switch to root user, run and press enter/enter/enter ….
EXAMPLE: Run script as root user

[oracle@localhost ~]$ su
Password: 
[root@localhost oracle]# /u01/app/oracle/middleware5/oms/allroot.sh

Starting to execute allroot.sh ......... 

Starting to execute /u01/app/oracle/middleware5/oms/root.sh ......
Running Oracle 11g root.sh script...

The following environment variables are set as:
    ORACLE_OWNER= oracle
    ORACLE_HOME=  /u01/app/oracle/middleware5/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]: [ENTER]
The file "oraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: [ENTER]
The file "coraenv" already exists in /usr/local/bin.  Overwrite it? (y/n) 
[n]: [ENTER]

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/middleware5/oms
Finished execution of  /u01/app/oracle/middleware5/oms/root.sh ......

Confirm when completed

Then – confirm previous window.

Last step

It was the last step of installation process.
The confirmation window is displayed.
Close it.

Run browser

Open browser and go to displayed adress: https://oem12c:7801/em
Click “Add Exception” (is collapsed under “I Understand the Risk” section)

Confirm exception

Confirm Security Exception of server certificate and remember the choice.

Log into oem12c

Success – we got latest version!

Updated to Release 5 (12.1.0.5.0)

009. Possible errors:

IMPORTANT! AFTER INSTALLATION IS COMPLETED – LOG OFF AND LOG AGAIN.
Installer changed few enviromental variables – no reboot needed, just close this shell session and log again.

Otherwise You can see some errors:
SP2-0152: ORACLE may not be functioning properly

[oracle@localhost ~]$ sqlplus "/as sysdba"
SP2-1503: Unable to initialize Oracle call interface
SP2-0152: ORACLE may not be functioning properly

ORA-12545: Connect failed because target host or object does not exist

[oracle@localhost ~]$ sqlplus "/as sysdba"

SQL*Plus: Release 11.1.0.7.0 - Production on Sat Jul 11 17:35:30 2015

Copyright (c) 1982, 2008, Oracle.  All rights reserved.

ERROR:
ORA-12545: Connect failed because target host or object does not exist

Enter user-name: sys as sysdba
Enter password: 
ERROR:
ORA-12545: Connect failed because target host or object does not exist