Created
July 5, 2013 19:40
-
-
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
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
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="("/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 | |
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