database::db definition

Overview

This class contains the actual database definition using the ora_database type. Here you can customize some of the attributes of your database.

When these customizations aren’t enough, you can replace the class with your own class. See ora_profile::database for an explanation on how to do this.

Attributes

version

The version of Oracle you want to install.

The default is : 19.0.0.0

To customize this consistently use the hiera key ora_profile::database::version.

Type: Ora_Install::Version

Back to overview of database::db_definition

oracle_home

The home directory to use for the Oracle installation.

The default is : /u01/app/oracle/product/#{version}/db_home1

To customize this consistently use the hiera key ora_profile::database::oracle_home.

Type: Stdlib::Absolutepath

Back to overview of database::db_definition

oracle_base

The base directory to use for the Oracle installation.

The default is : /u01/app/oracle

To customize this consistently use the hiera key ora_profile::database::install_group.

Type: Stdlib::Absolutepath

Back to overview of database::db_definition

os_user

The OS user to use for Oracle install.

The default is : oracle

To customize this consistently use the hiera key ora_profile::database::os_user.

Type: String[1]

Back to overview of database::db_definition

install_group

The group to use for Oracle install.

The default is : oinstall

To customize this consistently use the hiera key ora_profile::database::install_group.

Type: String[1]

Back to overview of database::db_definition

dbname

The name of the database.

The default is DB01

To customize this consistently use the hiera key ora_profile::database::dbname.

This parameter can also be defined as Hash in which case the key(s) of the Hash are the name of the database(s). The defaults for all the database(s) in the Hash are the ones given to the db_definition class. In addition all properties and parameters taken by ora_database can be defined in hiera data.

Type: Variant[String[1],Hash]

Back to overview of database::db_definition

log_size

The log ize to use.

The default is : 100M Type: String[1]

Back to overview of database::db_definition

user_tablespace_size

The size for the USER tablespace.

The default value is 50M Type: String[1]

Back to overview of database::db_definition

system_tablespace_size

The size for the SYSTEM tablespace.

The default value is 50M Type: String[1]

Back to overview of database::db_definition

temporary_tablespace_size

The size for the TEMP tablespace.

The default value is 50M

Type: String[1]

Back to overview of database::db_definition

undo_tablespace_size

The size for the UNDO tablespace.

The default value is 50M Type: String[1]

Back to overview of database::db_definition

sysaux_tablespace_size

The size for the SYSAUX tablespace.

The default value is 50M Type: String[1]

Back to overview of database::db_definition

system_password

The system password to use for the database.

The default value is: Welcome01 Type: Easy_type::Password

Back to overview of database::db_definition

sys_password

The sys password to use for the database.

The default value is: Change_on_1nstall Type: Easy_type::Password

Back to overview of database::db_definition

container_database

Database is a container for pluggable databases. When you want to add pluggable database to this database, specify a value of enabled.

The default value is: disabled

Type: Enum['enabled','disabled']

Back to overview of database::db_definition

archivelog

The database should be running in archivelog mode.

Type: Enum['enabled','disabled']

Back to overview of database::db_definition

init_ora_template

The template to use for the init.ora parameters. This needs to be an epp template.

The default value is: ‘ora_profile/init.ora.epp’ Type: String[1]

Back to overview of database::db_definition

init_ora_params

The parameters to use in the template specified in init_ora_template.

The default value is:

ora_profile::database::db_definition::init_ora_params:
  dbname: "%{lookup('ora_profile::database::db_definition::dbname')}"
  dbdomain: "%{lookup('ora_profile::database::db_definition::dbdomain')}"
  db_create_file_dest: "%{lookup('ora_profile::database::db_definition::data_file_destination')}"
  db_recovery_file_dest: "%{lookup('ora_profile::database::db_definition::db_recovery_file_dest')}"
  db_recovery_file_dest_size: 20480m
  compatible: "%{lookup('ora_profile::database::db_definition::version')}"
  oracle_base: "%{lookup('ora_profile::database::db_definition::oracle_base')}"
  container_database: "%{lookup('ora_profile::database::db_definition::container_database')}"
  sga_target: 1024m
  pga_aggregate_target: 256m
  processes: 300
  open_cursors: 300
  db_block_size: 8192
  log_archive_format: '%t_%s_%r.dbf'
  audit_trail: db
  remote_login_passwordfile: EXCLUSIVE
  undo_tablespace: UNDOTBS1
  memory_target: 0
  memory_max_target: 0

Type: Hash

Back to overview of database::db_definition

data_file_destination

The location of the datafiles.

Type: String[1]

Back to overview of database::db_definition

db_recovery_file_dest

The location of the Flash Recovery Area.

Type: String[1]

Back to overview of database::db_definition

ora_database_override

A hash with database settings that will override the default database settings.

Type: Hash

Back to overview of database::db_definition

dbdomain

The domain of the database.

The default is $facts['networking']['domain']

Type: Optional[String[1]]

Back to overview of database::db_definition

logoutput

log the outputs of Puppet® exec or not.

When you specify true Puppet® will log all output of exec types.

Valid values are:

• true
• false
• on_failure

Type: lint:ignore:manifest_whitespace_opening_brace_beforeVariant[Boolean,Enum['on_failure']]

Default:lookup({ name => 'logoutput', default_value => 'on_failure' })

Back to overview of database::db_definition

options

The options that need to be installed in the database. Default value: []

Valid values are:

• OWM
• JServer
• CTX
• ORD
• IM
• OLAP
• SDO
• OLS
• Sample
• APEX
• DV

The default value is []

Type: Array[Enum['OWM','JServer','CTX','ORD','IM','OLAP','SDO','OLS','Sample','APEX','DV']]

Back to overview of database::db_definition