plu/sql 添加运程数据库

来源:互联网 发布:淘宝哪家买家秀有福利 编辑:程序博客网 时间:2024/05/18 01:39

找到这个文件,G:\app\DLTB\product\11.2.0\dbhome_1\network\admin\tnsnames.ora

用记事本打开,添加:

如:

jxwx =  (DESCRIPTION =    (ADDRESS_LIST =      (ADDRESS = (PROTOCOL = TCP)(HOST = 134.100.64.147 )(PORT = 1521))    )    (CONNECT_DATA =      (SERVICE_NAME = ora97)    )  )

对比本地的ORCL:

ORCL =  (DESCRIPTION =    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))    (CONNECT_DATA =      (SERVER = DEDICATED)      (SERVICE_NAME = orcl)    )  )


0 0