去
E:\app\Administrator\virtual\product\12.2.0\dbhome_1\network\admin
tnsnames.ora中的
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
改为
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 你的计算机名)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
)
listener.ora中的
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
(ADDRESS =(PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
改为
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS =(PROTOCOL = TCP)(HOST =你的计算机名)(PORT = 1521))
(ADDRESS =(PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
然后重启oracle服务。计算机名可以右键 - 我的电脑找到
最后一步
记得把红圈里面的也改成计算机名