ORA-32004:obsolete or deprecaated parameter(s) specified for RDBMS instance Oracle 12c Release 1

最新推荐文章于 2017-03-03 16:31:31 发布

yaluo009

最新推荐文章于 2017-03-03 16:31:31 发布

阅读量733

点赞数

CC 4.0 BY-SA版权

分类专栏： database

本文链接：https://blog.youkuaiyun.com/yaluo009/article/details/51848515

database 专栏收录该内容

14 篇文章

订阅专栏

本文介绍在Oracle12c中如何配置数据库密码的大小写敏感性。虽然此参数已废弃，但在某些特定环境下仍需明确设置。为确保Oracle E-Business Suite的兼容性，需遵循特定步骤来启用或禁用密码大小写的敏感性。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

ORA-32004:obsolete or deprecaated parameter(s) specified for RDBMS instance,when Oracle 12c Release 1 startup.

######### # # Database Password Case Sensitivity ## The default value of this parameter is TRUE, i.e. passwords are case-sensitive at the database level.# Although the parameter is deprecated in Database 12c, it still needs to be explicitly set for Oracle E-Business Suite. # To enable case-sensitivity of database passwords in Oracle E-Business Suite# (supported with Oracle E-Business Suite Release 12.1.1 or higher), set the parameter to TRUE # and follow the steps in Doc ID 1581584.1. Also, if on a release prior to Release 12.2, # apply patch 12964564. To disable case-sensitivity, set the parameter to FALSE. # ##########

sec_case_sensitive_logon = FALSE

SOLUTION:

apply the newest psu patch, then remove the sec_case_sensitive_logon parameter from the database spfile or pfile.