Release notes

DMK_DBCREATE-release_notes

#################
# Release Notes #
#################

[planned dmk dbcreate 2.0.0]
  [Fixes]
  - #57 Updated SourceEnv function
  - #52 Updated File Header, Footer and Email
  - #35 hardening in dbi service best practices

[dmk_dbcreate 22-01]
  [Enhancements]
  - #48 Display generated dbca command in debug mode
  
[dmk_dbcreate 21-02]
  [Fixes]
  - #37 Fixed wrong controlfile path in init.ora
  - #32 PDB's are now added in /etc/oratab
    
  [Enhancements]
  - #39 Allow more dbca variables, e.g. DATA_4 in the config file to replace in the template file;
    variable names are now dynamically read from the config file.
  - #36 Modified to allow silent run with ansible:
    - added new switch -silent / environment variable DBCREATE_SILENT
    - replaced oracle password prompts by random generated passwords
  - #31 Added new field PDB_NAMES in configuration files $DMK_DBCREATE/etc/*.cfg to allow custom named PDB's

[dmk_dbcreate 20-02]
  [Fixes]
  - Fixed hardcoded release number
  - Fixed default oracle 18 template not found by fixing wrong oracle version (output of 'sqlplus -v' changed in Oracle >= 18)
    In addition now an error message with the full template path is displayed, if the template file cannot be found.
  - Fixed minor formatting issues of display messages and added more comment lines in generates files

  [Enhancements]
  - Modified DMK_DBcreate to support Oracle 19
  - At the end of database creation added display of "please check the logfiles under ..."
  - Changed DBCA templates ${DMK_DBCREATE}/templates/dbca/database/*.dbt and related code as follows:
    - Disabled autoextend for undotbs1 and moved undotbs1 settings into the DBCA template files
    - Moved oracle parameters archive_lag_target, audit_trail, control_file_record_keep_time, db_files into the DBCA templates files
    - Added Template Version 19-09 in header of all DBCA templates
    - Added automatic upgrade of DBCA templates from previous version
  - Added new parameter AUDIT_RETENTION_DAYS with default 31 to all database templates ${DMK_DBCREATE}/etc/*.cfg
    and modified related scripts accordingly to use this parameter to create a database job for purging audit data
  - Added support for Oracle Unified Auditing:
    - dmk_dbcreate.pl now validates if oracle is linked with unified auditing or not
    - Audit policies ORA_SECURECONFIG and ORA_LOGON_FAILURES are activated
    - Create audit cleanup dbms_scheduler job, which also loads spillover audit files
    - Display of active audit policies and audit retention for purge jobs
  - Added workaround against excessive SM/ADVISOR UNDO tablespace growth (Doc ID 2305512.1, Doc ID 2439129.1) by changing the UNLIMITED retention to 30 days
  - Added directories $DMK_DBCREATE/templates/dbca/database, $DMK_DBBCREATE/etc as search path for custom DBCA templates

[dmk_dbcreate 19-04]
  [Fixes]
  - Package has been cleaned by removing existing DB3.rsp response file
  - db_recovery_file_dest_size default value has been updated from 8129 to 8192 in the template
  - Support email address has been updated in the documentation
  - dmk_rman.pl has been replaced in the debugging message by correct dmk_dbcreate.pl script name

  [Enhancements]
  - Documentation has been updated for user to ensure that DMK is sourced on the correct ORACLE_HOME before creating the database
  - AMM parameters (memory_max_target and memory_target) have been removed and ASMM parameters (sga_target, sga_max_size and pga_aggregate_target) have been added from ORACLE 11g database templates
  - Specific templates for ORACLE 12.2 have been created in order to be able to use new features
  - Audit trail has been moved to SYSAUX for all databases starting 11.2.0.4
  - A new function using a new optional command line parameter (“-p”) has been developed in order to be able to pass a script to be executed at the end of the database creation
  - Post settings script (dbi_best_practices_post_db_creation.sql ) has been reviewed and refreshed
  - New templates have been created for Oracle 18c
  - For Oracle 19c simply copy the dbca 18c templates and adapt the necessary parameters

[dmk_dbcreate 20-07]
  [Fixes]
  - SPFILE softlink BestPractice ran twice once over dbi_best_practices_post_db_creation.sql and once over postCreation.sql
  [Enhancements]
  - hardcoded DBCA variables for OFA folders have been lifted