f



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

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
0
just_real
12/15/2008 4:41:53 AM
comp.databases.oracle.misc 8436 articles. 1 followers. Post Follow

9 Replies
1865 Views

Similar Articles

[PageSpeed] 4

On Dec 14, 10:41=A0pm, just_real <jth...@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@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

Which O/S user created the script?  Which O/S users can actually
execute this script?


David Fitzjarrell
0
ddf
12/15/2008 1:32:34 PM
On Dec 16, 12:32=A0am, ddf <orat...@msn.com> wrote:
> On Dec 14, 10:41=A0pm, just_real <jth...@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@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
>
> Which O/S user created the script? =A0Which O/S users can actually
> execute this script?
>
> David Fitzjarrell

Hi David

I am little raw to this. When you say which O/S user created the
script - how would I go about finding that out? How do I go about
finding out which O/S users can actually execute this script?

When I do an ls -l on the command line - rwx is the first set of three
letters shown. Not sure if that's what you were asking.
0
just_real
12/15/2008 11:08:06 PM
On Dec 16, 12:32=A0am, ddf <orat...@msn.com> wrote:
> On Dec 14, 10:41=A0pm, just_real <jth...@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@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
>
> Which O/S user created the script? =A0Which O/S users can actually
> execute this script?
>
> David Fitzjarrell

Hi David

Thanks for the reply. I am still new to this. How would I go about
finding out Which O/S user created the script?  Which O/S users can
actually
execute this script?

When executing ls -l at the command line, the first set of three
letters for the script was rwx. Not sure if this was what you were
after?


0
just_real
12/15/2008 11:40:40 PM
On Dec 15, 5:40=A0pm, just_real <jth...@gmail.com> wrote:
> On Dec 16, 12:32=A0am, ddf <orat...@msn.com> wrote:
>
>
>
>
>
> > On Dec 14, 10:41=A0pm, just_real <jth...@gmail.com> wrote:
>
> > > Hi
>
> > > I was trying to set up a test job in Enterprise manager and I got thi=
s
> > > 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
>
> > Which O/S user created the script? =A0Which O/S users can actually
> > execute this script?
>
> > David Fitzjarrell
>
> Hi David
>
> Thanks for the reply. I am still new to this. How would I go about
> finding out Which O/S user created the script? =A0Which O/S users can
> actually
> execute this script?
>
> When executing ls -l at the command line, the first set of three
> letters for the script was rwx. Not sure if this was what you were
> after?- Hide quoted text -
>
> - Show quoted text -

No, I'm 'after' the owner and group for that script, as well as the
permissions for anyone other than the owner.  The example below
describes how an ls -l record is arranged and which information I
requested:

  o  g  w     owner     group
  v   v  v         v          v
-rwx------   1 oracle   dba          685 Nov 19 06:17
get_version_all.sh

There are 10 characters in the first string, a 'special' character to
indicate things like named pipes, directories, special files, etc.
and, most commonly, three sets of 'rwx' or placeholders.  The example
above lists that the OWNER has full rights to the script; the group
and the rest of the world have no rights whatsoever.  Other
combinations might be:

-rw-rw-rw-   1 oracle   dba          685 Nov 19 06:17
get_version_all.sh

giving the owner, group and rest of the 'world' read and write
permissions, but no execute privilege.  Yet another possibility is:

-rwxr-xr-x   1 oracle   dba          685 Nov 19 06:17
get_version_all.sh

giving the owner full privileges, and the group and world read and
execute, but no write privilege.  It appears that someone other than
'oracle' wrote this script of yours and the permissions mask is set to
750, which translates to:

-rwxr-x---   1 nackle   dorf          685 Nov 27 16:39
grompenflommetz.sh

so the owner has full rights to read, write and execute the script,
the group has rights to read and execute the script and the rest of
the world can't do anything with it at all.  In this situation
'oracle' is part of the 'rest of the world' and is left out in the
cold, so to speak.  This could cause the 'permission denied' error you
are experiencing.  Of course no one will know that until you can post
the information I've requested.


David Fitzjarrell
0
ddf
12/16/2008 1:56:01 PM
On Dec 14, 8:41=A0pm, just_real <jth...@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@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/

0
joel
12/16/2008 7:35:57 PM
On Dec 17, 6:35=A0am, joel garry <joel-ga...@home.com> wrote:
> On Dec 14, 8:41=A0pm, just_real <jth...@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@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. =A0So I'll explicitly ask:
> Did you see metalink Note:391820.1 ? =A0Does $ORACLE_HOME/rdbms/admin/
> externaljob.ora exist?
> Is your oracle executable -rwsr-s--x =A0 1 oracle =A0 =A0 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. =A0Have
> 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. =A0The '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/

Hi David & JG

I will look into all that you've stated and get back to you. Thanks
again

jr
0
just_real
12/17/2008 12:36:09 AM
On Dec 17, 6:35=A0am, joel garry <joel-ga...@home.com> wrote:
> On Dec 14, 8:41=A0pm, just_real <jth...@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@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. =A0So I'll explicitly ask:
> Did you see metalink Note:391820.1 ? =A0Does $ORACLE_HOME/rdbms/admin/
> externaljob.ora exist?
> Is your oracle executable -rwsr-s--x =A0 1 oracle =A0 =A0 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. =A0Have
> 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. =A0The '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



0
just_real
12/17/2008 1:08:46 AM
On Dec 17, 12:08=A0pm, just_real <jth...@gmail.com> wrote:
> On Dec 17, 6:35=A0am, joel garry <joel-ga...@home.com> wrote:
>
>
>
> > On Dec 14, 8:41=A0pm, just_real <jth...@gmail.com> wrote:
>
> > > Hi
>
> > > I was trying to set up a test job in Enterprise manager and I got thi=
s
> > > 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. =A0So I'll explicitly ask:
> > Did you see metalink Note:391820.1 ? =A0Does $ORACLE_HOME/rdbms/admin/
> > externaljob.ora exist?
> > Is your oracle executable -rwsr-s--x =A0 1 oracle =A0 =A0 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. =A0Have
> > 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. =A0The '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_t=
m/
>
> 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 =A0x86_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 =A0 =A010.2.0.3.0 =A0 =A0 =A0Production


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
0
just_real
12/17/2008 3:08:40 AM
On Dec 16, 7:08=A0pm, just_real <jth...@gmail.com> wrote:
> On Dec 17, 12:08=A0pm, just_real <jth...@gmail.com> wrote:
>
>
>
>
>
> > On Dec 17, 6:35=A0am, joel garry <joel-ga...@home.com> wrote:
>
> > > On Dec 14, 8:41=A0pm, just_real <jth...@gmail.com> wrote:
>
> > > > Hi
>
> > > > I was trying to set up a test job in Enterprise manager and I got t=
his
> > > > error when it tried running the script.
>
> > > > I've created the script on a RAC cluster . It contains the followin=
g:
>
> > > > #!/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 advi=
se
> > > > as to what I am missing or did wrong?
>
> > > > I had a look at metalink and check the points given there but I see=
m
> > > > to have them covered.
>
> > > > Regards
>
> > > > Justin
>
> > > David's answer is part of the way there. =A0So I'll explicitly ask:
> > > Did you see metalink Note:391820.1 ? =A0Does $ORACLE_HOME/rdbms/admin=
/
> > > externaljob.ora exist?
> > > Is your oracle executable -rwsr-s--x =A0 1 oracle =A0 =A0 oinstall ?
> > > (Those s's mean run as the user, which is probably nobody as that not=
e
> > > 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. =A0Ha=
ve
> > > you applied any critical patch updates? Note:735219.1 says you have t=
o
> > > 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. =A0The 'puter takes things even more literal than the peopl=
e
> > > 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 =A0x86_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 =A0 =A010.2.0.3.0 =A0 =A0 =A0Production
>
> 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-12160=
8/?zIndex=3D23075

0
joel
12/17/2008 10:05:34 PM
Reply:

Similar Artilces:

Getting ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied
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/tiger1@PINFRA <<-! 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 ...

ORA-12546: TNS:permission denied / telnet: socket: Permission denied
I just want to share my tricky problem we had today. We noticed users not able to login to SQL plus or telnet from them box. Everything else was working fine. You can ftp / login / rlogin etc. Nothing was changed and no new software was installed. We rebooted the server that did not help. Finally we found that it is a permission problem on device file crw-rw-rw- 1 root sys 42, 0 Jan 10 16:15 tcp@0:tcp make sure you have read permission. Thakns Siva ...

ORA-12546: TNS:permission denied / telnet: socket: Permission denied #2
I just want to share my tricky problem we had today. We noticed users not able to login to SQL plus or telnet from them box. Everything else was working fine. You can ftp / login / rlogin etc. Nothing was changed and no new software was installed. We rebooted the server that did not help. Finally we found that it is a permission problem on device file /dev/tcp /devices/pseudo crw-rw-rw- 1 root sys 42, 0 Jan 10 16:15 tcp@0:tcp make sure you have read permission. Thakns Siva ...

10g Database Configuration Assistant fails with code ORA-12546
I originally thought the problem related only to the install process of 10g 10.1.0.2 on Windows Server 2003 but I have now established that the DBCA will not run successfully when run on its own either. I can get all the way through the wizard and then when I click OK to start the database creation it brings up a window with a tick beside "Copying database files" and the item being "Clone database creation in progress". At this point it fails with error: ORA-12546: TNS: Permission denied. So I can't create any databases - serious problem! What could be causing this...

rsync: failed to set permissions, Permission denied (13)
ftpd.exe & monitor.exe both exist at the source & dest, though they are the same date/timestamp, so they would not normally be copied. From the luckybackup log last night: <a name="error3"></a><font color=red>rsync: failed to set permissions on "U:/ftpserver/ftpd.exe": Permission denied (13) rsync: failed to set permissions on "U:/ftpserver/monitor.exe": Permission denied (13) Just these two files. Now, the source files were in use, but the dest files are not, and I don't understand this message. -- Regards, Al...

ORACLE 11i/ CONTRACT/ IMMEDIATE/ IN,in.jobs,misc.jobs.offered
OMNI GROUP tgugger@msn.com 419-380-8853 ORACLE 11i / TECHNICAL/ CONTRACT/ INDY AREA If interested and qualified answer the four questions at the bottom Of the page. Email answers WITH a resume to tgugger@msn.com. All questions must be answered to be considered. Position: Oracle 11i Technical Required Work: Implementation/ PL SQL Forms & Reports. Skill areas desired: Order Management Module/ Shipping, Start Date: Immediate Location: Indianapolis, IN area Duration: 2 months+ Rate $45-50 h...

Code that executes AFTER exit
If your code has a "::Requires" directive, then the preamble code in the required file runs BEFORE your code executes. So if you had Say 'Hello' ::Requires 'test.rex' .... and test.rex contains: Say 'From test.rex' .... then the result would be: From test.rex Hello Is there any way to get a similar effect, but AFTER your program has exited? -- Steve Swift http://www.swiftys.org.uk/swifty.html http://www.ringers.org.uk On Wed, 02 Mar 2011 07:22:26 +0000, Swifty wrote: >Is there any way to get a similar effect, but AFTER...

Oracle 9i Database Clone fails becaus 2nd Listener fails to start
Hi! I'm new to Oracle and I just set up an Oracle 9i Database on a WinXP Prof. System. The first one Database is now running pretty fine but now the Problem is, I need a second one. So I created a new Database and a new Listener. 1st Problem is, the Listener fails to start (ORA-12541: TNS:no listener) - why?? And you can imagine, if I furter try to clone my running Database it fails. Another thing is, that's impossible to start the ManagementServer Service - Error 1075 Another Service is required. Is the Management Server necessary for the 2nd Listener? Thx!! Christi...

Oracle database permissions
Can someone tell me how I can view a specific users permissions in Oracle 8.1.7? I want to know all the tables a specific user has rights to. Any help would be appreciated. "tercex11" <tercex11@yahoo.com> wrote in message news:1119050183.830850.112480@g44g2000cwa.googlegroups.com... > Can someone tell me how I can view a specific users permissions in > Oracle 8.1.7? I want to know all the tables a specific user has rights > to. Any help would be appreciated. > user_tab_privs The following article covers a dozen of the more useful security related dictionary...

Using DBMS_SCHEDULER to execute a three step job of different type(2 stored procedure and an executable)
Hi Guys, I would like to schedule 3 jobs which should run one after the other. The first job is a procedure which when successfully completed should invoke a executable from the operating system and once that finishes successfully , which can be determined by a return value should invoke another stored procedure. How can this be accomplished? your inputs are highly aprreciated. Thanks rateeshmohan@gmail.com wrote: > Hi Guys, > > > I would like to schedule 3 jobs which should run one after the other. > The first job is a procedure which when successfully completed should...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html ...

exit codes of background jobs?
Hello! I have a script, which spawns a lot of background jobs and then waits for them to finish. The exit code must be 0 iff all background-jobs succeeded. How can I do this? If I simply use `wait', the exit-codes of indidividual jobs are lost. I don't want to wait for individual ones separately, because there is no way to know, which exits first... I'm using ksh on Solaris-10, but am open to switching to some other shell. I know, how to do this in Tcl, but nobody else here knows the language and I'd like the script to be maintainable by more than one person :( Thanks! ...

DataBase DataBase DataBase DataBase
DataBase DataBase DataBase DataBase Porfessional Programmable Database Ver. 2.0 2.1 Million Record Capacity. Search Rate: 2000/Records/Second. DataBase Type: Random Access. Can Create Unlimited Databases. Programmable fields for any Application. Build Time One Second, (Auto Creates DB). Setup Time: Instantly, Just Enter DB Name. Ultra Easy to Learn (Typically 30 Seconds) Ultra Cheap Price, Special $20, Paypal Accepted. Application Mailed Instantly (file Attached Email). Easy Paypal Online Ordering. See Site Below. http://www.vehiclerepair.org/dbPro/dbpro.html Scott: #DataBase...

exit codes from piped executables
Hello, first I searched the comp.lang.tcl newsgroup for messages belonging to this theme. I found the thread: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&frame=right&th=5a7584afaae8bb90&seekm=1c8670d2.0405260607.5a4c08ce%40posting.google.com#link1 I read, that the portability of tcl demands to get only exit codes below 127 because above are reserved for signals and that "good" executables won't return more than 127. Only Windows executables are bad by returning full 4bytes instead of 7bits. I would really like to have a more distinguished way of exi...

Permission to the Oracle database table
Hello. I need some administrative help. Is there possible to give read grants to one user, and to give another one (to the same table) only write grants? Or better - is it possible to store procedure that will have access to the table and user has only rights to this procedure, not to the table? Thanks a lot for any advice. Yes, you can grant one user read, and another write access, as long as it is not the owner of the table; the owner always has all rights. Your last option is also possible, and it the correct approach as far as I am concerned. User A is owner of the tables, account is...

Failed with exit code 65280.
Hi all, I've had a look around but haven't managed to find any info on this particular problem. Maybe I was searching for the wrong stuff. Anyway, I have a script that runs the flac and lame tools to convert between FLAC and MP3. Within the script the variable $convert_command contains the full piped command with file pathnames etc. This is called using system() but it always fails with exit code 65280 and the warning, "Can't init outfile 'my_outfile'". However, when I run the same command from the shell everything is fine and the file is written. The destin...

Permission denied when executing the program
Dear all, I have completed installing and configuring the MPICH2. But when I execute the program as the public user, I have met such a problem: mpiexec -l -n 4 cpi problem with execution of cpi on admin: [Errno 13] Permission denied problem with execution of cpi on admin: [Errno 13] Permission denied problem with execution of cpi on admin: [Errno 13] Permission denied problem with execution of cpi on admin: [Errno 13] Permission denied the permision of cpi is ok. bash-3.00$ ls -l total 508 -rwxrwxrwx 1 root root 488035 Apr 25 00:56 cpi -rwxrwxrwx 1 root root 2204 Apr 25 00:...

How to run Job in Oracle after failed
Hi all, I just migrate from SQL Server to Oracle. I have a question when I work with job in Oracle, and try to use this forum to asking it. I ask this question is because I don't understand about Job in Oracle, not want to compare that. So, please don't fill me with a debate which is better between SQL Server or Oracle... At SQL Server, if a job failed, that job will still run again on next schedule, but not in Oracle. I think this beacuse Oracle job use Interval, so if once it failed, will not run again on next schedule. Is it right? How to fix that problem? Many thanks to you re...

Execute Ruby code stored in database
Hi, I've got a hypothetical question, and im hoping someone can answer it. Let's say ive got a MySql server and I store some Ruby code inside a column/table/database. Is there anyway I can load this data from a Ruby program and execute the code as if it was a part of the program? Cheers, Petr -- Posted via http://www.ruby-forum.com/. On Jan 6, 2008 6:31 PM, Petr Janda <petr@punchyouremployer.com> wrote: > Hi, > I've got a hypothetical question, and im hoping someone can answer it. > Let's say ive got a MySql server and I store some Ruby code inside a > col...

Load & Execute Code From a Database
Hi, Sometime ago there was a discussion about loading & running code held in a database and there were some adverse comments about security etc.. Was the method based on eval, or are there other ways to load and execute from a string of code stored in a database? Paul F Fraser [Note: parts of this message were removed to make it a legal post.] I guess you could sandbox it? There are Ruby sandboxes out there... Still not 100% protection I guess, but better than eval any day... Greetz! 2009/8/10 Paul F Fraser <paulf@a2zliving.com> > Hi, > Sometime ago there was a discus...

executing code without exiting the interpreter
When I launch the interpreter (i.e. just running "perl" at the command line) I'd like to be able to execute what I've written so far without quitting the interpreter (i.e. without doing a ctrl+D). I've looked at the available flags but haven't found a way of doing this. nikolas pontikos wrote: > When I launch the interpreter (i.e. just running "perl" at the command > line) I'd like to be able to execute what I've written so far without > quitting the interpreter (i.e. without doing a ctrl+D). > > I've looked at the availab...

ORA-12546: TNS:permission denied
OS: CentOs4.7 Oracle: 9.2.0.4.0 ruby: ruby 1.8.7 I'm trying install ruby & dbi & oci8 root have to connect sqlplus for oci8 oracle user connect sqlplus but root not [root]# sqlplus user/pass SQL*Plus: Release 9.2.0.4.0 - Production on Wed Feb 18 10:03:22 2009 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. ERROR: ORA-12546: TNS:permission denied ############# # Help Me!! ############# -- Posted via http://www.ruby-forum.com/. On 18.02.2009 02:05, Kyung won Cheon wrote: > OS: CentOs4.7 > Oracle: 9.2.0.4.0 > ruby: ruby 1.8.7 > > I'm ...

Executing exp as batch job fails
Hello Using Oracle 9.2.0.4/Windows 2000 I am trying to schedule an automatic dump of a database from a DOS window: at 17:00 /every:th d:\oracle\ora92\database\archive\dump.bat (meaning: execute dump.bat every Thursday at 17:00 hours) dump.bat contains: d: REM SET ORACLE_SID=mysid cd D:\oracle\ora92\database\archive REM exp parfile=dump.par exp system/****@mysid consistent=y compress=no file=mysid.dmp log=mysid.log full=y Then I get: EXP-00056: ORACLE error 12154 encountered ORA-12154: TNS:could not resolve service name EXP-00000: Export terminated unsuccessful...

databases.oracle.server job link
http://www.jobbankdata.com http://www.jobbankdata.com/index.htm http://www.jobbankdata.com/type-of-jobs.htm http://www.jobbankdata.com/find-job.htm http://www.jobbankdata.com/result.htm http://www.jobbankdata.com/create-app.htm http://www.jobbankdata.com/create-cv.htm http://www.jobbankdata.com/interview.htm http://www.jobbankdata.com/site.htm On Mar 12, 10:29 am, "good_online_jobs" <good_online_j...@yahoo.com> wrote: > http://www.jobbankdata.comhttp://www.jobbankdata.com/index.htmhttp://www.jobbankdata.com/type-of-jobs.htmhttp://www.jobbankdata.com/find-job.htmhttp://www....

Web resources about - ORA-27369: job of type EXECUTABLE failed with exit code: Permission denied - comp.databases.oracle.misc

Resources last updated: 2/16/2016 11:22:58 PM