tnsnames

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

Experience the Power of Puppet for Oracle

If you want to play and experiment with Puppet and Oracle, please take a look at our playgrounds. At our playgrounds, we provide you with a pre-installed environment, where you experiment fast and easy.

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.
sid  
user The user used for the specified installation.

connect_server

The name of the server to connect to.

Type: String[1]

Default:'DEDICATED'

Back to overview of tnsnames

connect_service_name

The name of the service to connect to.

Type: Optional[String[1]]

Default:undef

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

Type: Enum['tnsname','listener']

Default:'tnsname'

Back to overview of tnsnames

failover

Failover ON or OFF.

Valid values are:

  • ON
  • OFF

The default value is: ON

Type: String[1]

Default:'ON'

Back to overview of tnsnames

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 tnsnames

loadbalance

Load balance ON or OFF.

Valid values are:

  • ON
  • OFF

The default value is: ON

Type: port=>'1521',protocol=>'TCP'}},String[1]

Default:'ON'

Back to overview of tnsnames

oracle_home

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

Type: Stdlib::Absolutepath

Default:undef

Back to overview of tnsnames

server

A Hash defining the server entry.

The default value is:

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

Type: Hash

Default:{ myserver => { host => undef

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

Type: String[1]

Default:'oracle'

Back to overview of tnsnames

sid

The database SID to use. Type: Optional[String[1]]

Default:undef

Back to overview of tnsnames