Go Directly To
Oracle Developer Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
Get Started Guide
Join the world’s largest interactive community dedicated to Oracle technologies.
Learn from thousands of community experts
Get answers to your technical questions
Share your knowledge with peers
Please enter a title.
You can not post a blank message. Please type your message and try again.
Database Key Features
This discussion is archived
on Apr 23, 2013 8:13 AM by Franz_R
Run DBMS_SCHEDULER Job as other OS User
Apr 23, 2013 8:13 AM
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
Guide to External Jobs on 10g with dbms_scheduler e.g. scripts,batch files
-rw-r----- 1 root dba rdbms/admin/externaljob.ora
egrep -v '^#|^$' rdbms/admin/externaljob.ora
run_user = nobody
run_group = nobody
-rwsr-x--- 1 oracle dba bin/extjob
-rwxr-xr-x 1 oracle dba bin/extjobo
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
I have the same question
Show 0 Likes
This content has been marked as final.
Show 0 replies