DATAPATCH ERROR "ORA-20001/KUP-04017: OS message: Access denied" IF WINDOWS SERVICE IS STARTED AS ORACLE HOME USER
(Doc ID 2410178.1)
Last updated on FEBRUARY 12, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 12.1.0.1 and laterOracle Database Cloud Schema Service - Version N/A and later
Oracle Database Exadata Express Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Microsoft Windows x64 (64-bit)
Symptoms
SQL> select * from OPATCH_XML_INV;
ERROR:
ORA-29913: Error executing call ODCIEXTTABLEFETCH
ORA-29400: Data Cartridge Error
KUP-04004: Error reading file
D: \ app \ oracle \ product \ 12.1.0 \ dbhome_2 \ QOpatch \ qopiprep.bat
No lines have been chosen
Attempt to use a preprocessor script in an external table throws errors saying that the location file is unavailable (access denied).
If the output from the preprocessor script is placed in the location file, then the file is readable.
From qopatch log
------------------------
Field definitions for table OPATCH_XML_INV
Record format DELIMITED BY NEWLINE
Data in the file has the same endian appearance as the platform
Reject rows with null-only fields
Fields in data source:
XML_INVENTORY CHAR (100000000)
Finished with "UIJSVTBOEIZBEFFQBL"
Blanks as in SQL Loader truncate
KUP-04004: Error reading file D: \ app \ oracle \ product \ 12.1.0 \ dbhome_2 \ QOpatch \ qopiprep.bat
KUP-04017: OS message: The process was completed successfully.
KUP-04017: OS message: Access denied
KUP-04118: Operation "read_pipe", directory "skudmir"
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |