Friday 23 October 2020

OEM 13c : Oracle Enterprise manager Installation 13c on linux 64 bit OS.

OMR Database : OEMDB

OMS OEM Console : 13c

Oprerating System : OEL 7.7 64 bit

 OMR Database : 12.2.0.1 

links :  OMR Database minimum recommended parameter


  • Download and install oem 13c  ( we have downloaded OEM 13c already), Here OMR database and OEM13c are in same hosts we can install OMR database and OEM 13c server on different server as well.

[oracle@oem13c oem]$ ll

total 9497096

-rwxrwxr-x. 1 oracle oinstall 1278491093 Oct 20 19:21 em13300_linux64-2.bin

-rwxrwxr-x. 1 oracle oinstall 1742204641 Oct 20 19:22 em13300_linux64-2.zip

-rwxrwxr-x. 1 oracle oinstall 2090882426 Oct 20 19:23 em13300_linux64-3.zip

-rwxrwxr-x. 1 oracle oinstall 2117436260 Oct 20 19:24 em13300_linux64-4.zip

-rwxrwxr-x. 1 oracle oinstall  694002559 Oct 20 19:24 em13300_linux64-5.zip

-rwxrwxr-x. 1 oracle oinstall 1801995711 Oct 20 19:25 em13300_linux64-6.zip

  • Execute /em13300_linux64.bin to begin installation.

[oracle@oem13c oem]$ ./em13300_linux64.bin

STEP 1: skip the security update option :



STEP 2 : Skip software update 


STEP 3 : Fix warning  in my case i proceed further as kernel parameter and memory is sufficient for installation.


STEP 4 : In my case Proceed with option simple option


STEP 5 : Middleware home location | agent base directory | hostname


STEP 6 :  Provide sysman password which is used for OEM console. and provide OMR database details.


STEP 7:  Disable ( Configure a shared location for oracle BI publisher ) on next screenshot.



STEP 8: Review installation process details.


STEP 9 : After 4-5 hr depends on OS configuration run ./allroot.sh from middleware home.


STEP 10 : Installation complete so copy URL from console https://oem13c.example.com:7102/em

DNS configuration not installed on system for dns visit link :  or use host IP address https://192.168.56.71:7102/em



STEP 11 : Login OEM console using ip address  user name is sysman
 


STEP 12 : OEM Console 


This information is also available at: 


/u01/app/oracle/middleware/install/setupinfo.txt


See the following for information pertaining to your Enterprise Manager installation:



Use the following URL to access:


1. Enterprise Manager Cloud Control URL: https://oem13c.example.com:7803/em

2. Admin Server URL: https://oem13c.example.com:7102/console

3. BI Publisher URL: https://oem13c.example.com:9803/xmlpserver/servlet/home


 https://192.168.56.71:7803/em

The following details need to be provided while installing an additional OMS:


1. Admin Server Host Name: oem13c.example.com

2. Admin Server Port: 7102


You can find the details on ports used by this deployment at : /u01/app/oracle/middleware/install/portlist.ini



 NOTE:

 An encryption key has been generated to encrypt sensitive data in the Management Repository. If this key is lost, all encrypted data in the Repository becomes unusable. 


 A backup of the OMS configuration is available in /u01/app/oracle/gc_inst/em/EMGC_OMS1/sysman/backup on host oem13c.example.com. See Cloud Control Administrators Guide for details on how to back up and recover an OMS.


 NOTE: This backup is valid only for the initial OMS configuration. For example, it will not reflect plug-ins installed later, topology changes like the addition of a load balancer, or changes to other properties made using emctl or emcli. Backups should be created on a regular basis to ensure they capture the current OMS configuration. Use the following command to backup the OMS configuration:

/u01/app/oracle/middleware/bin/emctl exportconfig oms -dir <backup dir> 



Posted by at No comments:
Labels:

EM13c - OMR Database minimum recommended parameters

  •  Create OMR database 

Database Name: OEMDB

Operating system : Linux OEL 7.7 64 bit

Database Version : 12.2.0.1.0

  • OMR database minimum recommended parameter values needs to be set before installing OEM 13c Console.

set "_allow_insert_with_update_check"=true

set session_cached_cursors=200

alter system set sga_target=800M 

set session_cached_cursors=200

[oracle@oem13c ~]$ ps -ef |grep pmon

oracle   17149     1  0 19:02 ?        00:00:00 ora_pmon_OEMDB

oracle   18459 17501  0 19:14 pts/3    00:00:00 grep --color=auto pmon

[oracle@oem13c ~]$ sqlplus / as sysdba


SQL*Plus: Release 12.2.0.1.0 Production on Tue Oct 20 19:14:34 2020


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

Connected to:

Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production


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 sga_target=800M scope=both;


System altered.


SQL> alter system set pga_aggregate_target=450M scope=both;


System altered.


SQL> shut immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup

ORACLE instance started.


Total System Global Area  838860800 bytes

Fixed Size                  8626240 bytes

Variable Size             461377472 bytes

Database Buffers          364904448 bytes

Redo Buffers                3952640 bytes

Database mounted.

Database opened.

  • Download OEM 13c binary from oracle.com

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

[oracle@oem13c oem]$ ll

total 9497096

-rwxrwxr-x. 1 oracle oinstall 1278491093 Oct 20 19:21 em13300_linux64-2.bin

-rwxrwxr-x. 1 oracle oinstall 1742204641 Oct 20 19:22 em13300_linux64-2.zip

-rwxrwxr-x. 1 oracle oinstall 2090882426 Oct 20 19:23 em13300_linux64-3.zip

-rwxrwxr-x. 1 oracle oinstall 2117436260 Oct 20 19:24 em13300_linux64-4.zip

-rwxrwxr-x. 1 oracle oinstall  694002559 Oct 20 19:24 em13300_linux64-5.zip

-rwxrwxr-x. 1 oracle oinstall 1801995711 Oct 20 19:25 em13300_linux64-6.zip

[oracle@oem13c oem]$ 

Posted by at No comments:
Labels:

OEM : Add OEM 12c express edition console on database



Database Name: SMRPATCH7 ( standalone test database )

Hostname :  srv1.example.com

Operating System : SUSE 12 SP5 64 bit 

Note: Even we have configured EM Express with on of on our live  RAC 2 node machine  using scan DNS name. Due to free licience issue we have to configure free oem express edition  on that database. 
  •  Login database and Check port configuration information for EM express edition console.

SQL> SELECT DBMS_XDB_CONFIG.gethttpport FROM dual;

GETHTTPPORT
-----------
          0
  • Configure EM express port. In our case we have provided 5500

SQL> EXEC DBMS_XDB_CONFIG.sethttpsport(5500);

PL/SQL procedure successfully completed.

  • Check EM configuration port.

SQL> SELECT DBMS_XDB_CONFIG.gethttpsport FROM dual;

GETHTTPSPORT
------------
        5500

  • Check dispatcher entry , in some database i have seen no entry on dispatchers so OEM console didn't run even configuring port.


SQL>
NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
dispatchers                          string      (PROTOCOL=TCP) (SERVICE=SMRPATCH7XDB)                      
max_dispatchers                      integer

  • You can add entry on pfile  or dynamically below.
*.dispatchers='(PROTOCOL=TCP) (SERVICE=SMRPATCH7XDB)'



alter system set dispatchers = '(address=(protocol=tcp)(host=srv1.example.com))(dispatchers=40)(service=SMRPATCH7)(listener=listener_name)';

  • Login EM express edition OEM console below.

https://srv1.example.com:5500/em/










Posted by at No comments:
Labels:
Subscribe to: Posts (Atom)