DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: dbms_scheduler problems

Hybrid View

  1. #1
    Join Date
    Apr 2007
    Posts
    31

    dbms_scheduler problems

    OS: Solaris 10 64-bit
    DB: 10.2.0.3 64-bit with latest CPU patch

    We have 2 DB servers with the versions above. DBMS_SCHEDULER executes a shell script successfully on both as oracle, but using a different user in the rdbms/admin/externaljob.ora it works on 1 server and not the other. The configurations are identical. The newuser is in the group dba, has access to all of oracle's parent directories and it's bin directory. The permission's for the bin/extjob are correct (owned by root, setuid, etc per documentation). The shell script used is just for testing purposes so it doesn't even use the database. Regardless the environment variables have been set in the script which is basically:
    #!/bin/ksh
    export ORA...(and so on for env's)
    ls -1 /tmp/test.log

    The error I get when executing the job is:
    ORA-27369: job of type EXECUTABLE failed with exit code: Unknown error
    STANDARD_ERROR="Oracle Scheduler error: Config file is not owned by root or is writable by
    group or other or extjob is not setuid and owned by root"

    Which is incorrect so it must be caught in some exception.

    Any ideas on why it would work on 1 server and not the other? The only difference I've seen is that the server it works on is on a lesser version of a solaris 10 patchset.

  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    [quote]

    The configurations are identical.

    The only difference I've seen is that the server it works on is on a lesser version of a solaris 10 patchset.

    [quote/]

    Some thing contrdictory statements.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width