?
Solved

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

Posted on 2008-06-19
5
Medium Priority
?
10,451 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

[Webinar] How Hackers Steal Your Credentials

Do You Know How Hackers Steal Your Credentials? Join us and Skyport Systems to learn how hackers steal your credentials and why Active Directory must be secure to stop them.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows information on the Oracle Data Dictionary, starting with the Oracle documentation, explaining the different types of Data Dictionary views available by group and permissions as well as giving examples on how to retrieve data from th…
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses

764 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