While Importing ODI Metadata During Upgrade Getting ORA-01720: grant option does not exist for 'SYS.DUAL'
(Doc ID 2273764.1)
Last updated on AUGUST 03, 2020
Applies to:Oracle Utilities Advanced Spatial and Operational Analytics - Version 220.127.116.11.4 and later
Information in this document applies to any platform.
OUA - Oracle Utilities Analytics
ETL - Extract, Transform, Load
ODI - Oracle Data Integrator
On : 18.104.22.168.4 version, Install / Upgrade
OUA patch 22.214.171.124.4 applied on OUAV126.96.36.199.3 , fails on ETL component -while importing ODI metadata
1.Navigate to <Install_Dir>/ETL/ODI/Metadata and delete the existing zip files and folders from that location. -completed
2. Purge all the odi operator logs.- purged all logs
3 .Go to the temporary folder where you have downloaded the installer and run the following command from this folder
java -jar /OUA-V188.8.131.52.4-Multiplatform/OUA_184.108.40.206.4_generic.jar -logLevel finest
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