手动配置文件地址：D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora

tnsnames.ora文件内容：

# tnsnames.ora Network Configuration File: D:\app\Administrator\product\11.1.0\db_1\NETWORK\ADMIN\tnsnames.ora # Generated by Oracle configuration tools.

#用户1 server9 =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.10.9)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = pipdb)     )   )

#用户2 ORCL =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = WIN-SIE24JOVNUE)(PORT = 1521))     )     (CONNECT_DATA =       (SERVER = DEDICATED)       (SERVICE_NAME = orcl)     )   )