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

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.
systemsautomationAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
sdstuberConnect With a Mentor Commented:
did you grant READ on APEX_IMAGES to the oracle account?  
0
 
sdstuberCommented:
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
 
systemsautomationAuthor Commented:
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
 
systemsautomationAuthor Commented:
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
 
sdstuberCommented:
are you sure the database is running as "myuser"?

0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.