SoftTree Technologies SoftTree Technologies
Technical Support Forums
RegisterSearchFAQMemberlistUsergroupsLog in
Error 22285 following upgrade to 8.1.7

 
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools View previous topic
View next topic
Error 22285 following upgrade to 8.1.7
Author Message
Michael Walshe



Joined: 07 Jun 2001
Posts: 4

Post Error 22285 following upgrade to 8.1.7 Reply with quote

WE UPGRADED OUR DATABASE FROM 8.1.5 TO 8.1.7 RUNNING ON NT.
We did not re-install DB-mail which is version 1.1.03
PREVIOUSLY OUR ATTACH FILE WAS RUNNING OK FROM A DIRECTORY WHICH MAPPED ONTO
C:\Agrinet

Now the attach_file function is failing Error ORA-22285
Non existent directory or file for fileopen operation

Has something changed at 8.1.7 ?

Thu Jun 07, 2001 11:39 am View user's profile Send private message
SysOp
Site Admin


Joined: 26 Nov 2006
Posts: 6506

Post Re: Error 22285 following upgrade to 8.1.7 Reply with quote

Can you attach files from other directories?

Check the status of the DIRECTORY object
SELECT STATUS FROM ALL_OBJECTS WHERE ...

Also check that you still have permissions to access that OS file/directory from Oracle.

: WE UPGRADED OUR DATABASE FROM 8.1.5 TO 8.1.7 RUNNING ON NT.
: We did not re-install DB-mail which is version 1.1.03
: PREVIOUSLY OUR ATTACH FILE WAS RUNNING OK FROM A DIRECTORY WHICH MAPPED ONTO
: C:\Agrinet

: Now the attach_file function is failing Error ORA-22285
: Non existent directory or file for fileopen operation

: Has something changed at 8.1.7 ?

Thu Jun 07, 2001 11:59 am View user's profile Send private message
Michael Walshe



Joined: 07 Jun 2001
Posts: 4

Post Re: Error 22285 following upgrade to 8.1.7 Reply with quote

The STATUS for the DIRECTORY object being used is VALID.

The permissions on FOLDER are ok also.

I have not tried to ATTACH to another folder, as of yet.

Mon Jun 11, 2001 8:44 am View user's profile Send private message
Michael Walshe



Joined: 07 Jun 2001
Posts: 4

Post Re: Error 22285 following upgrade to 8.1.7 Reply with quote

: Can you attach files from other directories?

: Check the status of the DIRECTORY object
: SELECT STATUS FROM ALL_OBJECTS WHERE ...

: Also check that you still have permissions to access that OS file/directory
: from Oracle.

We solved problem by giving READ access on the DIRECTORY object to SYSTEM.

Wed Jun 20, 2001 4:26 am View user's profile Send private message
Display posts from previous:    
Reply to topic    SoftTree Technologies Forum Index » DB Audit, DB Mail, DB Tools All times are GMT - 4 Hours
Page 1 of 1

 
Jump to: 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


 

 

Powered by phpBB © 2001, 2005 phpBB Group
Design by Freestyle XL / Flowers Online.