Error: "ORA-28545: Error Diagnosed by Net8 When Connecting to an Agent" When Running the runETL Process Configured to Connect to a SQL Database Using the Oracle Gateway
(Doc ID 1316107.1)
Last updated on MAY 12, 2021
Applies to:
Primavera Data Warehouse - Version R2.1 and laterInformation in this document applies to any platform.
Symptoms
Using Reporting Database R2.1 configured to connect to a P6 EPPM database hosted on SQL Server through the Oracle Gateway, when attempting to process the runETL command for data extraction into the newly created reporting database, the following error occurs.
ERROR
-----------------------
extract [INFO] (Message) - ORA-28545: error diagnosed by Net8 when connecting to an agent
extract [INFO] (Message) - Unable to retrieve text of NETWORK/NCR message 65535
extract [INFO] (Message) - ORA-02063: preceding 2 lines from <SID>
extract [INFO] (Progress) - Step 3/9 Part 1/4 - FAILED (28545) (0 hours, 0 minutes, 5 seconds, 609 milliseconds)
Changes
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 |
Changes |
Cause |
Solution |
References |