Hyperion Financial Management (HFM) (MOSC)

MOSC Banner

Oracle HFM 创建应用报数据库错误ORA-28040: 没有匹配的验证协议

edited Apr 2, 2019 9:06AM in Hyperion Financial Management (HFM) (MOSC) 1 commentAnswered

以Oracle Database 12c Enterprise Edition 12.2.0.1.0 RAC 集群作为Oracle HFM  数据库。创建应用程序时报ORA-28040: 没有匹配的验证协议 错误

根据关于ORA-28040报错的官方文档 https://docs.oracle.com/database/121/NETRF/sqlnet.htm#NETRF2010)提供的解决方法,需要修改$ ORACLE_HOME / network / admin / sqlnet.ora 文件,将SQLNET.ALLOWED_LOGON_VERSION = 8注释掉(如果没有sqlnet.ora 文件,那么就创建一个),修改为如下的行:

SQLNET.ALLOWED_LOGON_VERSION_SERVER = 8

SQLNET.ALLOWED_LOGON_VERSION_ CLIENT = 8

修改后重启RAC,但是依然报以上错误。然后尝试将集群变成单机数据库,HFM创建应用程序成功。

但未找到使用RAC时报错的原因。鉴于生产环境需要使用RAC集群数据库,则需要得到好的解决方法。

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center