• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1008
  • Last Modified:

Receive ORA-29283 when opening 2nd File

I am updating from Oracle 8i to 11g r2. Having ORA-29283 invalid file operation  ORA-06512: at Sys.UTL_FILE , line 536 error on 2nd file opening.  If I comment the second opening, the procdure is successfull in creating a file.  Is there a parameter that needs to be updated from a default of 1?  The OS is UNIX.
0
allclem
Asked:
allclem
  • 3
1 Solution
 
AkenathonCommented:
Please post a working, MINIMAL code sample, so that we can reproduce and help you out.
0
 
madunixChief Information Security Officer Commented:
How are you updating the DB? ...As I know,you cant do that direct. you should do it 8->9 then 9->10 then 10->11 ...eventualy you can migrate 9r2 to 11, but is very dangerous. Better export database install 11 and import back. Of course if it is not huge!


0
 
allclemAuthor Commented:
This is a new install with a datsbase import.
0
 
allclemAuthor Commented:
Turns out the issue is not with Oracle.  I was able to create my files with sql plus.  My tool of choice is Toad for Oracle.   I just upgraded to 10.6.1 and was not able to create my files in the 11g database running the prcdure in Toad Editor.   I will open a ticket with Toad.  Thank you all who responded.
0
 
allclemAuthor Commented:
Turns out the issue is not with Oracle.  I was able to create my files with sql plus.  My tool of choice is Toad for Oracle.   I just upgraded to 10.6.1 and was not able to create my files in the 11g database running the prcdure in Toad Editor.   I will open a ticket with Toad.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now