Last active
December 19, 2015 08:29
-
-
Save aririikonen/5925691 to your computer and use it in GitHub Desktop.
CHEF: echa-oracle v1.0.0 cookbook test output on DigitalOcean VM 3rd of July 2013
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Bootstrapping Chef on FQDN | |
Failed to authenticate root - trying password auth | |
Enter your password: | |
FQDN --2013-07-03 12:28:11-- http://opscode.com/chef/install.sh | |
FQDN Resolving opscode.com... | |
FQDN 184.106.28.82 | |
FQDN Connecting to opscode.com|184.106.28.82|: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-03 12:28:12-- http://www.opscode.com/chef/install.sh | |
FQDN Resolving www.opscode.com... | |
FQDN 184.106.28.83 | |
FQDN Connecting to www.opscode.com|184.106.28.83|:80... | |
FQDN connected. | |
FQDN HTTP request sent, awaiting response... | |
FQDN 200 OK | |
FQDN Length: 6515 (6.4K) [application/x-sh] | |
FQDN Saving to: `STDOUT' | |
FQDN | |
0% [ ] 0 --.-K/s | |
100%[======================================>] 6,515 --.-K/s in 0.1s | |
FQDN | |
FQDN 2013-07-03 12:28:12 (63.0 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.oCmXfgjj/chef-11.4.4.x86_64.rpm: Header V4 DSA/SHA1 Signature, key ID XXXXXX: NOKEY | |
FQDN Preparing... | |
FQDN ######################################## (100%) | |
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 FQDN 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-03T12:28:40+00:00] WARN: Cloning resource attributes for yum_package[ksh] from prior resource (CHEF-3694) | |
FQDN [2013-07-03T12:28:40+00:00] WARN: Previous yum_package[ksh]: /var/chef/cache/cookbooks/echa-oracle/recipes/oracle_user_config.rb:40:in `from_file' | |
FQDN [2013-07-03T12:28:40+00:00] WARN: Current yum_package[ksh]: /var/chef/cache/cookbooks/echa-oracle/recipes/deps_install.rb:23:in `block in from_file' | |
FQDN [2013-07-03T12:28:40+00:00] WARN: Cloning resource attributes for package[logrotate] from prior resource (CHEF-3694) | |
FQDN [2013-07-03T12:28:40+00:00] WARN: Previous package[logrotate]: /var/chef/cache/cookbooks/echa-oracle/recipes/logrotate_alert_log.rb:24:in `from_file' | |
FQDN [2013-07-03T12:28:40+00:00] WARN: Current package[logrotate]: /var/chef/cache/cookbooks/echa-oracle/recipes/logrotate_listener.rb:23:in `from_file' | |
FQDN Converging 71 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-tempfile20130703-6400-13fabtv 2013-07-03 12:28:49.874000361 +0000 | |
FQDN +++ /tmp/chef-rendered-template20130703-6400-wksn04 2013-07-03 12:28:49.873000383 +0000 | |
FQDN @@ -0,0 +1,36 @@ | |
FQDN | |
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/11R | |
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 +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 + | |
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 * 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 - 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-tempfile20130703-6400-kivwn6 2013-07-03 12:28:50.659001046 +0000 | |
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/ora_limits 2013-07-03 12:28:50.657001121 +0000 | |
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 +#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 | |
FQDN - install version 0.3.107-10.el6 of package libaio | |
FQDN | |
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 | |
FQDN - install version 3.81-20.el6 of package make | |
FQDN | |
FQDN * yum_package[sysstat] action install | |
FQDN | |
FQDN - install version 9.0.4-20.el6 of package sysstat | |
FQDN | |
FQDN Recipe: echa-oracle::kernel_params | |
FQDN * bash[sysctl_reload] action nothing (up to date) | |
FQDN * directory[/etc/sysctl.d] action create | |
FQDN - create new directory /etc/sysctl.d | |
FQDN - change mode from '' to '0755' | |
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-tempfile20130703-6400-sd82wb 2013-07-03 12:29:14.274998454 +0000 | |
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/ora_params 2013-07-03 12:29:14.272998346 +0000 | |
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 +net.core.wmem_max = 1048576 | |
FQDN | |
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-script20130703-6400-11ccxhe" | |
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://FQDN_HTTPS/orapkg/p10404530_112030_Linux-x86-64_1of7.zip] action run | |
FQDN | |
FQDN - execute curl -kO https://FQDN_HTTPS/orapkg/p10404530_112030_Linux-x86-64_1of7.zip | |
FQDN | |
FQDN * execute[unzip_media_11R23-https://FQDN_HTTPS/orapkg/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://FQDN_HTTPS/orapkg/p10404530_112030_Linux-x86-64_2of7.zip] action run | |
FQDN | |
FQDN - execute curl -kO https://FQDN_HTTPS/orapkg/p10404530_112030_Linux-x86-64_2of7.zip | |
FQDN | |
FQDN * execute[unzip_media_11R23-https://FQDN_HTTPS/orapkg/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-tempfile20130703-6400-8r4v0d 2013-07-03 12:33:02.894000037 +0000 | |
FQDN +++ /tmp/chef-diff20130703-6400-1ayleuw 2013-07-03 12:33:02.894000037 +0000 | |
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 * template[/opt/oracle/install_dir/db11R23.rsp] action create | |
FQDN | |
FQDN - create template[/opt/oracle/install_dir/db11R23.rsp] | |
FQDN --- /tmp/chef-tempfile20130703-6400-1aebv7n 2013-07-03 12:33:03.601000112 +0000 | |
FQDN +++ /tmp/chef-rendered-template20130703-6400-uaim5q 2013-07-03 12:33:03.601000112 +0000 | |
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=FQDN | |
FQDN +UNIX_GROUP_NAME=oinstall | |
FQDN +INVENTORY_LOCATION=/opt/oraInventory | |
FQDN +SELECTED_LANGUAGES=en | |
FQDN +ORACLE_HOME=/opt/oracle/11R | |
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 +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 | |
FQDN * bash[run_rdbms_installer] action run | |
FQDN | |
FQDN - execute "bash" "/tmp/chef-script20130703-6400-1m4n7uk" | |
FQDN | |
FQDN * execute[root.sh_rdbms] action run | |
FQDN | |
FQDN - execute /opt/oracle/11R23/root.sh | |
FQDN | |
FQDN * execute[install_dir_cleanup] action run | |
FQDN | |
FQDN - execute rm -rf /opt/oracle/install_dir/* | |
FQDN | |
FQDN * template[/opt/oracle/11R23/network/admin/listener.ora] action create | |
FQDN | |
FQDN - create template[/opt/oracle/11R23/network/admin/listener.ora] | |
FQDN --- /tmp/chef-tempfile20130703-6400-1gxm99u 2013-07-03 12:36:32.728001754 +0000 | |
FQDN +++ /tmp/chef-rendered-template20130703-6400-103fkru 2013-07-03 12:36:32.726001870 +0000 | |
FQDN @@ -0,0 +1,10 @@ | |
FQDN +LISTENER = | |
FQDN + (DESCRIPTION_LIST = | |
FQDN + (DESCRIPTION = | |
FQDN + (ADDRESS = (PROTOCOL = TCP)(HOST = FQDN)(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/11R23/bin/lsnrctl start | |
FQDN | |
FQDN * template[/etc/init.d/oracle] action create | |
FQDN | |
FQDN - create template[/etc/init.d/oracle] | |
FQDN --- /tmp/chef-tempfile20130703-6400-1cwyfz3 2013-07-03 12:36:33.927999727 +0000 | |
FQDN +++ /tmp/chef-rendered-template20130703-6400-owwpm2 2013-07-03 12:36:33.926999705 +0000 | |
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/11R23/bin/dbstart /opt/oracle/11R" | |
FQDN + RETVAL=$? | |
FQDN + [ "$RETVAL" = 0 ] && touch /var/lock/subsys/oracle | |
FQDN + ;; | |
FQDN + | |
FQDN +'stop') | |
FQDN + su - oracle -c "/opt/oracle/11R23/bin/dbshut /opt/oracle/11R" | |
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 | |
FQDN +exit 0 | |
FQDN | |
FQDN * service[oracle] action enable | |
FQDN | |
FQDN - enable service service[oracle] | |
FQDN | |
FQDN * ruby_block[set_rdbms_install_flag] action create | |
FQDN - execute the ruby block set_rdbms_install_flag | |
FQDN | |
FQDN * cookbook_file[/opt/oracle/11R23/sqlplus/admin/glogin.sql] action create | |
FQDN | |
FQDN - create a new cookbook_file /opt/oracle/11R23/sqlplus/admin/glogin.sql | |
FQDN --- /opt/oracle/11R23/sqlplus/admin/glogin.sql 2011-04-10 22:57:50.000000000 +0000 | |
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/glogin.sql 2013-07-03 12:36:34.659000653 +0000 | |
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 --- 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 --- | |
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-script20130703-6400-1lw3b0o" | |
FQDN | |
FQDN * bash[patch_rdbms_opatch] action run | |
FQDN | |
FQDN - execute "bash" "/tmp/chef-script20130703-6400-a16jjf" | |
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-script20130703-6400-n5k8wl" | |
FQDN | |
FQDN | |
FQDN * ruby_block[set_latest_patch_install_flag] action create | |
FQDN | |
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 | |
FQDN (up to date) | |
FQDN * execute[send_start_to_oracle_service] action run | |
FQDN | |
FQDN - execute service oracle start | |
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-tempfile20130703-6400-1mobf3s 2013-07-03 12:41:05.998999778 +0000 | |
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/oracle-alert-log 2013-07-03 12:41:05.996999739 +0000 | |
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-tempfile20130703-6400-17gk0im 2013-07-03 12:41:06.605000040 +0000 | |
FQDN +++ /var/chef/cache/cookbooks/echa-oracle/files/default/oracle-listener 2013-07-03 12:41:06.603000055 +0000 | |
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 | |
FQDN Recipe: echa-oracle::createdb | |
FQDN * directory[/oradata2] action create | |
FQDN | |
FQDN - create new directory /oradata2 | |
FQDN | |
FQDN - change mode from '' to '0755' | |
FQDN - change owner from '' to 'oracle' | |
FQDN - change group from '' to 'oinstall' | |
FQDN | |
FQDN * template[/opt/oracle/11R23/assistants/dbca/templates/default_template.dbt] action create | |
FQDN | |
FQDN - create template[/opt/oracle/11R23/assistants/dbca/templates/default_template.dbt] | |
FQDN --- /tmp/chef-tempfile20130703-6400-eoarme 2013-07-03 12:41:07.399999961 +0000 | |
FQDN | |
FQDN +++ /tmp/chef-rendered-template20130703-6400-1ocundu 2013-07-03 12:41:07.398999946 +0000 | |
FQDN @@ -0,0 +1,392 @@ | |
FQDN +<DatabaseTemplate name="default_template" description="" version="11.1.0.0.0"> | |
FQDN + <CommonAttributes> | |
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 | |
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 + <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 | |
FQDN + <initParam name="control_files" value="("/oradata/{DB_UNIQUE_NAME}/control01.ctl", "/oracle/{DB_UNIQUE_NAME}/redo1/control02.ctl")"/> | |
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 + <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 | |
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 + <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 | |
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 + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/data01.dbf"> | |
FQDN + <tablespace>DATA</tablespace> | |
FQDN + <temporary>false</temporary> | |
FQDN + <online>true</online> | |
FQDN | |
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 + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/temp1/temp01.dbf"> | |
FQDN + <tablespace>TEMP</tablespace> | |
FQDN + <temporary>true</temporary> | |
FQDN | |
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 + <maxSize unit="MB">32767</maxSize> | |
FQDN + </DatafileAttributes> | |
FQDN + <DatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/users01.dbf"> | |
FQDN | |
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 | |
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>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 | |
FQDN + <TablespaceAttributes id="DATA"> | |
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">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 | |
FQDN + <datafilesList> | |
FQDN + <TablespaceDatafileAttributes id="/oradata/{DB_UNIQUE_NAME}/data1/data01.dbf"> | |
FQDN + <id>-1</id> | |
FQDN + </TablespaceDatafileAttributes> | |
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 | |
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 | |
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 + <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 + <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 | |
FQDN + <TablespaceAttributes id="USERS"> | |
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 + <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 | |
FQDN + <id>-1</id> | |
FQDN + </TablespaceDatafileAttributes> | |
FQDN + </datafilesList> | |
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 | |
FQDN + <RedoLogGroupAttributes id="4"> | |
FQDN + <reuse>false</reuse> | |
FQDN + <fileSize unit="KB">204800</fileSize> | |
FQDN + <Thread>1</Thread> | |
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 | |
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 + <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 (skipped due to only_if) | |
FQDN * bash[dbca_createdb_FOO] action run | |
FQDN | |
FQDN - execute "bash" "/tmp/chef-script20130703-6400-1wv2hex" | |
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 = FQDN)(PORT = 1521)) | |
FQDN ) | |
FQDN (CONNECT_DATA = | |
FQDN (SERVICE_NAME = FOO) | |
FQDN ) | |
FQDN ) | |
FQDN | |
FQDN ' >> /opt/oracle/11R23/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/11R23/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-script20130703-6400-11dm4qs" | |
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, 60 resources updated |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment