我有一个数据库"test",我连接到地址123.45.67.89:1521.
如何使用PL/SQL Developer连接到它?
我有一个数据库"test",我连接到地址123.45.67.89:1521.
如何使用PL/SQL Developer连接到它?
我建议创建一个TNSNAMES.ORA文件.从Oracle客户端安装目录导航至network\admin.您可能已经有一个名为TNSNAMES.ORA的文件,如果有,请编辑它,否则使用您喜欢的文本编辑器创建它.
接下来,只需添加如下条目:
MYDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 123.45.67.89)(PORT = 1521))
(CONNECT_DATA = (SID = TEST)(SERVER = DEDICATED))
)
您可以将MYDB更改为任何您喜欢的,这是应用程序将使用TNSNAMES中的信息来查找数据库的标识符.
最后,在PL/SQL Developer中使用MYDB作为您的数据库登录.它应该会自动在TNSNAMES.ORA中查找连接字符串.
If that does not work, hit Help->About then click the icon with an "i" in it in the upper-lefthand corner. The fourth tab is the "TNS Names" tab, check it to confirm that it is loading the proper TNSNAMES.ORA file. If it is not, you may have multiple Oracle installations on your computer, and you will need to find the one that is in use.