Tag Archives: oem

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/

OEM DBConsole manually

Steps to configure Oracle 11g OEM DBConsole manually for database

In case your database is cloned from other database where you have grid already installed and configured. After the cloning, in the target database the same set of configuration will not work. You have to reconfigure the same. For that we have to drop the existing configuration first. If it is a new database you can directly configure using emca.

1. Drop dbcontrol configuration
2. Create the OEM repository
3. Configure EM db control
4. Verify the configuration
5. How to check status of EM database control
6. How to stop EM database control
7. How to start EM database control


Step 1. Drop the existing configuration if it is having sysman user already present.

SQL> Select username from dba_users where username='SYSMAN';

USERNAME
------------------------------
SYSMAN

The below command to drop the existing configuration

[oracle@rac2 ~]$ emca -deconfig dbcontrol db -repos drop

STARTED EMCA at Jul 21, 2016 2:06:14 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: cat
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

----------------------------------------------------------------------
WARNING : While repository is dropped the database will be put in quiesce mode.
----------------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/cat/emca_2016_07_21_14_06_14.log.
Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.util.GeneralUtil initSQLEngineLoacly
WARNING: ORA-28000: the account is locked

Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.ParamsManager checkListenerStatusForDBControl
WARNING: Error initializing SQL connection. SQL operations cannot be performed
Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.EMDBPreConfig performDeconfiguration
WARNING: EM is not configured for this database. No EM-specific actions can be performed. Some of the possible reasons may be:
 1) EM is configured with different hostname then physical host. Set environment variable ORACLE_HOSTNAME= and re-run EMCA script
 2) ORACLE_HOSTNAME is set. Unset it and re-run EMCA script
Jul 21, 2016 2:06:56 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Dropping the EM repository (this may take a while) ...
Jul 21, 2016 2:08:09 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully dropped
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 21, 2016 2:08:10 PM
[oracle@rac2 ~]$


Step 2. Create the OEM repository

[oracle@rac2 ~]$ emca -repos create

STARTED EMCA at Jul 21, 2016 2:08:43 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: cat
Listener port number: 1521
Password for SYS user:
Password for SYSMAN user:

Do you wish to continue? [yes(Y)/no(N)]: yes
Jul 21, 2016 2:08:56 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/cat/emca_2016_07_21_14_08_43.log.
Jul 21, 2016 2:08:56 PM oracle.sysman.emcp.EMReposConfig createRepository
INFO: Creating the EM repository (this may take a while) ...
Jul 21, 2016 2:12:29 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Repository successfully created
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 21, 2016 2:12:29 PM
[oracle@rac2 ~]$


Step 3. Confitgure EM db control

[oracle@rac2 ~]$ emca -config dbcontrol db

STARTED EMCA at Jul 21, 2016 2:26:10 PM
EM Configuration Assistant, Version 11.2.0.3.0 Production
Copyright (c) 2003, 2011, Oracle.  All rights reserved.

Enter the following information:
Database SID: cat
Listener port number: 1521
Listener ORACLE_HOME [ /u01/app/11.2.0/grid ]:
Password for SYS user:
Password for DBSNMP user:
Password for SYSMAN user:
Email address for notifications (optional):
Outgoing Mail (SMTP) server for notifications (optional):
-----------------------------------------------------------------

You have specified the following settings

Database ORACLE_HOME ................ /u01/app/oracle/product/11.2.0/db_1

Local hostname ................ rac2.rajasekhar.com
Listener ORACLE_HOME ................ /u01/app/11.2.0/grid
Listener port number ................ 1521
Database SID ................ cat
Email address for notifications ...............
Outgoing Mail (SMTP) server for notifications ...............

-----------------------------------------------------------------
Do you wish to continue? [yes(Y)/no(N)]: yes
Jul 21, 2016 2:34:25 PM oracle.sysman.emcp.EMConfig perform
INFO: This operation is being logged at /u01/app/oracle/cfgtoollogs/emca/cat/emca_2016_07_21_14_26_10.log.
Jul 21, 2016 2:34:29 PM oracle.sysman.emcp.EMReposConfig uploadConfigDataToRepository
INFO: Uploading configuration data to EM repository (this may take a while) ...
Jul 21, 2016 2:35:10 PM oracle.sysman.emcp.EMReposConfig invoke
INFO: Uploaded configuration data successfully
Jul 21, 2016 2:35:10 PM oracle.sysman.emcp.ParamsManager getLocalListener
WARNING: Error retrieving listener for rac2.rajasekhar.com
Jul 21, 2016 2:35:12 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Securing Database Control (this may take a while) ...
Jul 21, 2016 2:35:58 PM oracle.sysman.emcp.util.DBControlUtil secureDBConsole
INFO: Database Control secured successfully.
Jul 21, 2016 2:35:58 PM oracle.sysman.emcp.util.DBControlUtil startOMS
INFO: Starting Database Control (this may take a while) ...
Jul 21, 2016 2:36:38 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: Database Control started successfully
Jul 21, 2016 2:36:39 PM oracle.sysman.emcp.EMDBPostConfig performConfiguration
INFO: >>>>>>>>>>> The Database Control URL is https://rac2.rajasekhar.com:1158/em <<<<<<<<<<<
Jul 21, 2016 2:36:45 PM oracle.sysman.emcp.EMDBPostConfig invoke
WARNING:
************************  WARNING  ************************

Management Repository has been placed in secure mode wherein Enterprise Manager data will be encrypted.  The encryption key has been placed in the file: /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/config/emkey.ora. Ensure this file is backed up as the encrypted data will become unusable if this file is lost.

***********************************************************
Enterprise Manager configuration completed successfully
FINISHED EMCA at Jul 21, 2016 2:36:45 PM
[oracle@rac2 ~]$
[oracle@rac2 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.rajasekhar.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log
[oracle@rac2 ~]$
[oracle@rac2 ~]$


Step 4. Verify the configuration by typing Database Control URL

emca


How to check the status of EM database control

[oracle@rac2 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.rajasekhar.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log
[oracle@rac2 ~]$


How to stop EM database control

[oracle@rac2 ~]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.rajasekhar.com:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
 ...  Stopped.
[oracle@rac2 ~]$
[oracle@rac2 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.rajasekhar.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is not running.
[oracle@rac2 ~]$


How to start EM database control

[oracle@rac2 ~]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.rajasekhar.com:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ........ started.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log
[oracle@rac2 ~]$
[oracle@rac2 ~]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
Copyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.
https://rac2.rajasekhar.com:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /u01/app/oracle/product/11.2.0/db_1/rac2.rajasekhar.com_cat/sysman/log
[oracle@rac2 ~]$

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.