My Oracle Support Banner

Oracle Analytics Client Tool Cannot Connect ADW that Use mTLS Authentication (Doc ID 2921892.1)

Last updated on NOVEMBER 03, 2023

Applies to:

Oracle Analytics Cloud - Version November 2022 (6.9) and later
Information in this document applies to any platform.


 When Admin tool (Oracle Analytics Client Tool) tries to import metadata using new wallet file, it cannot connect Autonomous Database (ADW) with the following error.  

 ORA-29003: SSL transport detected mismatched server certificate.


Use new wallet described in the following Doc:
ALERT: Action Required for Autonomous Databases (Doc ID 2911553.1)

Reproducible Step:
1. Download a new wallet file from ADW.
2. Unzip the wallet file and  copy cwallet.sso, sqlnet.ora, and tnsnames.ora to  <Developer Client Tool installation folder>\domains\bi\config\fmwconfig\bienv\core folder on client machine.
3. Edit WALLET_LOCATION in sqlnet.ora as following.

4. Start Admin tool and create new database and new connection pool.

5. Import metadata.
   ==> ORA-29003 error occurs.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.