Native library cannot be loaded (OCI)
What steps will reproduce the problem?
1. add Oracle data source
2. download drivers by clicking the link in the dialog
3. fill TNSADMIN directory
4. select one of the offered (by auto-completion) TNS names (not all from tnsnames.ora are actually offered here)
5. Select Driver: OCI
6. Enter a known valid User and Password
7. click Test Connection
What is the expected result? Successful connection
What happens instead?
Native library cannot be loaded. C:\oracle\product\21.0.0\client_1\bin\ocijdbc21.dll: Impossibile trovare la procedura specificata.
..in english “the specified procedure could not be found”
It looks like that jetbrains Oracle data source for datagrip has a bug that doesn't allow to load correctly the oci oracle driver on windows 10 (64bit). …It's quite ugly.
There's a post for this same issue of 9 yeats ago!!! https://youtrack.jetbrains.com/issue/DBE-2407
Is there a way to ask for a correction in a next release?
Here follows the logs content about it.
2025-02-27 09:58:20,172 [5642108] INFO - #c.i.e.r.RemoteProcessSupport - "C:\Program Files\JetBrains\DataGrip 2024.1.3\jbr\bin\java" -Doracle.net.tns_admin=C:\oracle\product\12.1.0\dbhome_1\NETWORK\ADMIN -Djava.rmi.server.hostname=127.0.0.1 -Duser.timezone=UTC -Djava.library.path=C:\oracle\product\21.0.0\client_1\bin -Xmx750m -Xms256m "-Djdbc.classpath=C:\Program Files\JetBrains\DataGrip 2024.1.3\plugins\DatabaseTools\lib\jdbc-console.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\jdbc\ojdbc8\21.1.0.0\ojdbc8-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\xml\xdb\21.1.0.0\xdb-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\xml\xmlparserv2\21.1.0.0\xmlparserv2-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\nls\orai18n\21.1.0.0\orai18n-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\jdbc\ucp\21.1.0.0\ucp-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\jdbc\rsi\21.1.0.0\rsi-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\security\osdt_core\21.1.0.0\osdt_core-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\security\osdt_cert\21.1.0.0\osdt_cert-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\security\oraclepki\21.1.0.0\oraclepki-21.1.0.0.jar;C:\oracle\product\21.0.0\client_1\jdbc\lib\ojdbc11.jar" --add-exports java.desktop/sun.awt=ALL-UNNAMED --add-exports java.desktop/java.awt.peer=ALL-UNNAMED --add-opens java.desktop/java.awt=ALL-UNNAMED --add-opens=jdk.unsupported/sun.misc=ALL-UNNAMED --add-opens=java.base/java.nio=ALL-UNNAMED --add-opens=java.base/java.util=ALL-UNNAMED -Dfile.encoding=UTF-8 -classpath "C:\Program Files\JetBrains\DataGrip 2024.1.3\lib\util_rt.jar;C:\Program Files\JetBrains\DataGrip 2024.1.3\lib\util-8.jar;C:\Program Files\JetBrains\DataGrip 2024.1.3\lib\groovy.jar;C:\Program Files\JetBrains\DataGrip 2024.1.3\plugins\DatabaseTools\lib\jdbc-console.jar;C:\Program Files\JetBrains\DataGrip 2024.1.3\plugins\grid-core-impl\lib\jdbc-console-types.jar;C:\Program Files\JetBrains\DataGrip 2024.1.3\lib\util.jar" com.intellij.database.remote.RemoteJdbcServer oracle.jdbc.OracleDriver2025-02-27 09:58:20,429 [5642365] INFO - #c.i.e.r.RemoteProcessSupport - Using classpath: C:\Program Files\JetBrains\DataGrip 2024.1.3\plugins\DatabaseTools\lib\jdbc-console.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\jdbc\ojdbc8\21.1.0.0\ojdbc8-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\xml\xdb\21.1.0.0\xdb-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\xml\xmlparserv2\21.1.0.0\xmlparserv2-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\nls\orai18n\21.1.0.0\orai18n-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\jdbc\ucp\21.1.0.0\ucp-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\jdbc\rsi\21.1.0.0\rsi-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\security\osdt_core\21.1.0.0\osdt_core-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\security\osdt_cert\21.1.0.0\osdt_cert-21.1.0.0.jar;C:\Users\A.Rossi\AppData\Roaming\JetBrains\DataGrip2024.1\jdbc-drivers\Oracle\21.1.0.0\com\oracle\database\security\oraclepki\21.1.0.0\oraclepki-21.1.0.0.jar;C:\oracle\product\21.0.0\client_1\jdbc\lib\ojdbc11.jar2025-02-27 09:58:20,429 [5642365] INFO - #c.i.e.r.RemoteProcessSupport - and base loader jdk.internal.loader.ClassLoaders$PlatformClassLoader@63d4e2ba2025-02-27 09:58:20,723 [5642659] INFO - #c.i.e.r.RemoteProcessSupport - Desktop actions are jbr-api2025-02-27 09:58:20,967 [5642903] INFO - #c.i.e.r.RemoteProcessSupport - Port/ServicesPort/ID: 51845/57231/RemoteDriverImpl486caae42025-02-27 09:58:21,003 [5642939] INFO - #c.i.d.d.DatabaseConnectionEstablisher - Connecting to: jdbc:oracle:oci:@PROD_NEW2025-02-27 09:58:21,004 [5642940] INFO - #c.i.e.r.RemoteProcessSupport - 2025-02-27 09:58:21,004 [5642940] INFO - #c.i.d.d.DatabaseConnectionEstablisher - Auth provider: user-pass2025-02-27 09:58:21,004 [5642940] INFO - #c.i.d.d.DatabaseCredentialsAuthProvider - Connecting as: AGR1_ROSSI_AL2025-02-27 09:58:21,228 [5643164] WARN - #c.i.d.d.DatabaseConnectionEstablisher - Connecting to: jdbc:oracle:oci:@PROD_NEW2025-02-27 09:58:21,229 [5643165] WARN - #c.i.d.d.DatabaseConnectionEstablisher - C:\oracle\product\21.0.0\client_1\bin\ocijdbc21.dll: Impossibile trovare la procedura specificata2025-02-27 09:58:21,229 [5643165] INFO - #c.i.e.r.RemoteProcessSupport - Terminating: 127.0.0.1:51845/RemoteDriverImpl486caae42025-02-27 09:58:21,286 [5643222] INFO - #c.i.e.r.RemoteProcessSupport - Process finished with exit code -12025-02-27 09:59:31,209 [5713145] WARN - #c.i.u.i.p.ProjectIndexableFilesFilterHealthCheck - Following files are indexable but they were NOT found in filter. Errors count: 1. Examples:file id=15855 path=C:/Users/A.Rossi/DataGripProjects/nuovo/.idea/dataSources/897647ec-5a45-425c-b9ba-078e8a08b04e.xml
请先登录再写评论。
Please create a new bug report directly on YouTrack, as the one mentioned is quite old - https://youtrack.jetbrains.com/newIssue?project=DBE
I had a similar issue with where the downloaded JDBC driver did not match the version from my local client. The solution that worked for me was to remove the downloaded drivers and replace it with ojdbc8.jar from my local client install. After that I was able to connect using OCI and Kerberos.