Managing Applications using Enterprise Manager (MOSC)

MOSC Banner

I'm trying to add a condition to the emcli list -sql command.

emcli list -sql='select TARGET_NAME,DISPLAY_NAME,HOST_NAME from mgmt$target'

Works great.

emcli list -sql='select TARGET_NAME,DISPLAY_NAME,HOST_NAME from mgmt$target WHERE TARGET_TYPE="oracle_database"'

Invalid column name : Error is ORA-00904: "ORACLE_DATABASE": invalid identifier

Are WHERE clauses not allowed? No matter how I attempt to dereference this I get the same result. Invalid column name.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center