Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Execute permission denied on "oracle"

Alianto
Advisor

Execute permission denied on "oracle"

Hi,

Anybody ever encounter this problem ?

$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Tue May 14 08:49:02 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect internal;
sh: /home/oracle817/bin/oracle: Execute permission denied.
ERROR:
ORA-24314: service handle not initialized


SQL> connect / as sysdba;
sh: /home/oracle817/bin/oracle: Execute permission denied.
ERROR:
ORA-12547: TNS:lost contact


SQL>

If Yes, would You like to share your experience and solution ?
fyi, I encountered this problem after installing Oracle Server program with tuning kernel parameters, like maxdsiz and maxdsiz_64. The new value of maxdsiz is 512M and maxdsiz_64=1G.

Thanks You,

Cheers,

Alianto
8 REPLIES
Bill Hassell
Honored Contributor

Re: Execute permission denied on "oracle"

Try:

ll /home/oracle817/bin/oracle

It should read: -rwxr-xr-x 1 oracle users ...
In Unix shorthand, this is 755 permissions and gives execution permissions to every user to run this program.


Bill Hassell, sysadmin
Alianto
Advisor

Re: Execute permission denied on "oracle"

The permission mode of this file as follow,

# ls -al /home/oracle817/bin/oracle
-rwsr-s--x 1 oracle dba 36216424 May 13 19:51 /home/oracle817/bin/oracle
Steven Sim Kok Leong
Honored Contributor

Re: Execute permission denied on "oracle"

Hi,

Have you relinked your Oracle binaries?

Hope this helps. Regards.

Steven Sim Kok Leong
Email: steven@beepz.com. Homepage: https://www.beepz.com
Sukant Naik
Trusted Contributor

Re: Execute permission denied on "oracle"

Hi Alianto,

I found this link on the Oracle site regarding your problem.

Subject: oracle execute permission denied

RDBMS Version: 8.1.7.2
Operating System and Version: HPUX 11.0
Error Number (if applicable):
Product (i.e. SQL*Loader, Import, etc.):
Product Version:

oracle execute permission denied

After I relink oracle ($relink all),I start svrmgrl.
I get the following error code

oracle@scosvr5/export1/robee/oracle/product/8.1.7/bin>svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

sh: /export1/robee/oracle/product/8.1.7/bin/oracle: Execute permission denied.
sh: /export1/robee/oracle/product/8.1.7/bin/oracle: Execute permission denied.
ORA-12547: TNS:lost contact
SVRMGR> exit
sh: /export1/robee/oracle/product/8.1.7/bin/oracle: Execute permission denied.
sh: /export1/robee/oracle/product/8.1.7/bin/oracle: Execute permission denied.
Server Manager complete.
oracle@scosvr5/export1/robee/oracle/product/8.1.7/bin>


the permission of oracle file is :
-rwsr-s--x 1 oracle dba 36343168 Aug 8 16:22 oracle



we recently had this problem and needed to applly HP patches for "ld".
Check the HP web site for the exact patch name.



Hi,

Install HP-UX linker tools cumulative patch PHSS_22514 or later.

After you install this patch, all of the Oracle executables need to be relinked:
For Oracle8i:

1) Change to the "bin" directory:

% cd $ORACLE_HOME/bin

2) Use the "relink" utility with the "all" argument:

% relink all

3) Use the "relink" utility with the "utilities" argument:

% relink utilities

4) Change to the "sqlplus/lib" directory:

% cd $ORACLE_HOME/sqlplus/lib

5) Use the "make" command to relink "sqlplus":

% make -f ins_sqlplus.mk install


-Sukant
Who dares he wins
Alexander M. Ermes
Honored Contributor

Re: Execute permission denied on "oracle"

Hi there.
To change the permissions :

chmod 6751 oracle
.
Is the user you logged in with a member of group dba ?

Rgds
Alexander M. Ermes
.. and all these memories are going to vanish like tears in the rain! final words from Rutger Hauer in "Blade Runner"
Alianto
Advisor

Re: Execute permission denied on "oracle"

Hi Sukant,

There is new patch PHSS_26262 which is supersede of PHSS_22514. I have got it and schedule for patching very soon.

Cheers,

Alianto
Robert P Jessie
Occasional Advisor

Re: Execute permission denied on "oracle"

Are you 64bit?
Alianto
Advisor

Re: Execute permission denied on "oracle"

Hi,

After applying patch PHSS_26262 and reinstall Oracle Program 8.1.7.0, I encounter other error :

$ export ORACLE_SID=land
$ sqlplus /nolog

SQL*Plus: Release 8.1.7.0.0 - Production on Sat May 18 14:56:31 2002

(c) Copyright 2000 Oracle Corporation. All rights reserved.

SQL> connect internal;
ERROR:
ORA-24327: need explicit attach before authenticating a user


SQL> exit
$ svrmgrl

Oracle Server Manager Release 3.1.7.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation. All Rights Reserved.

ORA-03113: end-of-file on communication channel
SVRMGR> exit
Server Manager complete.
$

I thought I don't need to relink Oracle programs as I done with fresh installation.

Anybody ever seen this error ? and how to resolve ? please share

Cheers,

Alianto