Need help with emcli in OEM 12c, maybe use shell script or python and run a series of emcli commands.
I have to populate the target properties of every target in OEM 12c.
I am trying a few to see if this will work.
When I run this, i get 82 rows.
select 'emcli set_target_property_value -property_records="'||a.TA
from mgmt$target a,
(select target_name host,property_value from mgmt$target_properties
where target_type='host' and property_name='orcl_gtp_li
where a.host_name=b.host
and a.host_name like '%lods07%';
I have attached the file, please take a look.
On the server after I log into emcli and log in as sysman, I can run each line follows:
oms_home@loem301dz:/odb/oe
Properties updated successfully
How do i create either a shell script or python script to either execute each line as a script or write a python script to do so?
I am trying a few to see if this will work.
When I run this, i get 82 rows.
select 'emcli set_target_property_value -property_records="'||a.TA
from mgmt$target a,
(select target_name host,property_value from mgmt$target_properties
where target_type='host' and property_name='orcl_gtp_li
where a.host_name=b.host
and a.host_name like '%lods07%';
I have attached the file, please take a look.
On the server after I log into emcli and log in as sysman, I can run each line follows:
oms_home@loem301dz:/odb/oe
Properties updated successfully
How do i create either a shell script or python script to either execute each line as a script or write a python script to do so?
Do more with
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Hi, what you can do is create a shell script of the first part that sends the output to a secondary file. Then as a next step call that secondary file from the shell script.
Something like:
Something like:
sqlplus -s user/password@database << EOF
set head off
set feedback off
set head off
set pages 0
spool secondary_script
select 'emcli set_target_property_value -property_records="'||a.TARGET_NAME||':'||a.TARGET_TYPE||':LifeCycle Status:'||b.property_value||'"'
from mgmt$target a,
(select target_name host,property_value from mgmt$target_properties
where target_type='host' and property_name='orcl_gtp_lifecycle_status') b
where a.host_name=b.host
and a.host_name like '%lods07%';
spool off
EOF
sh ./secondary_script
Premium Content
You need an Expert Office subscription to comment.Start Free Trial