Forge Home

oradb

Oracle Database 11g R2 11.2.0.3 linux

260,008 downloads

16,586 latest version

0.4 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Version information

  • 3.0.19 (latest)
  • 3.0.18
  • 3.0.17
  • 3.0.16 (deleted)
  • 3.0.15
  • 3.0.14
  • 3.0.13
  • 3.0.12
  • 3.0.11
  • 3.0.10
  • 3.0.9
  • 3.0.8
  • 3.0.7
  • 3.0.6
  • 3.0.5
  • 3.0.4
  • 3.0.3
  • 3.0.2
  • 3.0.1
  • 3.0.0
  • 2.0.10
  • 2.0.9
  • 2.0.8
  • 2.0.7
  • 2.0.6
  • 2.0.5
  • 2.0.4
  • 2.0.3
  • 2.0.2
  • 2.0.1
  • 2.0.0
  • 1.0.35
  • 1.0.34
  • 1.0.33
  • 1.0.32
  • 1.0.31
  • 1.0.30
  • 1.0.29
  • 1.0.28
  • 1.0.27
  • 1.0.26
  • 1.0.25
  • 1.0.24
  • 1.0.23
  • 1.0.22
  • 1.0.21
  • 1.0.20
  • 1.0.19
  • 1.0.18
  • 1.0.17
  • 1.0.16
  • 1.0.15
  • 1.0.14
  • 1.0.13
  • 1.0.12
  • 1.0.11
  • 1.0.10
  • 1.0.9
  • 1.0.8
  • 1.0.7
  • 1.0.6
  • 1.0.5
  • 1.0.4
  • 1.0.3
  • 1.0.2
  • 1.0.1
  • 1.0.0
  • 0.9.9
  • 0.9.8
  • 0.9.7
  • 0.9.6
  • 0.9.5
  • 0.9.4
  • 0.9.3
  • 0.9.1
  • 0.9.0
  • 0.8.9
  • 0.8.8
  • 0.8.7
  • 0.8.5
  • 0.8.3
  • 0.8.2
  • 0.8.1
  • 0.8.0
  • 0.7.9
  • 0.7.8
  • 0.7.7
  • 0.7.6
  • 0.7.5
  • 0.7.4
  • 0.7.3
  • 0.7.2
  • 0.7.0
  • 0.6.1
  • 0.6.0
  • 0.5.0
  • 0.4.0
  • 0.3.0
  • 0.2.0
  • 0.1.2
  • 0.1.1
  • 0.1.0
released Mar 9th 2013

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'biemond-oradb', '0.1.2'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add biemond-oradb
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install biemond-oradb --version 0.1.2

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download

Documentation

biemond/oradb — version 0.1.2 Mar 9th 2013

Oracle Database Linux puppet module

created by Edwin Biemond
biemond.blogspot.com
Github homepage

Should work for RedHat,CentOS ,Ubuntu, Debian or OracleLinux should work without any problems

Oracle Database Features

  • installs oracle database 11.2.0.3

Coming in next release

  • Create database instances
  • Apply OPatch

Files

Download oracle database software from support.oracle.com
Patch 10404530: 11.2.0.3.0 PATCH SET FOR ORACLE DATABASE SERVER
and upload this to the files folder of the oradb puppet module

1358454646 Mar 9 17:31 p10404530_112030_Linux-x86-64_1of7.zip
1142195302 Mar 9 17:47 p10404530_112030_Linux-x86-64_2of7.zip
979195792 Mar 9 18:01 p10404530_112030_Linux-x86-64_3of7.zip
659229728 Mar 9 18:11 p10404530_112030_Linux-x86-64_4of7.zip
616473105 Mar 9 18:19 p10404530_112030_Linux-x86-64_5of7.zip
479890040 Mar 9 18:26 p10404530_112030_Linux-x86-64_6of7.zip
113915106 Mar 9 18:28 p10404530_112030_Linux-x86-64_7of7.zip

important support nodes [ID 1441282.1] Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64)
[ID 454196.1] ./sqlplus: error on libnnz11.so: cannot restore segment prot after reloc
[ID 1454982.1] Installing 11.2.0.3 32-bit (x86) or 64-bit (x86-64) on RHEL6 Reports That Packages "elfutils-libelf-devel-0.97" and "pdksh-5.2.14" are missing (PRVF-7532)

templates.pp

The databaseType value should contain only one of these choices.

  • EE : Enterprise Edition

  • SE : Standard Edition

  • SEONE : Standard Edition One

    class { 'oradb::installdb':
          file         => 'p10404530_112030_Linux-x86-64',
          databaseType => 'SE',
          oracleBase   => '/oracle',
          oracleHome   => '/oracle/product/11.2/db',
          user         => 'oracle',
          group        => 'dba',
          downloadDir  => '/install/',  
    }
    

site.pp

install the following module to set the database kernel parameters
puppet module install fiddyspence-sysctl

install the following module to set the database user limits parameters puppet module install erwbgy-limits

 node database {
 
   # Controls the default maxmimum size of a mesage queue
   sysctl { 'kernel.msgmnb':
     ensure    => 'present',
     permanent => 'yes',
     value     => '65536',
   }
 
   # Controls the maximum size of a message, in bytes
   sysctl { 'kernel.msgmax':
     ensure    => 'present',
     permanent => 'yes',
     value     => '65536',
   }
 
   # Controls the maximum number of shared memory segments, in pages
   sysctl { 'kernel.shmmax':
     ensure    => 'present',
     permanent => 'yes',
     value     => '2147483648',
   }
 
   # Controls the maximum shared segment size, in bytes
   sysctl { 'kernel.shmall':
     ensure    => 'present',
     permanent => 'yes',
     value     => '2097152',
   }
 
   sysctl { 'fs.file-max':
     ensure    => 'present',
     permanent => 'yes',
     value     => '6815744',
   }
 
   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',
   }
 
 
   # The interval between the last data packet sent (simple ACKs are not considered data) and the first keepalive probe
   sysctl { 'net.ipv4.tcp_keepalive_time':
     ensure    => 'present',
     permanent => 'yes',
     value     => '1800',
   }
 
   # The interval between subsequential keepalive probes, regardless of what the connection has exchanged in the meantime
   sysctl { 'net.ipv4.tcp_keepalive_intvl':
     ensure    => 'present',
     permanent => 'yes',
     value     => '30',
   }
 
   # The number of unacknowledged probes to send before considering the connection dead and notifying the application layer
   sysctl { 'net.ipv4.tcp_keepalive_probes':
     ensure    => 'present',
     permanent => 'yes',
     value     => '5',
   }
 
   # The time that must elapse before TCP/IP can release a closed connection and reuse its resources. During this TIME_WAIT state, reopening the connection to the client costs less than establishing a new connection. By reducing the value of this entry, TCP/IP can release closed connections faster, making more resources available for new connections.
   sysctl { 'net.ipv4.tcp_fin_timeout':
     ensure    => 'present',
     permanent => 'yes',
     value     => '30',
   }
 
   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 { 'limits':
     config => {
                '*'        => { 'nofile'  => { soft => '2048'   , hard => '8192',   },
                              },
                '@oracle'  => { 'nofile'  => { soft => '1024'   , hard => '65536',  },
                                'nproc'   => { soft => '2048'   , hard => '16384',   },
                                'stack'   => { soft => '10240'  ,},
                              },
                },
     use_hiera => false,
   }
 
 
   package { 'binutils.x86_64':
     ensure  => present,
   }
 
   package { 'compat-libstdc++-33.x86_64':
     ensure  => present,
   }
 
   package { 'glibc.x86_64':
     ensure  => present,
   }
   package { 'ksh.x86_64':
     ensure  => present,
   }
 
   package { 'libaio.x86_64':
     ensure  => present,
   }
 
   package { 'libgcc.x86_64':
     ensure  => present,
   }
 
   package { 'libstdc++.x86_64':
     ensure  => present,
   }
 
   package { 'make.x86_64':
     ensure  => present,
   }
 
   package { 'compat-libcap1.x86_64':
     ensure  => present,
   }
 
   package { 'gcc.x86_64':
     ensure  => present,
   }
   package { 'gcc-c++.x86_64':
     ensure  => present,
   }
 
   package { 'glibc-devel.x86_64':
     ensure  => present,
   }
 
   package { 'libaio-devel.x86_64':
     ensure  => present,
   }
 
   package { 'libstdc++-devel.x86_64':
     ensure  => present,
   }
 
   package { 'sysstat.x86_64':
     ensure  => present,
   }
 
 
 }
 
 node 'dbagent1.alfa.local' inherits database {
 }