Home E-mail Us Oracle Articles New Oracle Articles Oracle Training Oracle Tips Oracle Forum Class Catalog Remote DBA Oracle Tuning Emergency 911 RAC Support Apps Support Analysis Design Implementation Oracle Support SQL Tuning Security Oracle UNIX Oracle Linux Monitoring Remote support Remote plans Remote services Application Server Applications Oracle Forms Oracle Portal App Upgrades SQL Server Oracle Concepts Software Support Remote Support Development Implementation Consulting Staff Consulting Prices Help Wanted! Oracle Posters Oracle Books Oracle Scripts Ion Excel-DB |
Question: I am getting the following errors when attempting to run import impdp using the network_link option: C:>impdp example/example@db DIRECTORY=DATA_PUMP_DIR NETWORK_LINK=db.legal.regn.net remap_schema=BI:example tables=BI.BI_DIRECT dumpfile=BI.dmp logfile=BI.log Got the following errors : ORA-39002: invalid operation ORA-39070: Unable to open the log file. ORA-29283: invalid file operation ORA-06512: at 'SYS.UTL_FILE', line 536 ORA-29283: invalid file operation The directory I created (DATA_PUMP_DIR) shows read-only in the general tab of the property. Answer: You want to test your database link first, and make sure that you have connectivity to the remote server. See these notes on creation and setup for the network_link parameter. Oracle shows this as a root cause of your impdp failure: ORA-29283: 'invalid file operation' Cause: An attempt was made to read from a file or directory that does not exist, or file or directory access was denied by the operating system. Action: Verify file and directory access privileges on the file system, and if reading, verify that the file exists.
| |||
|
![File File](/uploads/1/2/4/8/124896772/613214668.png)
Home E-mail Us Oracle Articles New Oracle Articles Oracle Training Oracle Tips Oracle Forum Class Catalog Remote DBA Oracle Tuning Emergency 911 RAC Support Apps Support Analysis Design Implementation Oracle Support SQL Tuning Security Oracle UNIX Oracle Linux Monitoring Remote support Remote plans Remote services Application Server Applications Oracle Forms Oracle Portal App Upgrades SQL Server Oracle Concepts Software Support Remote Support Development Implementation Consulting Staff Consulting Prices Help Wanted! Oracle Posters Oracle Books Oracle Scripts Ion Excel-DB |
Question: I am trying to run export (expdp) in a Windows environment, and I am getting these errors: ORA-39002: invalid operation dbms_datapump.get_status(178...) ORA-39002: invalid operation ORA-39070: unable to open the log file. ORA-29283: invalid file opertion ORA-06512: at 'SYS.UTL_FILE', line 536 ORA-29283: invalid file operation How do I fix these ORA-39002, ORA-39070. ORA-29283 and ORA-06512 errors? Answer: There are several MOSC notes that apply to this issue: 1 - Windows: MOSC Note 858401.1 - DataPump Export (EXPDP) To A Windows Mapped Network Drive Returns Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 2 - UNIX/Linux: MOSC Note 1305166.1: Errors ORA-39002 ORA-39070 ORA-29283 ORA-6512 When Using DataPump Export (EXPDP) or Import (IMPDP). a) Our schemas don't have read, write access to the directory specified or b) the oracle user does not have read, write access on the directory at the Operating System level. So that's an easy fix : sudo chown -R oracle:oinstall /export/oracle If we are on a Windows machine, then we need to make sure that both the listener and the database have been started with the exact same username.
|