I want to use execute_sql of emcli within python

User_4Y93Z

in Oracle 13.2.1 OEM,  I am using emcli tool.  In that I am passing test.py as below

emcli @test.py

cat test.py is as below

login ( username="Admin_user", password="admin_pw" )

myDBs = list( resource="Targets", search="TARGET_TYPE='oracle_database'" )

for DB in myDBs.out()['data']:

    print DB['TARGET_NAME']

    execute_sql -sql="select * from global_name;" -credential_set_name="DBCredsSYSDBA" -targets="DB["TARGET_NAME"],:oracle_database"   <-- That is within the python script, I am trying to call execute_sql.  How to do this?

Courtney Llamas-Oracle

There's some example scripts online that might help - http://www.snapdba.com/wp-content/uploads/2013/04/em_relocate_checker.txt

https://www.slideshare.net/gokhanatil/em13c-write-powerful-scripts-with-emcli

https://www.doag.org/formes/pubfiles/7567039/2015-K-DB-Gokhan_Atil-Jump_into_the_EMCLI__A_Crash_Course_for_EM12c_Adminis…