oracle报错ORA-00600: 内部错误代码, 参数: [ksacl_ValidateAccess: !snlinGetNameInfo] 解决方法
文件位置
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服务。计算机名可以右键 - 我的电脑找到
然后重新建立连接,修改主机名为上面找到的计算机名。