oracle因为改变电脑名监听无效的解决办法
1、找到oracle的安装目录:如 D:\Oracle\product\10.2.0\db_2\network\ADMIN
2、找到network文件夹下的ADMIN文件夹
3、打开listener.ora文件
4.修改listener.ora文件
LISTENER = www.2cto.com
(DESCRIPoracle账号TION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = mycomputer(自己的电脑名))(PORT = 1521))
)
)