OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » ora-22288 (11gR2 RHEL5.5)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ora-22288 [message #633495]

Thu, 19 February 2015 11:42

smunir362
Messages: 310
Registered: September 2007

Senior Member

Hi,
After upgrade 10g to 11gR2 we are facing following error

ORA-22288 file or LOB operation FILEOPEN failed No such file or directory
ORA-06512 at abc.file_utl_pkg line 249
ORA-06512 at abc.trg_event_dt line 22
ORA-04088 error during e

Report message to a moderator

Re: ora-22288 [message #633496 is a reply to message #633495]

Thu, 19 February 2015 11:50

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

We don't know what you did when you got this error.
We even have not the complete error message.

Quote:

No such file or directory

This may be a clue for you.

Report message to a moderator

Re: ora-22288 [message #633497 is a reply to message #633496]

Thu, 19 February 2015 11:57

smunir362
Messages: 310
Registered: September 2007

Senior Member

but file exists on OS. It was working in 10g. After upgrade to 11gR2 it happened.

Report message to a moderator

Re: ora-22288 [message #633498 is a reply to message #633497]

Thu, 19 February 2015 12:07

Michel Cadot
Messages: 68758
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

But maybe Oracle has not the right to access it.

Report message to a moderator

Re: ora-22288 [message #633508 is a reply to message #633498]

Thu, 19 February 2015 14:01

Bill B
Messages: 1971
Registered: December 2004

Senior Member

have you set up the directory object in oracle and does the oracle user have r/w access to that directory?

Report message to a moderator

Re: ora-22288 [message #633538 is a reply to message #633508]

Fri, 20 February 2015 16:12

Kevin Meade
Messages: 2103
Registered: December 1999
Location: Connecticut USA

Senior Member

99% of the time there are two reasons for this. Both of them have already been stated.

1. privileges. Somewhere along the way, the proper access to one or more objects has not been granted. (this is Michel's response)
2. wrong name. You used bad name. Either names have changed on the new server or you spelled it wrong somehow. (this is Bills' response)

The reality is, this problem is fully in your court. You need to start doing basic debugging to try and figure it out. This may in fact mean tracing each line one at a time looking at what it does and what variable values it is using and seeing exactly where the error shows up.

Good luck. We can't really debug your code for you no matter how much we want to. Sorry.

Kevin

Report message to a moderator

Re: ora-22288 [message #633565 is a reply to message #633497]

Sat, 21 February 2015 11:50

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

smunir362 wrote on Thu, 19 February 2015 09:57

but file exists on OS. It was working in 10g. After upgrade to 11gR2 it happened.

Oracle does NOT know or care about what may have existed in the past & neither should you.
The error code & message provides clues as to what Oracle knows reality to be NOW.
It is your challenge to find & fix the problem or just be satisfied with having the error thrown.

Report message to a moderator

Previous Topic:	New to using Oracle. Need help!
Next Topic:	How to delete data from all the tables with one Query?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Jun 01 15:27:26 CDT 2025