ODI-26039 and "TNS-04605: Invalid syntax error: Unexpected char or LITERAL..." Errors Recieved when Testing Dataserver Connection for Autonomous Database Using a Wallet
(Doc ID 2741036.1)
Last updated on JUNE 16, 2023
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 and later
Oracle Data Integrator on Marketplace - Version 220.127.116.11.200123 and later
Information in this document applies to any platform.
In Oracle Data Integrator (ODI) Studio, when testing an Autonomous Database (ADB) data server connection which uses a wallet file, an error like the following occurs:
The tnsnames.ora file was regenerated but the error is the same.
The issue occurred after performing the following steps:
- Set up a new installation of ODI to use ADW as a target
- Download the wallet file to the ODI studio machine
- Configure studio to use the wallet file
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!