Adoptable Cookbooks List

Looking for a cookbook to adopt? You can now see a list of cookbooks available for adoption!
List of Adoptable Cookbooks

Supermarket Belongs to the Community

Supermarket belongs to the community. While Chef has the responsibility to keep it running and be stewards of its functionality, what it does and how it works is driven by the community. The chef/supermarket repository will continue to be where development of the Supermarket application takes place. Come be part of shaping the direction of Supermarket by opening issues and pull requests or by joining us on the Chef Mailing List.

Select Badges

Select Supported Platforms

RSS

oracle_aix (1) Versions 1.2.2

Installs/Configures Oracle 12c rdbms for AIX 7.1

Berkshelf/Librarian
Policyfile
Knife
cookbook 'oracle_aix', '~> 1.2.2'
cookbook 'oracle_aix', '~> 1.2.2', :supermarket
knife cookbook site install oracle_aix
knife cookbook site download oracle_aix
README
Dependencies
Changelog
Quality 44%

Description

This chef cookbook is based off the work originally published by Ari Riikonen called Oracle chef cookbook version 1.2.2

It installs and configures the Oracle RDBMS, with patches, to the latest version of 12c for the AIX Operating System. The version with 11g R2 has NOT been tested on AIX.

I wish to acknowldege Air Riikonen's great work here in which made porting to AIX easy to do.

Features: * Oracle 12c Release 1 support with AIX 7.1 (Note Customers using the cookbook must have valid licensing to use Oracle 12c products).

Non-goals: * Oracle client install is 11g R2 but has not been tested on AIX and given the work done on AIX, expect there to be some issues if tried. * We did not port Oracle 11gr2 Release support to AIX 7.1. It was a non-goal.

DiskSpace Requirements - assumes space exists in following directories ========= ============ /oracle - default base and install area: 10 GB /oracle/oradata - default oracle data directory: 10 GB /opt - chef installation: .5 GB /tmp - available temp space: 10 GB

Quickstart (database)

  • Have either an open Source Chef Server or a Hosted Chef account at the ready.
  • Use AIX 7.1 or later.
  • Requires a web server for Oracle source files. Set up a Web server to serve them over HTTPS unless you're on a secure local network.
  • Create a role to override the default attribute values for the URLs of Oracle's install files & patches with your own; e.g.:

ora_12c_aix.rb ========================================================== name "ora_12c_aix" description "Role applied to Oracle 12c AIX test machines."

run_list 'recipe[oracle_aix]','recipe[oracle_aix::createdb]'

override_attributes :oracle => { :rdbms => { :dbs_root => "/oracle/oradata", :sys_pw => 'oracle', :system_pw => 'oracle', :dbsnmp_pw => 'oracle', :latest_patch => { :dirname_12c => '20831110', :url => 'http://localhost/CHEF/oracle/p20831110_121020_AIX64-5L.zip'}, :opatch_update_url => 'http://localhost/CHEF/oracle/p6880880_121010_AIX64-5L.zip', :install_files => ['http://localhost/CHEF/oracle/V73231-01_1of2.zip', 'http://localhost/CHEF/oracle/V73231-01_2of2.zip'], :dbbin_version => '12c', }, :user => { :uid => 4000, :gid => 4000, :edb_use => false, :ora_pw => 'oracle', } } ==========================================================

  • You need to set up an encrypted data bag item to secure the oracle user's password. See Opscode's docs site for details on encrypted data bags: encrypted data bag doc Your encrypted item requires a key named pw, whose value is the password of the oracle user- you can set that to whatever you want. You must set the value of node[:oracle][:user][:edb] to the name of your data bag, and that of node[:oracle][:user][:edb_item] to the name of the encrypted item; the defaults are oracle and foo, respectively.

  • alternatively, setting :ebs_use to false and setting :ora_pw will use the password provided. :edb_use => false, :ora_pw => 'oracle',

  • Bootstrap the node, telling Chef to create the FOO database on it:

12c : knife bootstrap HOSTNAME -x root -P <rootpassword> -N HOSTNAME '-r role[ora_12c_aix]'
-j '{oracle:{rdbms:{dbs:{FOO:false}}}}' -y -V

  • Go grab a cup of tea, as this is apt to take a fair amount of time to complete :-)

Requirements

Oracle

See here:

[Oracle's requirements for 12c] See edelivery and check the latest patches for the oracle 12c database This installtion uses update patch 20831110 DATABASE PATCH SET UPDATE 12.1.0.2.4

Chef

This cookbook was successfully tested using Chef-Client 12.5.1, in combo with the open source Chef Server 12, as well as with Hosted Chef.

then run chef-server-ctl reconfigure to reconfigure Chef Server.

Platforms

*# AIX 7.1 (power7)

Packages

  • Access to My Oracle Support to download the 11g R2 install media and the patch files.

  • Download the 12.1.0.2.4 install files from eDelivery.oracle.com My Oracle Support as well as an active CSI.

12c

Oracle 12c OPatch 12.1.0.1.8       - p6880880_121010_AIX64-5L.zip
Oracle 12c Patch 12.1.0.2.4        - p20831110_121020_AIX64-5L.zip
Oracle 12c 12.1.0.2.0 DBMS         - V73231-01_1of2.zip
Oracle 12c 12.1.0.2.0 DBMS         - V73231-01_2of2.zip
Oracle 12c 12.1.0.2.0 64bit Client - V73233-01.zip

Miscellaneous

  • Ensure that your FQDN is properly configured (check the output of hostname -f), else runInstaller will fail.
  • At least a basic knowledge of Oracle administration will come in handy, in particular if you want to modify attributes' values and/or modify the cookbook's code or resources.

  • Please check Oracle database specific swap recommendations from:

See Ari's Original README.md called READMEPRE_AIX.md for much further important information.

License and Authors

Original Authors: * Author:: Ari Riikonen ari.riikonen@gmail.com
* Author:: Dominique Poulain

Copyright:: 2014, Ari Riikonen

Licensed under the Apache License, Version 2.0 (the "License"); you may not use this file except in compliance with the License. You may obtain a copy of the License at

http://www.apache.org/licenses/LICENSE-2.0

Unless required by applicable law or agreed to in writing, software distributed under the License is distributed on an "AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied. See the License for the specific language governing permissions and limitations under the License.

Dependent cookbooks

aix >= 0.1.0

Contingent cookbooks

There are no cookbooks that are contingent upon this one.

CHANGELOG for oracle_aix

1.2.2:

  • Support for 12c for AIX

Collaborator Number Metric
            

1.2.2 failed this metric

Failure: Cookbook has 0 collaborators. A cookbook must have at least 2 collaborators to pass this metric.

Contributing File Metric
            

1.2.2 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a CONTRIBUTING.md file

Foodcritic Metric
            

1.2.2 failed this metric

FC009: Resource attribute not recognised: oracle_aix/recipes/oracle_user_config.rb:30
FC009: Resource attribute not recognised: oracle_aix/recipes/oracli_user_config.rb:30
FC033: Missing template file: oracle_aix/recipes/logrotate_alert_log.rb:26
FC033: Missing template file: oracle_aix/recipes/logrotate_listener.rb:27
FC064: Ensure issues_url is set in metadata: oracle_aix/metadata.rb:1
FC065: Ensure source_url is set in metadata: oracle_aix/metadata.rb:1
FC066: Ensure chef_version is set in metadata: oracle_aix/metadata.rb:1
FC069: Ensure standardized license defined in metadata: oracle_aix/metadata.rb:1
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/cli_latest_patch.rb:86
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/clibin.rb:127
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/createdb.rb:50
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/createdb.rb:60
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/createdb.rb:98
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/createdb.rb:199
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/dbbin.rb:253
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/latest_dbpatch.rb:119
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/oracle_user_config.rb:99
FC104: Use the :run action in ruby_block instead of :create: oracle_aix/recipes/oracli_user_config.rb:98
Run with Foodcritic Version 12.2.1 with tags metadata,correctness ~FC031 ~FC045 and failure tags any

License Metric
            

1.2.2 passed this metric

No Binaries Metric
            

1.2.2 passed this metric

Publish Metric
            

1.2.2 passed this metric

Supported Platforms Metric
            

1.2.2 passed this metric

Testing File Metric
            

1.2.2 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must contain a TESTING.md file

Version Tag Metric
            

1.2.2 failed this metric

Failure: To pass this metric, your cookbook metadata must include a source url, the source url must be in the form of https://github.com/user/repo, and your repo must include a tag that matches this cookbook version number