Oracle OEM 13.5 Installation on Windows Setup
Channel: Database Guy
Date: 2024-04-07

Timeline

00:00 Overview
03:15 Install Visual C++ Redistributable
06:40 Download Oracle 19c Database home & OEM 13.5
10:10 Pre-requisites for Oracle 19c Database Home 
15:40 Set Environment Variables
17:40 Install Oracle 19c Database Home 
19:27 Create Listener
21:30 Create Database for OEM Repository
26:48 Listener Static Registration
28:15 Database Configuration for OEM
30:00 Install OEM
42:20 Login OEM
43:40 Stop OEM (Optional)  

Database Config Steps for OEM Database

#--- Configure Database parameters to support OEM

sqlplus / as sysdba

ALTER SYSTEM SET LOCAL_LISTENER='OEM:1521'              SCOPE=BOTH;
ALTER SYSTEM SET "_allow_insert_with_update_check"=true SCOPE=BOTH;
ALTER SYSTEM SET shared_pool_size=600M                  SCOPE=BOTH;
ALTER SYSTEM SET parallel_max_servers=8                 SCOPE=BOTH; 
ALTER SYSTEM SET parallel_min_servers=0                 SCOPE=BOTH; 
ALTER SYSTEM SET session_cached_cursors=200             SCOPE=SPFILE;
ALTER SYSTEM SET processes=300                          SCOPE=SPFILE;

execute dbms_auto_task_admin.disable('auto optimizer stats collection',null,null);

SHUT IMMEDIATE;
STARTUP;