Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
Oracle Database + Options
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Apr 23, 2013 8:13 AM by
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
This content has been marked as final.
Show 0 replies