Class: OraUtils::OraCommand

Inherits:
Object
  • Object
show all
Defined in:
lib/orabase/utils/ora_command.rb

Constant Summary collapse

DEFAULT_TIMEOUT =

5 minutes

300
ORA_OS_USER_NAME = 
'ORA_OS_USER'
ASM_OS_USER_NAME = 
'ASM_OS_USER'
VALID_OPTIONS = 
[
  :sid,
  :os_user,
  :password,
  :timeout,
  :username,
]

Instance Method Summary collapse

Constructor Details

#initialize(command, options, valid_options = VALID_OPTIONS) ⇒ OraCommand

Returns a new instance of OraCommand.



18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
 
# File 'lib/orabase/utils/ora_command.rb', line 18

def initialize(command, options, valid_options = VALID_OPTIONS)
  @valid_options  = valid_options
  check_options( options )
  @command        = command
  @oratab         = OraUtils::OraTab.new
  @password       = options[:password] # may be empty
  @timeout        = options.fetch(:timeout) { DEFAULT_TIMEOUT}
  @sid            = options.fetch(:sid) { raise ArgumentError, "you need to specify a sid for oracle access"}
  if asm_sid?
    @os_user      = options.fetch(:os_user) {default_asm_user}
    @username     = options.fetch(:username){'sysasm'}
  else
    @os_user      = options.fetch(:os_user) {default_ora_user}
    @username     = options.fetch(:username){'sysdba'}
  end
end

Instance Method Details

#command_string(arguments = '') ⇒ Object 



35
36
37
 
# File 'lib/orabase/utils/ora_command.rb', line 35

def command_string(arguments = '')
  "su - #{@os_user} -c \"export ORACLE_SID=#{@sid};export ORAENV_ASK=NO;. oraenv; #{@command} #{arguments}\""
end

#execute(arguments) ⇒ Object 



39
40
41
42
43
44
45
46
47
 
# File 'lib/orabase/utils/ora_command.rb', line 39

def execute(arguments)
  options = {:failonfail => true}
  value = ''
  within_time(@timeout) do
    Puppet.debug "Executing #{@command} command: #{arguments} on #{@sid} as #{os_user}, connected as #{username}"
    value = Puppet::Util::Execution.execute(command_string(arguments), options)
  end
  value
end