Category Archives: EM

Add Targets Manually on EM Cloud Control 13c

EM, , , , , , , , , , , ,

Add Database on EM Cloud Control 13c

Table of Contents
___________________________________________________________________________________________________

0. Overview
1. Agent Host Environment
2. Install EM 13C Agent on Host (Add host targets manually)
3. Add database to EM 13C
___________________________________________________________________________________________________


0. Overview

There are various different ways that a database can be added in Cloud Control (eg. manual discovery, automatic discovery, discovery via guided processes, discovery via EMCLI).  
This document describes how the target can be added manually.


1. Agent host Environment

Platform                        : Linuxx86_64, Linux 7
Server IP 		        : 192.168.2.11 / dg1.rajasekhar.com
OEM Version 			: 13c Release 3 (13.3.0.0)
Agent HOME 			: /u01/app/oracle/agent/agent13c/
DB ORACLE_HOME			: /u01/app/oracle/product/19.0.0/dbhome_1
Database Name 			: dell
Database Version 		: 19.3.0.0.0


2. Install EM 13C Agent on Host(Add host targets manually)

Please follow the screen shots.

3. Add database to EM 13C

Please follow the screen shots.

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +65-94693551
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

OEM 13C Release 3 Install

EM, , , , , , , , ,

Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0) Installation on Oracle Linux 64 bit

Table of Contents

___________________________________________________________________________________________________

0. Overview
1. Environment
2. Verify Certification
3. Download Software
      3.1 Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0)
      3.2 Oracle Database 19c (19.3) for Linux x86-64
4. Install Oracle 19c Release 3 on Linux 7.5
5. Create Repository Database 19.3
6. Install EM Cloud Control 13c Release 3 (13.3.0.0)
7. Open Enterprise Manager Cloud Control
8. Stop EM Cloud Control 13c
9. Start EM Cloud Control 13c

___________________________________________________________________________________________________


0. Overview

Oracle Enterprise Manager is a system management tool which provides an integrated solution for managing your heterogeneous environment. It combines a graphical console, agents, common services, and tools to provide an integrated, comprehensive systems management platform for managing Oracle products.

1. Environment

Platform   		: Linuxx86_64, Linux 7
Server IP 		: 192.168.2.10
OEM Version 		: 13c Release 3 (13.3.0.0)
OMS HOME		: /u01/app/oracle/middleware
Agent HOME 		: /u01/app/oracle/agent
DB ORACLE_HOME		: /u01/app/oracle/product/19.0.0/dbhome_1
Repository DB Name 	: OEMSTAR
Repository DB Version 	: 19.3.0.0.0
OMS Binary Owner 	: oracle:oinstall
DB Binary Owner		: oracle:oinstall


2. Verify Certification

Enterprise Manager Base Platform - OMS 13.3.0.0.0 is certified on Linux x86-64 Red Hat Enterprise Linux 7


3. Download Software

3.1 Oracle Enterprise Manager Cloud Control 13c Release 3 (13.3.0.0)

https://www.oracle.com/enterprise-manager/downloads/linux-x86-64-13c-rel3-downloads.html


3.2 Oracle Database 19c (19.3) for Linux x86-64


4. Install Oracle 19c Release 3 on Linux 7.5

Please find the sample doc below.
http://www.br8dba.com/install-19c/


5. Create Repository Database 19.3

[oracle@rac1 database]$ cd /u01/app/oracle/product/19.0.0/dbhome_1/bin/
[oracle@rac1 bin]$ ./dbca

































 -- Connection Verification

[oracle@oem ~]$ sqlplus sys@OEMSTAR as sysdba

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

Enter password:

Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>

Recommended parameter changes for 19c repository database.

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
OEMSTAR   READ WRITE

SQL>

SQL> alter system set "_allow_insert_with_update_check"=true scope=both;

System altered.

SQL> alter system set session_cached_cursors=200 scope=spfile;

System altered.

SQL> alter system set shared_pool_size=600M scope=spfile;

System altered.

SQL> alter system set processes=600 scope=spfile;

System altered.

SQL>

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup;
ORACLE instance started.

Total System Global Area 2432695144 bytes
Fixed Size                  8899432 bytes
Variable Size             536870912 bytes
Database Buffers         1879048192 bytes
Redo Buffers                7876608 bytes
Database mounted.
Database opened.
SQL> 

SQL> show parameter session_cached_cursors

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
session_cached_cursors               integer     200
SQL>
SQL> show parameter "_allow_insert_with_update_check"

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
_allow_insert_with_update_check      boolean     TRUE
SQL>
SQL> show parameter shared_pool_size

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
shared_pool_size                     big integer 608M
SQL>
SQL> show parameter processes

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
processes                            integer     600
SQL>


6. Install EM Cloud Control 13c Release 3 (13.3.0.0)

No need to unzip the software.

[oracle@rac1 ~]$ mkdir -p /u01/app/oracle/middleware
[oracle@rac1 ~]$ mkdir -p /u01/app/oracle/agent

[oracle@rac1 backup]$ ls -ltr
-rw-r--r--. 1 oracle oinstall  694002559 Jul 10 19:13 em13300_linux64-5.zip
-rwxr--r--. 1 oracle oinstall 1278491093 Jul 10 19:15 em13300_linux64.bin
-rw-r--r--. 1 oracle oinstall 1742204641 Jul 10 19:17 em13300_linux64-2.zip
-rw-r--r--. 1 oracle oinstall 1801995711 Jul 10 19:17 em13300_linux64-6.zip
-rw-r--r--. 1 oracle oinstall 2090882426 Jul 10 19:18 em13300_linux64-3.zip
-rw-r--r--. 1 oracle oinstall 2117436260 Jul 10 19:18 em13300_linux64-4.zip
[oracle@rac1 backup]$


[oracle@rac1 backup]$ ./em13300_linux64.bin
** The directory "/tmp" does not have enough space. At least 12289 MB of free space are required.
Please input another directory or [Exit]: /u01/app/oracle/backup
0%.........................................................................100%

Starting Oracle Universal Installer


7. Open Enterprise Manager Cloud Control

https://oem.rajasekhar.com:7803/em


8. Stop EM Cloud Control 13c

#Stop OMS

[oracle@oem ~]$ export OMS_HOME=/u01/app/oracle/middleware
[oracle@oem ~]$ /u01/app/oracle/middleware/bin/emctl stop oms -all
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation.  All rights reserved.
Stopping Oracle Management Server...
WebTier Successfully Stopped
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command
Stopping BI Publisher Server...
BI Publisher Server Already Stopped
BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command
AdminServer Successfully Stopped
BI Publisher Server is Down
BI Publisher is disabled, to enable BI Publisher on this host, use the 'emctl config oms -enable_bip' command
[oracle@oem ~]$

#Stop Agent

[oracle@oem ~]$ export AGENT_HOME=/u01/app/oracle/agent/agent_inst
[oracle@oem ~]$ /u01/app/oracle/agent/agent_inst/bin/emctl stop agent
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation.  All rights reserved.
Stopping agent ... stopped.
[oracle@oem ~]$

# Stop Database

[oracle@oem ~]$ . oraenv
ORACLE_SID = [oemstar] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@oem ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jul 11 21:23:46 2020
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> select name,open_mode from v$database;

NAME      OPEN_MODE
--------- --------------------
OEMSTAR   READ WRITE

SQL> shut immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>

[oracle@oem ~]$ ps -ef | grep tns
root        22     2  0 19:55 ?        00:00:00 [netns]
oracle    5025  9474  0 21:24 pts/0    00:00:00 grep --color=auto tns
oracle   20522     1  0 20:48 ?        00:00:00 /u01/app/oracle/product/19.0.0/dbhome_1/bin/tnslsnr OEMSTAR -inherit
[oracle@oem ~]$
[oracle@oem ~]$ lsnrctl stop OEMSTAR

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 11-JUL-2020 21:25:08

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oem.rajasekhar.com)(PORT=1522)))
The command completed successfully
[oracle@oem ~]$
[oracle@oem ~]$


9. Start EM Cloud Control 13c

# Start Database

[oracle@oem ~]$ . oraenv
ORACLE_SID = [oracle] ? oemstar
The Oracle base has been set to /u01/app/oracle
[oracle@oem ~]$ sqlplus

SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jul 11 20:17:38 2020
Version 19.3.0.0.0

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

Enter user-name: / as sysdba
Connected to an idle instance.

SQL> startup;
ORACLE instance started.

Total System Global Area 2432695144 bytes
Fixed Size                  8899432 bytes
Variable Size            1090519040 bytes
Database Buffers         1325400064 bytes
Redo Buffers                7876608 bytes
Database mounted.
Database opened.
SQL>

[oracle@oem ~]$ lsnrctl start OEMSTAR

[oracle@oem ~]$ lsnrctl status OEMSTAR

LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 11-JUL-2020 20:48:59

Copyright (c) 1991, 2019, Oracle.  All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=oem.rajasekhar.com)(PORT=1522)))
STATUS of the LISTENER
------------------------
Alias                     OEMSTAR
Version                   TNSLSNR for Linux: Version 19.0.0.0.0 - Production
Start Date                11-JUL-2020 20:48:21
Uptime                    0 days 0 hr. 0 min. 38 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /u01/app/oracle/product/19.0.0/dbhome_1/network/admin/listener.ora
Listener Log File         /u01/app/oracle/diag/tnslsnr/oem/oemstar/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=oem.rajasekhar.com)(PORT=1522)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1522)))
Services Summary...
Service "oemstar.rajasekhar.com" has 1 instance(s).
  Instance "oemstar", status READY, has 1 handler(s) for this service...
Service "oemstarXDB.rajasekhar.com" has 1 instance(s).
  Instance "oemstar", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@oem ~]$

#Start OMS

[oracle@oem ~]$ export OMS_HOME=/u01/app/oracle/middleware
[oracle@oem ~]$ /u01/app/oracle/middleware/bin/emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
[oracle@oem ~]$

#Start Agent
[oracle@oem ~]$ /u01/app/oracle/agent/agent_inst/bin/emctl start agent
Oracle Enterprise Manager Cloud Control 13c Release 3
Copyright (c) 1996, 2018 Oracle Corporation.  All rights reserved.
Starting agent ................................................................... started.
[oracle@oem ~]$

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +65-94693551
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

OEM Install 13.2

EM, , , , , ,

Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0) Installation on Oracle Linux 64 bit

Table of Contents

___________________________________________________________________________________________________

0. Overview
1. Environment
2. Verify Certification
3. Download Software
     3.1 Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0)
     3.2 Oracle Database 12c Release 1 (12.1.0.2.0) for Linux x86-64
     3.3 DB Template 12.1.0.2 for EM 13.2.0.0 on Linux x86-64
4. Install Oracle 12.1.0.2 software only
     4.1 Oracle Installation Prerequisites
     4.2 Set the password for the “oracle” user
     4.3 Set SELINUX to permissive
     4.4 Disable Firewall
     4.5 Create the directories
     4.6 Unzip Database Files
     4.7 Install Database software only 12.1.0.2
5. Unzip Database Template
6. Create Repository DB 12.1.0.2
7. Install EM Cloud Control 13c (13.2.0.0)
8. Open Enterprise Manager Cloud Control
___________________________________________________________________________________________________


0. Overview

Oracle Enterprise Manager is a system management tool which provides an integrated solution for managing your heterogeneous environment. It combines a graphical console, agents, common services, and tools to provide an integrated, comprehensive systems management platform for managing Oracle products.

1. Environment

Platform   		: Linuxx86_64, Linux 7
Server IP 		: 192.168.2.101
OEM Version 		: 13c Release 2 (13.2.0.0)
OMS HOME		: /u01/app/oracle/middleware
Agent HOME 		: /u01/app/oracle/agent
DB ORACLE_HOME		: /u01/app/oracle/product/12.1.0.2/db_1
Repository DB Name 	: OEMSTAR
Repository DB Version 	: 12.1.0.2
OMS Binary Owner 	: oracle:oinstall
DB Binary Owner		: oracle:oinstall


2. Verify Certification

Enterprise Manager Base Platform - OMS 13.2.0.0.0 is certified on Linux x86-64 Red Hat Enterprise Linux 7.


3. Download Software

3.1 Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0)

https://www.oracle.com/enterprise-manager/downloads/linux-x86-64-13c-rel2-downloads.html


3.2 Oracle Database 12c Release 1 (12.1.0.2.0) for Linux x86-64


3.3 DB Template 12.1.0.2 for EM 13.2.0.0 on Linux x86-64 (This is NOT Mandatory)

https://www.oracle.com/enterprise-manager/downloads/db-templates-13c-release2-downloads.html


Database Template (with EM 13.2.0.0 repository pre-configured) for Installing Oracle Enterprise Manager Cloud Control 13c Release 2 (13.2.0.0)
There are two templates available. In this article I will be using non-CDB architecture, but there is one for the Multitenant architecture also, however there won't be any CDB Repository Database.

12.1.0.2 DB Template for EM 13.2.0.0 on Linux x86-64
(OR)
12.1.0.2 DB Template with CDB PDB for EM 13.2.0.0 on Linux x86-64


4. Install Oracle 12.1.0.2 software only


4.1 Oracle Installation Prerequisites

# yum install oracle-rdbms-server-12cR1-preinstall -y


4.2 Set the password for the “oracle” user

[root@rac1 ~]# passwd oracle
Changing password for user oracle.
New password:
BAD PASSWORD: The password is shorter than 8 characters
Retype new password:
passwd: all authentication tokens updated successfully.
[root@rac1 ~]#


4.3 Set SELINUX to permissive

[root@rac1 ~]# cat /etc/selinux/config | grep -i "SELINUXTYPE=targeted"
SELINUXTYPE=targeted
[root@rac1 ~]#


4.4 Disable Firewall

[root@rac1 ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: active (running) since Wed 2019-09-18 00:17:12 +08; 2s ago
     Docs: man:firewalld(1)
 Main PID: 8252 (firewalld)
   CGroup: /system.slice/firewalld.service
           ââ8252 /usr/bin/python -Es /usr/sbin/firewalld --nofork --nopid

Sep 18 00:17:11 rac1 systemd[1]: Starting firewalld - dynamic firewall daemon...
Sep 18 00:17:12 rac1 systemd[1]: Started firewalld - dynamic firewall daemon.
[root@rac1 ~]#
[root@rac1 ~]# systemctl stop firewalld
[root@rac1 ~]# systemctl disable firewalld
[root@rac1 ~]# systemctl status firewalld
firewalld.service - firewalld - dynamic firewall daemon
   Loaded: loaded (/usr/lib/systemd/system/firewalld.service; disabled; vendor preset: enabled)
   Active: inactive (dead)
     Docs: man:firewalld(1)

Sep 18 00:17:11 rac1 systemd[1]: Starting firewalld - dynamic firewall daemon...
Sep 18 00:17:12 rac1 systemd[1]: Started firewalld - dynamic firewall daemon.
Sep 18 00:17:40 rac1 systemd[1]: Stopping firewalld - dynamic firewall daemon...
Sep 18 00:17:40 rac1 systemd[1]: Stopped firewalld - dynamic firewall daemon.
[root@rac1 ~]#


4.5 Create the directories

[root@rac1 ~]# mkdir -p /u01/app/oracle/product/12.1.0.2/db_1
[root@rac1 ~]# chown -R oracle:oinstall /u01
[root@rac1 ~]# chmod -R 775 /u01
[root@rac1 ~]#


4.6 Unzip Database Files

[oracle@rac1 backup]$ unzip linuxamd64_12102_database_1of2.zip
[oracle@rac1 backup]$ unzip linuxamd64_12102_database_2of2.zip


4.7 Install Database software only 12.1.0.2

[oracle@rac1 backup]$ cd database
[oracle@rac1 database]$ pwd
/u01/app/backup/database
[oracle@rac1 database]$ ls -ltr
total 24
-rwxr-xr-x.  1 oracle oinstall  500 Feb  7  2013 welcome.html
-rwxr-xr-x.  1 oracle oinstall 8533 Jul  7  2014 runInstaller <----
drwxr-xr-x.  2 oracle oinstall   34 Jul  7  2014 rpm
drwxrwxr-x.  2 oracle oinstall   29 Jul  7  2014 sshsetup
drwxrwxr-x.  2 oracle oinstall   61 Jul  7  2014 response
drwxr-xr-x. 14 oracle oinstall 4096 Jul  7  2014 stage
drwxr-xr-x.  4 oracle oinstall 4096 Sep 18 00:27 install
[oracle@rac1 database]$

[oracle@rac1 database]$ export DISPLAY=192.168.2.2:0.0
[oracle@rac1 database]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 500 MB.   Actual 3568 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 4095 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2019-09-18_12-34-54AM. Please wait ...[oracle@rac1 database]$


5. Unzip Database Template (This is NOT Mandatory, without this template you can create database)

[oracle@rac1 ~]$ cd /u01/app/oracle/product/12.1.0.2/db_1/assistants/dbca/templates
[oracle@rac1 templates]$ ls -ltr
total 679404
-rw-r--r--. 1 oracle oinstall     11000 Dec 23  2013 New_Database.dbt
-rw-r--r--. 1 oracle oinstall   2379776 Jul  7  2014 example.dmp
-rw-r--r--. 1 oracle oinstall  22339584 Jul  7  2014 example01.dfb
-rw-r--r--. 1 oracle oinstall 178683904 Jul  7  2014 sampleschema.dfb
-rw-r--r--. 1 oracle oinstall      5333 Jul  7  2014 sampleschema.xml
-rw-r--r--. 1 oracle oinstall 155189248 Jul  7  2014 pdbseed.dfb
-rw-r--r--. 1 oracle oinstall      4045 Jul  7  2014 pdbseed.xml
-rw-r--r--. 1 oracle oinstall 319102976 Jul  7  2014 Seed_Database.dfb
-rw-r--r--. 1 oracle oinstall  17973248 Jul  7  2014 Seed_Database.ctl
-rw-r--r--. 1 oracle oinstall      5028 Jul  7  2014 Data_Warehouse.dbc
-rw-r--r--. 1 oracle oinstall      4908 Jul  7  2014 General_Purpose.dbc
[oracle@rac1 templates]$ unzip /u01/app/backup/12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Linux_x64.zip
Archive:  /u01/app/backup/12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Linux_x64.zip
  inflating: set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_2_0_0_0_Large_deployment.sql
  inflating: set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_2_0_0_0_Medium_deployment.sql
  inflating: set_repo_param_12.1.0.2.0_Database_SQL_for_EM13_2_0_0_0_Small_deployment.sql
  inflating: shpool_12.1.0.2.0_Database_SQL_for_EM13_2_0_0_0.sql
  inflating: 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Large_deployment.dbc
  inflating: 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Medium_deployment.dbc
  inflating: 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0_Small_deployment.dbc
  inflating: 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0.dfb
  inflating: 12.1.0.2.0_Database_Template_for_EM13_2_0_0_0.ctl
[oracle@rac1 templates]$


6. Create Repository DB 12.1.0.2

[oracle@rac1 database]$ cd /u01/app/oracle/product/12.1.0.2/db_1/bin/
[oracle@rac1 bin]$ ./dbca <-----





































Connection Verification

[oracle@rac1 admin]$ sqlplus sys@OEMSTAR AS SYSDBA

SQL*Plus: Release 12.1.0.2.0 Production on Wed Sep 18 02:32:58 2019

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

Enter password:

Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options

SQL>

SQL> alter user SYSMAN identified by SYSMAN_123;

User altered.

SQL> alter user SYSMAN account unlock;

User altered.

SQL>


7. Install EM Cloud Control 13c (13.2.0.0)

No need to unzip the software.

[oracle@rac1 ~]$ mkdir -p /u01/app/oracle/middleware
[oracle@rac1 ~]$ mkdir -p /u01/app/oracle/agent

[oracle@rac1 backup]$ ls -ltr
total 7727644
-rwxrwxr-x. 1 oracle oinstall  474441637 Jun  3 12:15 em13200_linux64-6.zip
-rwxrwxr-x. 1 oracle oinstall  554607894 Jun  3 12:15 em13200_linux64.bin
-rwxrwxr-x. 1 oracle oinstall  553563556 Jun  3 12:16 em13200_linux64-3.zip
-rwxrwxr-x. 1 oracle oinstall 2118110455 Jun  3 12:31 em13200_linux64-2.zip
-rwxrwxr-x. 1 oracle oinstall 2084299941 Jun  3 12:31 em13200_linux64-4.zip
-rwxrwxr-x. 1 oracle oinstall 2128070240 Jun  3 12:32 em13200_linux64-5.zip
[oracle@rac1 backup]$


[oracle@rac1 backup]$ ./em13200_linux64.bin
** The directory "/tmp" does not have enough space. At least 10241 MB of free space are required.
Please input another directory or [Exit]: /u01/app/temp
0%.........................................................................100%
Launcher log file is /u01/app/temp/OraInstall2019-09-18_02-00-54AM/launcher2019-09-18_02-00-54AM.log.
Starting Oracle Universal Installer

Checking if CPU speed is above 300 MHz.   Actual 2603.810 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 4095 MB    Passed
Checking if this platform requires a 64-bit JVM.   Actual 64    Passed (64-bit not required)


8. Open Enterprise Manager Cloud Control

https://rac1.rajasekhar.com:7803/em

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +65-94693551
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

Apply Patch on Agent 13.1

EM, , , , , ,

Apply Patch on Oracle Management Agent 13c Release 1 (13.1.0.0.0)

Table of Contents
_________________________________________________________________________________________________

1. Environment
2. Download the patch from MOS
3. Verify OPatch Version
4. List Patches
5. Stop EM Agent
6. Unzip Patch
7. Apply Patch
8. List Patches
9. Start Agent
10. Status Agent
_________________________________________________________________________________________________


1. Environment

Platform   	: Linuxx86_64
Server IP 	: 192.168.2.101
OEM Version     : 13c Release 1 
OMS Home	: /u01/app/oracle/mwroem131
Agent Home	: /u01/app/oracle/agent131/agent_13.1.0.0.0


2. Download the patch from MOS


3. Verify OPatch Version

[oracle@rac1 ~]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/OPatch/opatch version
OPatch Version: 13.6.0.0.0 <-----

OPatch succeeded.
[oracle@rac1 ~]$


4. List Patches

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/agent131/agent_13.1.0.0.0
[oracle@rac1 ~]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/OPatch/opatch lsinv -oh /u01/app/oracle/agent131/agent_13.1.0.0.0
Oracle Interim Patch Installer version 13.6.0.0.0
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/agent131/agent_13.1.0.0.0
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/agent131/agent_13.1.0.0.0/oraInst.loc
OPatch version    : 13.6.0.0.0
OUI version       : 13.6.0.0.0
Log file location : /u01/app/oracle/agent131/agent_13.1.0.0.0/cfgtoollogs/opatch/opatch2019-06-02_20-49-49PM_1.log


OPatch detects the Middleware Home as "/u01/app/oracle/agent131"

Lsinventory Output file location : /u01/app/oracle/agent131/agent_13.1.0.0.0/cfgtoollogs/opatch/lsinv/lsinventory2019-06-02_20-49-49PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1.rajasekhar.com
ARU platform id: 226
ARU platform description:: Linux_AMD64


Interim patches (1) :

Patch  18421945     : applied on Sat Jun 01 23:17:55 SGT 2019
Unique Patch ID:  18724707
   Created on 12 Aug 2015, 02:07:32 hrs PST8PDT
   Bugs fixed:
     18421945



--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@rac1 ~]$


5. Stop EM Agent

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/agent131/agent_13.1.0.0.0/
[oracle@rac1 ~]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 13.1.0.0.0
OMS Version            : 13.1.0.0.0
Protocol Version       : 12.1.0.1.0
Agent Home             : /u01/app/oracle/agent131/agent_inst
Agent Log Directory    : /u01/app/oracle/agent131/agent_inst/sysman/log
Agent Binaries         : /u01/app/oracle/agent131/agent_13.1.0.0.0
Core JAR Location      : /u01/app/oracle/agent131/agent_13.1.0.0.0/jlib
Agent Process ID       : 2330
Parent Process ID      : 1941
Agent URL              : https://rac1.rajasekhar.com:3872/emd/main/
Local Agent URL in NAT : https://rac1.rajasekhar.com:3872/emd/main/
Repository URL         : https://rac1.rajasekhar.com:4903/empbs/upload
Started at             : 2019-06-02 14:59:50
Started by user        : oracle
Operating System       : Linux version 4.1.12-112.16.4.el7uek.x86_64 (amd64)
Number of Targets      : 33
Last Reload            : (none)
Last successful upload                       : 2019-06-02 21:13:01
Last attempted upload                        : 2019-06-02 21:13:01
Total Megabytes of XML files uploaded so far : 0.55
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 44.50%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2019-06-02 21:13:28
Last successful heartbeat to OMS             : 2019-06-02 21:13:28
Next scheduled heartbeat to OMS              : 2019-06-02 21:14:28

---------------------------------------------------------------
Agent is Running and Ready
[oracle@rac1 ~]$


[oracle@rac1 ~]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/bin/emctl stop agent
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Stopping agent ... stopped.
[oracle@rac1 ~]$

[oracle@rac1 ~]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent is Not Running
[oracle@rac1 ~]$


6. Unzip Patch

[oracle@rac1 ~]$ cp p25686936_131000_Generic.zip /u01/app/backup/MWPSU/AGENT

[oracle@rac1 ~]$ cd /u01/app/backup/MWPSU/AGENT
[oracle@rac1 AGENT]$ ls -ltr
total 19520
-rw-r--r--. 1 oracle oinstall 19985332 Jun  2 21:19 p25686936_131000_Generic.zip
[oracle@rac1 AGENT]$
[oracle@rac1 AGENT]$ unzip p25686936_131000_Generic.zip

[oracle@rac1 AGENT]$ ls -ltr
total 19520
drwxr-xr-x. 4 oracle oinstall       67 Apr  4  2017 25686936
-rw-r--r--. 1 oracle oinstall 19985332 Jun  2 21:19 p25686936_131000_Generic.zip
[oracle@rac1 AGENT]$


7. Apply Patch

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/agent131/agent_13.1.0.0.0
[oracle@rac1 25686936]$ cd /u01/app/backup/MWPSU/AGENT/25686936
[oracle@rac1 25686936]$ ls -ltr
total 28
drwxr-x---. 3 oracle oinstall    37 Apr  4  2017 files
drwxr-x---. 3 oracle oinstall    20 Apr  4  2017 etc
-rw-rw-r--. 1 oracle oinstall    24 Apr 18  2017 README.txt
-rw-rw-r--. 1 oracle oinstall 23830 Apr 18  2017 README.html
[oracle@rac1 25686936]$

[oracle@rac1 25686936]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/OPatch/opatch apply -oh /u01/app/oracle/agent131/agent_13.1.0.0.0
Oracle Interim Patch Installer version 13.6.0.0.0
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/agent131/agent_13.1.0.0.0
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/agent131/agent_13.1.0.0.0/oraInst.loc
OPatch version    : 13.6.0.0.0
OUI version       : 13.6.0.0.0
Log file location : /u01/app/oracle/agent131/agent_13.1.0.0.0/cfgtoollogs/opatch/25686936_Jun_02_2019_21_23_51/apply2019-06-02_21-23-45PM_1.log


OPatch detects the Middleware Home as "/u01/app/oracle/agent131"

Verifying environment and performing prerequisite checks...
OPatch continues with these patches:   25686936

Do you want to proceed? [y|n]
y
User Responded with: Y
All checks passed.
Backing up files...
Applying interim patch '25686936' to OH '/u01/app/oracle/agent131/agent_13.1.0.0.0'

Patching component oracle.sysman.top.agent, 13.1.0.0.0...
Patch 25686936 successfully applied.
Log file location: /u01/app/oracle/agent131/agent_13.1.0.0.0/cfgtoollogs/opatch/25686936_Jun_02_2019_21_23_51/apply2019-06-02_21-23-45PM_1.log

OPatch succeeded.
[oracle@rac1 25686936]$


8. List Patches

[oracle@rac1 25686936]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/OPatch/opatch lsinv -oh /u01/app/oracle/agent131/agent_13.1.0.0.0
Oracle Interim Patch Installer version 13.6.0.0.0
Copyright (c) 2019, Oracle Corporation.  All rights reserved.


Oracle Home       : /u01/app/oracle/agent131/agent_13.1.0.0.0
Central Inventory : /u01/app/oraInventory
   from           : /u01/app/oracle/agent131/agent_13.1.0.0.0/oraInst.loc
OPatch version    : 13.6.0.0.0
OUI version       : 13.6.0.0.0
Log file location : /u01/app/oracle/agent131/agent_13.1.0.0.0/cfgtoollogs/opatch/opatch2019-06-02_21-31-30PM_1.log


OPatch detects the Middleware Home as "/u01/app/oracle/agent131"

Lsinventory Output file location : /u01/app/oracle/agent131/agent_13.1.0.0.0/cfgtoollogs/opatch/lsinv/lsinventory2019-06-02_21-31-30PM.txt

--------------------------------------------------------------------------------
Local Machine Information::
Hostname: rac1.rajasekhar.com
ARU platform id: 226
ARU platform description:: Linux_AMD64


Interim patches (2) :

Patch  25686936     : applied on Sun Jun 02 21:24:03 SGT 2019
Unique Patch ID:  21169532
Patch description:  "EM-AGENT Bundle Patch 13.1.0.0.170418"
   Created on 4 Apr 2017, 00:39:32 hrs PST8PDT
   Bugs fixed:
     24437699, 25101457, 23478148, 21779343, 22616051, 23759799, 23013302
     22988508, 23089106, 23581450, 22046370, 24667762, 23079593, 24933541
     24450644, 23268700, 22823268, 19802080, 24447221, 22201508, 18197723
     22720511, 23724816, 24672237, 22568679, 23638365, 25686936, 23593972
     22847565, 24697787, 23592254, 22892276, 25289023, 22565184, 22684160
     22928984, 24842780, 22918272, 24456370, 25297713, 23208577, 24415605
     23292275, 22384903, 22304248, 24308442, 23030165, 25113676, 25136887
     23561531, 22542388, 25286373, 24934732, 23507445, 22448575, 23511066
     22293781, 22099911, 21449788, 21755932

Patch  18421945     : applied on Sat Jun 01 23:17:55 SGT 2019
Unique Patch ID:  18724707
   Created on 12 Aug 2015, 02:07:32 hrs PST8PDT
   Bugs fixed:
     18421945



--------------------------------------------------------------------------------

OPatch succeeded.
[oracle@rac1 25686936]$


9. Start Agent

[oracle@rac1 25686936]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/bin/emctl start agent
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Starting agent ................................................................ started.
[oracle@rac1 25686936]$


10. Status Agent

[oracle@rac1 25686936]$ /u01/app/oracle/agent131/agent_13.1.0.0.0/bin/emctl status agent
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
---------------------------------------------------------------
Agent Version          : 13.1.0.0.0
OMS Version            : 13.1.0.0.0
Protocol Version       : 12.1.0.1.0
Agent Home             : /u01/app/oracle/agent131/agent_inst
Agent Log Directory    : /u01/app/oracle/agent131/agent_inst/sysman/log
Agent Binaries         : /u01/app/oracle/agent131/agent_13.1.0.0.0
Core JAR Location      : /u01/app/oracle/agent131/agent_13.1.0.0.0/jlib
Agent Process ID       : 2277
Parent Process ID      : 2051
Agent URL              : https://rac1.rajasekhar.com:3872/emd/main/
Local Agent URL in NAT : https://rac1.rajasekhar.com:3872/emd/main/
Repository URL         : https://rac1.rajasekhar.com:4903/empbs/upload
Started at             : 2019-06-02 21:39:25
Started by user        : oracle
Operating System       : Linux version 4.1.12-112.16.4.el7uek.x86_64 (amd64)
Number of Targets      : 33
Last Reload            : (none)
Last successful upload                       : 2019-06-02 21:41:05
Last attempted upload                        : 2019-06-02 21:41:05
Total Megabytes of XML files uploaded so far : 0.02
Number of XML files pending upload           : 0
Size of XML files pending upload(MB)         : 0
Available disk space on upload filesystem    : 44.40%
Collection Status                            : Collections enabled
Heartbeat Status                             : Ok
Last attempted heartbeat to OMS              : 2019-06-02 21:40:10
Last successful heartbeat to OMS             : 2019-06-02 21:40:10
Next scheduled heartbeat to OMS              : 2019-06-02 21:41:22

---------------------------------------------------------------
Agent is Running and Ready
[oracle@rac1 25686936]$

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +65-94693551
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

Apply Patch on OMS

EM, , ,

Apply Oracle Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718 for Oracle Management Service

Table of Contents
_________________________________________________________________________________________________

0. Overview
1. Environment
2. Download the patch from MOS
3. Upgrade OMSPatcher
4. List patches which were applied
5. Unzip patch
6. Patch Verification using analyze
7. Stop OMS
8. Apply Patch
9. List Patches
10. Start OMS
_________________________________________________________________________________________________


0. Overview

Goal: We are going to apply PSU 25904755 (Enterprise Manager 13c Release 1 Patch Set Update 13.1.0.0.170718)

[oracle@rac1 ~]$ /u01/app/oracle/mwroem131/bin/emctl status oms -details
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Enter Enterprise Manager Root (SYSMAN) Password :  <--- Enter password
Console Server Host        : rac1.rajasekhar.com
HTTP Console Port          : 7788
HTTPS Console Port         : 7803
HTTP Upload Port           : 4889
HTTPS Upload Port          : 4903
EM Instance Home           : /u01/app/oracle/gc_inst/em/EMGC_OMS1
OMS Log Directory Location : /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/log
OMS is not configured with SLB or virtual hostname
Agent Upload is locked.
OMS Console is locked.
Active CA ID: 1
Console URL: https://rac1.rajasekhar.com:7803/em
Upload URL: https://rac1.rajasekhar.com:4903/empbs/upload

WLS Domain Information
Domain Name            : GCDomain
Admin Server Host      : rac1.rajasekhar.com
Admin Server HTTPS Port: 7102
Admin Server is RUNNING

Oracle Management Server Information
Managed Server Instance Name: EMGC_OMS1
Oracle Management Server Instance Host: rac1.rajasekhar.com
WebTier is Up
Oracle Management Server is Up
JVMD Engine is Up

BI Publisher Server Information
BI Publisher Managed Server Name: BIP
BI Publisher Server is Up

BI Publisher HTTP Managed Server Port   : 9701
BI Publisher HTTPS Managed Server Port  : 9803
BI Publisher HTTP OHS Port              : 9788
BI Publisher HTTPS OHS Port             : 9851
BI Publisher is locked.
BI Publisher Server named 'BIP' running at URL: https://rac1.rajasekhar.com:9851/xmlpserver
BI Publisher Server Logs: /u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/
BI Publisher Log        : /u01/app/oracle/gc_inst/user_projects/domains/GCDomain/servers/BIP/logs/bipublisher/bipublisher.log
[oracle@rac1 ~]$

Prerequisites:

weblogic admin server URL(t3s://rac1.rajasekhar.com:7102):>
weblogic admin server username(weblogic):>
weblogic admin server password:>


1. Environment

Platform   	: Linuxx86_64
Server IP 	: 192.168.2.101
OEM Version     : 13c Release 1 
OMS Home	: /u01/app/oracle/mwroem131


2. Download the patch from MOS


3. Upgrade OMSPatcher


4. List patches which were applied

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$ /u01/app/oracle/mwroem131/OMSPatcher/omspatcher lspatches -oh /u01/app/oracle/mwroem131
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       : /u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_18-55-36PM_1.log

Component Name/Version                            Component Type      System Patch        (Sub)-Patches       Patch Description
------------------------                          -------------       -------------       --------------      ------------------
oracle.jrf.adfrt/12.1.3.0.0                       Core                N/A                 22065592            One-off

oracle.webcenter.pageeditor/12.1.3.0.0            Core                N/A                 20882747            One-off

oracle.bi.xdo/12.1.3.0.0                          Core                N/A                 21839888            One-off

oracle.wls.clients/12.1.3.0.0                     Core                N/A                 19953516            One-off

oracle.xdk.jrf.jaxp/12.1.3.0.0                    Core                N/A                 19345252            One-off

oracle.wls.libraries/12.1.3.0.0                   Core                N/A                 21252292            One-off
                                                                      N/A                 21243471            One-off
                                                                      N/A                 18836900            One-off
                                                                      N/A                 19879223            One-off
                                                                      N/A                 19730967            One-off
                                                                      N/A                 20758863            One-off
                                                                      N/A                 19953516            One-off

oracle.xdk.jrf.xmlparserv2/12.1.3.0.0             Core                N/A                 19345252            One-off

oracle.fmwconfig.common.wls.shared/12.1.          Core                N/A                 18974665            One-off
3.0.0

oracle.bali.cabo/12.1.3.0.0                       Core                N/A                 18814458            One-off

oracle.ldap.rsf/12.1.3.0.0                        Core                N/A                 20022048            One-off

oracle.fmwconfig.common.shared/12.1.3.0.          Core                N/A                 18974665            One-off
0

oracle.ohs2/12.1.3.0.0                            Core                N/A                 19901079            One-off
                                                                      N/A                 20222451            One-off

oracle.wlsplugins/12.1.3.0.0                      Core                N/A                 20442348            One-off

oracle.wls.core.app.server/12.1.3.0.0             Core                N/A                 19982906            One-off

oracle.wls.workshop.code.completion.supp          Core                N/A                 19953516            One-off
ort/12.1.3.0.0


NOTE: N/A indicates that the subpatch mentioned in the Subpatches column was applied as a one-off patch and not as part of any system patch.

OMSPatcher has saved inventory details for the above component at below location.
"/u01/app/oracle/mwroem131"

For more details on installed patch(es), Please do "/u01/app/oracle/mwroem131/OPatch/opatch lsinventory -details"

OMSPatcher succeeded.
[oracle@rac1 ~]$

-- Looks like no PSU applied on OMS home.


5. Unzip patch

[oracle@rac1 MWPSU]$ pwd
/u01/app/backup/MWPSU
[oracle@rac1 MWPSU]$
[oracle@rac1 MWPSU]$ unzip p25904755_131000_Generic.zip
[oracle@rac1 MWPSU]$ ls -ltr
total 36076
drwxr-x---. 4 oracle oinstall       95 Jun 12  2017 25904755
-rw-r--r--. 1 oracle oinstall 36940116 Jun  2 18:50 p25904755_131000_Generic.zip
[oracle@rac1 MWPSU]$


6. Patch Verification using analyze

-- No need to shutdown OMS

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$ /u01/app/oracle/mwroem131/OMSPatcher/omspatcher apply /u01/app/backup/MWPSU/25904755 -analyze
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       : /u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_19-05-18PM_1.log

OMSPatcher log file: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-06-05PM_analyze.log

Please enter OMS weblogic admin server URL(t3s://rac1.rajasekhar.com:7102):>
Please enter OMS weblogic admin server username(weblogic):>
Please enter OMS weblogic admin server password:>



Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "25904755" and Oracle Home "/u01/app/oracle/mwroem131"...
Sub-patch(es) "25904755" are successfully analyzed for Oracle Home "/u01/app/oracle/mwroem131"


Complete Summary
================


All log file names referenced below can be accessed from the directory "/u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/2019-06-02_19-05-18PM_SystemPatch_25904755_1"

Prerequisites analysis summary:
-------------------------------

The following sub-patch(es) are applicable:

             Featureset   Sub-patches                                          Log file
             ----------   -----------                                          --------
  oracle.sysman.top.oms      25904755   25904755_ApplyPrereq2019-06-02_19-09-06PM_2.log



Log file location: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-06-05PM_analyze.log

OMSPatcher succeeded.
[oracle@rac1 ~]$


7. Stop OMS

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$ /u01/app/oracle/mwroem131/bin/emctl stop oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Stopping Oracle Management Server...
Oracle Management Server Successfully Stopped
Oracle Management Server is Down
JVMD Engine is Down
[oracle@rac1 ~]$


8. Apply Patch

[oracle@rac1 25904755]$ pwd
/u01/app/backup/MWPSU/25904755
[oracle@rac1 25904755]$ /u01/app/oracle/mwroem131/OMSPatcher/omspatcher apply
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       : /u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_19-20-08PM_1.log

OMSPatcher log file: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-20-36PM_deploy.log

Please enter OMS weblogic admin server URL(t3s://rac1.rajasekhar.com:7102):>
Please enter OMS weblogic admin server username(weblogic):>
Please enter OMS weblogic admin server password:>



Configuration Validation: Success


Running apply prerequisite checks for sub-patch(es) "25904755" and Oracle Home "/u01/app/oracle/mwroem131"...
Sub-patch(es) "25904755" are successfully analyzed for Oracle Home "/u01/app/oracle/mwroem131"

To continue, OMSPatcher will do the following:
[Patch and deploy artifacts]   : Apply sub-patch(es) [ 25904755 ] to component "oracle.sysman.top.oms" and version "13.1.0.0.0";
                                 Apply RCU artifact with patch "/u01/app/oracle/mwroem131/.omspatcher_storage/25904755_Jun_12_2017_03_40_04/original_patch";
                                 Register MRS artifact "targetType";
                                 Register MRS artifact "storeTargetType";
                                 Register MRS artifact "default_collection";
                                 Register MRS artifact "swlib"


Do you want to proceed? [y|n]
y <---
User Responded with: Y

Applying sub-patch "25904755 " to component "oracle.sysman.top.oms" and version "13.1.0.0.0"...

Updating repository with RCU reference file "/u01/app/oracle/mwroem131/.omspatcher_storage/25904755_Jun_12_2017_03_40_04/original_patch"

Registering service "targetType" with register file "/u01/app/oracle/mwroem131/sysman/metadata/targetType/oldVersions/host/12.1.0.5/host.xml"...

Registering service "storeTargetType" with register file "/u01/app/oracle/mwroem131/sysman/metadata/targetType/oldVersions/host/12.1.0.5/host.xml"...

Registering service "default_collection" with register file "/u01/app/oracle/mwroem131/sysman/metadata/default_collection/oldVersions/host/12.1.0.5/host.xml"...

Registering service "swlib" with register file "/u01/app/oracle/mwroem131/sysman/metadata/swlib/patch"...

Complete Summary
================


All log file names referenced below can be accessed from the directory "/u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/2019-06-02_19-20-08PM_SystemPatch_25904755_1"

Patching summary:
-----------------

Binaries of the following sub-patch(es) have been applied successfully:

                        Featureset   Sub-patches                                     Log file
                        ----------   -----------                                     --------
  oracle.sysman.top.oms_13.1.0.0.0      25904755   25904755_opatch2019-06-02_19-23-00PM_3.log

Deployment summary:
-------------------

The following artifact(s) have been successfully deployed:

               Artifacts                                                      Log file
               ---------                                                      --------
                     SQL       rcu_applypatch_original_patch_2019-06-02_19-24-36PM.log
          MRS-targetType           emctl_register_targetType_2019-06-02_19-27-11PM.log
     MRS-storeTargetType      emctl_register_storeTargetType_2019-06-02_19-27-38PM.log
  MRS-default_collection   emctl_register_default_collection_2019-06-02_19-28-13PM.log
               MRS-swlib                emctl_register_swlib_2019-06-02_19-28-35PM.log


Log file location: /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/25904755/omspatcher_2019-06-02_19-20-36PM_deploy.log

OMSPatcher succeeded.
[oracle@rac1 25904755]$


9. List Patches

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$ /u01/app/oracle/mwroem131/OMSPatcher/omspatcher lspatches
OMSPatcher Automation Tool
Copyright (c) 2017, Oracle Corporation.  All rights reserved.


OMSPatcher version : 13.6.0.0.4
OUI version        : 13.6.0.0.0
Running from       : /u01/app/oracle/mwroem131
Log file location  : /u01/app/oracle/mwroem131/cfgtoollogs/omspatcher/opatch2019-06-02_19-29-59PM_1.log

Component Name/Version                            Component Type      System Patch        (Sub)-Patches       Patch Description
------------------------                          -------------       -------------       --------------      ------------------
oracle.sysman.top.oms/13.1.0.0.0                  Core                25904755            25904755            enterprise manager base platform - oms 13.1.0.0.170718 psu (generic)

oracle.jrf.adfrt/12.1.3.0.0                       Core                N/A                 22065592            One-off

oracle.webcenter.pageeditor/12.1.3.0.0            Core                N/A                 20882747            One-off

oracle.bi.xdo/12.1.3.0.0                          Core                N/A                 21839888            One-off

oracle.wls.clients/12.1.3.0.0                     Core                N/A                 19953516            One-off

oracle.xdk.jrf.jaxp/12.1.3.0.0                    Core                N/A                 19345252            One-off

oracle.wls.libraries/12.1.3.0.0                   Core                N/A                 21252292            One-off
                                                                      N/A                 21243471            One-off
                                                                      N/A                 18836900            One-off
                                                                      N/A                 19879223            One-off
                                                                      N/A                 19730967            One-off
                                                                      N/A                 20758863            One-off
                                                                      N/A                 19953516            One-off

oracle.xdk.jrf.xmlparserv2/12.1.3.0.0             Core                N/A                 19345252            One-off

oracle.fmwconfig.common.wls.shared/12.1.          Core                N/A                 18974665            One-off
3.0.0

oracle.bali.cabo/12.1.3.0.0                       Core                N/A                 18814458            One-off

oracle.ldap.rsf/12.1.3.0.0                        Core                N/A                 20022048            One-off

oracle.fmwconfig.common.shared/12.1.3.0.          Core                N/A                 18974665            One-off
0

oracle.ohs2/12.1.3.0.0                            Core                N/A                 19901079            One-off
                                                                      N/A                 20222451            One-off

oracle.wlsplugins/12.1.3.0.0                      Core                N/A                 20442348            One-off

oracle.wls.core.app.server/12.1.3.0.0             Core                N/A                 19982906            One-off

oracle.wls.workshop.code.completion.supp          Core                N/A                 19953516            One-off
ort/12.1.3.0.0


NOTE: N/A indicates that the subpatch mentioned in the Subpatches column was applied as a one-off patch and not as part of any system patch.

OMSPatcher has saved inventory details for the above component at below location.
"/u01/app/oracle/mwroem131"

For more details on installed patch(es), Please do "/u01/app/oracle/mwroem131/OPatch/opatch lsinventory -details"

OMSPatcher succeeded.
[oracle@rac1 ~]$


10. Start OMS

[oracle@rac1 ~]$ export ORACLE_HOME=/u01/app/oracle/mwroem131
[oracle@rac1 ~]$ /u01/app/oracle/mwroem131/bin/emctl start oms
Oracle Enterprise Manager Cloud Control 13c Release 1
Copyright (c) 1996, 2015 Oracle Corporation.  All rights reserved.
Starting Oracle Management Server...
WebTier Successfully Started
Oracle Management Server Successfully Started
Oracle Management Server is Up
JVMD Engine is Up
Starting BI Publisher Server ...
BI Publisher Server Already Started
BI Publisher Server is Up
[oracle@rac1 ~]$

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +65-94693551
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/

Upgrade OMSPatcher

EM

How to upgrade the Enterprise Manager 13.1 Cloud Control OMSPatcher to the Latest Version

Table of Contents

___________________________________________________________________________________________________

0. Overview
1. Environment
2. Current OMSPatcher Version
3. Download the patch from MOS
4. Backup OMSPatcher directory
5. Unzip patch
6. Verify OMSPatcher Version
___________________________________________________________________________________________________


0. Overview

OMSPatcher Upgrade just like Oracle OPatch version upgrade.

How to upgrade the Enterprise Manager 13.1 Cloud Control OMSPatcher to the Latest Version (Doc ID 2135028.1)
EM 13.2 How to Upgrade the Enterprise Manager 13.2 & 13.3 Cloud Control OMSPatcher to the Latest Version (Doc ID 2203007.1)


1. Environment

Oracle Enterprise Manager Cloud Control 13c Release 1
OMS ORACLE_HOME=/u01/app/oracle/mwroem131/
DB ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1


2. Current OMSPatcher Version

[oracle@rac1 ]$ cd /u01/app/oracle/mwroem131/OMSPatcher
[oracle@rac1 OMSPatcher]$ export ORACLE_HOME=/u01/app/oracle/mwroem131/
[oracle@rac1 OMSPatcher]$ ./omspatcher version
OMSPatcher Version: 13.6.0.0.0 <------
OPlan Version: 12.1.0.2.2
OsysModel build: Wed Oct 14 06:21:23 PDT 2015

OMSPatcher succeeded.
[oracle@rac1 OMSPatcher]$


3. Download the patch from MOS


4. Backup OMSPatcher directory

[oracle@rac1 mwroem131]$ pwd
/u01/app/oracle/mwroem131
[oracle@rac1 mwroem131]$ ls -ld OMSPatcher/
drwxr-x---. 7 oracle oinstall 4096 Jun  1 19:15 OMSPatcher/
[oracle@rac1 mwroem131]$ mv OMSPatcher OMSPatcher_bkp_02062019
[oracle@rac1 mwroem131]$ ls -ld OMSPatcher
ls: cannot access OMSPatcher: No such file or directory
[oracle@rac1 mwroem131]$


5. Unzip patch

-- Copy the patch to OMS ORACLE_HOME 

[oracle@rac1 ~]$ cp p19999993_131000_Generic.zip /u01/app/oracle/mwroem131
[oracle@rac1 ~]$ cd /u01/app/oracle/mwroem131
[oracle@rac1 mwroem131]$ ls -ltr p19999993_131000_Generic.zip
-rw-r--r--. 1 oracle oinstall 720177 Jun  2 17:34 p19999993_131000_Generic.zip
[oracle@rac1 mwroem131]$ unzip p19999993_131000_Generic.zip
Archive:  p19999993_131000_Generic.zip
   creating: OMSPatcher/
  inflating: OMSPatcher/omspatcher.bat
   creating: OMSPatcher/jlib/
  inflating: OMSPatcher/jlib/omspatcher.jar
  inflating: OMSPatcher/jlib/oracle.omspatcher.classpath.jar
  inflating: OMSPatcher/jlib/oracle.omspatcher.classpath.unix.jar
  inflating: OMSPatcher/jlib/oracle.omspatcher.classpath.windows.jar
   creating: OMSPatcher/scripts/
   creating: OMSPatcher/scripts/oms/
   creating: OMSPatcher/scripts/oms/oms_child_scripts/
  inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery
  inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_jvm_discovery.bat
  inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls
  inflating: OMSPatcher/scripts/oms/oms_child_scripts/omspatcher_wls.bat
  inflating: OMSPatcher/scripts/oms/omspatcher
  inflating: OMSPatcher/scripts/oms/omspatcher.bat
   creating: OMSPatcher/wlskeys/
  inflating: OMSPatcher/wlskeys/createkeys.cmd
  inflating: OMSPatcher/wlskeys/createkeys.sh
   creating: OMSPatcher/oms/
  inflating: OMSPatcher/oms/generateMultiOMSPatchingScripts.pl
  inflating: OMSPatcher/omspatcher
  inflating: readme.txt
  inflating: PatchSearch.xml
[oracle@rac1 mwroem131]$
[oracle@rac1 mwroem131]$ ls -ld OMSPatcher
drwxr-xr-x. 6 oracle oinstall 4096 Apr 13  2017 OMSPatcher
[oracle@rac1 mwroem131]$


6. Verify OMSPatcher Version

[oracle@rac1 ~]$ cd /u01/app/oracle/mwroem131/OMSPatcher
[oracle@rac1 OMSPatcher]$ export ORACLE_HOME=/u01/app/oracle/mwroem131/
[oracle@rac1 OMSPatcher]$ ./omspatcher version
OMSPatcher Version: 13.6.0.0.4  <----- changed from version 13.6.0.0.0
OPlan Version: 12.1.0.2.2
OsysModel build: Wed Oct 14 06:21:23 PDT 2015

OMSPatcher succeeded.
[oracle@rac1 OMSPatcher]$

Caution: Your use of any information or materials on this website is entirely at your own risk. It is provided for educational purposes only. It has been tested internally, however, we do not guarantee that it will work for you. Ensure that you run it in your test environment before using.

Thank you,
Rajasekhar Amudala
Email: br8dba@gmail.com
WhatsApp : +65-94693551
Linkedin: https://www.linkedin.com/in/rajasekhar-amudala/