Forge Home

oradb

Oracle Database 11g R2 11.2 linux

259,960 downloads

16,585 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 17th 2013

Start using this module

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

Add this module to your Puppetfile:

mod 'biemond-oradb', '0.5.0'
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.5.0

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.5.0 Mar 17th 2013

Oracle Database Linux puppet module

created by Edwin Biemond
biemond.blogspot.com
Github homepage

Should work for RedHat,CentOS ,Ubuntu, Debian or OracleLinux

Oracle Database Features

  • Oracle Database 11.2.0.3 Linux installation
  • Oracle Database 11.2.0.1 Linux installation
  • Oracle Database Net configuration
  • Oracle Database Listener
  • Apply OPatch
  • Create database instances
  • Stop/Start database instances

Coming in next release

  • Oracle Database 11.2.0.1 Linux Client installation

Files

For 11.2.0.3 Download oracle database linux software from http://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

For 11.2.0.1 Download oracle database linux software from http://otn.oracle.com

database files of linux 11.2.0.3 ( support.oracle.com )

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

database files of linux 11.2.0.1 ( otn.oracle.com )

1239269270 Mar 10 17:05 linux.x64_11gR2_database_1of2.zip
1111416131 Mar 10 17:17 linux.x64_11gR2_database_2of2.zip

opatch database patch

25556377 Mar 10 12:48 p14727310_112030_Linux-x86-64.zip

patches opatch for 11.2.0.3

32551315 Mar 10 13:10 p6880880_112000_Linux-x86-64.zip

database client linux 11.2.0.1 ( otn.oracle.com )

706187979 Mar 10 16:48 linux.x64_11gR2_client.zip

important support node [ID 1441282.1] Requirements for Installing Oracle 11gR2 RDBMS on RHEL6 or OL6 64-bit (x86-64)

Oracle Database Facter

Contains Oracle Facter which displays the following

  • Oracle Software
  • Opatch patches

Example of the Oracle Database Facts

ora_inst_loc_data /oracle/oraInventory
ora_inst_patches_oracle_product_11.2_db Patches;14727310;
ora_inst_products /oracle/product/11.2/db;

templates.pp

The databaseType value should contain only one of these choices.

  • EE : Enterprise Edition

  • SE : Standard Edition

  • SEONE : Standard Edition One

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

or

oradb::installdb{ '112010_Linux-x86-64':
        version      => '11.2.0.1', 
        file         => 'linux.x64_11gR2_database',
        databaseType => 'SE',
        oracleBase   => '/oracle',
        oracleHome   => '/oracle/product/11.2/db',
        user         => 'oracle',
        group        => 'dba',
        downloadDir  => '/install/',  
 }

other

 # for this example OPatch 14727310
 # the OPatch utility must be upgraded ( patch 6880880)
 # after that 'cd $ORACLE_HOME/OPatch' and run 'ocm/bin/emocmrsp'
 oradb::opatch{'14727310_db_patch':
   oracleProductHome => '/oracle/product/11.2/db' ,
   patchId           => '14727310', 
   patchFile         => 'p14727310_112030_Linux-x86-64.zip',  
   user              => 'oracle',
   group             => 'dba',
   downloadDir       => '/install/',
   ocmrf             => 'true',   
   require           => Oradb::Installdb['112030_Linux-x86-64'],
 }

 oradb::net{ 'config net8':
        oracleHome   => '/oracle/product/11.2/db',
        user         => 'oracle',
        group        => 'dba',
        downloadDir  => '/install/',
        require      => Oradb::Opatch['14727310_db_patch'],
 }



 oradb::listener{'stop listener':
        oracleBase   => '/oracle',
        oracleHome   => '/oracle/product/11.2/db',
        user         => 'oracle',
        group        => 'dba',
        action       => 'start',  
        require      => Oradb::Net['config net8'],
 }


 oradb::listener{'start listener':
        oracleBase   => '/oracle',
        oracleHome   => '/oracle/product/11.2/db',
        user         => 'oracle',
        group        => 'dba',
        action       => 'start',  
        require      => Oradb::Listener['stop listener'],
 }


 oradb::database{ 'testDb_Create': 
                  oracleBase              => '/oracle',
                  oracleHome              => '/oracle/product/11.2/db',
                  user                    => 'oracle',
                  group                   => 'dba',
                  downloadDir             => '/install/',
                  action                  => 'create',
                  dbName                  => 'test',
                  dbDomain                => 'oracle.com',
                  sysPassword             => 'Welcome01',
                  systemPassword          => 'Welcome01',
                  dataFileDestination     => "/oracle/oradata",
                  recoveryAreaDestination => "/oracle/flash_recovery_area",
                  characterSet            => "AL32UTF8",
                  nationalCharacterSet    => "UTF8",
                  initParams              => "open_cursors=1000,processes=600,job_queue_processes=4,compatible=11.2.0.0.0",
                  sampleSchema            => 'TRUE',
                  memoryPercentage        => "40",
                  memoryTotal             => "800",
                  databaseType            => "MULTIPURPOSE",                         
                  require                 => Oradb::Listener['start listener'],
 }

oradb::dbactions{ 'stop testDb': 
                 oracleHome              => '/oracle/product/11.2/db',
                 user                    => 'oracle',
                 group                   => 'dba',
                 action                  => 'stop',
                 dbName                  => 'test',
                 require                 => Oradb::Database['testDb'],
}

oradb::dbactions{ 'start testDb': 
                 oracleHome              => '/oracle/product/11.2/db',
                 user                    => 'oracle',
                 group                   => 'dba',
                 action                  => 'start',
                 dbName                  => 'test',
                 require                 => Oradb::Dbactions['stop testDb'],
}

oradb::database{ 'testDb_Delete': 
                  oracleBase              => '/oracle',
                  oracleHome              => '/oracle/product/11.2/db',
                  user                    => 'oracle',
                  group                   => 'dba',
                  downloadDir             => '/install/',
                  action                  => 'delete',
                  dbName                  => 'test',
                  sysPassword             => 'Welcome01',
                  require                 => Oradb::Dbactions['start testDb'],
}

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,
   }

   package { 'unixODBC-devel':
     ensure  => present,
   }

   package { 'glibc.i686':
     ensure  => present,
   }

 
 
 }
 
 node 'dbagent1.alfa.local' inherits database {
 }