Any alternative response_file for CentOS?

ryan_T · March 11, 2011, 8:17am

Hi All,

I want to write a recipe to install Oracle on EC2 CentOS instance, which
requires some interactive input.
Use of response_file seems to meet my need.
Unfortunately, use of a response file is only supported on Debian and Ubuntu
at this time - as Opscode wiki says.

Is there any other ways to do this in CentOS?

Thanks,

Ryan

John_E_Vincent_lusis · March 11, 2011, 8:56am

I think you might be confusing the response_file for Oracle with the
dpkg support for response file. It's been a while since I've done an
"automated" Oracle install but you'll probably want to use the execute
resource.

Essentially it would be something like this gist:

gist.github.com

https://gist.github.com/lusis/865637

psuedocode-oracle-install-chef.rb

execute "install_oracle" do
  command "oracle_installer_bin oracle_response_file"
  action :run
  not_if { some idempotent way of determining if oracle is properly }
end

Note that the idempotence checks (not_if/only_if) are somewhat
limited. You'll probably want to create an LWRP in the end unless you
can wrap up the determination of a valid oracle install into a single
statement. For example, here's how we handle creating mysql accounts
for our users:

gist.github.com

https://gist.github.com/lusis/865645

user-cookbook-mysql-perms.rb

if u.has_key?("mysql_permissions") and u[:mysql_permissions].has_key?(node.name) then
  u[:mysql_permissions]["#{node.name}"].each do |database, grants| 
    Chef::Log.info("Found permission on #{node.name} for #{u[:id]}: DB: #{database}, Grants: #{grants.join(',')}")
    execute "grant-#{u[:id]}-#{database}-perms" do
      command "/usr/bin/mysql -u root -p#{mysql_password} -D mysql -r -B -N -e \"GRANT #{grants.join(',')} ON #{database}.* to '#{u[:id]}'@'localhost'\""
      action :run
      not_if { `/usr/bin/mysql -u root -p#{mysql_password} -D mysql -r -B -N -e \"SELECT COUNT(*) FROM user where User='#{u[:id]}' and Host = 'localhost'"`.to_i == 0 }
    end
  end 
end

You can see the hoops I'm jumping through in the 'not_if' statement to
avoid rerunning the work. I really should create a mysql permissions
LWRP.

Hope that helps!

John E. Vincent

On Fri, Mar 11, 2011 at 3:17 AM, ryan T ryanrobin@gmail.com wrote:

Hi All,

I want to write a recipe to install Oracle on EC2 CentOS instance, which
requires some interactive input.
Use of response_file seems to meet my need.
Unfortunately, use of a response file is only supported on Debian and Ubuntu
at this time - as Opscode wiki says.

Is there any other ways to do this in CentOS?

Thanks,

Ryan

ryan_T · March 11, 2011, 10:14am

Hi John,

Thanks for your help.

For use of execute resource psuedocode-oracle-install-chef.rb · GitHub, I'm still
confused how oracle_response_file
answers Oracle installation/configuration questions such as listener port,
system password,...

Could you please give some more details?

Thanks,

Ryan

On Fri, Mar 11, 2011 at 3:56 PM, John E. Vincent (lusis) <lusis.org+
chef-list@gmail.com> wrote:

I think you might be confusing the response_file for Oracle with the
dpkg support for response file. It's been a while since I've done an
"automated" Oracle install but you'll probably want to use the execute
resource.

Essentially it would be something like this gist:

psuedocode-oracle-install-chef.rb · GitHub

Note that the idempotence checks (not_if/only_if) are somewhat
limited. You'll probably want to create an LWRP in the end unless you
can wrap up the determination of a valid oracle install into a single
statement. For example, here's how we handle creating mysql accounts
for our users:

user-cookbook-mysql-perms.rb · GitHub

You can see the hoops I'm jumping through in the 'not_if' statement to
avoid rerunning the work. I really should create a mysql permissions
LWRP.

Hope that helps!

John E. Vincent
John E. Vincent - Roswell, Georgia | about.me

On Fri, Mar 11, 2011 at 3:17 AM, ryan T ryanrobin@gmail.com wrote:

Hi All,

I want to write a recipe to install Oracle on EC2 CentOS instance, which
requires some interactive input.
Use of response_file seems to meet my need.
Unfortunately, use of a response file is only supported on Debian and
Ubuntu
at this time - as Opscode wiki says.

Is there any other ways to do this in CentOS?

Thanks,

Ryan

John_E_Vincent_lusis · March 11, 2011, 10:17am

See here:

http://download.oracle.com/docs/cd/B10500_01/em.920/a96697/rsp.htm

I might have been mistaken but I understood it that you were talking
about using the oracle installer support for a non-interactive
install. (an rsp file).

On Fri, Mar 11, 2011 at 5:14 AM, ryan T ryanrobin@gmail.com wrote:

Hi John,

Thanks for your help.

For use of execute resource psuedocode-oracle-install-chef.rb · GitHub, I'm still
confused how oracle_response_file
answers Oracle installation/configuration questions such as listener port,
system password,...

Could you please give some more details?

Thanks,

Ryan

On Fri, Mar 11, 2011 at 3:56 PM, John E. Vincent (lusis)
lusis.org+chef-list@gmail.com wrote:

I think you might be confusing the response_file for Oracle with the
dpkg support for response file. It's been a while since I've done an
"automated" Oracle install but you'll probably want to use the execute
resource.

Essentially it would be something like this gist:

psuedocode-oracle-install-chef.rb · GitHub

Note that the idempotence checks (not_if/only_if) are somewhat
limited. You'll probably want to create an LWRP in the end unless you
can wrap up the determination of a valid oracle install into a single
statement. For example, here's how we handle creating mysql accounts
for our users:

user-cookbook-mysql-perms.rb · GitHub

You can see the hoops I'm jumping through in the 'not_if' statement to
avoid rerunning the work. I really should create a mysql permissions
LWRP.

Hope that helps!

John E. Vincent
John E. Vincent - Roswell, Georgia | about.me

On Fri, Mar 11, 2011 at 3:17 AM, ryan T ryanrobin@gmail.com wrote:

Hi All,

I want to write a recipe to install Oracle on EC2 CentOS instance, which
requires some interactive input.
Use of response_file seems to meet my need.
Unfortunately, use of a response file is only supported on Debian and
Ubuntu
at this time - as Opscode wiki says.

Is there any other ways to do this in CentOS?

Thanks,

Ryan

ryan_T · March 11, 2011, 10:26am

Sorry for the stupid question.
I didn't know of Oracle silent installation until you point it out.

Thanks,

Ryan

On Fri, Mar 11, 2011 at 5:17 PM, John E. Vincent (lusis) <lusis.org+
chef-list@gmail.com> wrote:

See here:

Customizing and Creating Response Files

I might have been mistaken but I understood it that you were talking
about using the oracle installer support for a non-interactive
install. (an rsp file).

On Fri, Mar 11, 2011 at 5:14 AM, ryan T ryanrobin@gmail.com wrote:

Hi John,

Thanks for your help.

For use of execute resource psuedocode-oracle-install-chef.rb · GitHub, I'm still
confused how oracle_response_file
answers Oracle installation/configuration questions such as listener
port,
system password,...

Could you please give some more details?

Thanks,

Ryan

On Fri, Mar 11, 2011 at 3:56 PM, John E. Vincent (lusis)
lusis.org+chef-list@gmail.com wrote:

I think you might be confusing the response_file for Oracle with the
dpkg support for response file. It's been a while since I've done an
"automated" Oracle install but you'll probably want to use the execute
resource.

Essentially it would be something like this gist:

psuedocode-oracle-install-chef.rb · GitHub

Note that the idempotence checks (not_if/only_if) are somewhat
limited. You'll probably want to create an LWRP in the end unless you
can wrap up the determination of a valid oracle install into a single
statement. For example, here's how we handle creating mysql accounts
for our users:

user-cookbook-mysql-perms.rb · GitHub

You can see the hoops I'm jumping through in the 'not_if' statement to
avoid rerunning the work. I really should create a mysql permissions
LWRP.

Hope that helps!

John E. Vincent
John E. Vincent - Roswell, Georgia | about.me

On Fri, Mar 11, 2011 at 3:17 AM, ryan T ryanrobin@gmail.com wrote:

Hi All,

I want to write a recipe to install Oracle on EC2 CentOS instance,
which
requires some interactive input.
Use of response_file seems to meet my need.
Unfortunately, use of a response file is only supported on Debian and
Ubuntu
at this time - as Opscode wiki says.

Is there any other ways to do this in CentOS?

Thanks,

Ryan

Sean_OMeara · March 11, 2011, 5:38pm

You're confusing the oracle response file with a dpkg preseed file.
The preseed is a feature of the debian package manager resource.

If you wrote an oracle LWRP you could make the oracle response file an
attribute of the resource.

Try something like this:

template "/path/to/responsefile" do
source "oracleresponse.erb"
variables(
:port = "1234"
:password = "1234"
end

execute "install_oracle" do
only_if "some_command_that_checks_for_preconditions"
not_if "some_command_that_checks_for_postconditions"
command "/path/toinstaller some_args /path/to/responsefile"
end

-s

On Fri, Mar 11, 2011 at 5:26 AM, ryan T ryanrobin@gmail.com wrote:

Sorry for the stupid question.
I didn't know of Oracle silent installation until you point it out.

Thanks,

Ryan

On Fri, Mar 11, 2011 at 5:17 PM, John E. Vincent (lusis)
lusis.org+chef-list@gmail.com wrote:

See here:

Customizing and Creating Response Files

I might have been mistaken but I understood it that you were talking
about using the oracle installer support for a non-interactive
install. (an rsp file).

On Fri, Mar 11, 2011 at 5:14 AM, ryan T ryanrobin@gmail.com wrote:

Hi John,

Thanks for your help.

For use of execute resource psuedocode-oracle-install-chef.rb · GitHub, I'm still
confused how oracle_response_file
answers Oracle installation/configuration questions such as listener
port,
system password,...

Could you please give some more details?

Thanks,

Ryan

On Fri, Mar 11, 2011 at 3:56 PM, John E. Vincent (lusis)
lusis.org+chef-list@gmail.com wrote:

I think you might be confusing the response_file for Oracle with the
dpkg support for response file. It's been a while since I've done an
"automated" Oracle install but you'll probably want to use the execute
resource.

Essentially it would be something like this gist:

psuedocode-oracle-install-chef.rb · GitHub

Note that the idempotence checks (not_if/only_if) are somewhat
limited. You'll probably want to create an LWRP in the end unless you
can wrap up the determination of a valid oracle install into a single
statement. For example, here's how we handle creating mysql accounts
for our users:

user-cookbook-mysql-perms.rb · GitHub

You can see the hoops I'm jumping through in the 'not_if' statement to
avoid rerunning the work. I really should create a mysql permissions
LWRP.

Hope that helps!

John E. Vincent
John E. Vincent - Roswell, Georgia | about.me

On Fri, Mar 11, 2011 at 3:17 AM, ryan T ryanrobin@gmail.com wrote:

Hi All,

I want to write a recipe to install Oracle on EC2 CentOS instance,
which
requires some interactive input.
Use of response_file seems to meet my need.
Unfortunately, use of a response file is only supported on Debian and
Ubuntu
at this time - as Opscode wiki says.

Is there any other ways to do this in CentOS?

Thanks,

Ryan

ryan_T · March 14, 2011, 8:48am

Thanks all.

I came up with something like this

execute "oraclexe-configure" do
command "/etc/init.d/oracle-xe configure < oraclexe_response_file >>
xesilentinstallation.log"
cwd "/tmp/oraclexe"
action :nothing
not_if {File.exists?("/etc/sysconfig/oracle-xe")}
end
template "/tmp/oraclexe/oraclexe_response_file" do
source "oraclexe_response_file.erb"
owner "root"
group "root"
mode "0600"
action :create
notifies :run, resources(:execute => "oraclexe-configure")
end

Thanks

Ryan

On Sat, Mar 12, 2011 at 12:38 AM, Sean OMeara someara@gmail.com wrote:

You're confusing the oracle response file with a dpkg preseed file.
The preseed is a feature of the debian package manager resource.

If you wrote an oracle LWRP you could make the oracle response file an
attribute of the resource.

Try something like this:

template "/path/to/responsefile" do
source "oracleresponse.erb"
variables(
:port = "1234"
:password = "1234"
end

execute "install_oracle" do
only_if "some_command_that_checks_for_preconditions"
not_if "some_command_that_checks_for_postconditions"
command "/path/toinstaller some_args /path/to/responsefile"
end

-s

On Fri, Mar 11, 2011 at 5:26 AM, ryan T ryanrobin@gmail.com wrote:

Sorry for the stupid question.
I didn't know of Oracle silent installation until you point it out.

Thanks,

Ryan

On Fri, Mar 11, 2011 at 5:17 PM, John E. Vincent (lusis)
lusis.org+chef-list@gmail.com wrote:

See here:

Customizing and Creating Response Files

I might have been mistaken but I understood it that you were talking
about using the oracle installer support for a non-interactive
install. (an rsp file).

On Fri, Mar 11, 2011 at 5:14 AM, ryan T ryanrobin@gmail.com wrote:

Hi John,

Thanks for your help.

For use of execute resource psuedocode-oracle-install-chef.rb · GitHub, I'm still
confused how oracle_response_file
answers Oracle installation/configuration questions such as listener
port,
system password,...

Could you please give some more details?

Thanks,

Ryan

On Fri, Mar 11, 2011 at 3:56 PM, John E. Vincent (lusis)
lusis.org+chef-list@gmail.com wrote:

I think you might be confusing the response_file for Oracle with the
dpkg support for response file. It's been a while since I've done an
"automated" Oracle install but you'll probably want to use the
execute
resource.

Essentially it would be something like this gist:

psuedocode-oracle-install-chef.rb · GitHub

Note that the idempotence checks (not_if/only_if) are somewhat
limited. You'll probably want to create an LWRP in the end unless you
can wrap up the determination of a valid oracle install into a single
statement. For example, here's how we handle creating mysql accounts
for our users:

user-cookbook-mysql-perms.rb · GitHub

You can see the hoops I'm jumping through in the 'not_if' statement
to
avoid rerunning the work. I really should create a mysql permissions
LWRP.

Hope that helps!

John E. Vincent
John E. Vincent - Roswell, Georgia | about.me

On Fri, Mar 11, 2011 at 3:17 AM, ryan T ryanrobin@gmail.com wrote:

Hi All,

I want to write a recipe to install Oracle on EC2 CentOS instance,
which
requires some interactive input.
Use of response_file seems to meet my need.
Unfortunately, use of a response file is only supported on Debian
and
Ubuntu
at this time - as Opscode wiki says.

Is there any other ways to do this in CentOS?

Thanks,

Ryan

Topic		Replies	Views
Oracle installation on windows? Chef Infra (archive)	14	1276	September 24, 2017
Announcement of echa-oracle cookbook Chef Infra (archive)	1	272	July 11, 2013
Is their any way to make wait chef resource to until installation gets completed? Chef Infra (archive)	3	1117	September 30, 2017
Bash problem? with oracle 11gr2 install Chef Infra (archive)	3	369	January 26, 2012
Collectd for centos? Chef Infra (archive)	6	452	July 17, 2012

Any alternative response_file for CentOS?

Related topics