Posted on 2011-09-07
When I try scheduling a job through OEM , i'm getting this message:
' "Details ORA-27369: job of type EXECUTABLE failed with exit code: Cannot assign requested address STANDARD_ERROR="/export/home/oracle/scripts/score_provider_delete.sh: line 17: /export/home/oracle: is a directory" '
The script executes and the rows intended to be deleted are indeed deleted but i get this ORA-27369 error from running this script
export ORACLE_BASE ORACLE_HOME ORACLE_SID
/u01/app/oracle/product/10.2.0.1/db_1/bin/sqlplus xoxomos/0rion<< EOF
DELETE FROM SCORE_PROVIDER_ACTION
WHERE ACTION_URL LIKE '%.jsp'
(SELECT PK1 FROM SCORE_PROVIDER