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]$