Skip to content

fatmcgav/puppet-oradb

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

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
  • Installs RCU repositoy for Oracle SOA Suite ( 11.1.1.6.0 and 11.1.1.7.0 )

Some manifests like installdb.pp, opatch.pp or rcusoa.pp supports an alternative mountpoint for the big oracle files.
When not provided it uses the files location of the oradb puppet module
else you can use $puppetDownloadMntPoint => "/mnt" or "puppet:///modules/xxxx/"

Coming in next release

  • Oracle Database 11.2.0.1 Linux Client installation
  • Auto startup scripts

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

rcu linux installer

408989041 Mar 17 20:17 ofm_rcu_linux_11.1.1.6.0_disk1_1of1.zip
411498103 Apr 1 21:23 ofm_rcu_linux_11.1.1.7.0_32_disk1_1of1.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'],
}

Oracle SOA Suite Repository Creation Utility (RCU)

oradb::rcusoa{    'DEV_PS6':
                 rcuFile          => 'ofm_rcu_linux_11.1.1.7.0_32_disk1_1of1.zip',
                 version          => '11.1.1.7',  
                 oracleHome       => '/oracle/product/11.2/db',
                 user             => 'oracle',
                 group            => 'dba',
                 downloadDir      => '/install/',
                 action           => 'create',
                 dbServer         => 'dbagent1.alfa.local:1521',  
                 dbService        => 'test.oracle.com',
                 sysPassword      => 'Welcome01',
                 schemaPrefix     => 'DEV',
                 reposPassword    => 'Welcome02',
}

oradb::rcusoa{    'Delete_DEV3_PS5':
                 rcuFile          => 'ofm_rcu_linux_11.1.1.6.0_disk1_1of1.zip',
                 version          => '11.1.1.6',  
                 oracleHome       => '/oracle/product/11.2/db',
                 user             => 'oracle',
                 group            => 'dba',
                 downloadDir      => '/install/',
                 action           => 'delete',
                 dbServer         => 'dbagent1.alfa.local:1521',  
                 dbService        => 'test.oracle.com',
                 sysPassword      => 'Welcome01',
                 schemaPrefix     => 'DEV3',
                 reposPassword    => 'Welcome02',
                 require          => Oradb::Rcusoa['DEV3_PS6'],
}

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

About

Puppet Oracle DB management. Split out from https://github.com/biemond/puppet

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published