Skip to content

Instantly share code, notes, and snippets.

@aririikonen
Created July 5, 2013 19:40
Show Gist options
  • Save aririikonen/5936747 to your computer and use it in GitHub Desktop.
Save aririikonen/5936747 to your computer and use it in GitHub Desktop.
CHEF: echa-oracle v1.0.0 cookbook test output on EC2 RHEL VM 5th of July 2013
Instance ID: i-XXXXXXXX
Flavor: m1.small
Image: ami-9bf6e0ef
Region: region
Availability Zone: availzone
Security Groups: sec_group
Tags: {"Name"=>"i-XXXXXXXX"}
SSH Key: key1
Waiting for instance......................
Public DNS Name: FQDN
Public IP Address: X.X.X.X
Private DNS Name: ip-X-X-X-X.region.compute.internal
Private IP Address: X.X.X.X
Waiting for sshd.......................done
Bootstrapping Chef on FQDN
FQDN --2013-07-05 10:37:15-- http://opscode.com/chef/install.sh
FQDN Resolving opscode.com...
FQDN 184.106.28.83
FQDN Connecting to opscode.com|184.106.28.83|:80...
FQDN connected.
FQDN HTTP request sent, awaiting response...
FQDN 301 Moved Permanently
FQDN Location: http://www.opscode.com/chef/install.sh [following]
FQDN --2013-07-05 10:37:15-- http://www.opscode.com/chef/install.sh
FQDN Resolving www.opscode.com...
FQDN 184.106.28.82
FQDN Connecting to www.opscode.com|184.106.28.82|:80...
FQDN connected.
FQDN HTTP request sent, awaiting response...
FQDN 200 OK
FQDN Length: 6515 (6.4K) [application/x-sh]
FQDN Saving to: âSTDOUTâ
0% [ ] 0 --.-K/s
100%[======================================>] 6,515 --.-K/s in 0.1s
FQDN
FQDN 2013-07-05 10:37:16 (58.5 KB/s) - written to stdout [6515/6515]
FQDN
FQDN Downloading Chef 11.4.4 for el...
FQDN Installing Chef 11.4.4
FQDN warning: /tmp/tmp.HWEbGz39/chef-11.4.4.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID YYYYYYY: NOKEY
FQDN Preparing...
FQDN ######################################## (100%)
FQDN
FQDN ########################################### [100%]
FQDN 1:chef
FQDN ( 1%)
FQDN # ( 3%)
FQDN ## ( 6%)
FQDN ### ( 8%)
FQDN #### ( 10%)
FQDN ##### ( 13%)
FQDN ###### ( 15%)
FQDN ####### ( 17%)
FQDN ######## ( 19%)
FQDN ######### ( 22%)
FQDN ########## ( 24%)
FQDN ########### ( 26%)
FQDN ############ ( 28%)
FQDN ############# ( 31%)
FQDN ############## ( 33%)
FQDN ############### ( 35%)
FQDN ################ ( 38%)
FQDN ################# ( 40%)
FQDN ################## ( 42%)
FQDN ################### ( 44%)
FQDN #################### ( 47%)
FQDN ##################### ( 49%)
FQDN ###################### ( 51%)
FQDN ####################### ( 53%)
FQDN ######################## ( 56%)
FQDN ######################### ( 58%)
FQDN ########################## ( 60%)
FQDN ########################### ( 63%)
FQDN ############################ ( 65%)
FQDN ############################# ( 67%)
FQDN ############################## ( 69%)
FQDN ############################### ( 72%)
FQDN ################################ ( 74%)
FQDN ################################# ( 76%)
FQDN ################################## ( 78%)
FQDN ################################### ( 81%)
FQDN #################################### ( 83%)
FQDN ##################################### ( 85%)
FQDN ###################################### ( 88%)
FQDN ####################################### ( 90%)
FQDN ######################################## ( 92%)
FQDN ######################################### ( 94%)
FQDN ########################################## ( 97%)
FQDN ########################################### [100%]
FQDN Thank you for installing Chef!
FQDN Starting Chef Client, version 11.4.4
FQDN Creating a new client identity for i-XXXXXXXX using the validator key.
FQDN resolving cookbooks for run list: ["echa-oracle", "echa-oracle::logrotate_alert_log", "echa-oracle::logrotate_listener", "echa-oracle::createdb"]
FQDN Synchronizing Cookbooks:
FQDN - echa-oracle
FQDN Compiling Cookbooks...
FQDN [2013-07-05T10:38:06-04:00] WARN: Cloning resource attributes for yum_package[ksh] from prior resource (CHEF-3694)
FQDN [2013-07-05T10:38:06-04:00] WARN: Previous yum_package[ksh]: /var/chef/cache/cookbooks/echa-oracle/recipes/oracle_user_config.rb:38:in `from_file'
FQDN [2013-07-05T10:38:06-04:00] WARN: Current yum_package[ksh]: /var/chef/cache/cookbooks/echa-oracle/recipes/deps_install.rb:21:in `block in from_file'
FQDN [2013-07-05T10:38:06-04:00] WARN: Cloning resource attributes for package[logrotate] from prior resource (CHEF-3694)
FQDN [2013-07-05T10:38:06-04:00] WARN: Previous package[logrotate]: /var/chef/cache/cookbooks/echa-oracle/recipes/logrotate_alert_log.rb:22:in `from_file'
FQDN [2013-07-05T10:38:06-04:00] WARN: Current package[logrotate]: /var/chef/cache/cookbooks/echa-oracle/recipes/logrotate_listener.rb:21:in `from_file'
FQDN Converging 72 resources
FQDN Recipe: echa-oracle::oracle_user_config
FQDN * group[oinstall] action create
FQDN
FQDN - create group[oinstall]
FQDN
FQDN * user[oracle] action create
FQDN
FQDN - create user user[oracle]
FQDN
FQDN * yum_package[ksh] action install
FQDN
FQDN - install version 20100621-19.el6_4.3 of package ksh
FQDN
FQDN * group[dba] action create
FQDN
FQDN - create group[dba]
FQDN
FQDN * template[/home/oracle/.profile] action create_if_missing
FQDN
FQDN - create template[/home/oracle/.profile]
FQDN --- /tmp/chef-tempfile20130705-1387-1ygk4b2 2013-07-05 10:38:51.732952911 -0400
FQDN +++ /tmp/chef-rendered-template20130705-1387-mkuyr8 2013-07-05 10:38:51.730952848 -0400
FQDN @@ -0,0 +1,36 @@
FQDN +# Enable core files
FQDN +ulimit -S -c unlimited > /dev/null 2>&1
FQDN +
FQDN +EDITOR=/bin/vi
FQDN +ORACLE_BASE=/opt/oracle
FQDN +ORACLE_HOME=/opt/oracle/11R23
FQDN +ORACLE_SID=
FQDN +ORA_ENV=11R23
FQDN +ORACLE_HOSTNAME=`hostname -f`
FQDN +export EDITOR ORACLE_BASE ORACLE_HOME ORACLE_SID ORA_ENV ORACLE_HOSTNAME
FQDN +
FQDN +
FQDN +
FQDN +NLS_DATE_FORMAT='YYYYMMDD.HH24MISS'
FQDN +NLS_LANG=american_america.al32utf8
FQDN
FQDN +export NLS_DATE_FORMAT NLS_LANG
FQDN +
FQDN +
FQDN +
FQDN +PATH=$PATH:/usr/sbin:$ORACLE_BASE/dba/bin:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch
FQDN +export PATH
FQDN +
FQDN +
FQDN +
FQDN +alias checkdumps='du -hs /opt/oracle/admin/*/*'
FQDN +alias dba='sqlplus "/ as sysdba"'
FQDN +alias pp='ps -ef | grep ora_pmon'
FQDN +alias cdora='cd /opt/oracle'
FQDN +alias ls='ls --color=auto'
FQDN +
FQDN +
FQDN +
FQDN +HOSTNAME=`hostname | awk -F. '{print $1}'`
FQDN +PS1='[$USER@$HOSTNAME] -->${ORACLE_SID}<-- $ORA_ENV
FQDN +$PWD> '
FQDN +export PS1
FQDN
FQDN
FQDN * execute[gen_dir_colors] action run
FQDN
FQDN - execute /usr/bin/dircolors -p > /home/oracle/.dir_colors
FQDN
FQDN
FQDN * execute[change_oracle_user_pw] action run
FQDN
FQDN - execute echo oracle: | /usr/sbin/chpasswd
FQDN
FQDN * ruby_block[set_pw_attr] action create
FQDN
FQDN - execute the ruby block set_pw_attr
FQDN
FQDN * cookbook_file[/etc/security/limits.d/oracle.conf] action create
FQDN
FQDN - create a new cookbook_file /etc/security/limits.d/oracle.conf
FQDN --- /tmp/chef-tempfile20130705-1387-480zt9 2013-07-05 10:38:52.872953789 -0400
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/ora_limits 2013-07-05 10:38:52.870953849 -0400
FQDN @@ -0,0 +1,8 @@
FQDN +# Lines are commented out when the default limits are already
FQDN +# equal to, or greater than, the values recommended by Oracle.
FQDN
FQDN +#oracle soft nofile 1024
FQDN +oracle hard nofile 65536
FQDN +oracle soft nproc 2047
FQDN +oracle hard nproc 16384
FQDN +#oracle soft stack 10240
FQDN +#oracle hard stack 32768
FQDN
FQDN Recipe: echa-oracle::deps_install
FQDN * yum_package[binutils] action install
FQDN (up to date)
FQDN * yum_package[compat-libcap1] action install
FQDN
FQDN - install version 1.10-1 of package compat-libcap1
FQDN
FQDN * yum_package[compat-libstdc++-33] action install
FQDN
FQDN - install version 3.2.3-69.el6 of package compat-libstdc++-33
FQDN
FQDN * yum_package[gcc] action install
FQDN
FQDN - install version 4.4.7-3.el6 of package gcc
FQDN
FQDN * yum_package[gcc-c++] action install
FQDN
FQDN - install version 4.4.7-3.el6 of package gcc-c++
FQDN
FQDN * yum_package[glibc] action install
FQDN (up to date)
FQDN * yum_package[glibc-devel] action install
FQDN (up to date)
FQDN * yum_package[ksh] action install
FQDN (up to date)
FQDN * yum_package[libgcc] action install
FQDN (up to date)
FQDN * yum_package[libstdc++] action install
FQDN (up to date)
FQDN * yum_package[libstdc++-devel] action install
FQDN (up to date)
FQDN * yum_package[libaio] action install
FQDN (up to date)
FQDN * yum_package[libaio-devel] action install
FQDN
FQDN - install version 0.3.107-10.el6 of package libaio-devel
FQDN
FQDN * yum_package[make] action install
FQDN (up to date)
FQDN * yum_package[sysstat] action install
FQDN (up to date)
FQDN Recipe: echa-oracle::kernel_params
FQDN * bash[sysctl_reload] action nothing (up to date)
FQDN * directory[/etc/sysctl.d] action create
FQDN
FQDN - create new directory /etc/sysctl.d
FQDN
FQDN - change mode from '' to '0755'
FQDN
FQDN
FQDN * cookbook_file[/etc/sysctl.d/ora_params] action create
FQDN
FQDN - create a new cookbook_file /etc/sysctl.d/ora_params
FQDN --- /tmp/chef-tempfile20130705-1387-18kibap 2013-07-05 10:39:53.900953966 -0400
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/ora_params 2013-07-05 10:39:53.898954052 -0400
FQDN @@ -0,0 +1,15 @@
FQDN +# Oracle 11g R2 kernel tuning
FQDN +kernel.sem = 250 32000 100 128
FQDN +fs.file-max = 6815744
FQDN +fs.aio-max-nr = 1048576
FQDN +net.ipv4.ip_local_port_range = 9000 65500
FQDN +net.core.rmem_default = 262144
FQDN +net.core.rmem_max = 4194304
FQDN +net.core.wmem_default = 262144
FQDN
FQDN +net.core.wmem_max = 1048576
FQDN +
FQDN +# The kernel parameters below are already set to
FQDN +# a value equal to or higher than the minimum recommended by Oracle.
FQDN +#kernel.shmall = 2097152 recommended, set to 4294967296
FQDN +#kernel.shmmax = 536870912 recommended, set to 68719476736
FQDN +#kernel.shmmni = 4096 recommended, set to 4096
FQDN
FQDN * bash[sysctl_reload] action run
FQDN
FQDN - execute "bash" "/tmp/chef-script20130705-1387-18yui2b"
FQDN
FQDN
FQDN Recipe: echa-oracle::dbbin
FQDN * directory[/opt/oracle] action create
FQDN
FQDN - create new directory /opt/oracle
FQDN
FQDN - change mode from '' to '0755'
FQDN - change owner from '' to 'oracle'
FQDN - change group from '' to 'oinstall'
FQDN
FQDN
FQDN * directory[/opt/oracle/install_dir] action create
FQDN
FQDN - create new directory /opt/oracle/install_dir
FQDN
FQDN - change mode from '' to '0755'
FQDN - change owner from '' to 'oracle'
FQDN - change group from '' to 'oinstall'
FQDN
FQDN
FQDN * yum_package[unzip] action install
FQDN (up to date)
FQDN * execute[fetch_media_11R23-https://HTTPS_FQDN/ora_package_directory/p10404530_112030_Linux-x86-64_1of7.zip] action run
FQDN
FQDN - execute curl -kO https://HTTPS_FQDN/ora_package_directory/p10404530_112030_Linux-x86-64_1of7.zip
FQDN
FQDN * execute[unzip_media_11R23-https://HTTPS_FQDN/ora_package_directory/p10404530_112030_Linux-x86-64_1of7.zip] action run
FQDN
FQDN - execute unzip p10404530_112030_Linux-x86-64_1of7.zip
FQDN
FQDN * execute[fetch_media_11R23-https://HTTPS_FQDN/ora_package_directory/p10404530_112030_Linux-x86-64_2of7.zip] action run
FQDN
FQDN - execute curl -kO https://HTTPS_FQDN/ora_package_directory/p10404530_112030_Linux-x86-64_2of7.zip
FQDN
FQDN * execute[unzip_media_11R23-https://HTTPS_FQDN/ora_package_directory/p10404530_112030_Linux-x86-64_2of7.zip] action run
FQDN
FQDN - execute unzip p10404530_112030_Linux-x86-64_2of7.zip
FQDN
FQDN * file[/opt/oracle/oraInst.loc] action create
FQDN
FQDN - create new file /opt/oracle/oraInst.loc with content checksum aca2f8
FQDN --- /tmp/chef-tempfile20130705-1387-1qbdvpo 2013-07-05 10:46:35.445953351 -0400
FQDN +++ /tmp/chef-diff20130705-1387-181vyfj 2013-07-05 10:46:35.444953351 -0400
FQDN
FQDN @@ -0,0 +1,2 @@
FQDN +inst_group=oinstall
FQDN +inventory_loc=/opt/oraInventory
FQDN
FQDN * directory[/opt/oraInventory] action create
FQDN
FQDN - create new directory /opt/oraInventory
FQDN
FQDN - change mode from '' to '0755'
FQDN - change owner from '' to 'oracle'
FQDN - change group from '' to 'oinstall'
FQDN
FQDN
FQDN * template[/opt/oracle/install_dir/db11R23.rsp] action create
FQDN
FQDN - create template[/opt/oracle/install_dir/db11R23.rsp]
FQDN --- /tmp/chef-tempfile20130705-1387-1vk7rw6 2013-07-05 10:46:36.609951634 -0400
FQDN
FQDN +++ /tmp/chef-rendered-template20130705-1387-1hz2szk 2013-07-05 10:46:36.608951578 -0400
FQDN @@ -0,0 +1,22 @@
FQDN +oracle.install.responseFileVersion=/oracle/install/rspfmt_dbinstall_response_schema_v11_2_0
FQDN +oracle.install.option=INSTALL_DB_SWONLY
FQDN +ORACLE_HOSTNAME=ip-X-X-X-X.region.compute.internal
FQDN +UNIX_GROUP_NAME=oinstall
FQDN +INVENTORY_LOCATION=/opt/oraInventory
FQDN +SELECTED_LANGUAGES=en
FQDN +ORACLE_HOME=/opt/oracle/11R23
FQDN +ORACLE_BASE=/opt/oracle
FQDN +oracle.install.db.InstallEdition=EE
FQDN +oracle.install.db.EEOptionsSelection=false
FQDN +oracle.install.db.DBA_GROUP=dba
FQDN +oracle.install.db.OPER_GROUP=dba
FQDN
FQDN +oracle.install.db.isRACOneInstall=false
FQDN +oracle.install.db.config.starterdb.type=GENERAL_PURPOSE
FQDN +oracle.install.db.config.starterdb.memoryOption=false
FQDN +oracle.install.db.config.starterdb.installExampleSchemas=false
FQDN +oracle.install.db.config.starterdb.enableSecuritySettings=true
FQDN +oracle.install.db.config.starterdb.control=DB_CONTROL
FQDN +oracle.install.db.config.starterdb.automatedBackup.enable=false
FQDN +SECURITY_UPDATES_VIA_MYORACLESUPPORT=false
FQDN +DECLINE_SECURITY_UPDATES=true
FQDN +oracle.installer.autoupdates.option=SKIP_UPDATES
FQDN
FQDN * bash[run_rdbms_installer] action run
FQDN
FQDN - execute "bash" "/tmp/chef-script20130705-1387-1k4ui3l"
FQDN
FQDN
FQDN * execute[root.sh_rdbms] action run
FQDN
FQDN - execute /opt/oracle/11.2.0.3/root.sh
FQDN
FQDN * execute[install_dir_cleanup] action run
FQDN
FQDN - execute rm -rf /opt/oracle/install_dir/*
FQDN
FQDN * template[/opt/oracle/11.2.0.3/network/admin/listener.ora] action create
FQDN
FQDN - create template[/opt/oracle/11.2.0.3/network/admin/listener.ora]
FQDN --- /tmp/chef-tempfile20130705-1387-1drls3a 2013-07-05 10:56:35.311948247 -0400
FQDN +++ /tmp/chef-rendered-template20130705-1387-irbuko 2013-07-05 10:56:35.310948165 -0400
FQDN @@ -0,0 +1,10 @@
FQDN +LISTENER =
FQDN + (DESCRIPTION_LIST =
FQDN + (DESCRIPTION =
FQDN + (ADDRESS = (PROTOCOL = TCP)(HOST = ip-X-X-X-X.region.compute.internal)(PORT = 1521))
FQDN + )
FQDN + )
FQDN +
FQDN +SECURE_REGISTER_LISTENER = (IPC)
FQDN +ADR_BASE_LISTENER =
FQDN +
FQDN
FQDN
FQDN * execute[start_listener] action run
FQDN
FQDN - execute /opt/oracle/11.2.0.3/bin/lsnrctl start
FQDN
FQDN * template[/etc/init.d/oracle] action create
FQDN
FQDN - create template[/etc/init.d/oracle]
FQDN --- /tmp/chef-tempfile20130705-1387-1tg3nl4 2013-07-05 10:56:37.220953353 -0400
FQDN +++ /tmp/chef-rendered-template20130705-1387-e9lp89 2013-07-05 10:56:37.219953350 -0400
FQDN @@ -0,0 +1,27 @@
FQDN +#!/bin/sh
FQDN +#
FQDN +# Init file for Oracle database server
FQDN +#
FQDN +# chkconfig: 35 99 02
FQDN +# description: Oracle database server
FQDN +
FQDN +case "$1" in
FQDN
FQDN +'start')
FQDN + su - oracle -c "/opt/oracle/11.2.0.3/bin/dbstart /opt/oracle/11R23"
FQDN + RETVAL=$?
FQDN + [ "$RETVAL" = 0 ] && touch /var/lock/subsys/oracle
FQDN + ;;
FQDN +
FQDN +'stop')
FQDN + su - oracle -c "/opt/oracle/11.2.0.3/bin/dbshut /opt/oracle/11R23"
FQDN + RETVAL=$?
FQDN + [ "$RETVAL" = 0 ] && rm -f /var/lock/subsys/oracle
FQDN + ;;
FQDN +
FQDN +*)
FQDN + echo "Usage: $0 { start | stop }"
FQDN + exit 1
FQDN + ;;
FQDN +
FQDN +esac
FQDN +exit 0
FQDN
FQDN * service[oracle] action enable
FQDN
FQDN - enable service service[oracle]
FQDN
FQDN
FQDN * ruby_block[set_rdbms_install_flag] action create
FQDN
FQDN - execute the ruby block set_rdbms_install_flag
FQDN
FQDN * cookbook_file[/opt/oracle/11.2.0.3/sqlplus/admin/glogin.sql] action create
FQDN
FQDN - create a new cookbook_file /opt/oracle/11.2.0.3/sqlplus/admin/glogin.sql
FQDN --- /opt/oracle/11.2.0.3/sqlplus/admin/glogin.sql 2011-04-10 22:57:50.000000000 -0400
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/glogin.sql 2013-07-05 10:56:38.240954437 -0400
FQDN @@ -1,16 +1,4 @@
FQDN ---
FQDN --- Copyright (c) 1988, 2011, Oracle and/or its affiliates.
FQDN --- All rights reserved.
FQDN ---
FQDN --- NAME
FQDN --- glogin.sql
FQDN ---
FQDN --- DESCRIPTION
FQDN
FQDN --- SQL*Plus global login "site profile" file
FQDN ---
FQDN --- Add any SQL*Plus commands here that are to be executed when a
FQDN --- user starts SQL*Plus, or uses the SQL*Plus CONNECT command.
FQDN ---
FQDN --- USAGE
FQDN --- This script is automatically run
FQDN ---
FQDN +define _editor=vi
FQDN +set sqlprompt _user'@'_connect_identifier>
FQDN +set pagesize 3000
FQDN +set linesize 130
FQDN
FQDN Recipe: echa-oracle::latest_dbpatch
FQDN * execute[send_stop_to_oracle_service] action run
FQDN
FQDN - execute service oracle stop
FQDN
FQDN * bash[fetch_latest_patch_media_11R23] action run
FQDN
FQDN - execute "bash" "/tmp/chef-script20130705-1387-1i01h1o"
FQDN
FQDN
FQDN * bash[patch_rdbms_opatch] action run
FQDN
FQDN - execute "bash" "/tmp/chef-script20130705-1387-1eoa7bx"
FQDN
FQDN * execute[gen_response_file] action run
FQDN
FQDN - execute echo | ./OPatch/ocm/bin/emocmrsp -output ./ocm.rsp foo bar && chmod 0644 ./ocm.rsp
FQDN
FQDN * bash[apply_latest_patch_rdbms] action run
FQDN
FQDN - execute "bash" "/tmp/chef-script20130705-1387-12krp4x"
FQDN
FQDN * ruby_block[set_latest_patch_install_flag] action create
FQDN - execute the ruby block set_latest_patch_install_flag
FQDN
FQDN Recipe: echa-oracle::get_version
FQDN * ruby_block[set_rdbms_version_attr] action create
FQDN
FQDN - execute the ruby block set_rdbms_version_attr
FQDN
FQDN * ruby_block[set_rdbms_version_attr] action nothing
FQDN (up to date)
FQDN Recipe: echa-oracle::latest_dbpatch
FQDN * ruby_block[set_latest_patch_install_flag] action nothing (up to date)
FQDN * execute[send_start_to_oracle_service] action run
FQDN
FQDN - execute service oracle start
FQDN
FQDN * execute[install_dir_cleanup_lp] action run
FQDN
FQDN - execute rm -rf /opt/oracle/install_dir/*
FQDN
FQDN Recipe: echa-oracle::logrotate_alert_log
FQDN * package[logrotate] action install
FQDN (up to date)
FQDN * cookbook_file[/etc/logrotate.d/oracle-alert-log] action create
FQDN
FQDN - create a new cookbook_file /etc/logrotate.d/oracle-alert-log
FQDN --- /tmp/chef-tempfile20130705-1387-zogxot 2013-07-05 11:09:21.022953489 -0400
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/oracle-alert-log 2013-07-05 11:09:21.020953533 -0400
FQDN @@ -0,0 +1,9 @@
FQDN +/opt/oracle/diag/rdbms/*/*/trace/alert_*.log {
FQDN +weekly
FQDN +copytruncate
FQDN +rotate 10400
FQDN +compress
FQDN +create 640 oracle oinstall
FQDN +dateext
FQDN +dateformat -%Y-%m-%d-%s
FQDN +}
FQDN
FQDN Recipe: echa-oracle::logrotate_listener
FQDN * package[logrotate] action install
FQDN (up to date)
FQDN * cookbook_file[/etc/logrotate.d/oracle-listener] action create
FQDN
FQDN - create a new cookbook_file /etc/logrotate.d/oracle-listener
FQDN --- /tmp/chef-tempfile20130705-1387-1ww1lbm 2013-07-05 11:09:21.712950794 -0400
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/oracle-listener 2013-07-05 11:09:21.711950720 -0400
FQDN @@ -0,0 +1,9 @@
FQDN +/opt/oracle/diag/tnslsnr/*/listener/trace/listener.log {
FQDN +weekly
FQDN +copytruncate
FQDN +rotate 8
FQDN +compress
FQDN +create 640 oracle oinstall
FQDN +dateext
FQDN +dateformat -%Y-%m-%d-%s
FQDN +}
FQDN
FQDN Recipe: echa-oracle::createdb
FQDN * directory[/oradata] action create
FQDN
FQDN - create new directory /oradata
FQDN
FQDN - change mode from '' to '0755'
FQDN - change owner from '' to 'oracle'
FQDN - change group from '' to 'oinstall'
FQDN
FQDN
FQDN * template[/opt/oracle/11.2.0.3/assistants/dbca/templates/default_template.dbt] action create
FQDN
FQDN - create template[/opt/oracle/11.2.0.3/assistants/dbca/templates/default_template.dbt]
FQDN --- /tmp/chef-tempfile20130705-1387-tesgc2 2013-07-05 11:09:22.537953348 -0400
FQDN +++ /tmp/chef-rendered-template20130705-1387-wsuspv 2013-07-05 11:09:22.536953348 -0400
FQDN @@ -0,0 +1,392 @@
FQDN +<DatabaseTemplate name="default_template" description="" version="11.1.0.0.0">
FQDN + <CommonAttributes>
FQDN
FQDN + <option name="OMS" value="false"/>
FQDN + <option name="JSERVER" value="true"/>
FQDN + <option name="SPATIAL" value="false"/>
FQDN + <option name="IMEDIA" value="true"/>
FQDN + <option name="XDB_PROTOCOLS" value="true">
FQDN + <tablespace id="SYSAUX"/>
FQDN + </option>
FQDN + <option name="ORACLE_TEXT" value="true">
FQDN + <tablespace id="SYSAUX"/>
FQDN + </option>
FQDN + <option name="SAMPLE_SCHEMA" value="false"/>
FQDN + <option name="CWMLITE" value="false"/>
FQDN + <option name="EM_REPOSITORY" value="false"/>
FQDN + <option name="APEX" value="false"/>
FQDN + <option name="OWB" value="true"/>
FQDN + <option name="DV" value="false"/>
FQDN + </CommonAttributes>
FQDN + <Variables/>
FQDN
FQDN + <CustomScripts Execute="false"/>
FQDN + <InitParamAttributes>
FQDN + <InitParams>
FQDN + <initParam name="db_name" value=""/>
FQDN + <initParam name="dispatchers" value="(PROTOCOL=TCP) (SERVICE={SID}XDB)"/>
FQDN + <initParam name="audit_file_dest" value="{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/adump"/>
FQDN + <initParam name="compatible" value="11.2.0.0.0"/>
FQDN + <initParam name="remote_login_passwordfile" value="EXCLUSIVE"/>
FQDN + <initParam name="log_archive_dest_2" value="'LOCATION=/oradata/{DB_UNIQUE_NAME}/arch2'"/>
FQDN + <initParam name="log_archive_dest_1" value="'LOCATION=/oradata/{DB_UNIQUE_NAME}/arch1'"/>
FQDN + <initParam name="processes" value="999"/>
FQDN + <initParam name="undo_tablespace" value="UNDOTBS1"/>
FQDN + <initParam name="control_files" value="(&quot;/oradata/{DB_UNIQUE_NAME}/control01.ctl&quot;, &quot;/oracle/{DB_UNIQUE_NAME}/redo1/control02.ctl&quot;)"/>
FQDN + <initParam name="diagnostic_dest" value="/opt/oracle"/>
FQDN + <initParam name="db_recovery_file_dest" value="/oradata/{DB_UNIQUE_NAME}/flash_recovery_area"/>
FQDN + <initParam name="audit_trail" value="DB"/>
FQDN + <initParam name="log_archive_format" value="{SID}_%t_%s_%r.arc"/>
FQDN + <initParam name="memory_target" value="1157627904"/>
FQDN + <initParam name="sessions" value="1520"/>
FQDN + <initParam name="db_block_size" value="8192"/>
FQDN
FQDN + <initParam name="open_cursors" value="1000"/>
FQDN + <initParam name="db_recovery_file_dest_size" value="20971520000"/>
FQDN + </InitParams>
FQDN + <MiscParams>
FQDN + <characterSet>AL32UTF8</characterSet>
FQDN + <nationalCharacterSet>AL16UTF16</nationalCharacterSet>
FQDN + <archiveLogMode>true</archiveLogMode>
FQDN + <initParamFileName>{ORACLE_BASE}/admin/{DB_UNIQUE_NAME}/pfile/init.ora</initParamFileName>
FQDN + </MiscParams>
FQDN + <SPfile useSPFile="true">{ORACLE_HOME}/dbs/spfile{SID}.ora</SPfile>
FQDN + </InitParamAttributes>
FQDN + <StorageAttributes>
FQDN + <ControlfileAttributes id="Controlfile">
FQDN + <maxDatafiles>200</maxDatafiles>
FQDN + <maxLogfiles>16</maxLogfiles>
FQDN + <maxLogMembers>3</maxLogMembers>
FQDN + <maxLogHistory>1</maxLogHistory>
FQDN + <maxInstances>8</maxInstances>
FQDN + <image name="control01.ctl" filepath="/oradata/{DB_UNIQUE_NAME}/data1/"/>
FQDN + <image name="control02.ctl" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + </ControlfileAttributes>
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/sysaux01.dbf">
FQDN
FQDN + <tablespace>SYSAUX</tablespace>
FQDN + <temporary>false</temporary>
FQDN + <online>true</online>
FQDN + <status>0</status>
FQDN + <size unit="MB">600</size>
FQDN + <reuse>true</reuse>
FQDN + <autoExtend>true</autoExtend>
FQDN + <increment unit="KB">10240</increment>
FQDN + <maxSize unit="MB">32767</maxSize>
FQDN + </DatafileAttributes>
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/system01.dbf">
FQDN + <tablespace>SYSTEM</tablespace>
FQDN + <temporary>false</temporary>
FQDN + <online>true</online>
FQDN + <status>0</status>
FQDN + <size unit="MB">730</size>
FQDN + <reuse>true</reuse>
FQDN + <autoExtend>true</autoExtend>
FQDN + <increment unit="KB">10240</increment>
FQDN + <maxSize unit="MB">32767</maxSize>
FQDN + </DatafileAttributes>
FQDN
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/data01.dbf">
FQDN + <tablespace>DATA</tablespace>
FQDN + <temporary>false</temporary>
FQDN + <online>true</online>
FQDN + <status>0</status>
FQDN + <size unit="MB">1500</size>
FQDN + <reuse>true</reuse>
FQDN + <autoExtend>true</autoExtend>
FQDN + <increment unit="MB">500</increment>
FQDN + <maxSize unit="MB">20000</maxSize>
FQDN + </DatafileAttributes>
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/index1/index01.dbf">
FQDN + <tablespace>INDEX</tablespace>
FQDN + <temporary>false</temporary>
FQDN + <online>true</online>
FQDN + <status>0</status>
FQDN + <size unit="MB">500</size>
FQDN + <reuse>true</reuse>
FQDN + <autoExtend>true</autoExtend>
FQDN + <increment unit="MB">500</increment>
FQDN + <maxSize unit="MB">20000</maxSize>
FQDN + </DatafileAttributes>
FQDN
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/temp1/temp01.dbf">
FQDN + <tablespace>TEMP</tablespace>
FQDN + <temporary>true</temporary>
FQDN + <online>true</online>
FQDN + <status>0</status>
FQDN + <size unit="MB">68</size>
FQDN + <reuse>true</reuse>
FQDN + <autoExtend>true</autoExtend>
FQDN + <increment unit="KB">640</increment>
FQDN + <maxSize unit="MB">32767</maxSize>
FQDN + </DatafileAttributes>
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/undo1/undotbs01.dbf">
FQDN + <tablespace>UNDOTBS1</tablespace>
FQDN + <temporary>false</temporary>
FQDN + <online>true</online>
FQDN + <status>0</status>
FQDN + <size unit="MB">430</size>
FQDN + <reuse>true</reuse>
FQDN + <autoExtend>true</autoExtend>
FQDN + <increment unit="KB">5120</increment>
FQDN
FQDN + <maxSize unit="MB">32767</maxSize>
FQDN + </DatafileAttributes>
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/users01.dbf">
FQDN + <tablespace>USERS</tablespace>
FQDN + <temporary>false</temporary>
FQDN + <online>true</online>
FQDN + <status>0</status>
FQDN + <size unit="MB">100</size>
FQDN + <reuse>true</reuse>
FQDN + <autoExtend>true</autoExtend>
FQDN + <increment unit="KB">1280</increment>
FQDN + <maxSize unit="MB">32767</maxSize>
FQDN + </DatafileAttributes>
FQDN + <TablespaceAttributes id="SYSAUX">
FQDN + <online>true</online>
FQDN + <offlineMode>1</offlineMode>
FQDN + <readOnly>false</readOnly>
FQDN + <temporary>false</temporary>
FQDN + <defaultTemp>false</defaultTemp>
FQDN + <undo>false</undo>
FQDN + <local>true</local>
FQDN + <blockSize>8192</blockSize>
FQDN + <allocation>1</allocation>
FQDN + <uniAllocSize unit="KB">-1</uniAllocSize>
FQDN + <initSize unit="KB">64</initSize>
FQDN + <increment unit="KB">0</increment>
FQDN
FQDN + <incrementPercent>0</incrementPercent>
FQDN + <minExtends>1</minExtends>
FQDN + <maxExtends>2147483645</maxExtends>
FQDN + <minExtendsSize unit="KB">64</minExtendsSize>
FQDN + <logging>true</logging>
FQDN + <recoverable>false</recoverable>
FQDN + <maxFreeSpace>0</maxFreeSpace>
FQDN + <autoSegmentMgmt>true</autoSegmentMgmt>
FQDN + <bigfile>false</bigfile>
FQDN + <datafilesList>
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/sysaux01.dbf">
FQDN + <id>-1</id>
FQDN + </TablespaceDatafileAttributes>
FQDN + </datafilesList>
FQDN + </TablespaceAttributes>
FQDN + <TablespaceAttributes id="SYSTEM">
FQDN + <online>true</online>
FQDN + <offlineMode>1</offlineMode>
FQDN + <readOnly>false</readOnly>
FQDN + <temporary>false</temporary>
FQDN + <defaultTemp>false</defaultTemp>
FQDN + <undo>false</undo>
FQDN + <local>true</local>
FQDN + <blockSize>8192</blockSize>
FQDN + <allocation>1</allocation>
FQDN + <uniAllocSize unit="KB">-1</uniAllocSize>
FQDN
FQDN + <initSize unit="KB">64</initSize>
FQDN + <increment unit="KB">0</increment>
FQDN + <incrementPercent>0</incrementPercent>
FQDN + <minExtends>1</minExtends>
FQDN + <maxExtends>2147483645</maxExtends>
FQDN + <minExtendsSize unit="KB">64</minExtendsSize>
FQDN + <logging>true</logging>
FQDN + <recoverable>false</recoverable>
FQDN + <maxFreeSpace>0</maxFreeSpace>
FQDN + <autoSegmentMgmt>false</autoSegmentMgmt>
FQDN + <bigfile>false</bigfile>
FQDN + <datafilesList>
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/system01.dbf">
FQDN + <id>-1</id>
FQDN + </TablespaceDatafileAttributes>
FQDN + </datafilesList>
FQDN + </TablespaceAttributes>
FQDN + <TablespaceAttributes id="DATA">
FQDN + <online>true</online>
FQDN + <offlineMode>1</offlineMode>
FQDN
FQDN + <readOnly>false</readOnly>
FQDN + <temporary>false</temporary>
FQDN + <defaultTemp>false</defaultTemp>
FQDN + <undo>false</undo>
FQDN + <local>true</local>
FQDN + <blockSize>8192</blockSize>
FQDN + <allocation>2</allocation>
FQDN + <uniAllocSize unit="KB">1024</uniAllocSize>
FQDN + <initSize unit="KB">1024</initSize>
FQDN + <increment unit="KB">1024</increment>
FQDN + <incrementPercent>0</incrementPercent>
FQDN + <minExtends>1</minExtends>
FQDN + <maxExtends>2147483645</maxExtends>
FQDN + <minExtendsSize unit="KB">1024</minExtendsSize>
FQDN + <logging>true</logging>
FQDN + <recoverable>false</recoverable>
FQDN + <maxFreeSpace>0</maxFreeSpace>
FQDN + <autoSegmentMgmt>true</autoSegmentMgmt>
FQDN + <bigfile>false</bigfile>
FQDN + <datafilesList>
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/data01.dbf">
FQDN + <id>-1</id>
FQDN + </TablespaceDatafileAttributes>
FQDN
FQDN + </datafilesList>
FQDN + </TablespaceAttributes>
FQDN + <TablespaceAttributes id="INDEX">
FQDN + <online>true</online>
FQDN + <offlineMode>1</offlineMode>
FQDN + <readOnly>false</readOnly>
FQDN + <temporary>false</temporary>
FQDN + <defaultTemp>false</defaultTemp>
FQDN + <undo>false</undo>
FQDN + <local>true</local>
FQDN + <blockSize>8192</blockSize>
FQDN + <allocation>2</allocation>
FQDN + <uniAllocSize unit="KB">256</uniAllocSize>
FQDN + <initSize unit="KB">256</initSize>
FQDN + <increment unit="KB">256</increment>
FQDN + <incrementPercent>0</incrementPercent>
FQDN + <minExtends>1</minExtends>
FQDN + <maxExtends>2147483645</maxExtends>
FQDN + <minExtendsSize unit="KB">256</minExtendsSize>
FQDN + <logging>true</logging>
FQDN + <recoverable>false</recoverable>
FQDN + <maxFreeSpace>0</maxFreeSpace>
FQDN + <autoSegmentMgmt>true</autoSegmentMgmt>
FQDN + <bigfile>false</bigfile>
FQDN + <datafilesList>
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/index1/index01.dbf">
FQDN + <id>-1</id>
FQDN + </TablespaceDatafileAttributes>
FQDN + </datafilesList>
FQDN + </TablespaceAttributes>
FQDN + <TablespaceAttributes id="TEMP">
FQDN + <online>true</online>
FQDN + <offlineMode>1</offlineMode>
FQDN + <readOnly>false</readOnly>
FQDN + <temporary>true</temporary>
FQDN + <defaultTemp>true</defaultTemp>
FQDN + <undo>false</undo>
FQDN + <local>true</local>
FQDN + <blockSize>8192</blockSize>
FQDN + <allocation>2</allocation>
FQDN + <uniAllocSize unit="KB">1024</uniAllocSize>
FQDN + <initSize unit="KB">1024</initSize>
FQDN + <increment unit="KB">1024</increment>
FQDN + <incrementPercent>0</incrementPercent>
FQDN + <minExtends>1</minExtends>
FQDN + <maxExtends>-1</maxExtends>
FQDN + <minExtendsSize unit="KB">1024</minExtendsSize>
FQDN + <logging>false</logging>
FQDN + <recoverable>false</recoverable>
FQDN + <maxFreeSpace>0</maxFreeSpace>
FQDN
FQDN + <autoSegmentMgmt>false</autoSegmentMgmt>
FQDN + <bigfile>false</bigfile>
FQDN + <datafilesList>
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/temp1/temp01.dbf">
FQDN + <id>-1</id>
FQDN + </TablespaceDatafileAttributes>
FQDN + </datafilesList>
FQDN + </TablespaceAttributes>
FQDN
FQDN + <TablespaceAttributes id="UNDOTBS1">
FQDN + <online>true</online>
FQDN + <offlineMode>1</offlineMode>
FQDN + <readOnly>false</readOnly>
FQDN + <temporary>false</temporary>
FQDN + <defaultTemp>false</defaultTemp>
FQDN + <undo>true</undo>
FQDN
FQDN + <local>true</local>
FQDN + <blockSize>8192</blockSize>
FQDN + <allocation>1</allocation>
FQDN + <uniAllocSize unit="KB">-1</uniAllocSize>
FQDN + <initSize unit="KB">64</initSize>
FQDN + <increment unit="KB">0</increment>
FQDN + <incrementPercent>0</incrementPercent>
FQDN + <minExtends>1</minExtends>
FQDN + <maxExtends>2147483645</maxExtends>
FQDN + <minExtendsSize unit="KB">64</minExtendsSize>
FQDN + <logging>true</logging>
FQDN + <recoverable>false</recoverable>
FQDN + <maxFreeSpace>0</maxFreeSpace>
FQDN + <autoSegmentMgmt>false</autoSegmentMgmt>
FQDN + <bigfile>false</bigfile>
FQDN + <datafilesList>
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/undo1/undotbs01.dbf">
FQDN + <id>-1</id>
FQDN + </TablespaceDatafileAttributes>
FQDN + </datafilesList>
FQDN + </TablespaceAttributes>
FQDN + <TablespaceAttributes id="USERS">
FQDN + <online>true</online>
FQDN
FQDN + <offlineMode>1</offlineMode>
FQDN + <readOnly>false</readOnly>
FQDN + <temporary>false</temporary>
FQDN + <defaultTemp>false</defaultTemp>
FQDN + <undo>false</undo>
FQDN + <local>true</local>
FQDN + <blockSize>8192</blockSize>
FQDN + <allocation>1</allocation>
FQDN + <uniAllocSize unit="KB">-1</uniAllocSize>
FQDN + <initSize unit="KB">64</initSize>
FQDN + <increment unit="KB">0</increment>
FQDN + <incrementPercent>0</incrementPercent>
FQDN + <minExtends>1</minExtends>
FQDN + <maxExtends>2147483645</maxExtends>
FQDN + <minExtendsSize unit="KB">64</minExtendsSize>
FQDN + <logging>true</logging>
FQDN + <recoverable>false</recoverable>
FQDN + <maxFreeSpace>0</maxFreeSpace>
FQDN + <autoSegmentMgmt>true</autoSegmentMgmt>
FQDN + <bigfile>false</bigfile>
FQDN + <datafilesList>
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/users01.dbf">
FQDN + <id>-1</id>
FQDN + </TablespaceDatafileAttributes>
FQDN + </datafilesList>
FQDN
FQDN + </TablespaceAttributes>
FQDN + <RedoLogGroupAttributes id="1">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN + <member ordinal="0" memberName="redo01_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo01_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + <RedoLogGroupAttributes id="2">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN + <member ordinal="0" memberName="redo02_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo02_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + <RedoLogGroupAttributes id="3">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN + <member ordinal="0" memberName="redo03_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo03_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + <RedoLogGroupAttributes id="4">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN
FQDN + <member ordinal="0" memberName="redo04_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo04_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + <RedoLogGroupAttributes id="5">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN + <member ordinal="0" memberName="redo05_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo05_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + <RedoLogGroupAttributes id="6">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN + <member ordinal="0" memberName="redo06_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo06_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + <RedoLogGroupAttributes id="7">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN + <member ordinal="0" memberName="redo07_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo07_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + <RedoLogGroupAttributes id="8">
FQDN + <reuse>false</reuse>
FQDN + <fileSize unit="KB">204800</fileSize>
FQDN + <Thread>1</Thread>
FQDN
FQDN + <member ordinal="0" memberName="redo08_1.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo1/"/>
FQDN + <member ordinal="1" memberName="redo08_2.rdo" filepath="/oradata/{DB_UNIQUE_NAME}/redo2/"/>
FQDN + </RedoLogGroupAttributes>
FQDN + </StorageAttributes>
FQDN +</DatabaseTemplate>
FQDN
FQDN * ruby_block[print_empty_db_hash_warning] action create
FQDN (skipped due to only_if)
FQDN * bash[dbca_createdb_FOO] action run
FQDN
FQDN - execute "bash" "/tmp/chef-script20130705-1387-11i69j7"
FQDN
FQDN * ruby_block[set_FOO_install_flag] action create
FQDN
FQDN - execute the ruby block set_FOO_install_flag
FQDN
FQDN * ruby_block[append_FOO_stanza_to_lsnr_conf] action create
FQDN
FQDN - execute the ruby block append_FOO_stanza_to_lsnr_conf
FQDN
FQDN * execute[append_FOO_to_tnsnames.ora] action run
FQDN
FQDN - execute echo 'FOO =
FQDN (DESCRIPTION =
FQDN (ADDRESS_LIST =
FQDN (ADDRESS = (PROTOCOL = TCP)(HOST = ip-X-X-X-X.region.compute.internal)(PORT = 1521))
FQDN )
FQDN (CONNECT_DATA =
FQDN (SERVICE_NAME = FOO)
FQDN )
FQDN )
FQDN
FQDN ' >> /opt/oracle/11.2.0.3/network/admin/tnsnames.ora
FQDN
FQDN * execute[edit_oratabs_FOO_config] action run
FQDN
FQDN - execute sed -i.old '/^FOO/s/N$/Y/' /etc/oratab
FQDN
FQDN * execute[reload_listener_to_register_FOO] action run
FQDN
FQDN - execute /opt/oracle/11.2.0.3/bin/lsnrctl reload
FQDN
FQDN * directory[/oradata/FOO/export] action create
FQDN
FQDN - create new directory /oradata/FOO/export
FQDN
FQDN - change mode from '' to '0755'
FQDN - change owner from '' to 'oracle'
FQDN - change group from '' to 'dba'
FQDN
FQDN
FQDN * bash[block_change_tracking_FOO] action run
FQDN
FQDN - execute "bash" "/tmp/chef-script20130705-1387-1280g7m"
FQDN
FQDN * directory[/oradata/FOO/backup1] action create
FQDN
FQDN - create new directory /oradata/FOO/backup1
FQDN
FQDN - change mode from '' to '0755'
FQDN - change owner from '' to 'oracle'
FQDN - change group from '' to 'oinstall'
FQDN
FQDN
FQDN * execute[set_oracle_sid_to_oracle_profile_FOO] action run
FQDN
FQDN - execute sed -i 's/ORACLE_SID=/ORACLE_SID=FOO/g' /home/oracle/.profile
FQDN
FQDN Chef Client finished, 58 resources updated
Instance ID: i-XXXXXXXX
Flavor: m1.small
Image: ami-9bf6e0ef
Region: region
Availability Zone: availzone
Security Groups: sec_group
Security Group Ids: default
Tags: {"Name"=>"i-XXXXXXXX"}
SSH Key: key1
Root Device Type: ebs
Root Volume ID: vol-ZZZZZZZZ
Root Device Name: /dev/sda1
Root Device Delete on Terminate: true
Warning: 20GB EBS volume size is larger than size set in AMI of 7GB.
Use file system tools to make use of the increased volume size.
Public DNS Name: FQDN
Public IP Address: X.X.X.X
Private DNS Name: ip-X-X-X-X.region.compute.internal
Private IP Address: X.X.X.X
Environment: _default
Run List: role[ora_quickstart]
JSON Attributes: {"oracle"=>{"rdbms"=>{"dbs"=>{"FOO"=>false}}}}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment