Applying a portal patch with OPATCH returns ERROR: Invalid SYS Connect Info
Applies to:
Portal - Version: 9.0.4.1 to 9.0.4.2
This problem can occur on any platform.
Symptoms
* While applying a portal patch using opatch you get the following error:
ERROR: Invalid SYS Connect Info ,cannot proceed with the installation
* The SYS password is not the default: change_on_install
* Providing the sys connect information while applying the patch still gives the same error.i.e.:opatch apply -silent
-pre -s
-p
-ss sys -sp -c :
:
Cause
BUG:4138095 - Applying Patch 4119778 Version 4 For 9.0.4.1 Results In Error
Solution
1. Connet to sqlplus as sys user and reset the SYS password to the default SYS password: change_on_install
This change will be only used for the patch install. You can later change the password back to the original pasword.
2. Apply the patch using opatch but this time do not specify the -ss and -sp parameters.
i.e.:opatch apply -silent
-pre -s
-p
-c :
:
3. Reset the SYS password back to the original password.
申请补丁时报错:无效的系统文件连接信息
应用:
Portal - Version: 9.0.4.1 to 9.0.4.2
该问题可能发生在任何平台
症状
在使用opatch申请补丁时会报如下错误:
无效的系统文件连接信息,不能继续进行安装
系统文件的密码不是默认的,在安装的过程修改了
在申请补丁时提供系统文件连接信息,仍然会报同样的错:
opatch apply -silent
-pre -s
-p
-ss sys -sp -c :
:
原因
BUG:4138095 --申请补丁419778的版本是4,导致出错
解决方案
1.连接数据库,将系统文件的密码重新设置为默认的系统文件密码
修改只适用于补丁安装,可以在稍后将密码改为初始密码
2.使用opatch申请补丁,不要指定-ss和-sp参数
opatch apply -silent
-pre -s
-p
-c :
:
3.重新设置系统文件的密码为初始密码