installdb

Overview

You can use this class to install a working oracle database on your system.

This defined type supports the following versions of Oracle:

• 11.2.0.1
• 11.2.0.3
• 11.2.0.4
• 12.1.0.1
• 12.1.0.2
• 12.2.0.1
• 18.0.0.0
• 19.0.0.0 ( and all subversions)
• 21.0.0.0 ( and all subversions)

Example

Here is an example on how you can use this class to install an Oracle database on your system.

ora_install::installdb{ '12.1.0.2_Linux-x86-64':
  version                   => '12.1.0.2',
  file                      => 'V46095-01',
  database_type             => 'SE',
  oracle_base               => '/oracle',
  oracle_home               => '/oracle/product/12.1/db',
  bash_profile              => true,
  user                      => 'oracle',
  group                     => 'dba',
  group_install             => 'oinstall',
  group_oper                => 'oper',
  download_dir              => '/data/install',
  zip_extract               => true,
  puppet_download_mnt_point => $puppet_download_mnt_point,
}

Experience the Power of Puppet for Oracle

If you want to play and experiment with Puppet and Oracle, please take a look at our playgrounds. At our playgrounds, we provide you with a pre-installed environment, where you experiment fast and easy.

For Oracle   here at our playground...

Attributes

database_type

Selects the type of database you want to install.

At this point in time the following database types are supported and allowed:

• EE : Enterprise Edition (all versions)
• SE : Standard Edition (versions <= 12.1.0.1)
• SEONE : Standard Edition One (versions <= 12.1.0.1)
• SE2 : Standard Edition Two (versions >= 12.1.0.2)

The default value is: SE2

Type: Enum['SE2','SE','EE','SEONE']

Default:'SE2'

Back to overview of installdb

download_dir

The directory where the Puppet software puts all downloaded files.

Before Puppet can actually use remote files, they must be downloaded first. Puppet uses this directory to put all files in.

The default value is: /install

Type: Stdlib::Absolutepath

Default:'/install'

Back to overview of installdb

bash_profile

Create a bash profile for the specified user or not.

Valid values are true and false.

When you specify a true for the parameter, Puppet will create a standard bash profile for the specified user. The bash profile will be placed in a directory named user_base_dir/user.

ora_install::client { 'Oracle client':
  ...
  bash_profile  => true,
  user          => 'oracle',
  user_base_dir => '/home',
  ...
}

This snippet will create a bash profile called /home/oracle/.bash_profile.

Type: Boolean

Default:true

Back to overview of installdb

bash_additions

The text to add at the end of the bash_profile. This parameter will only be used when you have specified true for the parameter bash_profile

The default value is an empty string.

Type: String

Default:''

Back to overview of installdb

cleanup_install_files

Cleanup extracted files after use.

This is a boolean value. When you set this value to true. The installer class will remove all extracted zip files after it has done its work.

The default value is: true

Here is an example:

ora_install::....{...
  ...
  cleanup_install_files => false,  # Keep all unzipped files
  ...
}

Type: Boolean

Default:true

Back to overview of installdb

cluster_nodes

A comma seperated list of the nodes running in the RAC cluster.

Example: node1,node2

Type: Optional[String[1]]

Default:undef

Back to overview of installdb

ee_optional_components

This variable is used to enable or disable custom install.

When its is set to true, the attribute ee_options_selection is used. When this value is false, the attribute ee_options_selection is ignored.

Type: Optional[String[1]]

Default:undef

Back to overview of installdb

ee_options_selection

List of Enterprise Edition Options you would like to install.

Check the oracle documentation what values are valid.

Type: Boolean

Default:false

Back to overview of installdb

file

The source file to use.

Type: String[1]

Default:undef

Back to overview of installdb

group

The os group to use for these Oracle puppet definitions.

The default value is: dba

Type: String[1]

Default:'dba'

Back to overview of installdb

group_install

The os group to use for installation.

The default value is: oinstall

Type: String[1]

Default:'oinstall'

Back to overview of installdb

group_oper

The OS group to allow operator rights.

The default value is: oper

Type: String[1]

Default:'oper'

Back to overview of installdb

is_rack_one_install

This variable is used to enable or disable RAC One Node install.

• true : Value of RAC One Node service name is used.
• false : Value of RAC One Node service name is not used.

The default value is: false

Type: Boolean

Default:false

Back to overview of installdb

ora_inventory_dir

The directory that contains the oracle inventory.

The default value is: /oracle_base/oraInventory

Type: Optional[Stdlib::Absolutepath]

Default:undef

Back to overview of installdb

oracle_base

A directory to use as Oracle base directory.

Type: Stdlib::Absolutepath

Default:undef

Back to overview of installdb

oracle_home

A directory to be used as Oracle home directory for this software.

Type: Stdlib::Absolutepath

Default:undef

Back to overview of installdb

puppet_download_mnt_point

The base path of all remote files for the defined type or class.

The default value is: puppet:///modules/ora_install

Type: Optional[String[1]]

Default:undef

Back to overview of installdb

temp_dir

Directory to use for temporary files.

Type: Stdlib::Absolutepath

Default:'/tmp'

Back to overview of installdb

bypass_tmp_noexec

This variable is used to enable or disable bypassing noexec mount option on $temp_dir.

• true : The $temp_dir filesystem will be remounted with exec option for the duration of the database software installation, provided $temp_dir is a filesystem.
• false : The $temp_dir filesystem will be left alone.

The default value is: true

Type: Boolean

Default:true

Back to overview of installdb

user

The user used for the specified installation. The install class will not create the user for you. You must do that yourself.

The default value is: oracle

Type: String[1]

Default:'oracle'

Back to overview of installdb

umask

The umask to use for commands that run in the context of either the grid user or the oracle user.

The default is 0022

Type: String[1]

Default:'0022'

Back to overview of installdb

user_base_dir

The directory to use as base directory for the users.

Type: Stdlib::Absolutepath

Default:'/home'

Back to overview of installdb

version

Specifies the version of the component you want to manage or install.

At this point in type we support the installation of:

• 11.2.0.1
• 11.2.0.3
• 11.2.0.4
• 12.1.0.1
• 12.1.0.2
• 12.2.0.1
• 18.0.0.0
• 19.0.0.0 (and all subversions)
• 21.0.0.0 (and all subversions)

Here is an example on how to specify the version:

ora_install::....{...
  ...
  version => '12.1.0.2',
  ...
}

Type: Ora_install::Version

Default:undef

Back to overview of installdb

zip_extract

The specified source file is a zip file that needs te be extracted. When you specify a value of false, the source attribute must contain a reference to a directory instead of a zip file.

The default value is: true

Type: Boolean

Default:true

Back to overview of installdb

user_password

The password for the Oracle user on Windows.

This parameter is only used on windows systems

Type: Optional[String[1]]

Default:undef

Back to overview of installdb

logoutput

log the outputs of Puppet exec or not.

When you specify true Puppet will log all output of exec types.

Valid values are:

• true
• false
• on_failure

Type: Variant[Boolean,Enum['on_failure']]

Default:lookup( { name => 'logoutput', default_value => 'on_failure' })

Back to overview of installdb

allow_insecure

When set to true Ignore HTTPS certificate errors

(default: false) Type: Boolean

Default:lookup( { name => 'allow_insecure', default_value => false })

Back to overview of installdb