Skip to Main Content

SQL Developer

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Seamless IAM DB Token authentication with SQL Developer 24 (JDBC 23.3) – ORA-18726 and missing SDK setup steps

Alessandro_Moccia32 hours ago

Need official documentation: Seamless IAM DB Token authentication with SQL Developer 24 (JDBC 23.3) – ORA-18726 and missing SDK setup steps

Hello Oracle team,
we are configuring SQL Developer 24 with JDBC 23.3 to connect automatically to an Autonomous Database using IAM DB Token authentication over TCPS (1522). The goal is a seamless login where SQL Developer authenticates to OCI Identity Domain, obtains the IAM DB token, and connects without running the OCI CLI manually.

Environment:

  • SQL Developer 24
  • JDBC 23.3
  • OCI CLI 3.39
  • Autonomous Database with private endpoint
  • OCI profile and wallet already tested (manual token works)

When SQL Developer tries to generate the token automatically, the connection fails with:
ORA-18726: Failed to get a value from an OracleResourceProvider

This shows that the embedded JDBC driver cannot call the OCI SDK classes to create the token.

We followed the A-Team article "Seamless authentication to the Oracle Database with SQL Developer 23AI, JDBC drivers, and an OCI Identity Domain", but it does not include clear installation steps for OCI SDK libraries (oci-java-sdk-auth, oci-java-sdk-database, oci-java-sdk-common) and does not specify how SQL Developer 24 should load them from Maven or its classpath.

Request:
Please provide official Oracle documentation describing:

  1. The exact required JDBC and OCI SDK JARs and versions
  2. Where to place them inside SQL Developer 24 so automatic IAM DB token generation works
  3. The supported product.conf, JVM options, and JDBC URL parameters for this configuration

This would clarify the correct setup and replace the incomplete blog instructions.

Comments
Post Details
Added 32 hours ago
0 comments
17 views