Friday, May 29, 2015

EBS Workflow Service Components Status



Good piece of script to identify the status of the workflow components from sql prompt.
This is alternate option to see workflow service components status from OAM GUI.


Run the below SQL as apps user

col component_id format 999999
col startup_mode format a10
col component_status format a10
col component_name format a50
set linesize 125
set pagesize 25
select component_id, startup_mode,component_status,component_type,component_name from fnd_svc_components

order by component_id;

Search and Replace String across multiple files in Linux

  perl -pi -e 's/old_string/new_string/g' file_pattern

  perl -pi -e 's/temp/tmp/g' *.html
  /happy/
To correctly replace it, you would have to escape the forward slashes with the escape character (the backslash) so that the forward slashes aren't interpreted as commands. Your replacement string would need to be:
  \/happy\/