Solved

ORA-22288: file or LOB operation FILEOPEN failed Permission denied

Posted on 2008-06-19
5
9,150 Views
Last Modified: 2013-12-18
I have installed Oracle XE (Universal) on Fedora Core 8

I am trying to update Apex to 3.1.1. I have downloaded and extracted the zip file using unizp apex_3.1.1.zip

I ran   @apexins SYSAUX SYSAUX TEMP /i/
and  @apxchpwd

Both were successful

Now when I am executing this

@apxldimg.sql /home/myuser

I am getting

Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production


PL/SQL procedure successfully completed.

old   1: create directory APEX_IMAGES as '&1/apex/images'
new   1: create directory APEX_IMAGES as '/home/myuser/apex/images'

Directory created.

declare
*
ERROR at line 1:
ORA-22288: file or LOB operation FILEOPEN failed
Permission denied
ORA-06512: at "SYS.DBMS_LOB", line 523
ORA-06512: at "SYS.XMLTYPE", line 287
ORA-06512: at line 15



PL/SQL procedure successfully completed.


Commit complete.

timing for: Load Images
Elapsed: 00:00:00.06

Directory dropped.


Kindly help.
0
Comment
Question by:systemsautomation
  • 3
  • 2
5 Comments
 
LVL 73

Expert Comment

by:sdstuber
ID: 21828528
what user is running your database?  assuming it's a user called "oracle"

does oracle have access to /home/myuser/apex/images?

the database os user needs to have permission at the operating system level in order to grant access to users.
0
 

Author Comment

by:systemsautomation
ID: 21828585
oracle user is myuser

yes myuser is the owner of /home/myuser/apex and all its subfolders and files

I have also tried it using root user but no luck
0
 
LVL 73

Accepted Solution

by:
sdstuber earned 250 total points
ID: 21828594
did you grant READ on APEX_IMAGES to the oracle account?  
0
 

Author Comment

by:systemsautomation
ID: 21828681
Thanks a lot.

When I did chmod 777 -R myuser

then it worked.

Buy why the user itself does not have privileges on its own folder?
0
 
LVL 73

Expert Comment

by:sdstuber
ID: 21830203
are you sure the database is running as "myuser"?

0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.

910 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

25 Experts available now in Live!

Get 1:1 Help Now