ora_install
Version information
This version is compatible with:
- Puppet Enterprise 2021.3.x, 2021.2.x, 2021.1.x, 2021.0.x, 2019.8.x, 2019.7.x, 2019.5.x, 2019.4.x, 2019.3.x, 2019.2.x, 2019.1.x, 2019.0.x, 2018.1.x, 2017.3.x, 2017.2.x, 2017.1.x, 2016.5.x, 2016.4.x
- Puppet >= 4.0.0 < 8.0.0
- Windows,RedHat,CentOS,OracleLinux,SLES,Debian,Ubuntu,Solaris
Tasks:
- agent_action
- apply_psu_db
- db_action
- grid_action
Start using this module
Add this declaration to your Puppetfile:
mod 'enterprisemodules-ora_install', '5.14.1'Learn more about managing modules with a PuppetfileDocumentation
Table of Contents
- Overview
- Experience the Power of Puppet for Oracle databases
- License
- Description - What the module does and why it is useful
- Setup
- Usage - Configuration options and additional functionality
- Reference - An under-the-hood peek at what the module is doing and how
- Limitations - OS compatibility, etc.
Overview
This module allows you to install multiple Oracle database related products. It is part of our family of Puppet modules to install, manage and secure Oracle databases with Puppet. Besides the ora_install module, this family also contains:
ora_configFor configuring every aspect of your Oracle databaseora_cisTo secure your databases according to the CIS benchmarks.ora_profileThe ora_profile module allows an easy path from first simple installation to a fully customized Enterprise setup.
All of these modules support Oracle versions 11, 12, 18, 19 and 21.
Experience the Power of Puppet for Oracle databases
Managing the configuration of your Oracle databases can be hard. With Puppet at your side, you get super-powers when installing and managing Oracle Databases. If you want to play and experiment with this please take a look at our playgrounds.
License
This is a commercially licensed module. But you can use the module on VirtualBox based development systems for FREE. You can request a FREE trial license here
Check the License for details.
Description
The ora_install module contains all Puppet classes, defined types and custom types needed to install Oracle RDBMS and Oracle ASM on a system. Instead of writing complex Bash scripts, using this module, you can now define your Oracle software installation in an easy, declarative way.
All knowledge required to install and manage your Oracle installation is coded into the Puppet modules. This means you can focus on the "what" and leave the implementation details to our modules.
Our modules support a broad range of Oracle versions. We are committed to making our modules work on future releases. This allows our customers an easy upgrade path from older to newer versions.
The module has support for:
- installasm Install the ASM Grid software
- installdb Install the Oracle Database software
- installem Install Enterprise Manager software
- installem_agent Install the Enterprise Manager Agent software
- goldengate Install the goldengate software
- client Install the Oracle client software
- database Create a simple databases
- db_listener Start the listener
- net Install and configure SQL*Net
- opatchupgrade Ensure the correct Opatch version on your system
- rcu Create a Fusion Repository
- tnsnames Manage TNS names entries
Setup
Requirements
The ora_install module requires:
- Puppet module [
enterprisemodules-easy_type]((https://forge.puppet.com/enterprisemodules/easy_type) installed. - Puppet version 4.0 or higher. Can be Puppet Enterprise or Puppet Open Source
- Oracle 11 or higher, including support for Oracle 18, Oracle 19 and Oracle 21
- A valid Oracle license
- A valid Enterprise Modules license for usage
- Runs on most Linux systems
- Runs on Solaris
- Runs on Windows systems
Installing the ora_install module
To install these modules, you can use a Puppetfile
mod 'enterprisemodules/ora_install', '4.6.0'
Then use the librarian-puppet or r10K to install the software.
You can also install the software using the puppet module command:
puppet module install enterprisemodules-ora_install
Usage
Building a total Oracle setup requires quite some work. To help you, we have built some examples. This repo contains a demonstration of a simple database installation.
Reference
You can find some more information here regarding this Puppet module:
And here are some related blog posts:
- How to ensure you only use Oracle features you paid for
- Oracle 12.2 support added to our Oracle modules
- Secure your Oracle database
- Manage Oracle containers with Puppet
- Manage your Oracle users with Puppet
- Reaching into your Oracle database with Puppet
- Manage your Oracle database schemas with Puppet
- Managing your Oracle database size with Puppet
- Using Puppet to manage Oracle
Limitations
This module runs on Solaris, Windows and most Linux versions. It requires a puppet version higher than 4. Other configurations are no supported.
Reference
Table of Contents
Classes
ora_install::prepareautostart: Prepare autostart of the database for linux.
Defined types
ora_install::autostartdatabase: This defined type create's a startup script for the specified database and enables the service.ora_install::client: Installs the Oracle client software.ora_install::database: This defined type allows you to create or delete a database.ora_install::database_pluggable: Creates or delete a pluggable database.ora_install::dbactions: Defined type to start and stop a database.ora_install::goldengate: Installs the Oracle goldengate software.ora_install::installasm: Installs and configures Oracle grid.ora_install::installdb: You can use this class to install a working oracle database on your system.ora_install::installem: Installs the Oracle Enterprse Manager.ora_install::installem_agent: Installs the Oracle Enterprise Manager Agent.ora_install::listener: Manage the oracle listener[DEPRECATED]ora_install::net: Installs and configures Oracle SQL*Netora_install::opatch: [DEPRECATED] Wrapper defined type for installing patches.ora_install::opatchupgrade: Installs or upgrades the specified version of the Oracle OPatch utility.ora_install::prepareautostart_for: Prepare autostart of the database for linux.ora_install::rcu: Install the repository for several Oracle Fusion products.ora_install::tnsnames: Manages an entry in a `tnsnames.ora_install::utils::dborainst: See the file "LICENSE" for the full license governing this code. == define: ora_install::utils::dborainst creates oraInst.loc for oracle p
Resource types
db_control: control the database instance state like running,stop,restartdb_directory_structure: add all the directories needed by the oracle db or asm installationdb_listener: control the oracle db listener state like running,stop,restartdb_opatch: This is the Oracle Patch process called OPatchdb_rcu: This is the Oracle RCU ( Repository creation utility) installer typeora_home: This resource allows you to manage Oracle homes.ora_install: Start the setup for applying ora_install classes.ora_opatch: This resource allows you to manage opatch patches on a specific database home.ora_tab_entry: With this type you can manage entries in the systems oratab file. Here is an example on how to use this: ora_tab_entry { 'MYDB': en
Functions
opatch_version: See the file "LICENSE" for the full license governing this code. Returns the the installed Opatch version for a specfied Oracle homeora_install::changed_oracle_home_for: See the file "LICENSE" for the full license governing this code. This function checks if the specified home, is the current home for the spora_install::opatch_version: See the file "LICENSE" for the full license governing this code. Returns the the installed Opatch version for a specfied Oracle homeora_install::ora_patches_installed: See the file "LICENSE" for the full license governing this code. This function checks if the specfied patches are installed. The patch listora_install::ora_patches_missing: See the file "LICENSE" for the full license governing this code. This function checks if the specfied patches are installed. For type = dbora_install::ora_physical_patches: See the file "LICENSE" for the full license governing this code. This function parses a Hash of patches and looks for resources with sub_paora_install::oracle_existsora_patches_installed: See the file "LICENSE" for the full license governing this code. This function checks if the specfied patches are installed. The patch listora_physical_patches: See the file "LICENSE" for the full license governing this code. This function parses a Hash of patches and looks for resources with sub_paoracle_exists
Data types
Tasks
agent_action: Enable, disable or start a puppet agent run.apply_psu_db: Execute the PSU database update for specified SID.db_action: Execute an action pn the specified Oracle instancegrid_action: Execute actions (stop/start) on Oracle Grid installations for patching.listener_action: Execute an action on the Oracle listeneropatch_upgrade: Apply patch(es) to an Oracle home.restart: Restart the specified Oracle instance on the specified nodeshutdown: Shutdown the specified Oracle instance on the specified nodestartup: Startup the specified Oracle instance on the specified nodeswitch_grid_home: Switch a running instance to an other already available Oracle home.switch_oracle_home: Switch a running instance to an other already available Oracle home.upgrade_db: Execute the database upgrade for specified SID.
Plans
ora_install::install_grid_home_and_patch: This plan will install a new GRID_HOME and apply the specified patches to it.ora_install::install_oracle_home: This plan will install a new ORACLE_HOME.ora_install::install_oracle_home_and_patch: This plan will install a new ORACLE_HOME and apply the specified patches to it.ora_install::opatch_upgrade: This plan will install a new version of OPatch in specified ORACLE_HOME.ora_install::patch_home: This plan will install patches into specified home.ora_install::switch_home_and_apply_psu: This plan will switch an Oracle database to an already existing other ORACLE_HOME and apply the patches in the database.ora_install::switch_home_asm: This plan will switch an Grid Infrastructure installation to an already existing other GRID_HOME.
Classes
ora_install::prepareautostart
ora_install::prepareautostart
This class creates the script needed to start the database after a system reboot. It supports both systemd and the older startup scripts.
Here is an example on how to use it:
class { 'class ora_install::prepareautostart':
oracle_home => '/oracle/db1',
user => 'oracle',
service_name => 'start_db1',
}
This class is a conveniance class arround the defined type prepareautostart_for.
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::prepareautostart class:
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
user
Data type: String[1]
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
Default value: 'oracle'
service_name
Data type: String[1]
The name of the init service to use.
The default value is: dbora
Default value: 'dbora'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
Defined types
ora_install::autostartdatabase
ora_install::autostartdatabase
The end result is that the named Oracle database is restarted after a system restart.
Here is an example on how to use it:
ora_install::autostartdatabase{ 'autostart oracle':
oracle_home => '/oracle/product/12.1/db',
user => 'oracle',
db_name => 'test',
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::autostartdatabase defined type:
db_domain
Data type: Optional[String[1]]
The domain of the database.
Default value: undef
db_name
Data type: String[1]
The name of the database.
Default value: undef
db_policy
Data type: Enum['AUTOMATIC','MANUAL','NORESTART']
The srvctl management policy for the database Valid values are:
AUTOMATICMANUALNORESTARTThe default value is:AUTOMATIC
Default value: 'AUTOMATIC'
db_type
Data type: Enum['database','grid']
The type of the database used to specify if the database should be started by an init script or srvctl. Valid values are:
griddatabaseThe default value is: 'database'
Default value: 'database'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
service_name
Data type: String[1]
The service name to start.
Default value: 'dbora'
start_option
Data type: Enum['OPEN','MOUNT','READ ONLY']
The srvctl startup options for the database. Valid values are:
OPENMOUNTREAD ONLYThe default value is:OPEN
Default value: 'OPEN'
user
Data type: String[1]
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
Default value: 'oracle'
ora_install::client
ora_install::client
Using this defined type you can install the Oracle client software on your system.
Here is an example on how to use it:
ora_install::client{ '12.1.0.1_Linux-x86-64':
version => '12.1.0.1',
file => 'linuxamd64_12c_client.zip',
oracle_base => '/oracle',
oracle_home => '/oracle/product/12.1/client',
user => 'oracle',
group => 'dba',
group_install => 'oinstall',
download_dir => '/install',
bash_profile => true,
puppet_download_mnt_point => "puppet:///modules/ora_install/",
ora_inventory_dir => '/oracle/product',
logoutput => true,
}
support for multiple versions
This defined type has support for installing different versions of the client software on your system. In order to do this use the defined type multiple times in you manifest and use a different oracle_home and a different file.
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::client defined type:
bash_profiledb_portdownload_dirfilegroupgroup_installlogoutputora_inventory_diroracle_baseoracle_homepuppet_download_mnt_pointremote_filetemp_dirumaskuseruser_base_dirversioninstall_typeinstall_optionsallow_insecure
bash_profile
Data type: Boolean
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.
Default value: true
db_port
Data type: Integer
The IP port to use for database communication.
The default value is: 1521
Default value: 1521
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
file
Data type: String[1]
The source file to use.
Default value: undef
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
group_install
Data type: String[1]
The os group to use for installation.
The default value is: oinstall
Default value: 'oinstall'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
The default value is: /oracle_base/oraInventory
Default value: undef
oracle_base
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
remote_file
Data type: Optional[Boolean]
DEPRECATED
This parameter is not being used anymore and will be removed in a future release.
true.
Default value: undef
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
umask
Data type: String[1]
The umask to use for commands that run in the context of either the grid user or the oracle user.
The default is 0022
Default value: '0022'
user
Data type: String[1]
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
Default value: 'oracle'
user_base_dir
Data type: Stdlib::Absolutepath
The directory to use as base directory for the users.
Default value: '/home'
version
Data type: Ora_install::Version
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
Default value: undef
install_type
Data type: Enum['Administrator','Runtime','InstantClient','Custom']
Default value: 'Administrator'
install_options
Data type: Optional[Array[String]]
Default value: []
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::database
ora_install::database
Under the hood the calls the dbca utility to do the work. When you need more control over the individual settings when creating the database, you must use the ora_database custom type of the ora_config module
Here is an example on how to use this defined type to create a database:
ora_install::database{ 'testDb_Create':
action => 'create',
oracle_base => '/oracle',
oracle_home => '/oracle/product/11.2/db',
version => '11.2',
user => 'oracle',
group => 'dba',
download_dir => '/install',
action => 'create',
db_name => 'test',
db_domain => 'oracle.com',
db_port => '1521',
sys_password => 'Welcome01',
system_password => 'Welcome01',
data_file_destination => "/oracle/oradata",
recovery_area_destination => "/oracle/flash_recovery_area",
character_set => "AL32UTF8",
nationalcharacter_set => "UTF8",
init_params => {'open_cursors' => '1000',
'processes' => '600',
'job_queue_processes' => '4' },
sample_schema => 'TRUE',
memory_percentage => "40",
memory_total => "800",
database_type => "MULTIPURPOSE",
em_configuration => "NONE",
require => Ora_install::Listener['start listener'],
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::database defined type:
actionasm_diskgroupasm_snmp_passwordcharacter_setcluster_nodescontainer_databasedata_file_destinationdatabase_typedb_conf_typedb_domaindb_namedb_portdb_snmp_passworddownload_direm_configurationgroupinit_paramslogoutputmemory_percentagememory_totalnationalcharacter_setoracle_baseoracle_homepuppet_download_mnt_pointrecovery_area_destinationrecovery_diskgroupsample_schemastorage_typesys_passwordsystem_passwordtemplatetemplate_typeuserversionmemory_mgmt_type
action
Data type: Enum['create','delete']
The action that must be taken. create or delete. Valid values are:
createdeleteThe default value is:create
Default value: 'create'
asm_diskgroup
Data type: Optional[String[1]]
The ASM diskgroup to use for the database.
The default value is: DATA
Default value: 'DATA'
asm_snmp_password
Data type: Optional[Easy_type::Password]
The password to use for the ASMSNMP user.
Default value: undef
character_set
Data type: String[1]
The character set to use for running the database.
The default value is: AL32UTF8
Default value: 'AL32UTF8'
cluster_nodes
Data type: Optional[String[1]]
A comma seperated list of the nodes running in the RAC cluster.
Example: node1,node2
Default value: undef
container_database
Data type: Boolean
Database is a container for pluggable databases.
When you want to add pluggable database to this database, specify a value of true.
The default value is: false
Default value: false
data_file_destination
Data type: Optional[String[1]]
The location of the data file's.
Default value: undef
database_type
Data type: Optional[Enum['MULTIPURPOSE','DATA_WAREHOUSING','OLTP']]
The kind of database you want to create. Valid values are:
MULTIPURPOSEDATA_WAREHOUSINGOLTPThe default value is:MULTIPURPOSE
Default value: 'MULTIPURPOSE'
db_conf_type
Data type: Enum['SINGLE','RAC','RACONE']
The type of database that needs to be installed. Valid values are:
SINGLERACRACONE
Default value: 'SINGLE'
db_domain
Data type: Optional[String[1]]
The domain of the database.
Default value: undef
db_name
Data type: String[1]
The name of the database.
Default value: 'orcl'
db_port
Data type: Optional[Integer]
The IP port to use for the database.
The default value is: 1521
Default value: 1521
db_snmp_password
Data type: Optional[Easy_type::Password]
Password to use for the dbsnmp user.
Default value: undef
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
em_configuration
Data type: Enum['CENTRAL','LOCAL','ALL','NONE','DBEXPRESS','BOTH']
The type of Enterprise Manager configuration. Valid values are:
CENTRAL(all versions)LOCAL(version < 12.2)ALL(version < 12.2)NONE(all versions)DBEXPRESS(version >= 12.2)BOTH(version >= 12.2) The default value is:NONE
Default value: 'NONE'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
init_params
Data type: Optional[Variant[String[1], Hash]]
The init parameters to use for the database. You can use either a comma separated string for init_params or a Hash.
Using comma separated string
Here is an example using a comma separated string:
ora_install::database{'my_database'
...
init_params => "open_cursors=1000,processes=600,job_queue_processes=4",
...
}
Using a Hash
Here is an example using a Hash:
ora_install::database{'my_database'
...
init_params => {'open_cursors' => '1000',
'processes' => '600',
'job_queue_processes' => '4' },
}
...
}
Default value: undef
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
memory_percentage
Data type: Integer
The percentage of physical memory for Oracle.
The default value is: 40
Default value: 40
memory_total
Data type: Integer
The total memory in MB to allocate to Oracle.
The default value is: 800
Default value: 1000
nationalcharacter_set
Data type: String[1]
Use this NLS Character set.
The default value is: UTF8
Default value: 'AL16UTF16'
oracle_base
Data type: String[1]
A directory to use as Oracle base directory.
Default value: undef
oracle_home
Data type: String[1]
A directory to be used as Oracle home directory for this software.
Default value: undef
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
recovery_area_destination
Data type: Optional[String[1]]
Location of the recovary files.
Default value: undef
recovery_diskgroup
Data type: Optional[String[1]]
Diskgroup to use for recovery files.
Default value: undef
sample_schema
Data type: Enum['TRUE','FALSE']
Load the sample schema or not.
Attention This is a string and not a boolean value.
The default value is: TRUE
Default value: 'TRUE'
storage_type
Data type: Enum['FS','CFS','ASM']
The storage type to use. Valid values are:
FSCFSASMFS
Default value: 'FS'
sys_password
Data type: Easy_type::Password
The password to use for the SYS user.
system_password
Data type: Easy_type::Password
The password to use for the SYSTEM user.
template
Data type: Optional[String[1]]
Use the specified template to create the database. You can choose between a set of pre-delivered templates, but also specify your own templates.
Using a pre-delivered template
ora_install delivers a few predefined templates.
- dbtemplate_11GR2
- dbtemplate_12.1
- dbtemplate_12.1_asm Here is an example on how to use this:
ora_install::database{ 'testDb_Create':
...
template => 'dbtemplate_12.1',
...
}
Using your own template
When you specify a template name not pre-delivered by ora_install, the defined type will look in the directory specified by puppet_download_mnt_point for your own template.
Here is an example:
template => 'my_dbtemplate_11gR2_asm',
puppet_download_mnt_point => '/vagrant', # 'ora_install' etc
The template must be have the following extension dbt.erb like dbtemplate_12.1.dbt.erb
- Click here for an 12.1 db instance template example
- Click here for an 11.2 db asm instance template example
Default value: undef
template_type
Data type: Optional[Enum['non-seed','seed']]
The template type DBCA uses.
There are two types of templates:
non-seedseedThe default value is:non-seed
Default value: 'non-seed'
user
Data type: String[1]
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
Default value: 'oracle'
version
Data type: Ora_install::ShortVersion
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
Default value: '12.2'
memory_mgmt_type
Data type: Optional[Enum['AUTO','AUTO_SGA','CUSTOM_SGA']]
Default value: 'AUTO_SGA'
ora_install::database_pluggable
ora_install::database_pluggable
Under the hood, this defined type calls the dbca utility to create or delete a pluggable database in the specified source database.
Here is an example on how to create pluggable database:
ora_install::database_pluggable{'pdb1':
ensure => 'present',
version => '12.1',
oracle_home_dir => '/oracle/product/12.1/db',
user => 'oracle',
group => 'dba',
source_db => 'orcl',
pdb_name => 'pdb1',
pdb_admin_username => 'pdb_adm',
pdb_admin_password => 'Welcome01',
pdb_datafile_destination => "/oracle/oradata/orcl/pdb1",
create_user_tablespace => true,
logoutput => true,
}
Here is an example on how to remove a pluggable database:
ora_install::database_pluggable{'pdb1':
ensure => 'absent',
version => '12.1',
oracle_home_dir => '/oracle/product/12.1/db',
user => 'oracle',
group => 'dba',
source_db => 'orcl',
pdb_name => 'pdb1',
pdb_datafile_destination => "/oracle/oradata/orcl/pdb1",
logoutput => true,
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::database_pluggable defined type:
create_user_tablespaceensuregrouplog_outputlogoutputoracle_home_dirpdb_admin_passwordpdb_admin_usernamepdb_datafile_destinationpdb_namesource_dbuserversion
create_user_tablespace
Data type: Boolean
Create a user tablespace in the PDB.
The default value is: false
Default value: true
ensure
Data type: Enum[present,absent]
State to obtain. The ensure attribute can be one of two values:
- present
- absent
When you specify
present, Puppet will make sure the resource is available with all specified options and properties. When the resource is already available(installed), and all attributes are as the are specified, Puppet will do nothing. When you specifyabsent, Puppet will remove the resource if it is available. If it is not installed, Puppet will do nothing.
Default value: present
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
log_output
Data type: Optional[Variant[Boolean,Enum['on_failure']]]
DEPRECATED This parameter is replaced by 'logoutput' and will be removed in a future release.
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: undef
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
oracle_home_dir
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
pdb_admin_password
Data type: Easy_type::Password
Password for the admin user in the PDB.
Default value: undef
pdb_admin_username
Data type: String[1]
Username for the admin user in the pluggable database.
The default value is: pdb_adm
Default value: 'pdb_adm'
pdb_datafile_destination
Data type: String[1]
The location where the PDB datafiles will be stored.
Default value: undef
pdb_name
Data type: String[1]
Name of the pluggable database.
Default value: undef
source_db
Data type: String[1]
The database name of the container(source) database.
Default value: undef
user
Data type: String[1]
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
Default value: 'oracle'
version
Data type: Enum['12.1','12.2', '18.0', '19.0', '21.0']
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
Default value: '12.1'
ora_install::dbactions
ora_install::dbactions
[DEPRECATED]
This is defined type to start or stop a database. Usage of this type is discouraged. Please use db_control for this function.
Here is an example on how to use this:
ora_install::dbactions{ 'stop testDb':
db_name => 'test',
oracle_home => '/oracle/product/11.2/db',
user => 'oracle',
group => 'dba',
action => 'stop',
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::dbactions defined type:
action
Data type: Enum['running','start','stop','abort']
The action you want to take. Valid values are:
startrunningstopabortDefault value is:start
Default value: 'start'
db_name
Data type: String[1]
The database you want to do the action on.
Default value: 'orcl'
db_type
Data type: Enum['database','asm','grid']
The type of service you want to manage. Valid values are:
databasegridasm
Default value: 'database'
grid_home
Data type: Optional[Stdlib::Absolutepath]
The oracle home directory to use for the GRID software.
Default value: undef
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
user
Data type: String[1]
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
Default value: 'oracle'
ora_install::goldengate
ora_install::goldengate
This module supports the following versions:
- 12.1.2
- 12.2.1
- 18.1.0
- 19.1.0
Here is an example on how to use this:
ora_install::goldengate{ 'ggate12.1.2':
version => '12.1.2',
file => '121200_fbo_ggs_Linux_x64_shiphome.zip',
database_type => 'Oracle',
database_version => 'ORA11g',
database_home => '/oracle/product/12.1/db',
oracle_base => '/oracle',
goldengate_home => "/oracle/product/12.1/ggate",
manager_port => 16000,
user => 'ggate',
group => 'dba',
group_install => 'oinstall',
download_dir => '/install',
puppet_download_mnt_point => puppet://modules/software,
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::goldengate defined type:
database_homedatabase_typedatabase_versiondownload_dirfilegoldengate_homegroupgroup_installlogoutputmanager_portoracle_basepuppet_download_mnt_pointtemp_dirumaskuserversionora_inventory_dirallow_insecure
database_home
Data type: Stdlib::Absolutepath
The home directory of the database.
Default value: undef
database_type
Data type: Enum['Oracle']
The type of database.
The default value is: Oracle
Default value: 'Oracle'
database_version
Data type: Enum['ORA11g','ORA12c']
The version of the database. Valid values are:
ORA11gORA12cORA11g
Default value: 'ORA11g'
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
file
Data type: String[1]
The file containing the software.
Default value: undef
goldengate_home
Data type: Stdlib::Absolutepath
The home to use for the goldengate software.
Default value: undef
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
group_install
Data type: String[1]
The os group to use for installation.
The default value is: oinstall
Default value: 'oinstall'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
manager_port
Data type: Integer
The IP port number of the manager. This is a required value.
Default value: undef
oracle_base
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
umask
Data type: String[1]
The umask to use for commands that run in the context of either the grid user or the oracle user.
The default is 0022
Default value: '0022'
user
Data type: String[1]
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
Default value: 'ggate'
version
Data type: Enum['12.1.2','12.2.1', '12.3.0','18.1.0', '19.1.0']
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
Default value: '12.3.0'
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
Default value: undef
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::installasm
ora_install::installasm
This defined class supports the following versions of grid:
- 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 sub versions)
- 21.0.0.0 (and all sub versions)
Here is an example on how to use this:
ora_install::installasm{ 'db_linux-x64':
version => hiera('db_version'),
file => hiera('asm_file'),
grid_type => 'HA_CONFIG',
grid_base => hiera('grid_base_dir'),
grid_home => hiera('grid_home_dir'),
ora_inventory_dir => hiera('oraInventory_dir'),
user_base_dir => '/home',
user => hiera('grid_os_user'),
group => 'asmdba',
group_install => 'oinstall',
group_oper => 'asmoper',
group_asm => 'asmadmin',
sys_asm_password => 'Welcome01',
asm_monitor_password => 'Welcome01',
asm_diskgroup => 'DATA',
disk_discovery_string => "/nfs_client/asm*",
disks => "/nfs_client/asm_sda_nfs_b1,/nfs_client/asm_sda_nfs_b2",
# disk_discovery_string => "ORCL:*",
# disks => "ORCL:DISK1,ORCL:DISK2",
disk_redundancy => "EXTERNAL",
download_dir => hiera('oracle_download_dir'),
remote_file => false,
puppet_download_mnt_point => hiera('oracle_source'),
}
The type of storage to use. Valid values are:
ASM_STORAGE(versions = 11)FILE_SYSTEM_STORAGE(versions <= 12.1)LOCAL_ASM_STORAGE(versions >= 12.1)CLIENT_ASM_STORAGE(versions >= 12.2)FLEX_ASM_STORAGE(versions >= 12.1)
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::installasm defined type:
asm_diskgroupasm_monitor_passwordcluster_namecluster_nodesconfigure_afddisk_au_sizedisk_discovery_stringdisk_redundancydisks_failgroup_namesbash_profilebash_additionsdisksdownload_dirfilegimr_configuregimr_dg_ausizegimr_dg_disksgimr_dg_disks_failgroup_namesgimr_dg_fg_namesgimr_dg_namegimr_dg_redundancygrid_basegrid_homegrid_typegroupgroup_asmgroup_installgroup_operlogoutputnetwork_interface_listora_inventory_dirpuppet_download_mnt_pointremote_filescan_namescan_portstand_alonestorage_optionsys_asm_passwordtemp_diruserumaskuser_base_dirversionzip_extractinstall_taskgimr_dgallow_insecure
asm_diskgroup
Data type: String[1]
The name of the ASM diskgroup to use.
DATA
Default value: 'DATA'
asm_monitor_password
Data type: Easy_type::Password
The password for the ASMSNMP user for monitoring in EM.
cluster_name
Data type: Optional[String[1]]
The name of the cluster.
Default value: undef
cluster_nodes
Data type: Optional[String[1]]
The names of the nodes in the RAC cluster. Valid values are:
node1:node1-vip,node2:node2-vip(version >= 11 <= 12.1)node1:node1-vip:HUB,node2:node2-vip:LEAF(version >= 12.1 Flex Cluster)node1,node2(version = 12.2 Application Cluster)node1:node1-vip:HUB:site1,node2:node2-vip:HUB:site2(version = 12.2 Extended Cluster)
Default value: undef
configure_afd
Data type: Optional[Boolean]
Specify whether or not to configure ASM Filter Driver instead of ASMLib.
The default value is: false
Default value: false
disk_au_size
Data type: Enum['1','2','4','8','16','32','64']
The disk_au size to use for the ASM disks.
Attention this is a String value not an Integer.
The default value is: 1
Default value: '1'
disk_discovery_string
Data type: Optional[String[1]]
The search string to use for discovering disks for ASM.
Default value: undef
disk_redundancy
Data type: Enum['NORMAL','HIGH','EXTERNAL']
The type of redundancy to use. Valid values are:
NORMALHIGHEXTERNALThe default value is:NORMAL
Default value: 'NORMAL'
disks_failgroup_names
Data type: Optional[String[1]]
A comma seperated list of device and failure group name. Valid values are:
/dev/sdb,CRSFG1,/dev/sdc,CRSFG2,/dev/sdd,CRSFG3(NORMAL redundancy)/dev/sdb,,/dev/sdc,,/dev/sdd,,/dev/sde,(EXTERNAL redundancy)/dev/sdb,CRSFG1,/dev/sdc,CRSFG2,/dev/sdd,CRSFG3,/dev/sde,CRSFG4,/dev/sdf,CRSFG5(HIGH redundancy)
Default value: undef
bash_profile
Data type: Boolean
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.
Default value: true
bash_additions
Data type: String
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.
Default value: ''
disks
Data type: Optional[String[1]]
List of disks to create a ASM DiskGroup.
Default value: undef
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
file
Data type: String[1]
The source file to use.
Default value: undef
gimr_configure
Data type: Optional[Boolean]
Specify whether or not to configure GIMR database (MGMTDB), 19c and higher only.
The default value is: false
Default value: false
gimr_dg_ausize
Data type: Optional[Enum['1','2','4','8','16','32','64']]
The disk_au size to use for the for the GIMR database (MGMTDB) diskgroup.
Attention this is a String value not an Integer.
The default value is: 1
Default value: '1'
gimr_dg_disks
Data type: Optional[String[1]]
List of disks to create the GIMR database (MGMTDB).
Default value: undef
gimr_dg_disks_failgroup_names
Data type: Optional[String[1]]
A comma seperated list of device and failure group name for the GIMR database (MGMTDB). Valid values are:
/dev/sdb,GIMRFG1,/dev/sdc,GIMRFG2,/dev/sdd,GIMRFG3(NORMAL redundancy)/dev/sdb,,/dev/sdc,,/dev/sdd,,/dev/sde,(EXTERNAL redundancy)/dev/sdb,GIMRFG1,/dev/sdc,GIMRFG2,/dev/sdd,GIMRFG3,/dev/sde,GIMRFG4,/dev/sdf,GIMRFG5(HIGH redundancy)
Default value: undef
gimr_dg_fg_names
Data type: Optional[String[1]]
Failure Groups for the GIMR storage data ASM disk group.
Default value: undef
gimr_dg_name
Data type: Optional[String[1]]
Specify the name of the diskgroup for the GIMR database (MGMTDB), 12. 2 and up only.
Default value: undef
gimr_dg_redundancy
Data type: Optional[Enum['NORMAL','HIGH','EXTERNAL']]
The type of redundancy to use for the GIMR database (MGMTDB) diskgroup. Valid values are:
NORMALHIGHEXTERNAL
Default value: undef
grid_base
Data type: Stdlib::Absolutepath
The directory to use as grid base.
Default value: undef
grid_home
Data type: Stdlib::Absolutepath
The directory to use as grid home.
Default value: undef
grid_type
Data type: Enum['CRS_CONFIG','HA_CONFIG','UPGRADE','CRS_SWONLY','HA_SWONLY']
The type of grid. Valid values are:
HA_CONFIGCRS_CONFIGHA_SWONLY(versions > 11)UPGRADECRS_SWONLYThe default value is:HA_CONFIG
Default value: 'HA_CONFIG'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'asmdba'
group_asm
Data type: String[1]
The OS group to use.
The default value is: asmdba
Default value: 'asmadmin'
group_install
Data type: String[1]
The os group to use for installation.
The default value is: oinstall
Default value: 'oinstall'
group_oper
Data type: String[1]
The OS group to allow ASM oper operations.
The default value is: asmoper
Default value: 'asmoper'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
network_interface_list
Data type: Optional[String[1]]
The list of interfaces to use for RAC. The value should be a comma separated strings where each string is as shown below
InterfaceName:SubnetAddress:InterfaceType
where InterfaceType can be either "1", "2", or "3" (1 indicates public, 2 indicates private, and 3 indicates the interface is not used) An example on how to use this:
installasm{'asm12':
...
network_interface_list => 'eth0:140.87.24.0:1,eth1:10.2.1.0:2,eth2:140.87.52.0:3'
...
}
Default value: undef
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
The default value is: /oracle_base/oraInventory
Default value: undef
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
remote_file
Data type: Optional[Boolean]
DEPRECATED
This parameter is not being used anymore and will be removed in a future release.
true.
Default value: undef
scan_name
Data type: Optional[String[1]]
The name to use for the SCAN service.
Default value: undef
scan_port
Data type: Optional[Integer]
The IP portnumber to use for the SCAN service.
Default value: undef
stand_alone
Data type: Boolean
Configuring Grid Infrastructure for a Stand-Alone Server.
The default value is: true
Default value: true
storage_option
Data type: Optional[Enum['FLEX_ASM_STORAGE','CLIENT_ASM_STORAGE','LOCAL_ASM_STORAGE','FILE_SYSTEM_STORAGE','ASM_STORAGE']]
Default value: undef
sys_asm_password
Data type: Easy_type::Password
The password to use for the SYSASM user.
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
user
Data type: String[1]
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
Default value: 'grid'
umask
Data type: String[1]
The umask to use for commands that run in the context of either the grid user or the oracle user.
The default is 0022
Default value: '0022'
user_base_dir
Data type: Stdlib::Absolutepath
The directory to use as base directory for the users.
Default value: '/home'
version
Data type: Ora_install::Version
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
Default value: undef
zip_extract
Data type: Boolean
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
Default value: true
install_task
Data type: Enum['ALL','EXTRACT','SETUP']
Default value: 'ALL'
gimr_dg
Data type: Optional[Boolean]
Default value: false
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::installdb
ora_install::installdb
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,
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::installdb defined type:
database_typedownload_dirbash_profilebash_additionscleanup_install_filescluster_nodesee_optional_componentsee_options_selectionfilegroupgroup_installgroup_operis_rack_one_installora_inventory_diroracle_baseoracle_homepuppet_download_mnt_pointremote_filetemp_dirbypass_tmp_noexecuserumaskuser_base_dirversionzip_extractuser_passwordlogoutputallow_insecure
database_type
Data type: Enum['SE2', 'SE', 'EE', 'SEONE']
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
Default value: 'SE2'
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
bash_profile
Data type: Boolean
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.
Default value: true
bash_additions
Data type: String
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.
Default value: ''
cleanup_install_files
Data type: Boolean
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
...
}
Default value: true
cluster_nodes
Data type: Optional[String[1]]
A comma seperated list of the nodes running in the RAC cluster.
Example: node1,node2
Default value: undef
ee_optional_components
Data type: Optional[String[1]]
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.
Default value: undef
ee_options_selection
Data type: Boolean
List of Enterprise Edition Options you would like to install. Check the oracle documentation what values are valid.
Default value: false
file
Data type: String[1]
The source file to use.
Default value: undef
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
group_install
Data type: String[1]
The os group to use for installation.
The default value is: oinstall
Default value: 'oinstall'
group_oper
Data type: String[1]
The OS group to allow operator rights.
The default value is: oper
Default value: 'oper'
is_rack_one_install
Data type: Boolean
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
Default value: false
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
The default value is: /oracle_base/oraInventory
Default value: undef
oracle_base
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
remote_file
Data type: Optional[Boolean]
DEPRECATED
This parameter is not being used anymore and will be removed in a future release.
true.
Default value: undef
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
bypass_tmp_noexec
Data type: Boolean
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
Default value: true
user
Data type: String[1]
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
Default value: 'oracle'
umask
Data type: String[1]
The umask to use for commands that run in the context of either the grid user or the oracle user.
The default is 0022
Default value: '0022'
user_base_dir
Data type: Stdlib::Absolutepath
The directory to use as base directory for the users.
Default value: '/home'
version
Data type: Ora_install::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.111.2.0.311.2.0.412.1.0.112.1.0.212.2.0.118.0.0.019.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',
...
}
Default value: undef
zip_extract
Data type: Boolean
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
Default value: true
user_password
Data type: Optional[String[1]]
Default value: undef
logoutput
Data type: Variant[Boolean, Enum['on_failure']]
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::installem
ora_install::installem
Here is an example on how to use this:
ora_install::installem{ 'em13200':
version => '13.2.0.0',
file => 'em13200p1_linux64',
oracle_base_dir => '/u01/app/oracle',
oracle_home_dir => '/u01/app/oracle/product/13.2.0.0/em_home1',
agent_base_dir => '/u01/app/oracle/agent',
software_library_dir => '/u01/app/oracle/swlib',
weblogic_user => 'weblogic',
weblogic_password => 'Welcome01',
database_hostname => 'em1320.example.com',
database_listener_port => 1521,
database_service_sid_name => 'EM122.domain.local',
database_sys_password => 'Welcome01',
sysman_password => 'Welcome01',
agent_registration_password => 'Welcome01',
deployment_size => 'SMALL',
user => 'oracle',
group => 'oinstall',
download_dir => '/install',
zip_extract => true,
puppet_download_mnt_point => 'puppet:///modules/software',
logoutput => true,
}
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::installem defined type:
admin_server_https_portagent_base_diragent_portagent_registration_passwordbi_publisher_http_portbi_publisher_https_portdatabase_hostnamedatabase_listener_portdatabase_service_sid_namedatabase_sys_passworddeployment_sizedownload_direm_central_console_http_portem_central_console_https_portem_upload_http_portem_upload_https_portfilegrouplogoutputmanaged_server_http_portmanaged_server_https_portnodemanager_https_portora_inventory_diroracle_base_diroracle_home_dirpuppet_download_mnt_pointsoftware_library_dirswonlysysman_passwordtemp_diruserversionweblogic_passwordweblogic_userzip_extracttablespace_locationallow_insecure
admin_server_https_port
Data type: Integer
The https IP port from the WLS Admin server.
The default value is: 7101
Default value: 7101
agent_base_dir
Data type: Stdlib::Absolutepath
The directory to use as base for the agent software.
Default value: undef
agent_port
Data type: Integer
The IP port to use to for the agent.
The default value is: 3872
Default value: 3872
agent_registration_password
Data type: Easy_type::Password
The password to use to register the agent.
bi_publisher_http_port
Data type: Integer
The http port to use for the BI Publisher.
The default value is: 9701
Default value: 9701
bi_publisher_https_port
Data type: Integer
The https port to use for the BI Publisher.
The default value is: 9801
Default value: 9801
database_hostname
Data type: String[1]
The DNS name of the database host.
Default value: undef
database_listener_port
Data type: Integer
The IP port for the database listener.
The default value is: 1521
Default value: 1521
database_service_sid_name
Data type: String[1]
The database service SID name for the database.
Default value: undef
database_sys_password
Data type: Easy_type::Password
The password of the SYS user of the database.
deployment_size
Data type: Enum['SMALL','MEDIUM','LARGE']
The size of the deployment. Valid values are:
SMALLMEDIUMLARGEThe default value is:SMALL
Default value: 'SMALL'
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
em_central_console_http_port
Data type: Integer
The port number of the HTTP port for the central console.
The default value is: 7788
Default value: 7788
em_central_console_https_port
Data type: Integer
The port number of the HTTPS port for the central console.
The default value is: 7799
Default value: 7799
em_upload_http_port
Data type: Integer
The port number of the HTTP port for the upload service.
The default value is: 1159
Default value: 4889
em_upload_https_port
Data type: Integer
The port number of the HTTPS port for the upload service.
The default value is: 4889
Default value: 1159
file
Data type: String[1]
The source file to use.
Default value: undef
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'oinstall'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
managed_server_http_port
Data type: Integer
The port number of the HTTP port for the Managed server.
The default value is: 7201
Default value: 7201
managed_server_https_port
Data type: Integer
The port number of the HTTPS port for the Managed server.
The default value is: 7301
Default value: 7301
nodemanager_https_port
Data type: Integer
The port number of the HTTPS port for the Node manager.
The default value is: 7401
Default value: 7401
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
The default value is: /oracle_base/oraInventory
Default value: undef
oracle_base_dir
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
oracle_home_dir
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
puppet_download_mnt_point
Data type: String[1]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
software_library_dir
Data type: Stdlib::Absolutepath
The directory to use for the software library.
Default value: undef
swonly
Data type: Boolean
Only install the software without configuration (true) or not (false).
The default value is: false
Default value: false
sysman_password
Data type: Easy_type::Password
The password to use for sysman.
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
user
Data type: String[1]
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
Default value: 'oracle'
version
Data type: Enum[ '12.1.0.4', '12.1.0.5', '13.1.0.0', '13.2.0.0', '13.3.0.0', '13.4.0.0', '13.5.0.0' ]
Default value: '12.1.0.5'
weblogic_password
Data type: Easy_type::Password
The password to use for WebLogic.
weblogic_user
Data type: String[1]
The username to use for WebLogic.
The default value is: weblogic
Default value: 'weblogic'
zip_extract
Data type: Boolean
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
Default value: true
tablespace_location
Data type: Optional[String[1]]
Default value: undef
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::installem_agent
ora_install::installem_agent
This defined type supports the following versions of Enterprise Manager:
- 12.1.0.4
- 12.1.0.5
- 13.1.0.0
- 13.2.0.0
- 13.3.0.0
- 13.3.0.0
- 13.4.0.0
- 13.5.0.0
Here is an example:
ora_install::installem_agent{ 'Install em agent':
version => '13.2.0.0',
install_type => 'agentPull',
install_version => '13.2.0.0.0',
oracle_base_dir => '/u01/app',
agent_base_dir => '/u01/app/agent/product',
agent_instance_home_dir => '/u01/app/agent/product/agent_inst',
agent_registration_password => 'regme',
agent_port => 3872,
sysman_password => 'Welkom01',
oms_host => 'em1320.example.com',
oms_port => 7799,
em_upload_port => 1159,
logoutput => true,
}
The version you want to install.
The default value is: 12.1.0.5.0
The agent version to be installed
12.1.0.412.1.0.513.1.0.013.2.0.0
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::installem_agent defined type:
agent_base_diragent_instance_home_diragent_portagent_registration_passworddownload_direm_upload_portgroupinstall_platforminstall_typeinstall_versionlogoutputoms_hostoms_portora_inventory_diroracle_base_dirsourcesysman_passwordsysman_useruserversiontemp_dirallow_insecure
agent_base_dir
Data type: Stdlib::Absolutepath
The directory to use as base for the agent software.
Default value: undef
agent_instance_home_dir
Data type: Optional[Stdlib::Absolutepath]
The directory to use as instance home.
Default value: undef
agent_port
Data type: Integer
The IP port to use to for the agent.
The default value is: 3872
Default value: 1830
agent_registration_password
Data type: Optional[Easy_type::Password]
The password to use to register the agent.
Default value: undef
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
em_upload_port
Data type: Integer
The port number of the HTTP port for the upload service.
The default value is: 1159
Default value: undef
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'oinstall'
install_platform
Data type: String[1]
The type of platform you want to install.
The default value is: Linux x86-64
Default value: 'Linux x86-64'
install_type
Data type: Enum['agentPull','agentDeploy']
The type of install. valid values are:
undefinedagentPullagentDeployThe default value is:undefined
Default value: undef
install_version
Data type: Enum[ '12.1.0.4.0', '12.1.0.5.0', '13.1.0.0.0', '13.2.0.0.0', '13.3.0.0.0', '13.4.0.0.0', '13.5.0.0.0' ]
Default value: '12.1.0.5.0'
logoutput
Data type: Variant[Boolean, Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
oms_host
Data type: String[1]
The OMS host to use.
Default value: undef
oms_port
Data type: Integer
The IP port to use for connecting to the OMS host.
Default value: undef
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
The default value is: /oracle_base/oraInventory
Default value: undef
oracle_base_dir
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
source
Data type: Optional[String[1]]
The source to use for the installation of the EM agent. Valid values are:
- an URL like:
https://<OMS_HOST>:<OMS_PORT>/em/install/getAgentImage - a local file like:
/tmp/12.1.0.4.0_AgentCore_226_Linux_x64.zip
Default value: undef
sysman_password
Data type: Optional[Easy_type::Password]
The password to use for sysman.
Default value: undef
sysman_user
Data type: String[1]
The sysman user.
The default value is: sysman
Default value: 'sysman'
user
Data type: String[1]
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
Default value: 'oracle'
version
Data type: Enum[ '12.1.0.4', '12.1.0.5', '13.1.0.0', '13.2.0.0', '13.3.0.0', '13.4.0.0', '13.5.0.0' ]
Default value: '12.1.0.5'
temp_dir
Data type: Stdlib::Absolutepath
Default value: '/tmp'
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::listener
ora_install::listener
This defined type is deprecated. Please use db_listener custom type to manage your listener.
Here is an example on how to use this:
ora_install::listener{'start listener':
action => 'start',
oracle_base => '/oracle',
oracle_home => '/oracle/product/11.2/db',
user => 'oracle',
group => 'dba',
listener_name => 'listener'
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::listener defined type:
action
Data type: Enum['running','start','abort','stop']
The action to take. Valid values are:
runningstartabortstopThe default value is:start
Default value: 'start'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
listener_name
Data type: String[1]
The name of the listener process.
The default value is: listener
Default value: 'listener'
oracle_base
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
user
Data type: String[1]
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
Default value: 'oracle'
ora_install::net
ora_install::net
This defined type allows you to install and configure Oracle SQL*net.
ora_install::net{ 'config net8':
oracle_home => '/oracle/product/11.2/db',
version => '11.2',
user => 'oracle',
group => 'dba',
download_dir => '/install',
db_port => 1521,
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::net defined type:
db_port
Data type: Integer
The IP port number to use for connecting to the database.
The default value is: 1521
Default value: 1521
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
user
Data type: String[1]
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
Default value: 'oracle'
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
version
Data type: Ora_install::ShortVersion
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
Default value: '11.2'
listener_name
Data type: String[1]
The name of the listener process.
The default value is: listener
Default value: 'listener'
ora_install::opatch
ora_install::opatch
Please useora_opatch to manage patches of your database software.
Here is an example on how to use this:
ora_install::opatch{'19121551_db_patch':
ensure => 'present',
oracle_product_home => hiera('oracle_home_dir'),
patch_id => '19121551',
patch_file => 'p19121551_112040_Linux-x86-64.zip',
user => hiera('oracle_os_user'),
group => 'oinstall',
download_dir => hiera('oracle_download_dir'),
ocmrf => true,
require => Ora_install::Opatchupgrade['112000_opatch_upgrade_db'],
puppet_download_mnt_point => hiera('oracle_source'),
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::opatch defined type:
bundle_sub_folderbundle_sub_patch_idclusterwaredownload_dirensuregroupocmrforacle_product_homepatch_filepatch_idpuppet_download_mnt_pointremote_fileuserallow_insecure
bundle_sub_folder
Data type: Optional[Integer]
The folder in the zip file used for the specified patch.
Default value: undef
bundle_sub_patch_id
Data type: Optional[Integer]
The subid of the patch.
Default value: undef
clusterware
Data type: Boolean
When true use opatch auto.
Default value false
Default value: false
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
ensure
Data type: Enum[present, absent]
State to obtain. The ensure attribute can be one of two values:
- present
- absent
When you specify
present, Puppet will make sure the resource is available with all specified options and properties. When the resource is already available(installed), and all attributes are as the are specified, Puppet will do nothing. When you specifyabsent, Puppet will remove the resource if it is available. If it is not installed, Puppet will do nothing.
Default value: present
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
ocmrf
Data type: Boolean
Wether or not to use OCMRF file.
The default value is: false
Default value: false
oracle_product_home
Data type: Stdlib::Absolutepath
The Oracle home to use.
Default value: undef
patch_file
Data type: String[1]
The name of the patch file.
Default value: undef
patch_id
Data type: Integer
The ID of the patch to apply.
Default value: undef
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
remote_file
Data type: Optional[Boolean]
DEPRECATED
This parameter is not being used anymore and will be removed in a future release.
true.
Default value: undef
user
Data type: String[1]
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
Default value: 'oracle'
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::opatchupgrade
ora_install::opatchupgrade
For opatchupgrade you need to provide the Oracle support csi_number and supportId and need to be online. Or leave them empty but it needs the Expect rpm to emulate OCM.
Here is an example on how to use this:
ora_install::opatchupgrade{'112000_opatch_upgrade':
oracle_home => '/oracle/product/11.2/db',
patch_file => 'p6880880_112000_Linux-x86-64.zip',
csi_number => '11111',
support_id => 'john.doe@gmail.com',
csi_number => undef,
support_id => undef,
opversion => '11.2.0.3.6',
user => 'oracle',
group => 'dba',
download_dir => '/install',
puppet_download_mnt_point => 'puppet:///modules/software',
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::opatchupgrade defined type:
csi_numberdownload_dirgrouplogoutputopversionoracle_homepatch_filepuppet_download_mnt_pointsupport_idumaskuserallow_insecure
csi_number
Data type: Optional[Integer]
The Customer Service Identification number. This is used to generate an OCMRF file.
Default value: undef
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
opversion
Data type: String[1]
The version of Opatch you want to install.
Default value: undef
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
patch_file
Data type: String[1]
The zip file containing the Opatch utility.
Default value: undef
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
support_id
Data type: Optional[String[1]]
Your support ID. This is used to generate an OCMRF file.
Default value: undef
umask
Data type: String[1]
The umask to use for commands that run in the context of either the grid user or the oracle user.
The default is 0022
Default value: '0022'
user
Data type: String[1]
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
Default value: 'oracle'
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::prepareautostart_for
ora_install::prepareautostart_for
This defined creates the script needed to start the database after a system reboot. It supports both systemd and the older startup scripts.
Here is an example on how to use it:
ora_install::prepareautostart {'DB1':
oracle_home => '/oracle/db1',
user => 'oracle',
service_name => 'start_db1',
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::prepareautostart_for defined type:
oracle_home
Data type: String[1]
A directory to be used as Oracle home directory for this software.
Default value: undef
user
Data type: String[1]
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
Default value: 'oracle'
service_name
The name of the init service to use.
The default value is: dbora
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
ora_install::rcu
ora_install::rcu
Creating a repository
Using this defined class, you can create repositories for several Oracle products. Here are some examples.
Here is an example on how to use it:
SOA suite repository
ora_install::rcu{'install_SOA_v11.1.1.9.0':
rcu_file => 'V75907-01.zip',
product => 'soasuite',
version => '11.1.1.9.0',
oracle_home => '/u01/app/oracle/product/11.2.0.4/db_home1',
user => 'oracle',
group => 'dba',
download_dir => '/install',
action => 'create',
db_server => 'asm112.example.com:1521',
db_service => 'DB112.domain.local',
sys_password => 'Welcome01',
schema_prefix => 'DEV',
repos_password => 'Welcome02',
puppet_download_mnt_point => 'puppet:///modules/software',
}
webcenter repository
ora_install::rcu{'install_WebCenter_11.1.1.7':
rcu_file => 'ofm_rcu_linux_11.1.1.7.0_32_disk1_1of1.zip',
product => 'webcenter',
version => '11.1.1.7',
oracle_home => '/u01/app/oracle/product/11.2.0.4/db_home1',
user => 'oracle',
group => 'dba',
download_dir => '/install',
action => 'create',
db_server => 'asm112.example.com:1521',
db_service => 'DB112.domain.local',
sys_password => 'Welcome01',
schema_prefix => 'DEV',
temp_tablespace => 'TEMP',
repos_password => 'Welcome02',
puppet_download_mnt_point => 'puppet:///modules/software',
}
OIM, OAM repository
OIM needs an Oracle Enterprise Edition database
ora_install::rcu{'install_OIM_11.1.2.1':
rcu_file => 'V37476-01.zip',
product => 'oim',
version => '11.1.2.1',
oracle_home => '/u01/app/oracle/product/11.2.0.4/db_home1',
user => 'oracle',
group => 'dba',
download_dir => '/data/install',
action => 'create',
db_server => 'asm112.example.com:1521',
db_service => 'DB112.domain.local',
sys_password => 'Welcome01',
schema_prefix => 'DEV',
repos_password => 'Welcome02',
puppet_download_mnt_point => 'puppet:///modules/software',
logoutput => true,
}
deleting a repository
You can also use this defined type to delete a repository. To do so, you need te specify delete as action.
Here is an example:
ora_install::rcu{'delete_SOA_11.1.1.6':
rcu_file => 'ofm_rcu_linux_11.1.1.6.0_disk1_1of1.zip',
product => 'soasuite',
version => '11.1.1.6',
oracle_home => '/oracle/product/11.2/db',
user => 'oracle',
group => 'dba',
download_dir => '/install',
action => 'delete',
db_server => 'asm112.example.com:1521',
db_service => 'DB112.domain.local',
sys_password => 'Welcome01',
schema_prefix => 'DEV',
repos_password => 'Welcome02',
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::rcu defined type:
actiondb_serverdb_servicedownload_dirgrouplogoutputoracle_homeproductpuppet_download_mnt_pointrcu_fileremote_filerepos_passwordschema_prefixsys_passwordsys_usertemp_tablespaceuserversionallow_insecure
action
Data type: Enum['create','delete']
The action to perform. Valid actions are:
createdeleteThe default value is:create
Default value: 'create'
db_server
Data type: String[1]
The name of the database server to use.
Default value: undef
db_service
Data type: String[1]
The name of the database service to use.
Default value: undef
download_dir
Data type: Stdlib::Absolutepath
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
Default value: '/install'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
logoutput
Data type: Variant[Boolean,Enum['on_failure']]
log the outputs of Puppet exec or not.
When you specify true Puppet will log all output of exec types.
Valid values are:
truefalseon_failure
Default value: lookup({name => 'logoutput', default_value => 'on_failure'})
oracle_home
Data type: Optional[Stdlib::Absolutepath]
A directory to be used as Oracle home directory for this software.
Default value: undef
product
Data type: Enum['soasuite','webcenter','oam','oim','all']
The name of the product for which you want to install the RCU. The following strings are supported as product:
soasuitewebcenteroamoimallThe default value is:soasuite
Default value: 'soasuite'
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
The default value is: puppet:///modules/ora_install
Default value: undef
rcu_file
Data type: String[1]
The file containing the RCU definition.
Default value: undef
remote_file
Data type: Optional[Boolean]
DEPRECATED
This parameter is not being used anymore and will be removed in a future release.
true.
Default value: true
repos_password
Data type: Easy_type::Password
The password for the repo user.
schema_prefix
Data type: String[1]
The prefix name to use for the schema.
Default value: undef
sys_password
Data type: Easy_type::Password
The password of the SYS user on the database.
sys_user
Data type: String[1]
The name of the SYS user on the database.
The default value is: sys
Default value: 'sys'
temp_tablespace
Data type: Optional[String[1]]
Create a temporary tablespace with this name.
Default value: undef
user
Data type: String[1]
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
Default value: 'oracle'
version
Data type: String[1]
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
Default value: '11.1.1.7'
allow_insecure
Data type: Boolean
Default value: lookup({name => 'allow_insecure', default_value => false})
ora_install::tnsnames
ora_install::tnsnames
ora` file.
Here is an examples on how to use this:
ora_install::tnsnames{'entry':
oracle_home => '/u01/app/oracle/product/12.2.0.1/db_home1',
user => 'oracle',
group => 'dba',
server => { myserver1 => { host => DB122a.example.nl, port => '1521', protocol => 'TCP' },
myserver2 => { host => DB122b.example.nl, port => '1521', protocol => 'TCP' }},
connect_service_name => 'DB122.domain.local',
connect_server => 'DEDICATED',
entry_type => 'tnsname',
}
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::tnsnames defined type:
connect_serverconnect_service_nameentry_typefailovergroup},oracle_homeserveruserloadbalancesid
connect_server
Data type: String[1]
The name of the server to connect to.
Default value: 'DEDICATED'
connect_service_name
Data type: Optional[String[1]]
The name of the service to connect to.
Default value: undef
entry_type
Data type: Enum['tnsname','listener']
The type of entry to manage. You can manage the next type of entries:
tnsnamelistenerThe default value is:tnsname
Default value: 'tnsname'
failover
Data type: String[1]
Failover ON or OFF. Valid values are:
ONOFFThe default value is:ON
Default value: 'ON'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
},
Data type: port=>'1521', protocol=>'TCP'
String[1]] loadbalance Load balance ON or OFF. Valid values are:
ONOFFThe default value is:ON
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
server
Data type: Hash
A Hash defining the server entry. The default value is:
{myserver => { host => undef, port => '1521', protocol => 'TCP' }}
Default value: {myserver => { host => undef, port => '1521', protocol => 'TCP' }}
user
Data type: String[1]
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
Default value: 'oracle'
loadbalance
Data type: String[1]
Default value: 'ON'
sid
Data type: Optional[String[1]]
Default value: undef
ora_install::utils::dborainst
See the file "LICENSE" for the full license governing this code.
== define: ora_install::utils::dborainst
creates oraInst.loc for oracle products
Parameters
The following parameters are available in the ora_install::utils::dborainst defined type:
ora_inventory_dir
Data type: Stdlib::Absolutepath
Default value: undef
os_group
Data type: String[1]
Default value: undef
os_user
Data type: String[1]
Default value: undef
Resource types
db_control
control the database instance state like running,stop,restart
Properties
The following properties are available in the db_control type.
ensure
Valid values: start, stop, running, abort, stopped
Aliases: "running"=>"start", "abort"=>"stop", "stopped"=>"stop"
Whether to do something.
Parameters
The following parameters are available in the db_control type.
db_typegrid_product_home_dirinstance_namenameoracle_product_home_diros_userproviderrefreshonly
db_type
Valid values: database, asm, grid
Aliases: "grid"=>"asm"
The type of instance.
Default value: database
grid_product_home_dir
The grid product home folder.
instance_name
The database instance name.
name
namevar
The title.
oracle_product_home_dir
The oracle product home folder.
os_user
The operating system user.
provider
The specific backend to use for this db_control resource. You will seldom need to specify this --- Puppet will usually
discover the appropriate provider for your platform.
refreshonly
Valid values: true, false
The command should only be run as a refresh mechanism for when a dependent object is changed.
Default value: false
db_directory_structure
add all the directories needed by the oracle db or asm installation
Properties
The following properties are available in the db_directory_structure type.
ensure
Valid values: present
Whether to do something.
Parameters
The following parameters are available in the db_directory_structure type.
create_orainst_only
Valid values: true, false
Only create oraInst.loc file.
Default value: false
download_dir
The download folder.
name
namevar
The title.
ora_inventory_dir
The oracle inventory folder.
oracle_base_dir
The oracle base folder.
os_group
The operating system group.
Default value: oinstall
os_user
The operating system user.
Default value: oracle
provider
The specific backend to use for this db_directory_structure resource. You will seldom need to specify this --- Puppet
will usually discover the appropriate provider for your platform.
db_listener
control the oracle db listener state like running,stop,restart
Parameters
The following parameters are available in the db_listener type.
provider
The specific backend to use for this db_listener resource. You will seldom need to specify this --- Puppet will
usually discover the appropriate provider for your platform.
db_opatch
This is the Oracle Patch process called OPatch
Properties
The following properties are available in the db_opatch type.
ensure
Valid values: present, absent, installed, purged
Aliases: "installed"=>"present", "purged"=>"absent"
Whether a patch should be applied.
Parameters
The following parameters are available in the db_opatch type.
bundle_sub_patch_idextracted_patch_dirnameocmrf_fileopatch_autooracle_product_home_dirorainst_diros_userpatch_idprovider
bundle_sub_patch_id
One of the Sub patch number of the bundle patch
extracted_patch_dir
The extracted patch folder.
name
namevar
The name of the OPatch.
ocmrf_file
The ocmrf file.
opatch_auto
opatch auto bundle patch
oracle_product_home_dir
The oracle product home folder.
orainst_dir
The orainst folder.
os_user
The weblogic operating system user.
patch_id
The patchId of the OPatch.
provider
The specific backend to use for this db_opatch resource. You will seldom need to specify this --- Puppet will usually
discover the appropriate provider for your platform.
db_rcu
This is the Oracle RCU ( Repository creation utility) installer type
Properties
The following properties are available in the db_rcu type.
ensure
Valid values: present, absent, create, delete
Aliases: "create"=>"present", "delete"=>"absent"
Whether a Repository should be created.
Parameters
The following parameters are available in the db_rcu type.
db_server
The database server for the RCU check/install.
db_service
The database service for the RCU check/install.
name
namevar
The prefix of the RCU.
oracle_home
The oracle database home folder.
os_user
The weblogic operating system user.
provider
The specific backend to use for this db_rcu resource. You will seldom need to specify this --- Puppet will usually
discover the appropriate provider for your platform.
statement
The RCU statement.
sys_password
The sys password for the RCU check/install.
sys_user
The sys username for the RCU check/install.
ora_home
This resource allows you to manage Oracle homes.
Properties
The following properties are available in the ora_home type.
ensure
Valid values: present, absent
The basic property that the resource should be in.
Default value: present
Parameters
The following parameters are available in the ora_home type.
provider
The specific backend to use for this ora_home resource. You will seldom need to specify this --- Puppet will usually
discover the appropriate provider for your platform.
ora_install
Start the setup for applying ora_install classes.
Properties
The following properties are available in the ora_install type.
ensure
Valid values: present, absent
The basic property that the resource should be in.
Default value: present
Parameters
The following parameters are available in the ora_install type.
provider
The specific backend to use for this ora_install resource. You will seldom need to specify this --- Puppet will
usually discover the appropriate provider for your platform.
ora_opatch
This resource allows you to manage opatch patches on a specific database home.
Parameters
The following parameters are available in the ora_opatch type.
provider
The specific backend to use for this ora_opatch resource. You will seldom need to specify this --- Puppet will usually
discover the appropriate provider for your platform.
ora_tab_entry
With this type you can manage entries in the systems oratab file.
Here is an example on how to use this:
ora_tab_entry { 'MYDB': ensure => 'present', comment => 'My own database', oracle_home => '/u01/app/oracle/product/12.2.0.1/db_home1', startup => 'Y', }
Properties
The following properties are available in the ora_tab_entry type.
ensure
Valid values: present, absent
The basic property that the resource should be in.
Default value: present
Parameters
The following parameters are available in the ora_tab_entry type.
provider
The specific backend to use for this ora_tab_entry resource. You will seldom need to specify this --- Puppet will
usually discover the appropriate provider for your platform.
Functions
opatch_version
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
Returns the the installed Opatch version for a specfied Oracle home
opatch_version(String $oracle_home)
See the file "LICENSE" for the full license governing this code.
Returns the the installed Opatch version for a specfied Oracle home
Returns: String
oracle_home
Data type: String
ora_install::changed_oracle_home_for
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
This function checks if the specified home, is the current home for the specified SID.
ora_install::changed_oracle_home_for(String[1,8] $sid, String[1] $oracle_home)
See the file "LICENSE" for the full license governing this code.
This function checks if the specified home, is the current home for the specified SID.
Returns: Variant[Boolean, Undef]
sid
Data type: String[1,8]
oracle_home
Data type: String[1]
ora_install::opatch_version
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
Returns the the installed Opatch version for a specfied Oracle home
ora_install::opatch_version(String $oracle_home)
See the file "LICENSE" for the full license governing this code.
Returns the the installed Opatch version for a specfied Oracle home
Returns: String
oracle_home
Data type: String
ora_install::ora_patches_installed
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
This function checks if the specfied patches are installed. The patch list is an array and has the syntax
['/oracle/home/dir:patchid']
It will check all registered Oracle homes for the installed patches.
ora_install::ora_patches_installed(Array $patch_list)
See the file "LICENSE" for the full license governing this code.
This function checks if the specfied patches are installed. The patch list is an array and has the syntax
['/oracle/home/dir:patchid']
It will check all registered Oracle homes for the installed patches.
Returns: Boolean
patch_list
Data type: Array
ora_install::ora_patches_missing
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
This function checks if the specfied patches are installed. For type = db (default) the function will return a hash with all homes and their patch details that needs at least one patch installed. For type = grid the function will return a hash with only patches that haven't been installed yet. There is a difference because of the way patches are applied for grid, opatchauto vs regular provider.
It will check all registered Oracle homes for the installed patches.
ora_install::ora_patches_missing(Hash $patch_list, Optional[String] $type)
See the file "LICENSE" for the full license governing this code.
This function checks if the specfied patches are installed. For type = db (default) the function will return a hash with all homes and their patch details that needs at least one patch installed. For type = grid the function will return a hash with only patches that haven't been installed yet. There is a difference because of the way patches are applied for grid, opatchauto vs regular provider.
It will check all registered Oracle homes for the installed patches.
Returns: Hash
patch_list
Data type: Hash
type
Data type: Optional[String]
ora_install::ora_physical_patches
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
This function parses a Hash of patches and looks for resources with sub_patches. If they are there, this function will translate it to the actual list of patches that need to be on the system.
ora_install::ora_physical_patches(Hash $patch_list)
See the file "LICENSE" for the full license governing this code.
This function parses a Hash of patches and looks for resources with sub_patches. If they are there, this function will translate it to the actual list of patches that need to be on the system.
Returns: Array
patch_list
Data type: Hash
ora_install::oracle_exists
Type: Ruby 4.x API
The ora_install::oracle_exists function.
ora_install::oracle_exists(String $oracle_home)
The ora_install::oracle_exists function.
Returns: Boolean
oracle_home
Data type: String
ora_patches_installed
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
This function checks if the specfied patches are installed. The patch list is an array and has the syntax
['/oracle/home/dir:patchid']
It will check all registered Oracle homes for the installed patches.
ora_patches_installed(Array $patch_list)
See the file "LICENSE" for the full license governing this code.
This function checks if the specfied patches are installed. The patch list is an array and has the syntax
['/oracle/home/dir:patchid']
It will check all registered Oracle homes for the installed patches.
Returns: Boolean
patch_list
Data type: Array
ora_physical_patches
Type: Ruby 4.x API
See the file "LICENSE" for the full license governing this code.
This function parses a Hash of patches and looks for resources with sub_patches. If they are there, this function will translate it to the actual list of patches that need to be on the system.
ora_physical_patches(Hash $patch_list)
See the file "LICENSE" for the full license governing this code.
This function parses a Hash of patches and looks for resources with sub_patches. If they are there, this function will translate it to the actual list of patches that need to be on the system.
Returns: Array
patch_list
Data type: Hash
oracle_exists
Type: Ruby 4.x API
The oracle_exists function.
oracle_exists(String $oracle_home)
The oracle_exists function.
Returns: Boolean
oracle_home
Data type: String
Data types
Ora_install::ShortVersion
The Ora_install::ShortVersion data type.
Alias of
Enum['11.2', '12.1', '12.2', '18.0', '19.0', '21.0']
Ora_install::Version
The Ora_install::Version data type.
Alias of
Enum['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', '21.0.0.0']
Tasks
agent_action
Enable, disable or start a puppet agent run.
Supports noop? false
Parameters
action
Data type: Enum['enable','disable','run']
The action to do on the agent.
comment
Data type: Optional[String[1]]
The comment to use when disabling puppet runs.
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
apply_psu_db
Execute the PSU database update for specified SID.
Supports noop? false
Parameters
sid
Data type: String[1,8]
SID of the database to connect to.
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
db_action
Execute an action pn the specified Oracle instance
Supports noop? false
Parameters
sid
Data type: Optional[String[1]]
SID of the database to connect to
action
Data type: Enum['start', 'stop', 'restart']
The action that needs to be executed on the database
type
Data type: Optional[Enum['immediate', 'abort', 'nomount', 'normal', 'mount', 'restrict', 'open', 'open recover', 'upgrade']]
Type of action
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
grid_action
Execute actions (stop/start) on Oracle Grid installations for patching.
Supports noop? false
Parameters
action
Data type: Enum['start', 'stop']
The action that needs to be executed
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
listener_action
Execute an action on the Oracle listener
Supports noop? false
Parameters
sid
Data type: Optional[String[1]]
SID of the database the listener is running for
action
Data type: Enum['start', 'stop', 'restart']
The action that needs to be executed on the database
listener_name
Data type: Optional[String[1]]
Name of the listener
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
opatch_upgrade
Apply patch(es) to an Oracle home.
Supports noop? false
Parameters
oracle_home
Data type: String[1]
The Oracle home to patch.
patch_file
Data type: Optional[String[1]]
The file needed to upgrade OPatch.
opatch_version
Data type: Optional[String[1]]
The version of OPatch to install.
patch_list
Data type: Hash
The list of patches to apply.
source
Data type: String[1]
The location where the patch files can be found.
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
restart
Restart the specified Oracle instance on the specified node
Supports noop? false
Parameters
sid
Data type: Optional[String[1]]
SID of the database to connect to
shutdown_type
Data type: Optional[Enum['abort', 'immediate', 'normal', 'transactional', 'transactional local']]
Type of shutdown
startup_type
Data type: Optional[Enum['nomount', 'mount', 'restrict', 'open recover']]
Type of startup
shutdown
Shutdown the specified Oracle instance on the specified node
Supports noop? false
Parameters
sid
Data type: Optional[String[1]]
SID of the database to connect to
type
Data type: Optional[Enum['abort', 'immediate', 'normal', 'transactional', 'transactional local']]
Type of shutdown
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
planned
Data type: Optional[Boolean]
Task is part of plan.
startup
Startup the specified Oracle instance on the specified node
Supports noop? false
Parameters
sid
Data type: Optional[String[1]]
SID of the database to connect to
type
Data type: Optional[Enum['nomount', 'mount', 'restrict', 'open recover', 'upgrade']]
Type of shutdown
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
switch_grid_home
Switch a running instance to an other already available Oracle home.
Supports noop? false
Parameters
sid
Data type: Optional[String[1,8]]
SID of the database to connect to.
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
new_home
Data type: String[1]
The new Oracle home for the sid.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
switch_oracle_home
Switch a running instance to an other already available Oracle home.
Supports noop? false
Parameters
sid
Data type: String[1,8]
SID of the database to connect to.
verbose
Data type: Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]
The level of verbosity to use.
new_home
Data type: String[1]
The new Oracle home for the sid.
format
Data type: Optional[Enum['pretty','json']]
Format of the output.
upgrade_db
Execute the database upgrade for specified SID.
Supports noop? false
Parameters
sid
Data type: String[1,8]
SID of the database to connect to.
Plans
ora_install::install_grid_home_and_patch
See the file "LICENSE" for the full license governing this code.
++--++
--++--
Examples
bolt plan run ora_install::install_grid_home_and_patch -t localhost version=19.0.0.0 file=LINUX.X64_193000_grid_home grid_type=HA_SWONLY grid_base=/u01/app/grid/admin grid_home=/u01/app/grid/product/19.0.0.0/grid_home2 ora_inventory_dir=/u01/app puppet_download_mnt_point=/nfs_share/software sys_asm_password=secret asm_monitor_password=secret patch_file=p6880880_190000_Linux-x86-64.zip opversion=12.2.0.1.17 patch_list='{"/u01/app/grid/product/19.0.0.0/grid_home2:30116789": {"source": "/nfs_share/software/p30116789_190000_Linux-x86-64.zip", "sub_patches": ["30125133","30122149","30122167","29401763"]}}'
Parameters
The following parameters are available in the ora_install::install_grid_home_and_patch plan:
dbserversys_asm_passwordasm_monitor_passwordversionfilegrid_typestand_alonegrid_basegrid_homeora_inventory_diruseruser_base_dirgroupgroup_installgroup_opergroup_asmdownload_dirtemp_dirzip_extractinstall_taskpuppet_download_mnt_pointdirspatch_filecsi_numbersupport_idopversionsourcepatch_listformat
dbserver
Data type: TargetSpec
The target for this plan.
sys_asm_password
Data type: String[1]
The password to use for the SYSASM user.
asm_monitor_password
Data type: String[1]
The password for the ASMSNMP user for monitoring in EM.
version
Data type: Ora_install::Version
The version that is installed in the used Oracle home.
Default value: undef
file
Data type: String[1]
The source file to use for the GRID_HOME installation.
Default value: undef
grid_type
Data type: Enum['CRS_CONFIG','HA_CONFIG','UPGRADE','CRS_SWONLY','HA_SWONLY']
The type of grid.
Default value: 'HA_CONFIG'
stand_alone
Data type: Boolean
Configuring Grid Infrastructure for a Stand-Alone Server.
Default value: true
grid_base
Data type: Stdlib::Absolutepath
The directory to use as grid base.
Default value: undef
grid_home
Data type: Stdlib::Absolutepath
The directory to use as grid home.
Default value: undef
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
Default value: undef
user
Data type: String[1]
The user used for the specified installation.
Default value: 'grid'
user_base_dir
Data type: Stdlib::Absolutepath
The directory to use as base directory for the users.
Default value: '/home'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
Default value: 'asmdba'
group_install
Data type: String[1]
The os group to use for installation.
Default value: 'oinstall'
group_oper
Data type: String[1]
The OS group to allow ASM oper operations.
Default value: 'asmoper'
group_asm
Data type: String[1]
The OS group to use.
Default value: 'asmadmin'
download_dir
Data type: Stdlib::Absolutepath
The directory where the Puppet software puts all downloaded files.
Default value: '/install'
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
zip_extract
Data type: Boolean
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.
Default value: true
install_task
Data type: Enum['ALL','EXTRACT','SETUP']
The task the installation should execute.
Default value: 'ALL'
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
Default value: undef
dirs
Data type: Optional[Array[Stdlib::Absolutepath]]
Directories that should be created in this plan. For example the parent directory (tree) of the GRID_HOME.
Default value: []
patch_file
Data type: String[1]
The zip file containing the Opatch utility.
Default value: undef
csi_number
Data type: Optional[Integer]
The Customer Service Identification number.
Default value: undef
support_id
Data type: Optional[String[1]]
Your support ID.
Default value: undef
opversion
Data type: String[1]
The version of Opatch you want to install.
Default value: undef
source
Data type: Optional[String[1]]
The source of the patch. Can be either an extracted folder or the raw zip file.
Default value: undef
patch_list
Data type: Hash
List of patches to apply.
Options:
- source
String[1]: Full path to the zipfile that contains the patch - sub_patches
Array: List of patch numbers that are part of the patchset
Default value: {}
format
Data type: Optional[Enum['json','pretty']]
Specify the format of the output, human readable (pretty) or not (json).
Default value: 'pretty'
ora_install::install_oracle_home
See the file "LICENSE" for the full license governing this code.
++--++
--++--
Examples
bolt plan run ora_install::install_oracle_home -t localhost version=18.0.0.0 file=LINUX.X64_180000_db_home oracle_base=/u01/app/oracle/admin oracle_home=/u01/app/oracle/product/18.0.0.0/db_home2 ora_inventory_dir=/u01/app puppet_download_mnt_point=/nfs_share/software
Parameters
The following parameters are available in the ora_install::install_oracle_home plan:
dbserverversionoracle_baseoracle_homefileusergroupgroup_installgroup_operdatabase_typedownload_dirtemp_dirdirscluster_nodesora_inventory_dirpuppet_download_mnt_pointformat
dbserver
Data type: TargetSpec
The target for this plan.
version
Data type: Ora_install::Version
The version that is installed in the used Oracle home.
Default value: undef
oracle_base
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
file
Data type: String[1]
The source file to use for the ORACLE_HOME installation.
Default value: undef
user
Data type: String[1]
The user used for the specified installation.
Default value: 'oracle'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
Default value: 'dba'
group_install
Data type: String[1]
The os group to use for installation.
Default value: 'oinstall'
group_oper
Data type: String[1]
The OS group to allow operator rights.
Default value: 'oper'
database_type
Data type: Enum['SE2', 'SE', 'EE', 'SEONE']
Selects the type of database you want to install.
Default value: 'EE'
download_dir
Data type: Stdlib::Absolutepath
The directory where the Puppet software puts all downloaded files.
Default value: '/install'
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
dirs
Data type: Optional[Array[Stdlib::Absolutepath]]
Directories that should be created in this plan. For example the parent directory (tree) of the GRID_HOME.
Default value: []
cluster_nodes
Data type: Optional[String[1]]
A comma seperated list of the nodes running in the RAC cluster.
Default value: undef
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
Default value: '/u01/app'
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
Default value: 'puppet:///modules/software'
format
Data type: Optional[Enum['json','pretty']]
Specify the format of the output, human readable (pretty) or not (json).
Default value: 'pretty'
ora_install::install_oracle_home_and_patch
See the file "LICENSE" for the full license governing this code.
++--++
--++--
Examples
bolt plan run ora_install::install_oracle_home_and_patch -t localhost version=18.0.0.0 file=LINUX.X64_180000_db_home oracle_base=/u01/app/oracle/admin oracle_home=/u01/app/oracle/product/18.0.0.0/db_home2 ora_inventory_dir=/u01/app puppet_download_mnt_point=/nfs_share/software patch_file=p6880880_190000_Linux-x86-64.zip opversion=12.2.0.1.17 patch_list='{"/u01/app/oracle/product/18.0.0.0/db_home2:30116795": {"source": "/nfs_share/software/p30116795_180000_Linux-x86-64.zip", "sub_patches": ["30112122","30113775"]}}'
Parameters
The following parameters are available in the ora_install::install_oracle_home_and_patch plan:
dbserverversionoracle_baseoracle_homefileusergroupgroup_installgroup_operdatabase_typedownload_dirtemp_dirdirscluster_nodesora_inventory_dirpuppet_download_mnt_pointpatch_filecsi_numbersupport_idopversionsourcepatch_listformat
dbserver
Data type: TargetSpec
The target for this plan.
version
Data type: Ora_install::Version
The version that is installed in the used Oracle home.
Default value: undef
oracle_base
Data type: Stdlib::Absolutepath
A directory to use as Oracle base directory.
Default value: undef
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
file
Data type: String[1]
The source file to use for the ORACLE_HOME installation.
Default value: undef
user
Data type: String[1]
The user used for the specified installation.
Default value: 'oracle'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
Default value: 'dba'
group_install
Data type: String[1]
The os group to use for installation.
Default value: 'oinstall'
group_oper
Data type: String[1]
The OS group to allow operator rights.
Default value: 'oper'
database_type
Data type: Enum['SE2', 'SE', 'EE', 'SEONE']
Selects the type of database you want to install.
Default value: 'EE'
download_dir
Data type: Stdlib::Absolutepath
The directory where the Puppet software puts all downloaded files.
Default value: '/install'
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
dirs
Data type: Optional[Array[Stdlib::Absolutepath]]
Directories that should be created in this plan. For example the parent directory (tree) of the GRID_HOME.
Default value: []
cluster_nodes
Data type: Optional[String[1]]
A comma seperated list of the nodes running in the RAC cluster.
Default value: undef
ora_inventory_dir
Data type: Optional[Stdlib::Absolutepath]
The directory that contains the oracle inventory.
Default value: '/u01/app'
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
Default value: 'puppet:///modules/software'
patch_file
Data type: String[1]
The zip file containing the Opatch utility.
Default value: undef
csi_number
Data type: Optional[Integer]
The Customer Service Identification number.
Default value: undef
support_id
Data type: Optional[String[1]]
Your support ID.
Default value: undef
opversion
Data type: String[1]
The version of Opatch you want to install.
Default value: undef
source
Data type: Optional[String[1]]
The source of the patch. Can be either an extracted folder or the raw zip file.
Default value: undef
patch_list
Data type: Hash
List of patches to apply.
Options:
- source
String[1]: Full path to the zipfile that contains the patch - sub_patches
Array: List of patch numbers that are part of the patchset
Default value: {}
format
Data type: Optional[Enum['json','pretty']]
Specify the format of the output, human readable (pretty) or not (json).
Default value: 'pretty'
ora_install::opatch_upgrade
See the file "LICENSE" for the full license governing this code.
++--++
--++--
Examples
bolt plan run ora_install::opatch_upgrade -t localhost oracle_home=/u01/app/oracle/product/18.0.0.0/db_home2 patch_file=p6880880_190000_Linux-x86-64.zip opversion=12.2.0.1.17 puppet_download_mnt_point=/nfs_share/software
Parameters
The following parameters are available in the ora_install::opatch_upgrade plan:
dbserveroracle_homepatch_filecsi_numbersupport_idopversionusergroupdownload_dirpuppet_download_mnt_pointformat
dbserver
Data type: TargetSpec
The target for this plan.
oracle_home
Data type: Stdlib::Absolutepath
A directory to be used as Oracle home directory for this software.
Default value: undef
patch_file
Data type: String[1]
The zip file containing the Opatch utility.
Default value: undef
csi_number
Data type: Optional[Integer]
The Customer Service Identification number.
Default value: undef
support_id
Data type: Optional[String[1]]
Your support ID.
Default value: undef
opversion
Data type: String[1]
The version of Opatch you want to install.
Default value: undef
user
Data type: String[1]
The user used for the specified installation.
Default value: 'oracle'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
Default value: 'dba'
download_dir
Data type: Stdlib::Absolutepath
The directory where the Puppet software puts all downloaded files.
Default value: '/install'
puppet_download_mnt_point
Data type: Optional[String[1]]
The base path of all remote files for the defined type or class.
Default value: undef
format
Data type: Optional[Enum['json','pretty']]
Specify the format of the output, human readable (pretty) or not (json).
Default value: 'pretty'
ora_install::patch_home
See the file "LICENSE" for the full license governing this code.
++--++
--++--
Examples
bolt plan run ora_install::patch_home -t localhost patch_list='{"/u01/app/oracle/product/18.0.0.0/db_home2:30116795": {"source": "/nfs_share/software/p30116795_180000_Linux-x86-64.zip", "sub_patches": ["30112122","30113775"]}}'
Parameters
The following parameters are available in the ora_install::patch_home plan:
dbserver
Data type: TargetSpec
The target for this plan.
install_group
Data type: String[1]
The os group to use for installation.
Default value: 'oinstall'
os_user
Data type: String[1]
The user used for the specified installation.
Default value: 'oracle'
source
Data type: Optional[String[1]]
The source of the patch. Can be either an extracted folder or the raw zip file.
Default value: undef
patch_list
Data type: Hash
List of patches to apply.
Options:
- source
String[1]: Full path to the zipfile that contains the patch - sub_patches
Array: List of patch numbers that are part of the patchset
Default value: {}
tmp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/install'
format
Data type: Optional[Enum['json','pretty']]
Specify the format of the output, human readable (pretty) or not (json).
Default value: 'pretty'
ora_install::switch_home_and_apply_psu
See the file "LICENSE" for the full license governing this code.
++--++
--++--
Examples
bolt plan run ora_install::switch_home_and_apply_psu -t localhost sid=DB180 new_home=/u01/app/oracle/product/18.0.0.0/db_home2
Parameters
The following parameters are available in the ora_install::switch_home_and_apply_psu plan:
dbserver
Data type: TargetSpec
The target for this plan.
sid
Data type: String[1]
The SID of the database that should be switched.
new_home
Data type: Stdlib::Absolutepath
The ORACLE_HOME where the database should be switched to.
format
Data type: Optional[Enum['json','pretty']]
Specify the format of the output, human readable (pretty) or not (json).
Default value: 'pretty'
verbose
Data type: Optional[Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]]
The level of verbosity to use.
Default value: 'info'
ora_install::switch_home_asm
See the file "LICENSE" for the full license governing this code.
++--++
--++--
Examples
bolt plan run ora_install::switch_home_asm -t localhost new_home=/u01/app/grid/product/19.0.0.0/grid_home2
Parameters
The following parameters are available in the ora_install::switch_home_asm plan:
dbserver
Data type: TargetSpec
The target for this plan.
new_home
Data type: Stdlib::Absolutepath
The ORACLE_HOME where the database should be switched to.
format
Data type: Optional[Enum['json','pretty']]
Specify the format of the output, human readable (pretty) or not (json).
Default value: 'pretty'
verbose
Data type: Optional[Optional[Enum['debug', 'info', 'notice', 'warning', 'err', 'alert', 'emerg', 'crit']]]
The level of verbosity to use.
Default value: 'info'
What are tasks?
Modules can contain tasks that take action outside of a desired state managed by Puppet. It’s perfect for troubleshooting or deploying one-off changes, distributing scripts to run across your infrastructure, or automating changes that need to happen in a particular order as part of an application deployment.
Tasks in this module release
Version updates
5.14.1
[installdb] Also use umask for oracle_context [opatchupgrade] Add parameter umask for execs [net] Add parameter umask for execs [installdb] Add parameter umask for execs [installasm] Add parameter umask for execs [goldengate] Add parameter umask for execs [client] Add parameter umask for execs [publish] fix length of summary info
5.14.0
- [facts] Add os_user, open_mode and role to ora_install_homes fact
5.13.0
[docs] Updated supported version numbers and regenerate REFERENCE.md [core] Add support for Oracle 21c grid infra (#149) [core] Add support for Oracle 21c client (#150) [core] Add support for Oracle 21c database (#147) [installem_agent] Update supported versions in documentation [opatchupgrade] Remove old OPatch first, extract as root and set permissions afterwards
5.12.3
- [db_control] Also stop the daemon processes in specified home and sid
5.12.2
- [ora_install_homes] Fix whitespacing issue
5.12.1
- [ora_install_homes] Fix when oracle homes are substrings
5.12.0
- [installem/installem_agent] Add support for EM 13.4 and 13.5
5.11.2
-[opatchupgrade] Fix error when nice title is specified
5.11.1
- [database] Add dbca response files for Oracle 18 and Oracle 19
5.11.0
- [core] Fix loadpath when gathering facts
- [installdb] Fix noexec mount option on if needed
- [ora_patches_missing] Accomodate patching Grid Infrastructure
5.10.2
- [core] Ensure correct loading of all ruby code independant of order
- [installdb] Fix duplicate declaration
- [quality] Fix puppet 4 unit tests
- [plans/patch_home] Fix deprecation message on ora_patches_installed
- [plans] Add selective module sync to all plans using puppet apply function
5.10.1
- [release] Add playground link to README
- [database] Add LD_LIBRARY_PATH as variable
5.10.0
- [opatchupgrade] Use namespaced opatch_version function
- [facts] Add running_listeners to ora_install_homes fact
5.9.0
- [release] Support puppet 7
5.8.1
- [core] Use namespaced oracle_exists function
5.8.0
- [core] Functions refactor, ora_install namespace added
5.7.0
- [core] Add easy_type::debug_evaluation to all classes
5.6.0
- [functions] Fix issue when removing patches
- [installem] Add support for software only install of Enterprise Manager
- [installem_agent] Fix issues on systems with noexec set on /tmp
5.5.10
- [db_rcu] Fix connection when TNS_ADMIN is set
- [db_control] Fix connection when TNS_ADMIN is set
5.5.9
- [database] Fix interpolation of template content
- [ora_opatch] Remove created directory directly
5.5.8
- Just a release
5.5.7
- [opatchupgrade] Fix typo in title
5.5.6
- [opatchupgrade] Fix error when nice title is specified
- [ora_opatch] Fix nul error when no sub_patches are specified
5.5.5
- [ora_patches_missing] Remove byebug
5.5.4
- [ora_patches_missing] Fix when no sub_patches are specified
- [ora_opatch] Fail when sub_patches include main patch_id
5.5.3
- [facts] Fix Invalid opatch version
5.5.2
- [installdb] cleanup created response file
- [facts] Better cleanup of files created by opatch lsinventory
- [database] Only create the template when we need it
- [net] Only create the response file when we need it
5.5.1
- [db_directory_structure] Add create_orainst_only parameter to type
- [dborainst] Use db_directory_structure to create oraInst.loc
- [client/goldengate/installasm/installdb/installem] Add os_user param
- [ora_patches_installed] Don't fail on non existing oracle home
5.5.0
- [functions] Add function that returns from the patchlist only the part of the hash with the homes that need to be patched
- [net] Add listener_name and make resources more unique [ch370]
- [functions] Add function that returns from the patchlist only the part of the hash with the homes that need to be patched
5.4.1
- [installdb] Fix duplicate properties for epp files
5.4.0
- [core] Replaces add erb templates for epp templates
- [installdb] Allow to install multiple oracle homes (of same version)
5.3.4
- [database] Fix typos in snmp password parameters to dbca
- [installasm] Fail when grid_type is HA_SWONLY on Linux and SunOS
5.3.3
- [ora_physical_patches] Take ensure => absent into account
- [plans] Add documentation And some minor changes to make the plan consistent.
- [facts] Fix determination of Opatch version on Oracle 19 systems
- [release] fixtures dependencies fix
5.3.2
- [release] puppet-archive dependency fix
- [database_pluggable] Use Sensitive data type for passwords
- [client] Better template for Oracle 19
5.3.1
- [installdb] Fix installation on RHEL8
5.3.0
- [installasm] Add support for bash_additions
- [installdb] Add support for bash_additions
- [plans] Add plans and tasks to install and patch new oracle and grid homes
- [bolt] Add tasks and plan to switch grid home
5.2.0
- [core] Add parameter allow_insecure for inscure ssl downloads
5.1.2
- [database] add quote’s arround password’s
5.1.1
- [release] Fix module dependencies
5.1.0
- [client] Add support for Oracle 19 client installtion
- [database] make asm and db snp passwords optional
5.0.0
To ensure secure operations, ss of this release all password must be Puppet data type Sensitive. This ensures that Puppet keeps these values safe.
- [core] Generate passwords for unspecfied passwords
- [core] Use Sentive data type for passwords
4.11.1
- [installasm] Change name of db_directory_structure and always call it
4.11.0
- [core] Add support for RHEL 8
- [facts] Fix error when inventory XML contains home with subelements
- [installasm] Allow for staged install in order to apply patches in between
- [installasm/installdb] Manage .bash_profile regardless if sw is installed
4.10.0
- [manifests] Remove notify’s
- [goldengate] Add support for version 18 and 19
4.9.1
- [db_control] Properly unset TWO_TASK
4.9.0
- [installasm] Expose GIMR database (MGMTDB) options
- [dbcontrol] unset TWO_TASK added to dbcontrol
4.8.3
- [core] Rename version 19.3.0.0 to 19.0.0.0
4.8.2
- [db_control] fix connect statement
4.8.1
- [db_control] specifically set NLS_LANG: in case the system NLS_LANGUAGE setting is something else
- [db_control] no alter session but unzet NLS_LANG
- [db_rcu] Fix when using non-english NLS
- [db_control] Fix when using non-english NLS
- [ora_opatch] Allow reinstallation of incompatible patch
4.8.0
- [ora_opatch] Fix issue when ora_install_homes fact not yet defined
- [installasm] Fix missing parameters for 18 and 19
- [ora_opatch] Add support to remove incompatible patches
4.7.2
- [installasm] Add response file for 19.3 grid install
4.7.1
- [installasm] Fix ASM 19.3 support
4.7.0
- [switch_oracle_home] Add support for RAC home
- [switch_oracle_home] Switch grid home
- [facts] Fix issue where ORACLE_SID is 8 characters long
4.6.1
- [installdb] Add extra checks for Oracle versions on Windows
- [installdb] Remove notice in windows
4.6.0
- [core] Add windows support
4.5.3
- [autostartdatabase] Fix merge issue causing idempotency problems
4.5.2
- [core] Speed up removal of old archive files
4.5.1
- Update metadata to inlcude Oracle 19
4.5.0
- [core] Add Oracle 19 support
4.4.5
- [core] Fix require ordering
4.4.4
- [changed_oracle_home] Fix on initial run
4.4.3
- [facts] Fix when oratab doesn’t exists
4.4.2
- [ora_install_homes] Make fact more resilent for missing Oracle homes
- [core] extracted requires to ensure ordering and constency
4.4.1
- [ora_tab_entry] Make the comment property read-only
4.4.0
- [ora_tab_entry] Fix comments when startup is yes.
- [switch_oracle_home] Initial experimental support for switching homes
- [facts] Fix detection of defined homes
- [core] Detect ASM sids for running sids
- [upgrade_db] Initial implementation of the task
- [apply_psu_db] Initial implementation of the task
- [autostartdatabase] Add support for changing oracle_home
- [changed_oracle_home_for] Fixed lookup of defined sids
- [db_listener] Add support for oracle_home switching
- [changed_oracle_home_for] Initial implementation to detect a changed oracle_home
- [core] Detect ASM sids for running sids
- [autostartdatabase] Add support for changing oracle_home
4.3.3
- [client] Backport support for component selection to Oracle 11
4.3.2
[autostartdatabase] Fix when oratab defined by somebody else
4.3.1
- [autostartdatabase] Suppress warning about startup value
4.3.0
- [autostartdatabase] Use ora_tab_entry for setting startup
- [ora_tab_entry] Initial implementation
4.2.1
- [installasm] Fix PATH variable in bash profile for oracle grid
- [installdb] Fix PATH variable in bash profile for oracle user
- [quality] Fix lint errors
4.2.0
- [client] Add support for custom installs
- [tasks] Update to new way of using module code
4.1.2
- [facts] Fix cleanup when running on WIndows
4.1.1
- [facts] Better cleanup of opatch files
- [facts] Speedup fact resolution for Oracle home
- [facts] Speedup fact resolution when wls facts are also on system
- [tnsnames] fix tests for older ruby versions
4.1.0
[testing] Remove deprecation messages [tnsnames] Add support for services to a sid instead of a service_name [docs] Fixed spelling issues, made formatting more consistent
4.0.2
- [facts] Normalize detection of Oracle os_user
- [ora_opatch] Suppress message when type is not refreshed
4.0.1
- [installem] Add parameter to specify tablespace_location and doc updates
- [ora_opatch] Cleanup files left by older versions of Opatch
- [facts] Cleanup files left by older versions of Opatch
- [docs] Updated supported versions
- [ora_opatch] Add 'OPatchAuto successful' as success string
- [ora_opatch] run as root and fix bug in opatchauto_command
- [installem_agent] Add support for EM 13.3.0.0.0
- [installem] Add support for 13.3
- [ora_install] Fix the opatchauto provider
4.0.0
- [core] Add support for Puppet 6
- [core] Add puppet 6 unit tests
- [ora_opatch] Check for existence of oracle home dir
- [core] Update module summary to include Oracle 18 and Goldengate 12
3.3.0
[goldengate] Add support for 12.3.0
3.2.1
- [opatch] Add support for noocmrf file to auto en opatchauto provider
3.2.0
- [facts] Fix ora_install_homes fact
- [ora_opatch] Add refreshonly parameter to ora_opatch
- [client] Add support for Oracle 18c
3.1.0
- [quality] Fix spec’s for Oracle 18
- [docs] Small changes to the docs for Oracle 18
- [docs] Add Oracle 18c
- [installasm] Add support for Oracle 18c
- [database] Add support for Oracle 18c
- [net] Add support for Oracle 18c
- [installdb] Add support for Oracle 18c
- [database] Add more dbca options for database creation from template
- [docs] Update source docs readability (#54)
- [docs] Add generated docs to the class and defined type header in Puppet strings format
- [autostartdatabase] Use variable for service_name instead of hardcoded value
- [database] Oracle 11g doesn't know the parameter -ignorePrereqs for dbca (#52)
3.0.14
- [functions] Fix error when fact is not present
- [core] Detect faulty oraInventory entry and fail (#51)
- [ora_patches_installed] Added specs
- [oracle_exists] Refactered and added tests and description
- [opatch_version] Fix when no fact is available. Add specs
- [ora_physical_patches] Add unit tests and better description
- [database] Create RAC database from template. Closes #47, closes #46 (#49)
- [core] Move more log statements from info to debug
- [release] Remove Scientific from list of supported OSes
- [spec] Add catalog tests for all supported OS-es
- [specs] Use module from the forge
- [docs] Regenerated documentation with type information and defaults
3.0.13
- [core] Remove all non-UTF characters
3.0.12
- [ora_opatch] Fix usage of standard ocmrf file
- [docs] Add type and defaults
3.0.11
- [db_listener] use Puppet::Util::Execution.execute in stead of backticks (#45)
- [installdb] Oracle 12.1.0.2 doesn't recognise type SE2 but it does SE
3.0.10
- [facts/functions] Use puppet_x functions for ora_install_homes facts and don't exclude agent (#43)
- [core] Use newer version of archive module
- [ora_opatch] Fix passing of standard and absent values for ocmrf_file
- [test] Update tested Puppet versions
- Add module sync (#42)
3.0.9
- [ora_opatch] Set the source_dir to the correct value for a subpatch (#41)
- [installem_agent] Checks the wrong agent home (#40)
- [templates] Fix missing tags in template (#39)
3.0.8
- [develop] Add easy docker environment for development
- [tasks] Add startup and shutdown task
- [db_control] Refacter for usage with tasks
- [release] Fix link to license in readme
3.0.7
- [release] Update the license text
3.0.6
- [core] Add license notice to files
- [README] Updated for publishing on the forge
3.0.5
- Add support for ASM Filter Driver (#38)
- [installasm] Add acceptance test
- [installdb] Add SE2 as options for database_type
- [install_em] Make default value for logoutput 'on_failure'
- [installem_agent] Make default value for logoutput 'on_failure'
- [installasm] Make default value for logoutput 'on_failure'
- [goldengate] Make default value for logoutput 'on_failure'
- [database] Make default value for logoutput 'on_failure'
- [installdb] Make default for logoutput 'on_failure'
3.0.4
- [opatchupgrade] Remove downloaded file (#36)
3.0.3
- [opatchupgrade] Manually remove downloaded file because archive doesn't
- [installs] Set extra variables for temp_dir in install commands
3.0.2
- [database] Fix 12.2 database creation from template
3.0.1
- [oracle_exists] Fix error when fact is undefined
- [client] Don't create a listener
- [ora_patches_installed] Fix name of log source
- [manifests] Make sure archive always extracts zipfiles and use temp_dir
- [facts] Get version of GoldenGate
3.0.0
- migrated all puppet code and facts and functions to Puppet 4/5 only
2.1.12
- [database] Fix usage of sanitized init params
2.1.11
- [installasm] Split storage_option validation per version and puppet doesn't allow empty before
2.1.10
- [opatchupgrade] Fix emocmrsp creation
- [autostartdatabase] Add option to put database under OHAS control in stead of init script
- [installasm] Split 11 from other versions for filenames
- [installasm] Fix issue with older puppet versions(<4.0.0)
- [installasm] Fix error in spec
- [installasm] Support for Oracle ASM 12.2
2.1.9
- [installem_agent] Add mandatory parameters to response file
2.1.8
- [database] Add support for Oracle 12.2
- [installdb] export logoutput from exec's and set default to on_fallure
- [net] Add support for 12.2
- [installdb] Add support for Oracle 12.2
2.1.7
- [ora_install] Add AGENT_BASE_DIR to template em_agent_pull.properties.erb
- [ora_install] Prevent error at first puppet run
- [autostartdatabase] Add support for multiple databases
- [installasm] Add parameter bash_profile
- [database] Add support for template_type
2.1.6
- [goldengate] Add new version to docs
- [db_control] Fix require paths for base class
- [ora_opatch] Add support for puppet generate types
2.1.5
- [core] Update meta information
- [installem_agent] Add support for EM agent version 13+. Closes #7
- [goldengate] Make it pre puppet 4 compatible
2.1.4
- [goldengate] Add support for version 12.2.1
2.1.3
- [core] Source .bashrc in .bash_profile. Closes #6
- [core] Use newer verion of easy_type
2.1.2
- [net] Add tmp_dir parameter and logoutput parameter
- [ora_opatch] Add support for http urls, zips and tars
- [ora_opatch] Fix logic for determining oracle and grid user
- [ora_installed_patches] Improved on the mechanism to find grid and oracle owner
- [opatchupgrade] Fix syntax issue for older puppet versions
- [opatchupgrade] Add support for OPatch 12.2.0.1.5 and 11.2.0.3.14
- [ora_opatch] Add support for OPatch 12.2.0.1.5 and 11.2.0.3.14
- [fuctions] Fix function for Puppet4 compatibility
- [installasm] Fixes syntax error in template. Closes #5
- [ora_opatch] Change mode of the provider code
2.1.1
- [ora_opatch] Added support for puppet:/// syntac for source
- [installem] Add tmp parameter
- [installdb] Add tmp parameter
- [installasm] Add tmp parameter
- [goldengate] Add tmp parameter
- [client] Add tmp parameter
- [core] Use settings from puppet-lint 2
- [core] Lock used gems
- [core] Add geppetto project file
2.1.0
- [ora_opatch] Fix multiple activation of opatch
- [opatchupgrade] Change default mount dir to new value
- [installasm] Add extra template
- [instalasm] Fix old module name
- [documentation] Included full list of site docs
- [database] Fix quoting of sample_schema property
- [ora_opatch] Fix default directory problem on Solaris
- [ora_opatch] Add comment read only property
- [ora_opatch] Fixed directory management of sources
- [ora_opatch] Autodetect os_user and notify when puppet version to old
2.0.5
- [db_control] Fix restart from database when db is down.
- [facts] ora_installed_patches now recognises ASM
- [ora_opatch] When opatch is not installed`, let the fact report an empty set of patches
- [db_control] Fix to adhere to refreshonly
2.0.4
- Puppet 4 compatible for db_listener
- Added function to translate ora_opatch resource list to list of physical patches
2.0.3
- Puppet 4 compatible
- added type ora_opatch and facts and functions to manage patches
2.0.2
- Renamed to enterprisemodules/ora_install
2.0.1
- bash_profile option for database clients
- rcu 11g fix
- 12.1.0.2 oracle client template
- db_listener type refreshonly fix
2.0.0
- All parameters of classes or defines are now in snake case and not in camel case
1.0.35
- Add support for Grid 12.1.0.2 (installasm)
- Fix unsetted vars in dbora template
- Added ability to put listener entries in tnsnames.ora
1.0.34
- autostart fix so it also works for Oracle Linux 5
- rcu prefix compare check fix ( Uppercase )
- RCU fixes for OIM or OAM 11.1.1.2.3
- installem em_upload_port parameter type fix
1.0.33
- Small Suse fix for the autostart service
- new installdb attribute cleanup_installfile
- option to provide the sys username for RCU
1.0.32
- be able to provide a listener name for starting the oracle listener ( manifest and custom type)
1.0.31
- installasm, stand alone parameter in combination with $grid_type == 'CRS_SWONLY' used as standalone or in RAC
- installasm, .profile fix for ORACLE_SID in case grid_type = HA_CONFIG -> +ASM or in grid_type = CRS_CONFIG -> +ASM1
1.0.30
- Removed Oracle Home under base check for ASM installations, in CRS_CONFIG or CRS_SWONLY this is not right
1.0.29
- Custom type for oracle db/asm/client/em directory structure instead of using dirtree and some oradb manifests
1.0.28
- fixed database install rsp 12.1.0.2
- db_listener custom puppet type/provider, listener.pp calls this type
1.0.27
- solaris fix for database.pp and opatch auto
- puppet_download_mnt_point parameter for database.pp which can be used for own db template
1.0.26
- Removed create_user functionality in installdb & client, Puppet should do it instead of oradb module
- Support for 12.1 pluggable database
- init_params of database.pp now also support a hash besides a comma separated string
- Refactored dbstructure so it works with multiple oracle homes
- Goldengate 12.1.2 now uses dbstructure
1.0.25
- added extra parameter validation to installdb, installasm and installem_agent
- opatch fix for opatch bundle zip files which has subfolders in the zip
- owner of the grid home or oracle home folder fix
- renamed clusterware parameter of the opatch type to opatch_auto
- storage_type parameter is now also used in the dbca command when using a database template
- Added ASM 11.2 Database template
1.0.24
- Enterprise Manager agent install with AgentPull & AgentDeploy
- Cleanup install zip files and extracted installation folder in installdb, installasm, installem and client
1.0.23
- Enterprise Manager 12.1.0.4 server installation support
- Support for Solaris 11.2
- autostart service for Solaris
1.0.22
- db_control puppet resource type, start or stop an instance or subscribe to changes like init_param
- Tnsnames change so it supports a TNS balanced configuration
- changed oraInst.loc permissions to 0755
1.0.21
- fix for windows/unix linefeed when oradb is used in combination with vagrant on a windows host
- opatch check bug when run it twice
- Add a tnsnames entry support
1.0.20
- Create a Database instance based on a template
- Be able to change the default listener port 1521 in net.pp & database.pp
- Opatch fix to apply same the patch twice on different oracle homes
1.0.19
- OPatch support for clusterware (GRID)
- Opatchupgrade now works for grid & database on the same node
1.0.18
- Puppet Lint fixes
- Rubocop fixes
- 12.1 Template fix for Oracle RAC
1.0.17
- Fix for puppet 3.7 and more strict parsing
- OPatch also checks for OPatch succeeded
- RAC installation parameters for database, installasm, installdb
1.0.16
- cleanup readme
- asm/grid for 12.1.0.1 & installasm fix for Oracle Restart fix, 11.2.0.1 rsp template fix
1.0.15
- RCU fix for multiple FMW Repositories, installasm fix with zip_extract = false
1.0.14
- Rename some internal manifest to avoid a conflict with orawls
1.0.13
- Oracle Database & Client 12.1.0.2 Support
1.0.11
- database client fix with remote file, set db_snmp_password on a database
1.0.10
- oraInst.loc bug fix, option to skip installdb bash profile
1.0.9
- 11.2 EE install options
1.0.8
- RCU & Opatch fixes in combination with ruby 1.9.3
1.0.7
- Added unit tests and OPatch upgrade support without OCM registration
1.0.6
- Grid install and ASM support
1.0.5
- refactored installdb and support for oinstall groups
1.0.4
- db_rcu native type used in rcu.pp
1.0.2
- db_opatch native type used in opatch.pp
1.0.1
- autostart multiple databases, small fixes
1.0.0
- oracle module add##on for user,role and tablespace creation
0.9.9
- em_configuration parameter for Database creation
0.9.7
- Oracle database 11.2.0.1, 12.1.0.1 client support, refactored installdb,net,goldengate
Dependencies
- puppetlabs-concat (>= 4.0.0 < 7.0.0)
- puppetlabs-powershell (>= 2.3.0 < 3.0.0)
- puppetlabs-stdlib (>= 5.1.0 < 7.0.0)
- puppet-archive (>= 3.2.0 < 5.0.0)
- enterprisemodules/easy_type (>= 2.16.0 < 3.0.0)
Enterprise Modules License d.d. January 2018
This license ("License") governs the terms and conditions under which ora_install module ("the Software")
is licensed by Enterprise Modules B.V, a limited liability company in the Netherlands, registered in
the Dutch Chamber of Commerce: 63689537 ("Licensor"), to the user of the Software ("Licensee").
Article 1. Grant of license
1.1 Licensor hereby grants to Licensee the right to use the Software for its internal business
purposes.
1.2 The license granted in the previous paragraph is limited to the use on VirtualBox Virtual
machines. For further use a commercial license must be directly obtained from Licensor.
Article 2. License limitations
2.1 All right, title and interest to the Software, the accompanying documentation and all
modifications and extensions thereto rest and remain with Licensor. Licensee only has the
rights and permissions explicitly granted by this License or granted in writing otherwise.
Licensee shall not use, copy, modify, distribute or publish the Software in any other manner.
Nothing in this License is intended to, and shall not be construed to, transfer to Licensee any
rights in intellectual property developed by Licensor.
2.2 In particular, Licensee shall not:
a) provide copies of the Software to third parties, including to entities controlling,
controlled by or under common control with Licensee;
b) sublicense the Software or otherwise make available the Software to such third parties,
including by rental, Software-as-a-Service models or otherwise;
c) remove indications of Licensor as copyright holder of the Software or to remove or render
illegible any part thereof.
2.3 The Software comprises third-party open source software. The respective third-party rights
holders grant Licensee the rights indicated in the applicable open source licenses. These
licenses can be found in the documentation. The License does not apply to this open source
software, and nothing in this License shall be construed as a limitation of any right granted
under an open source license.
Article 3. Trademark
3.1 This License does not grant permission to use the trade names, trademarks, service marks, or
product names of the Licensor, except as required for reasonable and customary use in
describing the origin of the Software.
Article 4. Limitation of Liability
4.1 Licensor provides the Software on an "AS IS" basis, and expressly disclaims all conditions,
representations or warranties, express or implied, including without limitation any implied
warranties of merchantability, fitness for a particular purpose, and non-infringement of third
party rights regarding the Software. Licensor is solely responsible for determining the
appropriateness of using the Software and assume any risks associated arising out of or in
connection with the Software and this License.
4.2 Licensor shall not be liable for any damages, including consequential, special, punitive and/or
incidental damages or fines imposed by regulatory bodies, arising out of or in connection with
the Software and this License.
4.3 Licensee shall release, defend, indemnify and hold harmless Licensor from and against any and
all claims, damages and liability arising in connection with the Software, including from
claims, damages or liability from customers of Licensee.
Article 5. Miscellaneous
5.1 Licensor reserves the right to change any or all parts of this License without prior notice.
5.2 The law of the Netherlands governs this License and the terms and conditions therein.
5.3 Any disputes arising between Licensor and Licensee in connection with the License will be
settled by the competent courts in the Netherlands for the principal place of business of the
Licensor.