10 Replies Latest reply: Jul 25, 2012 1:39 PM by EdStevens RSS

    ORA-29283: invalid file operation

    586608
      Hi,


      My Environment: Workstation - WinXP, Oracle10g, remotely connecting to a Win 2003 Server.


      I am trying to export (DataPump) the database remotely (VPN) onto my Win XP Workstation station and I am getting this error:

      ORA-39002: invalid operation
      ORA-39070: Unable to open the log file.
      ORA-29283: invalid file operation
      ORA-06512: at "SYS.UTL_FILE", line 475
      ORA-29283: invalid file operation
      I've already created dpump_dir on my workstation which is '\\tsclient\C\export_FrPrd'


      Can someone please share some knowledge?


      Regards,


      Texas!
        • 1. Re: ORA-29283: invalid file operation
          153119
          Oracle doesn't support UNC directories in all versions. As you assume Oracle never changes and you don't want to make any effort to mention your version, it is difficult to help you. On 10gR2 you need to make sure you start the Oracle service using a domain account. You must also start the listener using the same domain account. If you are using RAC you also need to run a CRSToken service.
          Typically measures like this are documented, either in the standard documentation no one reads, and on 'My Oracle Support' (Formerly Metaclunk)


          ----
          Sybrand Bakker
          Senior Oracle DBA
          • 2. Re: ORA-29283: invalid file operation
            586608
            Thanks alot.
            • 3. Re: ORA-29283: invalid file operation
              Paulie
              >


              ORA-39002: invalid operation
              ORA-39070: Unable to open the log file.
              ORA-29283: invalid file operation
              ORA-06512: at "SYS.UTL_FILE", line 475
              ORA-29283: invalid file operation
              I've already created dpump_dir on my workstation which is '\\tsclient\C\export_FrPrd'
              AFAIK, the UTL_File stuff can only write to the server on
              which it's located.

              Try this link

              http://www.orafaq.com/forum/t/48143/0/


              got from Googling BTW...

              Can someone please share some knowledge?
              Maybe you could start the ball rolling with some of your own - like db
              and OS versions - see my .sig...



              Paul...

              Texas!
              --

              When asking database related questions, please give other posters
              some clues, like OS (with version), version of Oracle being used and DDL.

              Other trivia such as CPU, RAM + Disk configuration might also be useful.
              The exact text and/or number of error messages is useful (!= "it didn't work!"). Thanks.

              Furthermore, as a courtesy to those who spend time analysing and attempting to help,
              please do not top post and do try to trim your replies!
              • 4. Re: ORA-29283: invalid file operation
                708415
                Hey Texas,

                I hope your problem has been solved by now. I was working on a similar problem the last days. Today I was able to solve it. I can share with you, what I did. Maybe it can help you as well.

                I've got the same errors as you did. Exactly the same.

                I found this searching the internet:

                Cause
                The current API cannot be executed because of inconsistencies between the API and the current definition of the job. Subsequent messages supplied by DBMS_DATAPUMP.GET_STATUS will further describe the error.

                Action
                Modify the API call to be consistent with the current job or redefine the job in a manner that will support the specified API.

                I found out that by creating the directory I made a mistake. After correcting that my expdp ran smoothly.

                SQL> CREATE DIRECTORY dpump_dir AS '/space/u03 */dpump_dir* ’;

                The part in bold or between *s had to go.

                SQL> CREATE DIRECTORY dpump_dir AS '/space/u03’;


                SQL> grant read, write on directory dpump_dir to Username;

                This error just happens, because your expdp agent doesn't find the right directory to build the dumpfile as well as logfile in.

                Another hint would be, that if you are trying to make a backup from any of the SYS objects, there is a restriction with expdp. You cannot use expdp to export those objects. You should use exp for that.

                If this doesn't answer your question. Please send me your command lines. I will be more than happy to take a look.

                Have a great day,

                Megan
                • 5. Re: ORA-29283: invalid file operation
                  746809
                  i installed oracle database 10g in windows xp.
                  In my laptop the flat file is located in E:\data_load\data.txt
                  i created directory in system schema
                  sql> create or replace directory SAMPLE as 'E:data_laod';
                  sql> GRANT READ, WRITE on directory SAMPLE to SCOTT;

                  after doing this i logged into scott schema and i can write the data to flat files
                  but i am unable to read the data from flat files by executing the procedure.

                  ERROR:
                  ORA-29283: invalid file operation

                  can anyone help me how to solve this error.
                  • 6. Re: ORA-29283: invalid file operation
                    EdStevens
                    user8993117 wrote:
                    i installed oracle database 10g in windows xp.
                    In my laptop the flat file is located in E:\data_load\data.txt
                    i created directory in system schema
                    sql> create or replace directory SAMPLE as 'E:data_laod';
                    sql> GRANT READ, WRITE on directory SAMPLE to SCOTT;

                    after doing this i logged into scott schema and i can write the data to flat files
                    but i am unable to read the data from flat files by executing the procedure.
                    What procedure were you trying to execute? How did you try to execute it?

                    >
                    ERROR:
                    ORA-29283: invalid file operation

                    can anyone help me how to solve this error.
                    BTW, did you notice you jumped on a 6-month old thread?
                    • 7. Re: ORA-29283: invalid file operation
                      737676
                      I have the same problem, I do as you said above, but it cannot work.
                      • 8. Re: ORA-29283: invalid file operation
                        avramits
                        sybrandb gave perfect solution for this problem. If error in a path then fix error. But this thread not about directory error. This thread about writing to UNC location.
                        • 9. Re: ORA-29283: invalid file operation
                          951753
                          Sir,
                          While using impdp command for data import, the following error message will appear.
                          (oracle-xe-10.2.0.1-1.0.i386)

                          ORA-29283: invalid file operation
                          ORA-06512: at "SYS.UTL_FILE", line 475
                          ORA-29283: invalid file operation
                          ORA-06512: at line 14

                          What can i do?

                          Arun
                          • 10. Re: ORA-29283: invalid file operation
                            EdStevens
                            948750 wrote:
                            Sir,
                            While using impdp command for data import, the following error message will appear.
                            (oracle-xe-10.2.0.1-1.0.i386)

                            ORA-29283: invalid file operation
                            ORA-06512: at "SYS.UTL_FILE", line 475
                            ORA-29283: invalid file operation
                            ORA-06512: at line 14

                            What can i do?
                            You can begin by starting your own thread instead of reviving one from the archives.
                            And when you do start your own thread, you can supply the same information as was requested in this thread.
                            Arun