windows上主机名长度超过16个字符导致连接报:ORA-12518

郑全 · 发表于 2025-11-21 19:06:34

解决了 [INS-30014]无法检查指定位置是否位于CFS上问题后，安装好数据库，结果客户端怎么都不能连接这个服务器，本地，使用@连接串，也不行，报ORA-12518错误。
ORA-12518 错误，一般都是与资源有关，关键是我这里才安装好，资源都没有使用，怎么会报这个错误呢，把监听的所有配置都检查了一遍，把不需要的部分都去掉，
还是不行，重启了主机，也不行，关掉本地的防火墙，也不行，看到本地还有两个安全软件，想想是否与此有关，但现场环境要关闭这两个安全软件，需要输入密码，
因此，让人去找相关人处理这个，在这个窗口，上MOS上搜了一下，还真找到这个问题：

登录/注册后可看大图

54429692046938ef4c.png (169.23 KB, 下载次数: 150)

下载附件

2025-11-21 19:01 上传

核对一下，前面安装时，确实使用的默认选择，第一项，就是虚拟账号，主机名字，正好16个字符
既然都对上了，最简单的办法，就是把主机名去掉几个字符，少于16个字符，重启主机，再测试，一切OK。问题解决。

但平时为什么没有遇到这个问题呢，我一般选择的最后一个选项，另外，我安装，一般都是安装最新的版本，比如19.26,所以没有遇到这个问题，记录一下。避免下次再遇到这个坑。

附MOS文章：
Windows Virtual account Listener refused the connection with error ORA-12518 (Doc ID 3107616.1)

In this Document
Symptoms
Changes
Cause
Solution
References

Applies to:
Oracle Net Services - Version 19.3.0.0.0 and later
Information in this document applies to any platform.
Symptoms
Windows Virtual account database service is running. Listener refused the connection with the following error: ORA-12518, TNS:listener could not hand off client connection.

Changes

Cause
The Device / System name is more than 15 caharcters. "XXXXXdb-dev-2025". The Device or hostname or system name should be less then 15 characters length

We have created a new bug for this case to troubleshoot the case.

Bug 38542990 - WINDOWS VIRTUAL ACCOUNT LISTENER REFUSED THE CONNECTION WITH ERROR ORA-12518

The long hostname causing VIRTUAL Account groupname not be added to provide PROCESS_DUP_HANDLE

In the InitializeProcessSecurity() function within ssmain.c, Access Control Entries (ACEs) are added for groups (ORA_DBA, ORA_INSTALL, ORA_GRID_LISTENERS, and ORA_CLIENT_LISTENERS) to grant PROCESS_DUP_HANDLE access.
Just before this step, the computer name is obtained via GetComputerNameEx(). However, due to a coding limitation, only the first 16 characters of the computer name are captured.
If the computer name exceeds 16 characters, it is truncated, which causes subsequent LookupAccountName calls to fail. As a result, the ACEs for the specified groups and access rights are not added.

Solution
Here the issue was caused by the machine name exceeding 16 characters. After updating the machine name to less then 15 characters and restart server fixed the problem.
Development reviewed the code and confirmed this issue was addressed in the MAIN branch under “23C: Support for Long Hostnames on Windows,” but this fix cannot be backported easily as it would require multiple additional transactions.

References
NOTE:951187.1 - Windows: TNS-12518 TNS-534 "Failed to Grant Connection Ownership"
NOTE:2159157.1 - 12c Windows: ORA-12518 Errors Connecting to 11g Dedicated Service Via Listener
NOTE:550859.1 - Troubleshooting Guide for TNS-12518 TNS listener could not hand off client connection

帐号		自动登录	找回密码
密码			注册

[安装] windows上主机名长度超过16个字符导致连接报:ORA-12518

浏览过的版块