如果某个Oracle补丁已经过时Obsolete或处于受密码保护Password Protected状态你通常无法在“Patches Updates”界面直接点击下载或者点击后会弹窗要求输入密码。要获取这种过时的补丁新版 MOS 统一通过提交服务请求Service Request, SR来向 Oracle 官方申请密码或下载权限具体操作步骤如下第一步登录mos选择“My Oracle Support”界面第二步填写请求1. 在“Select a product or service”一栏中选择 “Oracle Database - Enterprise Edition”2.在详细信息里面填写需求模板如下Subject:Request Download Permission for Obsolete/Password-Protected Patch 补丁号Description:Hello Team,We urgently need to download the following historical patch which is currently not directly downloadable or password-protected on My Oracle Support:Patch Number:补丁号Patch Description:补丁全名Platform:[请在此处填写你的操作系统平台例如Linux x86-64 / IBM AIX on POWER Systems (64-bit)]Business Justification:We are currently performing an environment alignment and testing procedure. Our existing production environment has already applied this specific 补丁信息. To ensure strict environment consistency and eliminate any potential compatibility risks during our validation/migration testing, we must use the exact same patch version in our test environment rather than a newer release.Could you please grant the download permission or provide the password for this patch?Thank you for your support.比如我想要一个OJVM补丁OJVM PATCH SET UPDATE 11.2.0.4.181016平台Linux x86-64该补丁号为28440700Subject:Request Download Permission for Obsolete/Password-Protected Patch 28440700Description:Hello Team,We urgently need to download the following historical patch which is currently not directly downloadable or password-protected on My Oracle Support:Patch Number:28440700Patch Description:OJVM PATCH SET UPDATE 11.2.0.4.181016Platform:Linux x86-64Business Justification:We are currently performing an environment alignment and testing procedure. Our existing production environment has already applied this specific OJVM patch version (11.2.0.4.181016). To ensure strict environment consistency and eliminate any potential compatibility risks during our validation/migration testing, we must use the exact same patch version in our test environment rather than a newer release.Could you please grant the download permission or provide the password for this patch?Thank you for your support.填写完成后提交即可在弹出的提示框选择“Start AI Support Assistant”在弹出的AI会话中选择创建SR服务第三步填写SR服务申请资料创建SR后系统会自动识别请求信息和类别如下所示保持默认即可若有问题可手动修改例如总结可以改成Unable to download historical patch 28440700 for OJVM PATCH SET UPDATE 11.2.0.4.181016 on Linux.继续填写填写产品版本运行环境系统生命周期以及问题分类如下所示填写平台类型、版本红色字提示 19.29 或 19.30 版本有个 RAC 滚动升级的 Bug 会导致数据损坏我这里申请的是 11g 补丁直接无视蓝色框Oracle 官方提示“我们最近发了高优先级安全公告为了安全和稳定强烈建议你用最新的 Release Updates (RUs)别用老补丁了。” 不用理它直接往下走Select the Best Option (再次细化分类)当前状态选择“Request Password protected patches for Quarterly Patch Releases”以及“ Password Request for any Other DB Version”其他任意数据库版本的密码请求因为 11g 已经属于非常老的“Other DB Version”了系统这个自动归类非常精准保持这个选项不要动。填写补丁号以及业务理由可以用下面的语句We are currently performing an environment alignment and testing procedure. Our existing production environment has already applied this specific OJVM patch version (11.2.0.4.181016). To ensure strict environment consistency and eliminate any potential compatibility risks during our validation and migration testing, we must use the exact same patch version in our test environment rather than a newer release.这段话的意思是“我们目前正在进行环境对齐和测试。我们现有的生产环境已经应用了这个特定的 OJVM 补丁版本11.2.0.4.181016。为了确保严格的环境一致性并消除验证和迁移测试期间任何潜在的兼容性风险我们必须在测试环境中使用完全相同的补丁版本而不是更新的版本。”提交创建完毕第四步查看结果此时耐心等待短则几小时长则几天如果有回复状态栏会出现“Solution Offered”或者会直接发邮件到绑定的邮箱点开看已经发了一个7天的有效密码需要尽快下载补丁下载成功后续可以回复一个 Thank you for your help使本次SR服务顺利结束