Forge Home

oracleinstantclient

Install Oracle Instant Client

8,229 downloads

7,670 latest version

4.3 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Version information

  • 1.0.0 (latest)
  • 0.1.0
released May 23rd 2017
This version is compatible with:
  • Puppet Enterprise 2017.2.x, 2017.1.x, 2016.5.x, 2016.4.x
  • Puppet >= 4.0.0 < 5.0.0

Start using this module

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

Add this module to your Puppetfile:

mod 'jgazeley-oracleinstantclient', '1.0.0'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add jgazeley-oracleinstantclient
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install jgazeley-oracleinstantclient --version 1.0.0

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.

Download

Documentation

jgazeley/oracleinstantclient — version 1.0.0 May 23rd 2017

oracleinstantclient

Table of Contents

  1. Overview
  2. Usage - Configuration options and additional functionality
  3. Limitations - OS compatibility, etc.
  4. Development - Guide for contributing to the module
  5. Release Notes

Overview

This module installs the Oracle Instant Client, plus related tools, libraries and SDKs.

This module does not include the Oracle RPM binary packages. You must download these from Oracle's website and place them in a Yum repo which is accessible by your system.

This module does not currently have the ability to serve up RPM packages from Puppet's fileserver. This could be added if necessary.

Usage

oracleinstantclient

The main usage of this module is via the oracleinstantclient class, which installs packages and handles a few extra bits required to make the Instant Client work.

version

Specify the version of Oracle Instant Client to install. This must match the packages you have downloaded from Oracle and placed in a local Yum repo. Default: 12.2

devel

Install the development package. Default: false

jdbc

Install the JDBC package. Default: false

odbc

Install the ODBC package. Default: false

sqlplus

Install the SQLPlus application package. Default: false

tools

Install the tools package. Default: false

selinux

Manage SELinux policies to allow Oracle Instant Client to work on RHEL. Default: true

eplan

Install eplan SQL script to enable explain plan usage in SQLPlus. Default: false

Example

This example shows all parameters with their default values.

class { oracleinstantclient:
  version => '12.2',
  devel   => false,
  jdbc    => false,
  odbc    => false,
  sqlplus => false,
  tools   => false,
  selinux => true,
  eplan   => false,
}

oracleinstantclient::ldap

The oracleinstantclient::ldap class allows you to configure Oracle Instant Client to use LDAP to look up Oracle server names.

ldapserver

The name of the LDAP server to use. This is a required parameter. Example: ldap.example.com

ldapcontext

The LDAP context to run in. This is a required parameter. Example: dc=example,dc=com

ldapport

The port to connect to the LDAP server on. Default: 389

ldaptype

The type of LDAP search to run. Default: OID

Example

class { oracleinstantclient::ldap:
  ldapserver  => 'ldap.example.com',
  ldapcontext => 'dc=example,dc=com',
  ldapport    => 389,
  ldaptype    => 'OID',
}

oracleinstantclient::sqlnet

The oracleinstantclient::sqlnet class allows you to configure Oracle Instant Client to use SQLNet to locate Oracle servers

sqlnetdomain

The default domain of your Oracle server. Example: example.com

sqlnetdirectory

The preference order of which directories to use to locate your Oracle server. Example: (LDAP,TNSNAMES)

sqlnetseed

The seed to use for crypto purposes. Example: SECRETSEED

sqlnetzone

The default zone of your Oracle server. Default: world

sqlnetexpire

SQLNet expire time. Default: 50

Example

class { oracleinstantclient::sqlnet:
  sqlnetdomain    => 'example.com',
  sqlnetdirectory => '(LDAP,TNSNAMES)',
  sqlnetseed      => 'SECRETSEED',
  sqlnetzone      => 'world',
  sqlnetexpire    => 50,
}

Limitations

This module is developed and tested on CentOS 6 and 7. Oracle's packages are in RPM format so it would not be easy to extend to other platforms.

Development

Pull requests welcome. No guarantee of development effort if the features are not useful to my employer.