PLSQL Developer连接远程数据库 想用PLSQL Developer连接远程服务器,也安装了ORACLE客户端,只是不会用,不知道如何连接。找网上的答案,只能说本人太菜,看不懂解答,期望能有详细的方法进行解答,先谢谢啦!本人安装了sqlplus.exe。尝试着去按网上的去操作,但是nsnames.ora在哪我都找不到,期望能有好心人给个详细的解决方法,无限感谢! 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 sqlplus.exe不是客户端吗?那它是什么? 1. 找到oracle安装数据库路径,到这个目录下。D:\oracle\product\10.2.0\db_1\network\ADMIN2. 使用记事本打开tnsnames修改下面的东西就可以了。。ORCLB是我配置的远程的。# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora# Generated by Oracle configuration tools.ORCL = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) )EXTPROC_CONNECTION_DATA = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) ) )ORCLB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.119)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = ORCL) ) ) 分组计算数量并取每组的最小时间。 在PL/SQL Developer中为啥看不到自己建的表呢? 字符字段做为查询条件,如果字段值为‘’,则查询条件不起作用 学校管理系统数据库设计问题 recover database until time怎么恢复不了数据 ORCL排序求助,请大家帮忙 请教一个SQL问题,急! oracle中删除一个表的列的sql语句是什么 初学oracle,创建数据库时出现ora-00988:缺少或无效口令错误!请指点,立刻给分!!! 一个从PL/SQL复制出来带符号的问题 请求帮忙,流复制配置问题,无法导原始数据 ORACLE一个存储过程调用另一个存储过程
2. 使用记事本打开tnsnames修改下面的东西就可以了。。ORCLB是我配置的远程的。# tnsnames.ora Network Configuration File: D:\oracle\product\10.2.0\db_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.ORCL =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl)
)
)EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)ORCLB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.119)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)