scripts/puppet4ccb/neals_playground/site_empty.pp

#
# puppet apply /vagrant/site_empty.pp --verbose --modulepath /vagrant/modules --hiera_config /vagrant/hiera.yaml --debug
#
# puppet parser validate /vagrant/site_empty.pp
#

  Package{ 
    allow_virtual  => false
  }

  node default {
     hiera_include('classes')
  }
	 
 # class patching_order {
 #   Class['fmw_opatch::weblogic'] ->
#	  Class['fmw_opatch::soa_suite'] ->
#	    Class['fmw_rcu::soa_suite'] ->
#		  Class['fmw_domain::domain']
 # }

  class domain_extensions_order {
    Class['fmw_domain::extension_soa_suite'] ->
	  Class['fmw_domain::extension_service_bus'] ->
	    Class['fmw_domain::extension_bam'] ->
		  Class['fmw_domain::extension_enterprise_schedular'] ->
		    Class['fmw_domain::nodemanager']
  }
  
  class wcdb_os {
  
  
    # file { '/u01/ouaf':
    # ensure => 'directory',
    # owner  => 'applmgr',
    # group  => 'applgrp',
    # mode   => '0644',
  # }
  # ##Add packages for fmw install
  # exec { "yum -y install glibc.i686":
    # path   => ['/usr/bin'],
    # unless => "rpm -q $packagename",
  # }
  
  
  # #Add packages for db install
  # exec { "yum -y install glibc.i686 binutils.x86_64 compat-libstdc++-33.x86_64 glibc.x86_64 ksh.x86_64 libaio.x86_64 libgcc.x86_64 libstdc++.x86_64 make.x86_64 compat-libcap1.x86_64 gcc.x86_64 gcc-c++.x86_64 glibc-devel.x86_64 libaio-devel.x86_64 libstdc++-devel.x86_64 sysstat.x86_64 unixODBC-devel glibc.i686 libXext.i686 libXtst.i686":
    # path   => ['/usr/bin'],
    # unless => "rpm -q $packagename",
  # }
  # package { "$packagename":
    # ensure => installed,
 # }
 
 exec { "yum -y update":
 command => 'yum -y update',
 path   => ['/usr/bin'],
 logoutput => 'on_failure',
  timeout     => 1800,
 }
 
    $install = [ 'binutils.x86_64', 'compat-libstdc++-33.x86_64', 'glibc.x86_64','ksh.x86_64','libaio.x86_64',
               'libgcc.x86_64', 'libstdc++.x86_64', 'make.x86_64','compat-libcap1.x86_64', 'gcc.x86_64',
               'gcc-c++.x86_64','glibc-devel.x86_64','libaio-devel.x86_64','libstdc++-devel.x86_64',
               'sysstat.x86_64','unixODBC-devel','glibc.i686','libXext.i686','libXtst.i686']
       

  package { $install:
    ensure  => present,
  }
  
  service { iptables:
        enable    => false,
        ensure    => false,
        hasstatus => true,
  }

  $groups = ['oinstall','dba' ,'oper' ]

  group { $groups :
    ensure      => present,
  }

  user { 'oracle' :
    ensure      => present,
    uid         => 500,
    gid         => 'oinstall',  
    groups      => $groups,
    shell       => '/bin/bash',
    password    => '$1$DSJ51vh6$4XzzwyIOk6Bi/54kglGk3.',
    home        => "/home/oracle",
    comment     => "This user oracle was created by Puppet",
    require     => Group[$groups],
    managehome  => true,
  }

  

  
   # class { 'limits':
         # config => {
                    # '*'       => { 'nofile'  => { soft => '2048'   , hard => '8192',   },},
                    # 'oracle'  => { 'nofile'  => { soft => '65536'  , hard => '65536',  },
                                    # 'nproc'  => { soft => '2048'   , hard => '16384',  },
                                    # 'stack'  => { soft => '10240'  ,},},
                    # },
         # use_hiera => false,
    # }
 
  # sysctl { 'kernel.msgmnb':                 ensure => 'present', permanent => 'yes', value => '65536',}
  # sysctl { 'kernel.msgmax':                 ensure => 'present', permanent => 'yes', value => '65536',}
  # sysctl { 'kernel.shmmax':                 ensure => 'present', permanent => 'yes', value => '2588483584',}
  # sysctl { 'kernel.shmall':                 ensure => 'present', permanent => 'yes', value => '2097152',}
  # sysctl { 'fs.file-max':                   ensure => 'present', permanent => 'yes', value => '6815744',}
  # sysctl { 'net.ipv4.tcp_keepalive_time':   ensure => 'present', permanent => 'yes', value => '1800',}
  # sysctl { 'net.ipv4.tcp_keepalive_intvl':  ensure => 'present', permanent => 'yes', value => '30',}
  # sysctl { 'net.ipv4.tcp_keepalive_probes': ensure => 'present', permanent => 'yes', value => '5',}
  # sysctl { 'net.ipv4.tcp_fin_timeout':      ensure => 'present', permanent => 'yes', value => '30',}
  # sysctl { 'kernel.shmmni':                 ensure => 'present', permanent => 'yes', value => '4096', }
  # sysctl { 'fs.aio-max-nr':                 ensure => 'present', permanent => 'yes', value => '1048576',}
  # sysctl { 'kernel.sem':                    ensure => 'present', permanent => 'yes', value => '250 32000 100 128',}
  # sysctl { 'net.ipv4.ip_local_port_range':  ensure => 'present', permanent => 'yes', value => '9000 65500',}
  # sysctl { 'net.core.rmem_default':         ensure => 'present', permanent => 'yes', value => '262144',}
  # sysctl { 'net.core.rmem_max':             ensure => 'present', permanent => 'yes', value => '4194304', }
  # sysctl { 'net.core.wmem_default':         ensure => 'present', permanent => 'yes', value => '262144',}
  # sysctl { 'net.core.wmem_max':             ensure => 'present', permanent => 'yes', value => '1048576',}

}

class wcdb_11g {
  require wcdb_os

    oradb::installdb{ '11.2_linux-x64':
            version                => '11.2.0.4',
            file                   => 'p13390677_112040_Linux-x86-64',
            databaseType           => 'SE',
            oracleBase             => hiera('oracle_base_dir'),
            oracleHome             => hiera('oracle_home_dir'),
            userBaseDir            => '/home',
            createUser             => false,
            user                   => 'oracle',
            group                  => 'dba',
            group_install          => 'oinstall',
            group_oper             => 'oper',
            downloadDir            => hiera('oracle_download_dir'),
            remoteFile             => false,
            puppetDownloadMntPoint => hiera('oracle_source'),  
    }

   oradb::net{ 'config net8':
            oracleHome   => hiera('oracle_home_dir'),
            version      => hiera('oracle_version'),
            user         => hiera('oracle_os_user'),
            group        => hiera('oracle_os_group'),
            downloadDir  => hiera('oracle_download_dir'),
            require      => Oradb::Installdb['11.2_linux-x64'],
   }

   oradb::listener{'start listener':
            oracleBase   => hiera('oracle_base_dir'),
            oracleHome   => hiera('oracle_home_dir'),
            user         => hiera('oracle_os_user'),
            group        => hiera('oracle_os_group'),
            action       => 'start',  
            require      => Oradb::Net['config net8'],
   }

   oradb::database{ 'wcDb': 
                    oracleBase              => hiera('oracle_base_dir'),
                    oracleHome              => hiera('oracle_home_dir'),
                    version                 => hiera('oracle_version'),
                    user                    => hiera('oracle_os_user'),
                    group                   => hiera('oracle_os_group'),
                    downloadDir             => hiera('oracle_download_dir'),
                    action                  => 'create',
                    dbName                  => hiera('oracle_database_name'),
                    dbDomain                => hiera('oracle_database_domain_name'),
                    sysPassword             => hiera('oracle_database_sys_password'),
                    systemPassword          => hiera('oracle_database_system_password'),
                    dataFileDestination     => "/oracle/oradata",
                    recoveryAreaDestination => "/oracle/flash_recovery_area",
                    characterSet            => "AL32UTF8",
                    nationalCharacterSet    => "UTF8",
                    initParams              => "open_cursors=1000,processes=600,job_queue_processes=4",
                    sampleSchema            => 'FALSE',
                    memoryPercentage        => "40",
                    memoryTotal             => "800",
                    databaseType            => "MULTIPURPOSE",                         
                    require                 => Oradb::Listener['start listener'],
   }

   oradb::dbactions{ 'start wcDb': 
                   oracleHome              => hiera('oracle_home_dir'),
                   user                    => hiera('oracle_os_user'),
                   group                   => hiera('oracle_os_group'),
                   action                  => 'start',
                   dbName                  => hiera('oracle_database_name'),
                   require                 => Oradb::Database['wcDb'],
   }

   oradb::autostartdatabase{ 'autostart oracle': 
                   oracleHome              => hiera('oracle_home_dir'),
                   user                    => hiera('oracle_os_user'),
                   dbName                  => hiera('oracle_database_name'),
                   require                 => Oradb::Dbactions['start wcDb'],
   }

   oradb::rcu{ 'DEV':
                    rcuFile                => 'ofm_rcu_linux_11.1.1.8.0_64_disk1_1of1.zip',
                    version                => '11.1.1.8',
                    product                => 'webcenter',
                    oracleHome             => hiera('oracle_home_dir'),
                    user                   => hiera('oracle_os_user'),
                    group                  => hiera('oracle_os_group'),
                    downloadDir            => hiera('oracle_download_dir'),
                    action                 => 'create',
                    dbServer               => 'admin.example.com:1521',  
                    dbService              => hiera('oracle_database_service_name'),
                    sysPassword            => hiera('oracle_database_sys_password'),
                    schemaPrefix           => 'DEV',
                    reposPassword          => hiera('oracle_database_rcu_password'),
                    tempTablespace         => 'TEMP',
                    puppetDownloadMntPoint => hiera('rcu_source'),
                    remoteFile             => false,
                    logoutput              => true, 
                    require                => Oradb::Dbactions['start wcDb'],
   }

}