dbTalk Databases Forums  

ORA-27369: job of type EXECUTABLE failed with exit code: Permissiondenied

comp.databases.oracle.misc comp.databases.oracle.misc


Discuss ORA-27369: job of type EXECUTABLE failed with exit code: Permissiondenied in the comp.databases.oracle.misc forum.



Reply
 
Thread Tools Display Modes
  #31  
Old   
just_real
 
Posts: n/a

Default Re: ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied - 12-16-2008 , 09:08 PM






On Dec 17, 12:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:
Quote:
On Dec 17, 6:35*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:



On Dec 14, 8:41*pm, just_real <jth... (AT) gmail (DOT) 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@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


Reply With Quote
  #32  
Old   
just_real
 
Posts: n/a

Default Re: ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied - 12-16-2008 , 09:08 PM






On Dec 17, 12:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:
Quote:
On Dec 17, 6:35*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:



On Dec 14, 8:41*pm, just_real <jth... (AT) gmail (DOT) 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@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


Reply With Quote
  #33  
Old   
just_real
 
Posts: n/a

Default Re: ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied - 12-16-2008 , 09:08 PM



On Dec 17, 12:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:
Quote:
On Dec 17, 6:35*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:



On Dec 14, 8:41*pm, just_real <jth... (AT) gmail (DOT) 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@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


Reply With Quote
  #34  
Old   
joel garry
 
Posts: n/a

Default Re: ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied - 12-17-2008 , 04:05 PM



On Dec 16, 7:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:
Quote:
On Dec 17, 12:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:





On Dec 17, 6:35*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:

On Dec 14, 8:41*pm, just_real <jth... (AT) gmail (DOT) 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@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 oracleinstall (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.

Quote:
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/stori.../?zIndex=23075



Reply With Quote
  #35  
Old   
joel garry
 
Posts: n/a

Default Re: ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied - 12-17-2008 , 04:05 PM



On Dec 16, 7:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:
Quote:
On Dec 17, 12:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:





On Dec 17, 6:35*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:

On Dec 14, 8:41*pm, just_real <jth... (AT) gmail (DOT) 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@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 oracleinstall (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.

Quote:
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/stori.../?zIndex=23075



Reply With Quote
  #36  
Old   
joel garry
 
Posts: n/a

Default Re: ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied - 12-17-2008 , 04:05 PM



On Dec 16, 7:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:
Quote:
On Dec 17, 12:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:





On Dec 17, 6:35*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:

On Dec 14, 8:41*pm, just_real <jth... (AT) gmail (DOT) 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@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 oracleinstall (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.

Quote:
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/stori.../?zIndex=23075



Reply With Quote
  #37  
Old   
joel garry
 
Posts: n/a

Default Re: ORA-27369: job of type EXECUTABLE failed with exit code:Permission denied - 12-17-2008 , 04:05 PM



On Dec 16, 7:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:
Quote:
On Dec 17, 12:08*pm, just_real <jth... (AT) gmail (DOT) com> wrote:





On Dec 17, 6:35*am, joel garry <joel-ga... (AT) home (DOT) com> wrote:

On Dec 14, 8:41*pm, just_real <jth... (AT) gmail (DOT) 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@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 oracleinstall (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.

Quote:
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/stori.../?zIndex=23075



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.