srkp.net
当前位置:首页 >> orAClE11g客户端连接远程orAClE数据库吗 >>

orAClE11g客户端连接远程orAClE数据库吗

1、找到$ORACLE_HOME/client_1/network/admin目录下的tnsnames.ora文件,并用文本模式打开。 2、添加以下内容: 本地实例名= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP地址)(PORT = 端口号)) (CONNECT_DATA = (SERVER = DEDI...

oracle 11g 客户端可以连接oracle 10g数据库。 无需设置任何东西,只要配置连接文件即可: 如 ora11 = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME...

1、安装oracle客户端; 2、在开始菜单选择Net Configure Assistant配置本地服务名; 3、按照提示一步一步往下配置就可以了;

1、找到$ORACLE_HOME/client_1/network/admin目录下的tnsnames.ora文件,并用文本模式打开。 2、添加以下内容: 本地实例名= (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 数据库IP地址)(PORT = 端口号)) (CONNECT_DATA = (SERVER = DEDI...

通过Net Configuration Assistant(网络配置助手)添加远程数据库服务名,程序通过服务名连接数据库,和连接本地数据库方法一样。

不用具体配置,只需在连接时,有一个地方要输入IP的,你输入Oracle安装的那台机器的IP就可以了

能!在自己的数据库下面建个dblink。建dblink的sql如下:create public database link dblink名 connect to "9i数据库名" identified by "密码" using '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=XXXX)(PORT = 1521)))(CONNECT_D...

1、$ORACLE_HOME/network/admin/tnsnames.ora文件是连接远程数据库的配置 文件 2、例如 YOURDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = yourdb)...

1、$ORACLE_HOME/network/admin/tnsnames.ora文件是连接远程数据库的配置文件 2、例如 YOURDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = yourdb) ...

1、$ORACLE_HOME/network/admin/tnsnames.ora文件是连接远程数据库的配置文件 2、例如 YOURDB = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.2)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = yourdb) ...

网站首页 | 网站地图
All rights reserved Powered by www.srkp.net
copyright ©right 2010-2021。
内容来自网络,如有侵犯请联系客服。zhit325@qq.com