Oracle SQL Developer-java.library.path中没有ocijdbc12 [英] Oracle SQL Developer - no ocijdbc12 in java.library.path

问题描述

我有一个虚拟机，最新版本的Oracle SQL Developer(包括JDK 8套件-尽管我还是单独安装了它)，并且有一个11G Oracle数据库.

I've a virtual machine, the latest version of Oracle SQL Developer (kit with JDK 8 included - although I installed it separately anyway), and there's a 11G Oracle Database.

我的机器上的TNS文件没有所有数据库的列表，而是按以下内容列出(有多个数据库):

My TNS file on my machine does not have the list of all databases, instead it it is as per below (there are multiple databases):

> CONN_DATA =   (DESCRIPTION =
>     (ADDRESS_LIST =
>       (ADDRESS = (PROTOCOL = TCP)(HOST = HOSTNAME)(PORT = XXXX))
>     )
>     (CONNECT_DATA =
>       (SERVICE_NAME = Bob)
>     )   )

我尝试使用多种方法连接到数据库之一.

I tried connecting to one of the databases using multiple methods.

• 如果我使用dbname作为连接标识符选择TNS conn类型，则在 no ocijdbc12中 java.library.path.我进入了高级设置，并手动指向了我的TNS文件，以防万一.
• 如果我选择基本"连接类型，则ORCL为 服务名称(也尝试将数据库用作SID)，本地主机作为主机名或我的数据库名称， 无法解析连接.
• 还尝试通过"CONN_DATA"使用TNS conn类型和网络标识符

• If I choose the TNS conn type using the dbname as the connect identifier, I get no ocijdbc12 in java.library.path. I went to the advanced settings, and manually pointed to my TNS file just in case.
• If I choose the Basic connection type, ORCL as service name (also tried the database as SID), localhost as hostname or the name of my database, it fails to resolve the connection.
• Also tried to use TNS conn type and Network identifier using "CONN_DATA"

我不知道该怎么办，类似的问题似乎可以解决我机器上的环境变量问题，但是我不确定如何确认.

I don't have a clue on what to do, similar issues seems to resolve on an environmental variable issue on my machine, but I'm unsure on how to confirm that.

推荐答案

即使这个问题比较老，我也遇到了同样的问题.

Even though this question is rather old, I had the same issue.

原因完全不同.

我没有正确设置网络别名.

I did not have the network aliases set correctly.

转到首选项-数据库-高级"，然后将路径设置为TNSNames目录.

Go to Preferences - Database - Advanced and set the path to TNSNames Directory.

这篇关于Oracle SQL Developer-java.library.path中没有ocijdbc12的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！