文章目录

1. 1. oracle10g 添加监听数手动配置方式

oracle10g 添加监听数手动配置方式

\

\

找到oracle安装目录C:\Oracle\product\10.1.0\Client_1\NETWORK\ADMIN\tnsnames.ora文件，像如下便是你要添加的连接远程数据库监听

\

DEMODB2_192.168.1.214 =
   (DESCRIPTION =
       (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.214)(PORT =
1521))
       )
       (CONNECT_DATA =\

           (SID = demodb2)
           (SERVER = DEDICATED)
       )
   )

\