Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Problems with credentials

JoeZDec 8 2010 — edited Jul 23 2013
Hi
using credentials sseems to be easy, but I have problems using them in 11.2 on linux:
This code is running without any problems:
begin
dbms_scheduler.create_job (job_name=>'TESTJOB',job_type=>'EXECUTABLE',job_action=> '/tmp/mytouch.sh',enabled=>TRUE);
end;
/
In externaljobs.ora run_user is tomtester and rungroup tomtester as well.
so I this my problems seems no to be a protection problem.

For using credentials I have an OS user tomtester with tomtester as password. I can connect with the user and can execute /tmp/mytouch.sh without any problems.

So I created a credential:

begin
dbms_scheduler.create_credential('MYCREDENTIAL','tomtester','tomtester');
end;
/

And modify my job creation script to use this credential:

begin
dbms_scheduler.create_job (job_name=>'TESTJOB',job_type=>'EXECUTABLE',job_action=> '/tmp/mytouch.sh',enabled=>TRUE,credential_name=>'MYCREDENTIAL');
end;
/
This job fails with error# 27370
"EXTERNAL_LOG_ID="job_81737_5706",
ORA-27369: Job vom Typ EXECUTABLE nicht erfolgreich mit Exit-Code: Argument list too long
STANDARD_ERROR="Launching external job failed: Invalid username or password""

Invalid user or password - why that? None of my OS users can execute any job. The error message is always Invalid user or password.
Any ideas?
Thanks in advance
Joe
This post has been answered by Rnr-Oracle on Dec 8 2010
Jump to Answer

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Aug 20 2013
Added on Dec 8 2010
17 comments
26,052 views