Let’s have a quick introduction of Upgrade in Oracle. As we go in depth of this article we have mentioned about the steps of an upgrade OEM from 12cR5 to 13cR2.
Thanks to my fellow DBA Kellyn Pot’Vin-Gorman who gave me idea to write on OEM 13c.
Day by day technologies get change and advanced technology come. Change plays an important role in human life. In our school time, we have learned about the Darwinian theory which explains the importance of change in the world.
In the same manner in the world of technology, we have also seen that Oracle database’s journey started from the First release: June 1992 (7.0) and still going on. Here we have a technical definition on upgradation . The upgrade is the process of replacing our existing software with a newer version of the same product. For example, replacing Oracle 9i release to Oracle 10g release. Upgrading our applications usually do not require special tools. Our existing reports should look and behave the same in both products. However, sometimes minor changes may be seen in a product. Upgradation is done at the Software level.
There are some reasons why do we need to upgrade our database which is mention below:-
- Updated hardware and operating systems.
- Security patches.
- Marketplace relevance
- Easier future upgrades.
- Data protection.
- Database consolidation
- Cloud migration
- Application vendor suppor
Oracle OEM 13c has been introduced with enhanced GUI and with a lot of new features.
OEM(Oracle Enterprise Manager) is pictorial representation of system, its status, downtime impact with lot of features to enhance the usability of Database. OEM 13c maximize support integration for Oracle Engineered Machine Exadata. OEM makes daily jobs easier and faster.
If we have Enterprise Manager Cloud Control 12c Release 5 (12.1.0.5), 12c Release 4 (12.1.0.4) or 12c Release 3 (12.1.0.3) then Oracle recommends that you upgrade it to 13c Release 1 to benefit from all the new features.
Supported environment for upgrading to OEM 13c Cloud control:
- OEM 12c Release 5 (12.1.0.5)
- OEM 12c Release 4 (12.1.0.4)
- OEM 12c Release 3 (12.1.0.3) without BI Publisher. If BI publisher is configured then we need to upgrade to 12c Release 4 or 5
Supported OMR database version
- Oracle 12.1.0.2.0
Supported Managed Targets
- Oracle 12.1.0.2.0
- Oracle 12.1.0.1.0
- Oracle 11.2.0.4.0
- Oracle 11.2.0.3.0
- Oracle 11.2.0.2.0
- Oracle 11.2.0.1.0
- Oracle 11.1.0.7.0
- Oracle 10.2.0.5.0
- Oracle 10.2.0.4.0
- Oracle 10.2.0.5.0
- Oracle 10.2.0.4.0
- Oracle 10.1.0.5.0
Supported Agent version
- Agent 13.1.0.0.0
- Agent 12.1.0.5.0
- Agent 12.1.0.4.0
- Agent 12.1.0.3.0
Restriction
- Pre-installed JDK or Oracle Weblogic is not supported from 13c Release 1 onward.
- Dedicated Oracle Weblogic Server 12c Release 1 is required.
- The central agent (in other words, the Management Agent installed with the OMS) is not upgraded by default. You must upgrade it using the Agent Upgrade Console available in the Enterprise Manager Cloud Control Console after upgrading the OMS.
- After upgrading the OMS, you must upgrade the Management Agent separately using the Agent Upgrade Console. Agent Upgrade Console is a GUI console that you see in the Enterprise Manager Cloud Control Console after you upgrade the OMS.
- To access the Agent Upgrade Console, from the Setup menu, click Manage Cloud Control, then select Upgrade Agents.
Below are the steps for upgrading OEM 12c (12.1.0.5) to OEM 13c (13.2.0.1)
Current OEM version – 12.1.0.5
Repository DB version – 12.1.0.2
Upgrade OEM version – 13.2.0.0
PREREQUISITES:
- OMS 13c repository database needs to be on 12.1.0.2 version. So, if the repository database is on a pre-12c release, then you need to upgrade it before upgrading the Cloud control.
- Cloud control 13c is not supported on OEL/RHEL 5 and so are the 13c agents. You cannot upgrade cloud control 12c on linux machine less than version 6 to 13c.
- Apply the latest PSU patch to the rdbms home of repository database.
- Make sure that database compatibility parameter equal to the database version
- Run utlrp.sql to make sure no invalid objects.
SQL> SELECT owner, object_name, object_type FROM dba_objects WHERE status = 'INVALID' AND owner IN ('SYS', 'SYSTEM', 'SYSMAN', 'MGMT_VIEW', 'DBSNMP', 'SYSMAN_MDS'); 2 3 no rows selected
6. Set optimizer_adaptive_features to FALSE;
SQL> conn / as sysdba Connected. SQL> alter system set optimizer_adaptive_features=FALSE scope=both; System altered
7. Verify that all the OMS have the same version of Plugins deployed. (Run from SYSMAN)
set serveroutput on declare oms_guids mgmt_medium_string_array := mgmt_medium_string_array(); oms_names mgmt_medium_string_array := mgmt_medium_string_array(); mismatches smp_emd_nvpair_array := smp_emd_nvpair_array(); begin select host_url, em_plugin_util.get_guid_from_name(unique_oms_name) bulk collect into oms_names, oms_guids from gc_oms_info; for j in 1..oms_guids.count loop dbms_output.put_line('Checking mismatch for OMS ' || oms_names(j)); mismatches := smp_emd_nvpair_array(); em_plugin_inventory.get_plugin_mismatch(oms_guids(j), mismatches); if mismatches is null or mismatches.count = 0 then dbms_output.put_line('No mismatch found for OMS ' || oms_names(j)); else dbms_output.put_line('Mismatch found for OMS ' || oms_names(j)); for i in 1..mismatches.count loop dbms_output.put_line('Plug-in on repository: ' || nvl(mismatches(i).name, 'None') || ', Plug-in on OMS: ' || nvl(mismatches(i).value, 'None')); end loop; end if; end loop; end; / Checking mismatch for OMS bttstdev64.stc.com.sa:4889_Management_Service No mismatch found for OMS bttstdev64.stc.com.sa:4889_Management_Service PL/SQL procedure successfully completed.
8. Check for stuck jobs:
SELECT job_type, status, cnt FROM ( SELECT job_type, status, count(*) as cnt FROM MGMT_JOB_EXEC_SUMMARY join MGMT_JOB_TYPE_INFO using (job_type_id) WHERE status NOT IN(3,4,5,8,18,19,23) group by job_type, status order by 3, 1, 2 ) where cnt > 10000; no rows selected
9. Remove obsolete plugins:
Below are the obsolete in 13c : ( if any is installed , please remove them )
- EMC Symmetrix Array (oracle.em.sesy)
- EMC Celerra Storage (oracle.em.secs)
- EMC Clariion Array (oracle.em.secl)
- Microsoft Biz Talk Server (oracle.em.smbs)
- Exalogic Elastic Cloud Infrastructure (oracle.em.soee)
Note: Below are the steps for removing obsolete plugins:
Go to SETUP -> EXTENSIBILITY -> PLUGINS
SELECT THE PLUGIN , that needs to be removed and Undeploy.
UNDEPLOY FROM -> MANAGEMENT SERVERS
10. Grant below privileges on repository database:
GRANT EXECUTE ON dbms_random TO dbsnmp; GRANT EXECUTE ON dbms_random TO sysman; REVOKE EXECUTE ON dbms_random FROM public;
11. Stop the OMS and the agent on OMS server:
-- Go to OMS HOME ./emctl stop oms all -- GO to AGENT_HOME on ( OMS server) ./emctl stop agent
12. Ensure that you do not have any login or logoff triggers set in the Oracle Database that houses the Oracle Management Repository
SELECT COUNT (trigger_name) FROM sys.dba_triggers WHERE TRIGGERING_EVENT LIKE 'LOGIN%' AND status='ENABLED'; SELECT COUNT (trigger_name) FROM sys.dba_triggers WHERE TRIGGERING_EVENT LIKE 'LOGOFF%' AND status='ENABLED';
Now we can start the Upgrade process for OEM 12cR5 to 13cR2
Download the Oracle OEM 13c software to your server.
Note: Don’t unzip them
oracle:~/Utility/13C$ ls -ltr total 14972494 -rwxrwxrwx 1 oracle oinstall 391887755 Oct 19 17:35 em13200_solaris_sparc64.bin -rwxrwxrwx 1 oracle oinstall 2108363980 Oct 21 05:28 em13200_solaris_sparc64-2.zip -rwxrwxrwx 1 oracle oinstall 2018746750 Oct 23 10:11 em13200_solaris_sparc64-3.zip -rwxrwxrwx 1 oracle oinstall 639119840 Oct 23 10:55 em13200_solaris_sparc64-4.zip -rwxrwxrwx 1 oracle oinstall 2141555621 Oct 23 11:21 em13200_solaris_sparc64-5.zip -rwxrwxrwx 1 oracle oinstall 360314098 Oct 23 17:01 em13200_solaris_sparc64-6.zip
Execute the .bin file from,( to invoke GUI)
oracle@:~/Utility/13C$ ./em13200_solaris_sparc64.bin 0%……………………………………………………………..100% Launcher log file is /var/tmp/OraInstall2016-10-24_11-11-57AM/launcher2016-10-24_11-11-57AM.log. Starting Oracle Universal Installer Checking if CPU speed is above 300 MHz. Actual 2998 MHz Passed Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed Checking swap space: must be greater than 512 MB. Actual 12442 MB Passed Checking if this platform requires a 64-bit JVM. Actual 64 Passed Preparing to launch the Oracle Universal Installer from /var/tmp/OraInstall2016-10-24_11-11-57AM ====Prereq Config Location main=== /var/tmp/OraInstall2016-10-24_11-11-57AM/stage/prereq EMGCInstaller args -scratchPath EMGCInstaller args /var/tmp/OraInstall2016-10-24_11-11-57AM EMGCInstaller args -sourceType EMGCInstaller args network EMGCInstaller args -timestamp EMGCInstaller args 2016-10-24_11-11-57AM EMGCInstaller args -paramFile EMGCInstaller args /var/tmp/sfx_AAAZSaqjs/Disk1/install/solaris_sparc64/oraparam.ini EMGCInstaller args -nocleanUpOnExit DiskLoc inside SourceLoc/export/home/oracle/Utility/13C EMFileLoc:/var/tmp/OraInstall2016-10-24_11-11-57AM/oui/em/ ScratchPathValue :/var/tmp/OraInstall2016-10-24_11-11-57AM
Enter A NEW OMS HOME LOCATION:
In the end root.sh script will pop up. Please run the same as the root user.
root@bttstdev64:~# /data/app/oracle/oms13c/allroot.sh Starting to execute allroot.sh ......... Starting to execute /data/app/oracle/oms13c/root.sh ...... /var/opt/oracle exist /data/app/oracle/oms13c Finished execution of /data/app/oracle/oms13c/root.sh ......
With this OMS upgrade has been completed. Let’s open the URL.
UPGRADE AGENTS:
Once OMS upgrade is done, we can upgrade the agents to 13.1 version. However, you still continue using the same old 12c plug-ins.
SETUP -> MANAGE CLOUD CONTROL -> UPGRADE AGENT
Now click on NOT UPGRADABLE AGENTS, to check which agents cant be upgraded directly.
Once the update is done, Follow the same process of upgrading agents.
Thank you for giving your valuable time to read the above information.
For More Detail , You can join us follow:
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp