I am trying to create a job using OEM that will use SQL*Plus. I am running a simple script (select sysdate from dual; ), but I keep getting the same error:


SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where ::= [/][@] | /
SP2-0306: Invalid option.
Usage: CONN[ECT] [logon] [AS {SYSDBA|SYSOPER}] | [INTERNAL]
where ::= [/][@] | /

It seems that OEM is not able to logon and issue the select statement. Any ideas?

I have OEM on windows2000, management server on the same machine, and connecting to a unix(DYNIX/PTX) database. The intelligent agent on the unix server is running fine. Thanks.