手动配置文件地址: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) ) )