ORA - 39002: the operation is invalid
ORA - 39070: unable to open the log file,
ORA - 29283: invalid file operations
ORA - 06512: in the "SYS. UTL_FILE", line 536
ORA - 29283: invalid file operations
Pray god to explain
I am just learning beginner
CodePudding user response:
DIRECTORY to the DIRECTORY is wrong, you use this check:Select * from dba_directories;
CodePudding user response:
APPLIES TO:The Oracle Database Enterprise Edition - Version 11.2.0.2 and later
Information in this document applies to any platform.
SYMPTOMS
During DataPump export or import you receive the below error messages:
ORA - 39002: invalid operation
ORA - 39070: Unable to open the log file.
ORA - 29283: invalid file operation
ORA - 06512: an "SYS. UTL_FILE", line 536
ORA - 29283: invalid file operation
CAUSE
1. One of the reason this problem usually can occurs when the listener process from then started under the same account as the database instance service. The listener forks the new server process and the when this runs under a company's security context as the database, then access to directories and files are likely impacted.
Both Please verify the following information:
1) the output of:
Ps - ef | grep SMON
2) the output of:
Ps - ef | grep TNSLSNR
3) the output of:
Ps - ef | grep LIST
4) the output of:
Ls - ld & lt; Full directory name of the directory to which the export/import is written>
Note:
When using the ASM, the listener have had started from the ASM Home Home the RDBMS Home. Depending on your security Settings, this may difference to this issue.
2. This issue can occur in RAC. DataPump export/import runs fine without the connect string.
Expdp system/directory=XXXXXXX dumpfile=XXX XXXXXX. DMP logfile=XXXXXX. The log schemas=XXXX
Export: Release 11.1.0.7.0-64 - bit Production on Tuesday, March 08, 2011 11:15:2 3
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to the Oracle Database 11 g Enterprise Edition Release 11.1.0.7.0-64 - bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining,
And Real Application Testing options
Starting "SYSTEM". "SYS_EXPORT_SCHEMA_03" : the SYSTEM/* * * * * * * * directory=XXXXX dumpfile=XXXXX. DMP logfile=XXXXXX. The log schemas=XXXXXXX
Estimate the progress in using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
The Total estimation using BLOCKS method: 3.25 MB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TABLE/TABLE
Processing object type SCHEMA_EXPORT/TABLE/INDEX/INDEX
Processing object type SCHEMA_EXPORT/FUNCTION/FUNCTION
Processing object type SCHEMA_EXPORT/FUNCTION/ALTER_FUNCTION
Processing object type SCHEMA_EXPORT POST_SCHEMA/PROCACT_SCHEMA
.. exported "XXXXXX". "XXXXXXXXXXXX" 1.122 MB 1156 rows
.. exported "XXXXXX". "XXXXXXXXXXXX" 131.1 KB 3980 rows
.. exported "XXXXXX". "XXXXXXXXXXXX" 7.710 KB rows 1
.. exported "XXXXXX". "XXXXXXXXXXXX" 6.054 KB 5 rows
.. exported "XXXXXX". "XXXXXXXXXXXX" 5.5 KB 2 rows
.. exported "XXXXXX". "XXXXXXXXXXXX" 5.492 KB rows 1
The Master table "SYSTEM". "SYS_EXPORT_SCHEMA_03" successfully the loaded/unloaded
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
The Dump file set for the SYSTEM. SYS_EXPORT_SCHEMA_03 is:
/opt/XXXXXXXXXX/3.0/admin/dbbackup/dump/XXXXXXXXXXX. DMP
Is the Job "SYSTEM". "SYS_EXPORT_SCHEMA_03" successfully completed the at 11:15:41
But with the connect strings, it fails to have the below error message
Expdp system/XXXX @ db directory=XXXXXXXXXX dumpfile=XXXXXXXX. DMP logfile=XXXXXXX. Log schemas=XXXXXX
Export: Release 11.1.0.7.0-64 - bit Production on Tuesday, March 08, 2011 11:16:2 0
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to the Oracle Database 11 g Enterprise Edition Release 11.1.0.7.0-64 - bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining,
And Real Application Testing options
ORA - 39002: invalid operation
ORA - 39070: Unable to open the log file.
ORA - 29283: invalid file operation
ORA - 06512: an "SYS. UTL_FILE", line 536
ORA - 29283: invalid file operation
Note: Both commands ran on the same server.
The reason can be because The connect string (TNS Name) is a load balancing The connect string and whenever you try to use The connect string with expdp/impdp, it goes to The other node where The directory information is not available, or The directory took a be a local folder which is not a Shared one.
nullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnullnull