Solved

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

Posted on 2008-06-19
5
10,102 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 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 74

Expert Comment

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

0

Featured Post

Enroll in June's Course of the Month

June's Course of the Month is now available! Every 10 seconds, a consumer gets hit with ransomware. Refresh your knowledge of ransomware best practices by enrolling in this month's complimentary course for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

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

Introduction A previously published article on Experts Exchange ("Joins in Oracle", http://www.experts-exchange.com/Database/Oracle/A_8249-Joins-in-Oracle.html) makes a statement about "Oracle proprietary" joins and mixes the join syntax with gen…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to recover a database from a user managed backup
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.

705 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