ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied [Oracle Help]

Prev: What's the default database administrator username in the Orcale 10g world?
Next: get the sid,serial# of my connection?

From: joel garry on 16 Dec 2008 14:35

On Dec 14, 8:41 pm, just_real <jth...(a)gmail.com> wrote:
> Hi
>
> I was trying to set up a test job in Enterprise manager and I got this
> error when it tried running the script.
>
> I've created the script on a RAC cluster . It contains the following:
>
> #!/bin/ksh
>
> . /oracle/.kshrc
>
> env >> /tmp/t.txt
> which sqlplus >> /tmp/t.txt
>
> sqlplus scott/abc(a)ORACLE123<<-!
> set serveroutput on size 1000000
> select 'Hello World' from dual
> /
> !
>
> I've ran this successfully via the command line. Could someone advise
> as to what I am missing or did wrong?
>
> I had a look at metalink and check the points given there but I seem
> to have them covered.
>
> Regards
>
> Justin

David's answer is part of the way there. So I'll explicitly ask:
Did you see metalink Note:391820.1 ? Does $ORACLE_HOME/rdbms/admin/
externaljob.ora exist?
Is your oracle executable -rwsr-s--x 1 oracle oinstall ?
(Those s's mean run as the user, which is probably nobody as that note
says - if you have different protection, you had an installation/
patching problem).
Which exact platform/OS/OS version are you on?
Which exact version of Oracle are you on, including 4 decimals. Have
you applied any critical patch updates? Note:735219.1 says you have to
change the permissions on the extjob executable.

Note:732963.1 points out the script must exist on all nodes of the
cluster with the proper permissions.

Are you sure the #!/bin/ksh is on the _first_ line of the script?
Are you sure there is a space after the period on the line . /
oracle/.kshrc?
Are all the /tmp/t.txt environment variables what you expect?
Are all the .kshrc environment variables exported?

Please remember to be specific as to which docs you've actually
followed. The 'puter takes things even more literal than the people
on this group.

jg
--
@home.com is bogus.
http://www.theregister.co.uk/2008/07/28/sun_dziuba_tm/

From: just_real on 16 Dec 2008 19:36

From: just_real on 16 Dec 2008 20:08

On Dec 17, 6:35 am, joel garry <joel-ga...(a)home.com> wrote:
> On Dec 14, 8:41 pm, just_real <jth...(a)gmail.com> wrote:
>
>
>
> > Hi
>
> > I was trying to set up a test job in Enterprise manager and I got this
> > error when it tried running the script.
>
> > I've created the script on a RAC cluster . It contains the following:
>
> > #!/bin/ksh
>
> > . /oracle/.kshrc
>
> > env >> /tmp/t.txt
> > which sqlplus >> /tmp/t.txt
>
> > sqlplus scott/abc(a)ORACLE123<<-!
> > set serveroutput on size 1000000
> > select 'Hello World' from dual
> > /
> > !
>
> > I've ran this successfully via the command line. Could someone advise
> > as to what I am missing or did wrong?
>
> > I had a look at metalink and check the points given there but I seem
> > to have them covered.
>
> > Regards
>
> > Justin
>
> David's answer is part of the way there. So I'll explicitly ask:
> Did you see metalink Note:391820.1 ? Does $ORACLE_HOME/rdbms/admin/
> externaljob.ora exist?
> Is your oracle executable -rwsr-s--x 1 oracle oinstall ?
> (Those s's mean run as the user, which is probably nobody as that note
> says - if you have different protection, you had an installation/
> patching problem).
> Which exact platform/OS/OS version are you on?
> Which exact version of Oracle are you on, including 4 decimals. Have
> you applied any critical patch updates? Note:735219.1 says you have to
> change the permissions on the extjob executable.
>
> Note:732963.1 points out the script must exist on all nodes of the
> cluster with the proper permissions.
>
> Are you sure the #!/bin/ksh is on the _first_ line of the script?
> Are you sure there is a space after the period on the line . /
> oracle/.kshrc?
> Are all the /tmp/t.txt environment variables what you expect?
> Are all the .kshrc environment variables exported?
>
> Please remember to be specific as to which docs you've actually
> followed. The 'puter takes things even more literal than the people
> on this group.
>
> jg
> --
> @home.com is bogus.http://www.theregister.co.uk/2008/07/28/sun_dziuba_tm/

Ok. I've gone through the items. And here are the results:

1. The current permissions for that script is - -rwxr----x- (This was
prior to me reading your last post and still got the permission
denied)

2. I've actually gone through the Note:391820.1 before. I confirm the
following:

a. $ORACLE_HOME/rdbms/admin/externaljob.ora exists
b. #!/bin/ksh is on the 1st line of the script
c. There is a space after the period on the line . /oracle/.kshrc
d. all things mentioned in that note is the same on my end with the
exception of :

3. Edit $ORACLE_HOME/rdbms/admin/externaljob.ora and set run_user to
the OS account that owns the Oracle installation and the database and
run_group to the OS group that owns the Oracle_Home.

Example:
OS account: oracle
OS group: oinstall

I am not too sure that I should be changing the default of nobody. I
am only trying to execute not write to the file. Or is my
understanding of this is wrong?

3. How do I change the permission for the executable to -rwsr-s--x ?

4. I am on a Linux 2.6.9-55.0.0.0.2.ELsmp x86_64 x86_64 x86_64 GNU/
Linux and
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production

From: just_real on 16 Dec 2008 22:08

On Dec 17, 12:08 pm, just_real <jth...(a)gmail.com> wrote:
> On Dec 17, 6:35 am, joel garry <joel-ga...(a)home.com> wrote:
>
>
>
> > On Dec 14, 8:41 pm, just_real <jth...(a)gmail.com> wrote:
>
> > > Hi
>
> > > I was trying to set up a test job in Enterprise manager and I got this
> > > error when it tried running the script.
>
> > > I've created the script on a RAC cluster . It contains the following:
>
> > > #!/bin/ksh
>
> > > . /oracle/.kshrc
>
> > > env >> /tmp/t.txt
> > > which sqlplus >> /tmp/t.txt
>
> > > sqlplus scott/abc(a)ORACLE123<<-!
> > > set serveroutput on size 1000000
> > > select 'Hello World' from dual
> > > /
> > > !
>
> > > I've ran this successfully via the command line. Could someone advise
> > > as to what I am missing or did wrong?
>
> > > I had a look at metalink and check the points given there but I seem
> > > to have them covered.
>
> > > Regards
>
> > > Justin
>
> > David's answer is part of the way there. So I'll explicitly ask:
> > Did you see metalink Note:391820.1 ? Does $ORACLE_HOME/rdbms/admin/
> > externaljob.ora exist?
> > Is your oracle executable -rwsr-s--x 1 oracle oinstall ?
> > (Those s's mean run as the user, which is probably nobody as that note
> > says - if you have different protection, you had an installation/
> > patching problem).
> > Which exact platform/OS/OS version are you on?
> > Which exact version of Oracle are you on, including 4 decimals. Have
> > you applied any critical patch updates? Note:735219.1 says you have to
> > change the permissions on the extjob executable.
>
> > Note:732963.1 points out the script must exist on all nodes of the
> > cluster with the proper permissions.
>
> > Are you sure the #!/bin/ksh is on the _first_ line of the script?
> > Are you sure there is a space after the period on the line . /
> > oracle/.kshrc?
> > Are all the /tmp/t.txt environment variables what you expect?
> > Are all the .kshrc environment variables exported?
>
> > Please remember to be specific as to which docs you've actually
> > followed. The 'puter takes things even more literal than the people
> > on this group.
>
> > jg
> > --
> > @home.com is bogus.http://www.theregister.co.uk/2008/07/28/sun_dziuba_tm/
>
> Ok. I've gone through the items. And here are the results:
>
> 1. The current permissions for that script is - -rwxr----x- (This was
> prior to me reading your last post and still got the permission
> denied)
>
> 2. I've actually gone through the Note:391820.1 before. I confirm the
> following:
>
> a. $ORACLE_HOME/rdbms/admin/externaljob.ora exists
> b. #!/bin/ksh is on the 1st line of the script
> c. There is a space after the period on the line . /oracle/.kshrc
> d. all things mentioned in that note is the same on my end with the
> exception of :
>
> 3. Edit $ORACLE_HOME/rdbms/admin/externaljob.ora and set run_user to
> the OS account that owns the Oracle installation and the database and
> run_group to the OS group that owns the Oracle_Home.
>
> Example:
> OS account: oracle
> OS group: oinstall
>
> I am not too sure that I should be changing the default of nobody. I
> am only trying to execute not write to the file. Or is my
> understanding of this is wrong?
>
> 3. How do I change the permission for the executable to -rwsr-s--x ?
>
> 4. I am on a Linux 2.6.9-55.0.0.0.2.ELsmp x86_64 x86_64 x86_64 GNU/
> Linux and
> Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
> PL/SQL Release 10.2.0.3.0 - Production
> CORE 10.2.0.3.0 Production

Ok. I've set the permission of the script with chmod 6751 and now get
the following error instead:

ORA-27369: job of type EXECUTABLE failed with exit code: No such file
or directory

From: joel garry on 17 Dec 2008 17:05

On Dec 16, 7:08 pm, just_real <jth...(a)gmail.com> wrote:
> On Dec 17, 12:08 pm, just_real <jth...(a)gmail.com> wrote:
>
>
>
>
>
> > On Dec 17, 6:35 am, joel garry <joel-ga...(a)home.com> wrote:
>
> > > On Dec 14, 8:41 pm, just_real <jth...(a)gmail.com> wrote:
>
> > > > Hi
>
> > > > I was trying to set up a test job in Enterprise manager and I got this
> > > > error when it tried running the script.
>
> > > > I've created the script on a RAC cluster . It contains the following:
>
> > > > #!/bin/ksh
>
> > > > . /oracle/.kshrc
>
> > > > env >> /tmp/t.txt
> > > > which sqlplus >> /tmp/t.txt
>
> > > > sqlplus scott/abc(a)ORACLE123<<-!
> > > > set serveroutput on size 1000000
> > > > select 'Hello World' from dual
> > > > /
> > > > !
>
> > > > I've ran this successfully via the command line. Could someone advise
> > > > as to what I am missing or did wrong?
>
> > > > I had a look at metalink and check the points given there but I seem
> > > > to have them covered.
>
> > > > Regards
>
> > > > Justin
>
> > > David's answer is part of the way there. So I'll explicitly ask:
> > > Did you see metalink Note:391820.1 ? Does $ORACLE_HOME/rdbms/admin/
> > > externaljob.ora exist?
> > > Is your oracle executable -rwsr-s--x 1 oracle oinstall ?
> > > (Those s's mean run as the user, which is probably nobody as that note
> > > says - if you have different protection, you had an installation/
> > > patching problem).
> > > Which exact platform/OS/OS version are you on?
> > > Which exact version of Oracle are you on, including 4 decimals. Have
> > > you applied any critical patch updates? Note:735219.1 says you have to
> > > change the permissions on the extjob executable.
>
> > > Note:732963.1 points out the script must exist on all nodes of the
> > > cluster with the proper permissions.
>
> > > Are you sure the #!/bin/ksh is on the _first_ line of the script?
> > > Are you sure there is a space after the period on the line . /
> > > oracle/.kshrc?
> > > Are all the /tmp/t.txt environment variables what you expect?
> > > Are all the .kshrc environment variables exported?
>
> > > Please remember to be specific as to which docs you've actually
> > > followed. The 'puter takes things even more literal than the people
> > > on this group.
>
> > > jg
> > > --
> > > @home.com is bogus.http://www.theregister.co.uk/2008/07/28/sun_dziuba_tm/
>
> > Ok. I've gone through the items. And here are the results:
>
> > 1. The current permissions for that script is - -rwxr----x- (This was
> > prior to me reading your last post and still got the permission
> > denied)
>
> > 2. I've actually gone through the Note:391820.1 before. I confirm the
> > following:
>
> > a. $ORACLE_HOME/rdbms/admin/externaljob.ora exists
> > b. #!/bin/ksh is on the 1st line of the script
> > c. There is a space after the period on the line . /oracle/.kshrc
> > d. all things mentioned in that note is the same on my end with the
> > exception of :
>
> > 3. Edit $ORACLE_HOME/rdbms/admin/externaljob.ora and set run_user to
> > the OS account that owns the Oracle installation and the database and
> > run_group to the OS group that owns the Oracle_Home.
>
> > Example:
> > OS account: oracle
> > OS group: oinstall
>
> > I am not too sure that I should be changing the default of nobody. I
> > am only trying to execute not write to the file. Or is my
> > understanding of this is wrong?

That is a long discussion about security. If you want nobody to run
your script, your script has to be readable and executable by nobody
(an actual user you should be able to see in your /etc/passwd). If
you want the oracle user to run the script, the script has to be
readable and executable by oracle:oinstall (or whoever the group
oracle is, you should log in as oracle and run the id command to see).

Search oracle.com for "project lockdown" I think it is called, for
security considerations.

>
> > 3. How do I change the permission for the executable to -rwsr-s--x ?
>
> > 4. I am on a Linux 2.6.9-55.0.0.0.2.ELsmp x86_64 x86_64 x86_64 GNU/
> > Linux and
> > Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bi
> > PL/SQL Release 10.2.0.3.0 - Production
> > CORE 10.2.0.3.0 Production
>
> Ok. I've set the permission of the script with chmod 6751 and now get
> the following error instead:
>
> ORA-27369: job of type EXECUTABLE failed with exit code: No such file
> or directory

That permission setting is for things that are run by oracle, not your
script, I want to be sure you set the correct executable, so ls -l
both the executable and your script file.

Also, ls -l the script file on all your nodes. I'm guessing you only
have it on one node? How many nodes do you have in your RAC?

jg
--
@home.com is bogus.
Getting poked by the repo man:
http://www3.signonsandiego.com/stories/2008/dec/16/australia-facebook-121608/?zIndex=23075

First | Prev |
Pages: 1 2
Prev: What's the default database administrator username in the Orcale 10g world?
Next: get the sid,serial# of my connection?