Clarification on Externaljob.ora and Permissions
(Doc ID 979186.1)
Last updated on JULY 05, 2023
Applies to:
Oracle Database - Enterprise Edition - Version 10.2.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Oracle Database Exadata Cloud Machine - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.
Goal
Q1) In order to support the external jobscheduling system from the database, will it first read the externaljob.ora file under $ORACLE_HOME/rdbms/admin. The file as run_user=nobody and run_owner=nobody. The permissions on the file extjob is i.e. 4750 and owned by root:owner
-rwsr-x--- 1 root gmp 587104 Jun 12 2009 extjob
Q2) The question is even if the extjob has permission 4750 and owned by root:ownergroup, will the external jobs scheduled from within the database be run by the settings defined in the externaljob.ora file. The externaljob.ora has run_user=nobody and run_owner=nobody.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Goal |
| Solution |
| References |