database pluggable

Overview

Creates or delete a pluggable database.

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

Attributes

create_user_tablespace

Create a user tablespace in the PDB.

The default value is: false

Type: Boolean

Default:true

Back to overview of database_pluggable

ensure

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 specify absent, Puppet® will remove the resource if it is available. If it is not installed, Puppet® will do nothing.

Type: Enum[present,absent]

Default:present

Back to overview of database_pluggable

group

The os group to use for these Oracle puppet definitions.

The default value is: dba

Type: String[1]

Default:'dba'

Back to overview of database_pluggable

logoutput

log the outputs of Puppet® exec or not.

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

Valid values are:

• true
• false
• on_failure

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

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

Back to overview of database_pluggable

oracle_home_dir

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

Type: Stdlib::Absolutepath

Default:undef

Back to overview of database_pluggable

pdb_admin_password

Password for the admin user in the PDB.

Type: Easy_type::Password

Default:undef

Back to overview of database_pluggable

pdb_admin_username

Username for the admin user in the pluggable database.

The default value is: pdb_adm

Type: String[1]

Default:'pdb_adm'

Back to overview of database_pluggable

pdb_datafile_destination

The location where the PDB datafiles will be stored.

Type: String[1]

Default:undef

Back to overview of database_pluggable

pdb_name

Name of the pluggable database.

Type: String[1]

Default:undef

Back to overview of database_pluggable

source_db

The database name of the container(source) database.

Type: String[1]

Default:undef

Back to overview of database_pluggable

user

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

The default value is: oracle

Type: String[1]

Default:'oracle'

Back to overview of database_pluggable

version

The version that is installed in the used Oracle home.

Puppet uses this value to decide on version specific actions.

Type: Enum['12.1','12.2','18.0','19.0','21.0']

Default:'12.1'

Back to overview of database_pluggable