Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2008-06-19
5
Medium Priority
?
10,908 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 74

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 74

Accepted Solution

by:
sdstuber earned 750 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 74

Expert Comment

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

0

Featured Post

New feature and membership benefit!

New feature! Upgrade and increase expert visibility of your issues with Priority Questions.

Question has a verified solution.

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

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many…
Configuring and using Oracle Database Gateway for ODBC Introduction First, a brief summary of what a Database Gateway is.  A Gateway is a set of driver agents and configurations that allow an Oracle database to communicate with other platforms…
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.
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines

610 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