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!

Run DBMS_SCHEDULER Job as other OS User

Franz_RApr 19 2013 — edited Apr 23 2013

Hello,

is this problem known or can some one help me please?
We use AIX 6.1 and 10.2.0.4.0 - 64bit.
When we create an Job it will be execute as OS User Oracle, but this is not wanted.
The file permisions are set as described in 557102

rdbms/admin/externaljob.ora
-rw-r----- 1 root dba rdbms/admin/externaljob.ora

egrep -v '^#|^$' rdbms/admin/externaljob.ora
run_user = nobody
run_group = nobody

bin/extjob
-rwsr-x--- 1 oracle dba bin/extjob

bin/extjobo
-rwxr-xr-x 1 oracle dba bin/extjobo

OSLevel
AIX 6100-07-06-1241

We tried different Users in the rdbms/admin/externaljob.ora file but every time the same behavior, the job runs as oracle.

Edited by: Franz_R on 23.04.2013 01:11

Locked Post

New comments cannot be posted to this locked post.

Locked on May 17 2013

Added on Apr 19 2013

#database-key-features, #scheduler

0 comments

864 views