Tag Archives: em 13c

Add Targets Manually on EM Cloud Control 13c

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

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/