ora_install
Version information
This version is compatible with:
- Puppet Enterprise 2023.8.x, 2023.7.x, 2023.6.x, 2023.5.x, 2023.4.x, 2023.3.x, 2023.2.x, 2023.1.x, 2023.0.x, 2021.7.x, 2021.6.x, 2021.5.x, 2021.4.x, 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 < 9.0.0
- ,
Tasks:
- agent_action
- apply_psu_db
- db_action
- grid_action
Plans:
- install_grid_home_and_patch
- install_oracle_home
- install_oracle_home_and_patch
- opatch_upgrade
- patch_home
- switch_home_and_apply_psu
- switch_home_asm
Start using this module
Add this module to your Puppetfile:
mod 'enterprisemodules-ora_install', '6.9.7'Learn more about managing modules with a PuppetfileDocumentation
Table of Contents
- 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.
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: ora_install See the file "LICENSE" for the full license governing this code.ora_install::clear_caches: This class contains the puppet code that implements the default facter cache invainvalidationlidatin rules.ora_install::fact_caching: This class ensure's that the ora_install facts that can be cached and are cached with the correct settings.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::net: Installs and configures Oracle SQL*Netora_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: Internal utility to create the required Oracle directories.
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
ora_install
See the file "LICENSE" for the full license governing this code.
ora_install::clear_caches
ora_install::clear_caches
Whenever a certain set of Puppet classes or defined types is applied, it will clear the facter caches for those facts that are implemented.
See the file "LICENSE" for the full license governing this code.
ora_install::fact_caching
ora_install::fact_caching
You can change all TTL settings for the facts if an other setting is more fitting for your setup.
See the file "LICENSE" for the full license governing this code.
Parameters
The following parameters are available in the ora_install::fact_caching class:
enabledproduct_version_ttlopatch_version_ttlinstalled_patches_ttlrunning_processes_ttldefined_sids_ttlora_install_inventory_loc_ttl
enabled
Data type: Boolean
When set to true, this enables facter caching for the ora_install module facts.
Beware that you need to have Facter version 4.1.0 or higher to enabled this. When you set this value to true, automatically TTL settings for most of the ora_install facts are set to a default value. For most installations, the default settings are fine.
When you set this value to true, the facter setting force-dot-resolution is enabled. You have to ensure that all of your facts keep on working with this setting.
product_version_ttl
Data type: Optional[String[1]]
The Time to Live for the ora_install_homes. product_version part of the ora_install_homes fact.
opatch_version_ttl
Data type: Optional[String[1]]
The Time to Live for the ora_install_homes. opatch_version part of the ora_install_homes fact.
installed_patches_ttl
Data type: Optional[String[1]]
The Time to Live for the ora_install_homes. installed_patches part of the ora_install_homes fact.
running_processes_ttl
Data type: Optional[String[1]]
The Time to Live for the ora_install_homes. running_processes part of the ora_install_homes fact.
defined_sids_ttl
Data type: Optional[String[1]]
The Time to Live for the ora_install_homes. defined_sids part of the ora_install_homes fact.
ora_install_inventory_loc_ttl
Data type: Optional[String[1]]
The Time to Live for the ora_install_inventory_loc fact.
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 conveneance class around 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_domaindb_namedb_policydb_typegrouplimitslogoutputoracle_homeservice_namestart_optionsystemd_templatesystemd_template_varsuser
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'
limits
Data type: Optional[Hash]
The limits for the systemd service. The default value is: undef Below is an axample. Currently only the 'hard' values are used.
ora_install::autostartdatabase::limits:
'*/nofile':
soft: 2048
hard: 8192
'oracle/nofile':
soft: 65536
hard: 65536
'oracle/nproc':
soft: 2048
hard: 16384
'oracle/stack':
soft: 10240
hard: 32768
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
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'
systemd_template
Data type: Optional[String[1]]
Use custom EPP template for systemd service The default value is: undef
Default value: undef
systemd_template_vars
Data type: Optional[Hash]
The variables to use when specifying a custom EPP template for systemd service The default value is: undef
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::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_pointtemp_dirumaskuseruser_base_dirversionallow_insecureinstall_typeinstall_optionsarchitecture
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
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
allow_insecure
Data type: Boolean
When set to true Ignore HTTPS certificate errors
(default: false)
Default value: lookup( { name => 'allow_insecure', default_value => false })
install_type
Data type: Enum['Administrator','Runtime','InstantClient','Custom']
Installation type of the Oracle client. The following choices are available. The value should contain only one of these choices:
- Administrator
- Runtime
- InstantClient
- Custom
The default is administrator.
Default value: 'Administrator'
install_options
Data type: Array[String]
The list of Client Components you would like to install. This property is considered only if INSTALL_TYPE is set to "Custom"
The following choices are available. You may specify any combination of these choices. The components you choose should be specified in the form "internal-component-name:version" Below is a list of components you may specify to install for Oracle 21.
- oracle.sqlj:21.0.0.0.0 -- "Oracle SQLJ"
- oracle.rdbms.util:21.0.0.0.0 -- "Oracle Database Utilities"
- oracle.javavm.client:21.0.0.0.0 -- "Oracle Java Client"
- oracle.sqlplus:21.0.0.0.0 -- "SQL*Plus"
- oracle.dbjava.jdbc:21.0.0.0.0 -- "Oracle JDBC/THIN Interfaces"
- oracle.ldap.client:21.0.0.0.0 -- "Oracle Internet Directory Client"
- oracle.rdbms.oci:21.0.0.0.0 -- "Oracle Call Interface (OCI)"
- oracle.precomp:21.0.0.0.0 -- "Oracle Programmer"
- oracle.xdk:21.0.0.0.0 -- "Oracle XML Development Kit"
- oracle.network.aso:21.0.0.0.0 -- "Oracle Advanced Security"
- oracle.oraolap.mgmt:21.0.0.0.0 -- "OLAP Analytic Workspace Manager and Worksheet"
- oracle.network.client:21.0.0.0.0 -- "Oracle Net"
- oracle.network.cman:21.0.0.0.0 -- "Oracle Connection Manager"
- oracle.network.listener:21.0.0.0.0 -- "Oracle Net Listener"
- oracle.ordim.client:21.0.0.0.0 -- "Oracle Multimedia Client Option"
- oracle.odbc:21.0.0.0.0 -- "Oracle ODBC Driver"
- oracle.dbdev:21.0.0.0.0 -- "Oracle SQL Developer"
- oracle.rdbms.scheduler:21.0.0.0.0 -- "Oracle Scheduler Agent"
- oracle.rdbms.drdaas:21.0.0.0.0 -- "Oracle Database Provider for DRDA"
Default value: []
architecture
Data type: Enum['client32','client']
The type of architecture client you want to install. This MUST match the file you are provinding to the installed. Valid values are:
clientclient32The default isclient
Default value: 'client'
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_typeusermemory_mgmt_typeversion
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: 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: 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: 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: 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'
memory_mgmt_type
Data type: Enum['AUTO','AUTO_SGA','CUSTOM_SGA']
The type of memory management to use for the database. The options are:
AUTOAUTO_SGACUSTOM_SGAThe default isAUTO_SGA
Default value: 'AUTO_SGA'
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'
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_tablespaceensuregrouplogoutputoracle_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'
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
- 21.3.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_dirumaskuserversionallow_insecureora_inventory_dir
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: Ora_install::DatabaseVersion
The version of the database. Valid values are:
ORA11gORA12cORA18cORA19cDefault version isORA11g
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', '21.3.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'
allow_insecure
Data type: Boolean
When set to true Ignore HTTPS certificate errors
(default: false)
Default value: lookup( { name => 'allow_insecure', 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
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'),
}
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_pointscan_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: 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: 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: 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
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']]
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)
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']
Kind of install task you want the class to do.
Default value: 'ALL'
gimr_dg
Data type: Boolean
Specify whether or not to configure a seperate diskgroup for the GIMR database (MGMTDB), 12.
2 and up only.
The default value is: false
Default value: false
allow_insecure
Data type: Boolean
When set to true Ignore HTTPS certificate errors
(default: false)
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_pointtemp_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
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]]
The password for the Oracle user on Windows. This parameter is only used on windows systems
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' })
allow_insecure
Data type: Boolean
When set to true Ignore HTTPS certificate errors
(default: false)
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,
}
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_extractallow_insecuretablespace_location
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']
The version that is installed in the used Oracle home. Puppet uses this value to decide on version specific actions.
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
allow_insecure
Data type: Boolean
When set to true Ignore HTTPS certificate errors
(default: false)
Default value: lookup( { name => 'allow_insecure', default_value => false })
tablespace_location
Data type: Optional[String[1]]
The location where the tablespace datafiles should be located. Only needed to specify when using ASM as underlying storage.
Default value: undef
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,
}
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']
The version you want to install.
The default value is: 12.1.0.5.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']
The agent version to be installed
12.1.0.412.1.0.513.1.0.013.2.0.0
Default value: '12.1.0.5'
temp_dir
Data type: Stdlib::Absolutepath
Directory to use for temporary files.
Default value: '/tmp'
allow_insecure
Data type: Boolean
When set to true Ignore HTTPS certificate errors
(default: false)
Default value: lookup( { name => 'allow_insecure', default_value => false })
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'
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::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
When set to true Ignore HTTPS certificate errors
(default: false)
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_for {'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'
group
Data type: String[1]
The os group to use for these Oracle puppet definitions.
The default value is: dba
Default value: 'dba'
limits
Data type: Optional[Hash]
The limits for the systemd service. The default value is: undef Below is an axample. Currently only the 'hard' values are used.
ora_install::autostartdatabase::limits:
'*/nofile':
soft: 2048
hard: 8192
'oracle/nofile':
soft: 65536
hard: 65536
'oracle/nproc':
soft: 2048
hard: 16384
'oracle/stack':
soft: 10240
hard: 32768
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' })
systemd_template
Data type: Optional[String[1]]
Use custom EPP template for systemd service The default value is: undef
Default value: undef
systemd_template_vars
Data type: Optional[Hash]
The variables to use when specifying a custom EPP template for systemd service The default value is: undef
Default value: undef
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
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
What are plans?
Modules can contain plans 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.
Version updates
6.9.7
- [ora_install_homes] Fix error when parsing client home on Windows
6.9.6
- [docs] Remove reference to devops superhero
- [facts] On Windows the install group is always ORA_INSTALL
Change-Id: I94452674c6b2a38d533d8e9cbff0cbfdbc9f8018
6.9.5
- [ora_install_homes] More resilient against missing directories
6.9.4
- [ora_opatch] Don’t (re)detetermine the installed patches
6.9.3
- [release] Update dependencies
- [db_directory_structure] Setting of ownership only done when specific dir is created
6.9.2
- [facts] Refresh opatch_version for new installations and fix bug with multiple homes
6.9.1
- [installdb] Bugfixes for Windows
6.9.0
- [core] Better support for windows
6.8.0
- [ora_instal_homes] Skip cman processes for listeners
- [ora_opatch] Fix detection of currently installed patches
- [facts] Integrate OCM running facts into ora_install_homes
6.7.0
- [ora_opatch] Add support for cwd parameter
6.6.3
- [db_opatch, facts] Use jdk clause only when specfied jdk exists
6.6.2
- [release] Update version of referenced systemd module
- [db_opatch] Fix syntax errors
6.6.1
- [install_emagent] Fix usage of deprecated function is_string
6.6.0
- [installem_agent] Make AgentPull more secure (no more logging of sensitive data
6.5.4
- [core] Removed stdlib::merge dependency
6.5.3
- [client] Fix install on Redhat 8
- [install_emagent] Fix usage of deprecated function is_string
6.5.2
- [release] Update version of dependency puppetlabs-concat
- [installem] Fix temp_dir type and dependency
6.5.1
- [core] Replace in Puppet 8 deprecated merge function
- [db_opatch] Fix jdk not found error by explicitly passing jdk path
6.5.0
- [core] Add support for Puppet 8
6.4.1
- [release] Update dependencies
6.4.0
[autostartdatabase] Implement custom template for systemd service (#169)
6.3.1
- [ora_install::oracle_exists] Make check less strict. Don’t need opatch
6.3.0
- [client] Support 32-bits client installer
6.2.6
- [ora_opatch] Fix reinstall of remove_patches_before patches
- [ora_opatch] Fix listing of installed patches
6.2.5
- [autostartdatabase] Implement systemd service
6.2.4
- [ora_tab_entry] Fix missing newline on inital entry
6.2.3
- [installem] Fix cleanup of downloaded zip
- [installasm] Fix cleanup of downloaded zip
6.2.2
- [ora_install_homes] Fix issue when using longer SID names
6.2.1
- [core] Remove check for database name length smaller equal 8
6.2.0
- [core] load oracle user profile when executing commands
- [ora_opatch] Unzip files as oracle user
- [ora_opatch] Use the ora_install_home fact for patching index
6.1.2
- [changed_oracle_home_for] Fix for usage with cached ora_install_homes again
6.1.1
- [changed_oracle_home_for] Fix for usage with cached ora_install_homes
6.1.0
- [release] Add support for AlmaLinux and Rocky
- [facts] Fix issue with ora_install_homes fact on Windows (#161)
6.0.0
- [release] Remove deprecated code
- [facts] Add fact caching
5.16.0
- [goldengate] Add support for version 21.3.0
- [core] Start using cleanup resource
5.15.1
- [goldengate] Also allow 18c and 19c to the templates
5.15.0
- [goldengate] Enable ORA18c and ORA19c database versions
5.14.4
- [ora_opatch] Leave removal of zip content to source_dir property]
5.14.3
- [core] Change Filepath object in LOAD_PATH to String
5.14.2
- [ora_opatch] Add support to force removal of patches
- [ora_install_homes] Fix runnings_sids when no database is running
- [database] Add init_params to dbca create from template (#153)
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 < 10.0.0)
- puppetlabs-powershell (>= 2.3.0 < 10.0.0)
- puppetlabs-stdlib (>= 5.1.0 < 10.0.0)
- puppet-archive (>= 3.2.0 < 8.0.0)
- puppet-systemd (>= 2.12.0 < 8.0.0)
- enterprisemodules/easy_type (>= 2.39.2 < 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.