Create the OEM Repository Database 

Notes: 

• Database oemdb is created via dbca 

• Non-CDB database is created (PDB is also supported for repository database) 

• Redo Log file size should be minimum 300 MB 

• After database is created, ensure parameters are changed to support an OEM 13.4 installation

• Database is converted to run in NOARCHIVELOG mode while OEM installation and configuration is in progress 

• Enable ARCHIVELOG mode once OEM 13.4 installation and configuration is completed.D:\oracle\product\19.0.0\dbhome_1\bin>sqlplus sys as sysdba   Connected to: 

  Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 – Production 

  Version 19.7.0.0.0 

   

  SQL> alter system set “_optimizer_nlj_hj_adaptive_join”= FALSE scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set “_optimizer_strans_adaptive_pruning” = FALSE scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set “_px_adaptive_dist_method” = OFF scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set “_sql_plan_directive_mgmt_control” = 0 scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set “_optimizer_dsdir_usage_control” = 0 scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set “_optimizer_use_feedback” = FALSE scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set “_optimizer_gather_feedback” = FALSE scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set “_optimizer_performance_feedback” = OFF scope=both sid=’*’; 

   

  System altered. 

   

  SQL> alter system set shared_pool_size=800M scope=spfile; 

   

  System altered. 

   

  SQL> alter system set processes=600 scope=spfile; 

   

  System altered. 

   

  SQL> alter system set session_cached_cursors=200 scope=spfile; 

   

  System altered. 

   

  SQL> alter system set “_allow_insert_with_update_check”=true scope=both; 

   

  System altered. 

   

   

   

  SQL> shutdown immediate; 

  Database closed. 

  Database dismounted. 

  ORACLE instance shut down. 

   

  SQL> startup mount; 

  ORACLE instance started. 

   

  Total System Global Area 4294964032 bytes 

  Fixed Size                  9036608 bytes 

  Variable Size             855638016 bytes 

  Database Buffers         3422552064 bytes 

  Redo Buffers                7737344 bytes 

  Database mounted. 

   

  SQL> alter database noarchivelog; 

   

  Database altered. 

   

  SQL> alter database open; 

   

  Database altered.