Overview

Manages an entry in a tnsnames.ora file.

Here is an examples on how to use this:

ora_install::tnsnames{'entry':
  oracle_home          => '/u01/app/oracle/product/12.2.0.1/db_home1',
  user                 => 'oracle',
  group                => 'dba',
  server               => { myserver1 => { host => DB122a.example.nl, port => '1521', protocol => 'TCP' },
                            myserver2 => { host => DB122b.example.nl, port => '1521', protocol => 'TCP' }},
  connect_service_name => 'DB122.domain.local',
  connect_server       => 'DEDICATED',
  entry_type           => 'tnsname',
}

Attributes

Attribute Name Short Description
connect_server The name of the server to connect to.
connect_service_name The name of the service to connect to.
entry_type The type of entry to manage.
failover Failover ON or OFF.
group The os group to use for these Oracle puppet definitions.
loadbalance Load balance ON or OFF.
oracle_home A directory to be used as Oracle home directory for this software.
server A Hash defining the server entry.
user The user used for the specified installation.

connect_server

The name of the server to connect to.

Back to overview of tnsnames

connect_service_name

The name of the service to connect to.

Back to overview of tnsnames

entry_type

The type of entry to manage.

You can manage the next type of entries:

  • tnsname
  • listener

The default value is: tnsname

Back to overview of tnsnames

failover

Failover ON or OFF.

Valid values are:

  • ON
  • OFF

The default value is: ON

Back to overview of tnsnames

group

The os group to use for these Oracle puppet definitions.

The default value is: dba

Back to overview of tnsnames

loadbalance

Load balance ON or OFF.

Valid values are:

  • ON
  • OFF

The default value is: ON

Back to overview of tnsnames

oracle_home

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

Back to overview of tnsnames

server

A Hash defining the server entry.

The default value is:

{myserver => { host => undef, port => '1521', protocol => 'TCP' }}

Back to overview of tnsnames

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

Back to overview of tnsnames