Link to home
Create AccountLog in
Avatar of Rao_S
Rao_S

asked on

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.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%';

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/oem01/orabin/admin>emcli set_target_property_value -property_records="testdb87.rnd.pncint.net:rac_database:LifeCycle Status:Test"
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?
ASKER CERTIFIED SOLUTION
Avatar of Gerwin Jansen
Gerwin Jansen
Flag of Netherlands image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account
Avatar of Rao_S
Rao_S

ASKER

Will look at it in detail later..