Operating System - OpenVMS
1828342 Members
3225 Online
109976 Solutions
New Discussion

Re: Mysterious error codes with OpenVMS 8.3 and Oracle

 
Martin Brindle
Occasional Advisor

Mysterious error codes with OpenVMS 8.3 and Oracle

Hi,

I'm looking for any OpenVMS experts who can help with a DBMS_Scheduler problem.

I'm attempting to run the following script, which runs the correctly from the command line.

1 begin
2 dbms_scheduler.create_job(job_name => 'myjob',
3 job_type => 'executable',
4 job_action => 'dsa10:[test]test.com',
5 enabled => TRUE,
6 auto_drop => TRUE);
7 dbms_scheduler.run_job('myjob');
8* end;


Running the script gives

SQL> /
begin
*
ERROR at line 1:
ORA-27369: job of type EXECUTABLE failed with exit code: error 9638456
ORA-06512: at "SYS.DBMS_ISCHED", line 148
ORA-06512: at "SYS.DBMS_SCHEDULER", line 374
ORA-06512: at line 7

How can I find out what error 9638456 is and is it likely to be an OpenVMS error or an Oracle error?

I've set all the file permissions and the owner, and i've created a externaljob.ora. I can call the script from an c program instead and after some fiddling, it gave a different error of 65537. Where are these error numbers located?
2 REPLIES 2
Hein van den Heuvel
Honored Contributor

Re: Mysterious error codes with OpenVMS 8.3 and Oracle

Hello Martin,

Welcome to the HP ITRC OpenVMS Forum.

So what does 'test.com' do?

The return looks like a 'normal' VMS error message:

$ exit 9638456
%DELETE-W-SEARCHFAIL, error searching for !AS
$


The 65537 status ia RMS NORMAL.

You can readily see that if you clear the low bit, turning it into a warning

$ exit 65536
%RMS-W-NORMAL, normal successful completion


hth,
Hein.
Martin Brindle
Occasional Advisor

Re: Mysterious error codes with OpenVMS 8.3 and Oracle

Thanks for your reply.

I keep changing test.com but it contains the following for the errors currently mentioned.

$ @dsa10:[oracle10]orauser dps10
$ sqlplus -s / @dsa10:[oracle10]test.sql

I think I'm right in saying that it's going to be down to setting up the environment for sqlplus are so forth that is causing me the errors? I'm not sure if this is the correct way to do it, as I'm no Oracle expert either.

test.sql by the way, contains

select * from dual;