dbs_scheduler_job fails

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

#!/usr/bin/bash
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/10.2.0.1/db_1
ORA_HOME_NAME=OraHomeBB
ORACLE_SID=BB60
export ORACLE_BASE ORACLE_HOME ORACLE_SID
/u01/app/oracle/product/10.2.0.1/db_1/bin/sqlplus xoxomos/0rion<< EOF
spool score_provider_delete;
DELETE FROM SCORE_PROVIDER_ACTION
    WHERE ACTION_URL LIKE '%.jsp'
    AND SCORE_PROVIDER_PK1=
    (SELECT PK1 FROM SCORE_PROVIDER
    WHERE HANDLE='resource/x-bb-assignment');
commit;
quit;
EOF

xoxomosAsked:
Who is Participating?
 
xoxomosAuthor Commented:
I deleted that line 17, you know the one past the end of the script?
Now it's ok.  Must have been some unprintable there or something
0
 
xoxomosAuthor Commented:
Strange.  If i leave off the quit from SQLPlus and the EOF to signal the end of the here document, the job executes and does not get the error??????
0
 
slightwv (䄆 Netminder) Commented:
Using "<<EOF" is called a 'Here Script'.  They kind of expect the terminator, then ending EOF, to gracefully end the script.

Just a semi-educated guess here is the 'quit' prematurely killed the pipe and Unix didn't know how to handle it gracefully.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
xoxomosAuthor Commented:
Thanks, I'll try it with an 'exit' instead of quit.
0
 
xoxomosAuthor Commented:
Pretty much the same with exit.  It does the commit, disconnects from SQLPlus, then gives me an error on line 17 which is one line longer than the script :-)
0
 
xoxomosAuthor Commented:
C grade because not excellent, not even good, just fair.  Should have looked for unprintable characters earlier:-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.