# == Class: oradb
#
class oradb ($shout = false) {

  if $::oradb::shout {
    notify {'oradb init.pp':}
  }


# set the tmpfs
mount { '/dev/shm':
  ensure      => present,
  atboot      => true,
  device      => 'tmpfs',
  fstype      => 'tmpfs',
  options     => 'size=3500m',
}

# Install DB software 12c
$puppet_download_mnt_point = "puppet:///modules/oradb/"

  oradb::installdb{ '12.1.0.2_Linux-x86-64':
  version                 => '12.1.0.1',
  file                    => 'linuxamd64_12102_database',
  database_type           => 'EE',
  oracle_base             => '/u01/app/oracle',
  oracle_home             => '/u01/app/oracle/product/12.1/db',
  bash_profile            => true,
  user                    => 'oracle',
  group                   => 'dba',
  group_install           => 'oinstall',
  group_oper              => 'oper',
  download_dir            => '/install',
  zip_extract             => true,
  puppet_download_mnt_point     => $puppet_download_mnt_point,
}

# DB Listener
db_listener{ 'startlistener':
  ensure          => 'running',  # running|start|abort|stop
  oracle_base_dir => '/u01/app/oracle',
  oracle_home_dir => '/u01/app/oracle/product/12.1/db',
  os_user         => 'oracle',
  listener_name   => 'listener' # which is the default and optional
}

oradb::database{ 'oraDb':
  oracle_base               => '/u01/app/oracle',
  oracle_home               => '/u01/app/oracle/product/12.1/db',
  version                   => '12.1',
  user                      => 'oracle',
  group                     => 'dba',
  template                  => 'dbtemplate_12.1',
  download_dir              => '/install',
  action                    => 'create',
  db_name                   => 'orcl',
  db_domain                 => 'local',
  sys_password              => 'oracle99',
  system_password           => 'oracle99',
  character_set             => 'AL32UTF8',
  nationalcharacter_set     => 'UTF8',
  sample_schema             => 'FALSE',
  memory_percentage         => '40',
  memory_total              => '800',
  database_type             => 'MULTIPURPOSE',
  em_configuration          => 'NONE',
  data_file_destination     => '/u01/oradata',
  recovery_area_destination => '/u01/flash_recovery_area',
  init_params               => {'open_cursors'        => '1000',
                                'processes'           => '600',
                                'job_queue_processes' => '4' },
  container_database        => true,
}

oradb::database_pluggable{'pdb1':
  ensure                   => 'present',
  version                  => '12.1',
  oracle_home_dir          => '/u01/app/oracle/product/12.1/db',
  user                     => 'oracle',
  group                    => 'dba',
  source_db                => 'orcl',
  pdb_name                 => 'pdb1',
  pdb_admin_username       => 'pdb_adm',
  pdb_admin_password       => 'oracle99',
  pdb_datafile_destination => "/u01/oradata/orcl/pdb1",
  create_user_tablespace   => true,
  log_output               => true,
}

}