Computing.Net > Forums > OpenVMS > Oracle 10g DBMS_Scheduler

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Click here to start participating now! Also, check out the New User Guide.

Oracle 10g DBMS_Scheduler

Reply to Message Icon

Name: loonyjuice
Date: January 25, 2007 at 01:36:57 Pacific
OS: 8.3
CPU/Ram: Alpha
Product: Hp
Comment:

I need to execute some scripts/programs from DBMS_Scheduler, and I'm receiving

ORA-27369: job of type EXECUTABLE failed with exit code: error 9638456

Is there anyway of knowing if this is a OpenVMS error or an Oracle Error. Oracle haven't been able to help so far. I've tried redirecting output from the script run by dbsm_scheduler into a file, by defining a user_mode file, but the contents of the file says:

%DCL-W-UNDFIL, file has not been opened by DCL - check logical name

I've set file permissions to execute for world users, and I can run the script for the shell. I've tried including my login script from withing the script i'm calling from dbms_scheduler, to make sure the env is set up, too.

I'd really appreciate some OpenVMS help with this problem.



Sponsored Link
Ads by Google

Response Number 1
Name: Bob Gezelter
Date: February 16, 2007 at 04:28:30 Pacific
Reply:

loonyjuice,

It is hard to troubleshoot this problem without being hand-on. It does sound like a protection or a logical name problem.

We can attempt to troubleshoot this problem one bit at a time in the forum. For starters, what is the name of the file that you are specifying?

If a hand-on approach is desired, we can take it offline.

- Bob Gezelter, http://www.rlgsc.com


0
Reply to Message Icon

Related Posts

See More


IPX in OpenVMS. Booting Alpha station


Use following form to reply to current message:

Login or Register to Reply
LoginRegister


Sponsored links

Ads by Google


Results for: Oracle 10g DBMS_Scheduler

vax cobol pro*cobol oracle www.computing.net/answers/openvms/vax-cobol-procobol-oracle/163.html

Recover Oracle 7.1 root password? www.computing.net/answers/openvms/recover-oracle-71-root-password/59.html

Communicate between ProC and Oracle! www.computing.net/answers/openvms/communicate-between-proc-and-oracle/126.html