2、配置$ORACLE_HOME/network/admin/tnsnames.ora
例如:
DB02 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.1.2)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = remotedb)
)
)
3、像remoteDB一样配置oracle环境变量
4、用sqlplus或者软件访问
例如:
sqlplus user/passwd@orcl
很简单,你在A电脑安装一个ORACLE 客户端,然后,在你所安装的ORACLE主目录文件找到tnsnames.ora文件打开,然后,(testdb是你要连接的B服务器实例名)加入一条记录如:TESTDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.0.xx)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = testdb)
)
)
或者,你在A机器上Oracle Net Manager 手动添加一条记录,按步骤来。Linux详细知识需求可参考下《Linux就该这么学》。
欢迎分享,转载请注明来源:内存溢出
评论列表(0条)