How to invoke and execute a script from OEM Oracle Tips by Burleson Consulting

Question:  I want to invoke a SQL*Plus script from inside OEM and when I try to execute the script from OEM I get a "SP1-0310: Unable to open file "myScript.sql"" error.  What is the complete process for executing a custom script within OEM?

Answer:  When including script names in OEM you must carefully include the fully-qualified path for the script:
     (i.e. /u01/app/oracle/scripts/myscript.sql).

Placing custom scripts within OEM is a great way to improve reporting, and see my notes on exception reporting within OEM here.

I have complete details on extending OEM to alert for customized thresholds in my book "Oracle Tuning: The Definitive Reference", but here is a quick overview of script execution from OEM:

1 - Create a "new event" from the OEM console

2 - Choose "enable unsolicited event" and then "test unsolicited event"

3 - Enter the script name with the full path.

You can also use the oemevent command to invoke a SQL script from OEM:

root> oemevent /u01/app/oracle/scripts/myscript.sql destination alert "Monitored destination message"
 

 

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.  You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.