Skip to main content
B
23-Emerald III
BenLoosli23-Emerald III
23-Emerald III
August 2, 2022
Solved

Oracle import fails

  • August 2, 2022
  • 3 replies
  • 29231 views

Doing on Oracle impdp for an upgrade and I get errors trying to write the log file. I have manually created a file in that same folder.

 

Connected to: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation: unexpected "LFI" error (1509)[29437]

Best answer by BenLoosli

Went to our Oracle expert this morning. He asked a bunch of questions and then I had to download SQLdeveloper. Once I looked at the database in SQLdeveloper, I caught a typo in the directory path definition.

3 replies

S
SWeiler_994026116-Pearl
16-Pearl
August 2, 2022

I've run into this same issue, it is from OS permissions. Make sure that the account running the impdp has full control on the folder where the log file is being written and be sure to run the cmd prompt as administrator. 

B
23-Emerald III
BenLoosli23-Emerald IIIAuthor
23-Emerald III
August 2, 2022

That is what is frustrating to me with this one. It is the second time I have done the database import on this computer and the first time it went in  with no issues. I wiped Oracle out between imports and reinstalled it. 

I am running the command window as administrator.

I can create a file, edit it and delete it from the GUI interface.

I can do a mkdir and the folder is created, and delete the created folder from the command prompt window.

I tried with no logfile being specified, but impdp still wants to create a log file.

I tried with a specific directory in the logfile: logfile=e:\util\imp_full,txt, and that too failed. My import file and the folder I am in is e:\util\backup.

I do have a call into PTC, but that could take days! 😞

S
SWeiler_994026116-Pearl
16-Pearl
August 2, 2022

Try giving the user "oracle" full control of the folder.

Marco Tosin
21-Topaz I
Marco Tosin21-Topaz I
21-Topaz I
August 3, 2022

@BenLoosli,

I experienced something similar myself.

 

In the end, my problem was that the import/export procedure is NOT able to overwrite the log file if it already exists in the folder.

 

I removed the log file and the procedure completed correctly

Marco
B
23-Emerald III
BenLoosli23-Emerald IIIAuthor
23-Emerald III
August 3, 2022

There is no full_imp.txt file in that folder. I am depending on the Oracle impdp command to create it. I do have the full_exp.txt file from the other system export in that folder, maybe I will remove it and see what happens.

B
23-Emerald III
BenLoosli23-Emerald IIIAuthor
23-Emerald III
August 3, 2022

Removed the full_exp.txt file and it still failed.

Tried my home directory c:\users \<username> and it still failed to create the import log text file.

I am in the administrators group, I am running the command as administrator, I have set Full Control permissions to the e:\

Util and e:\util\backup folders.

What is really weird is that this worked with no errors 2 months ago on my first install of Windchill12 with Oracle 19c. With that install I ran into UpgradeManager issues, so I removed everything to start over. 

B
23-Emerald III
BenLoosli23-Emerald IIIAuthorAnswer
23-Emerald III
August 4, 2022

Went to our Oracle expert this morning. He asked a bunch of questions and then I had to download SQLdeveloper. Once I looked at the database in SQLdeveloper, I caught a typo in the directory path definition.

    R
    RandyJones20-Turquoise
    20-Turquoise
    August 4, 2022
    @BenLoosli wrote:

    Went to our Oracle expert this morning. He asked a bunch of questions and then I had to download SQLdeveloper. Once I looked at the database in SQLdeveloper, I caught a typo in the directory path definition.

    I thought I was the only one that had typo's.

    Nothing will drive you nuts faster than one of those that you seem to not catch no matter how many times you look at it.

      Terms & ConditionsCookie settingsAccessibility statement