OFM相关故障的说明_Tomcat, WebLogic及J2EE讨论区_Weblogic技术|Tuxedo技术|中间件技术|Oracle论坛|JAVA论坛|Linux/Unix技术|hadoop论坛

总帖数

每页帖数

1/1页

返回列表

发起投票

查看: 3779 | 回复: 0

主题： OFM相关故障的说明

yanghui

注册用户

等级：上尉
经验：584
发帖：92
精华：0
注册：2011-12-13
状态：离线
发送短消息息给yanghui

加好友发送短消息息给yanghui

发消息

发表于：

2011-12-13 9:05:41 | [全部帖] [楼主帖]

楼主

Trying To Install Patch: Skipping_component=Oracle.Webdb,10.1.2.0.1
Applies to:
Portal - Version: 10.1.4
This problem can occur on any platform.
Symptoms
-- Problem Statement:
Trying to install Patch 5549991 PSE FOR BASE Bug 5257936 ON TOP OF 10.1.4.0.0 FOR LINUX 32BIT (46) (patch.log) fails with:
SKIPPING_COMPONENT=oracle.webdb,10.1.2.0.1
None of the patch actions is applicable to the Oracle Home.
OPatch will not apply the patch, exiting...
Cause
A custom function get_icportal_pagepath was invalid.
To check for invalid objects:
SQL> column object_name format A18 heading "Object name"
column object_type format A12 heading "Type"
column referenced_owner format A12 heading "Owner"
SQL> SELECT object_name, object_type, owner, status
FROM dba_objects
WHERE status='INVALID';
As the custom function/synonym is not in use, a backup was taken of it and then it was dropped.
The Patch 5549991 then installed successfully.
Solution
-- To implement the solution, please execute the following steps::
1. Check for any invalid objects;
2. Recompile those that are needed/seeded:
a) Use one of the following commands depending on the object type:
(i) Package SQL> alter package .
compile;
(ii) Package body SQL> alter package .
compile body;
(iii) View SQL> alter view . compile;
(iv) Trigger SQL> alter trigger compile;
b) If the object compiles with warnings, use either of the following scripts to view the errors.
SQL> show errors
or
SQL> select * from user_errors where name = '
' 3. For any (non-seeded) invalid objects which are not in use, take a backup (if they may be needed in the future) and then drop them; 4. Attempt to install the patch again. References Show Related Information Related Products * Middleware > Enterprise 2.0 and Portals > Portal > Portal

尝试安装补丁：

Skipping_component=Oracle.Webdb,10.1.2.0.1

应用：

Portal - Version: 10.1.4

该问题可能发生在任何平台

症状

问题状态

Trying to install Patch 5549991 PSE FOR BASE Bug 5257936 ON TOP OF 10.1.4.0.0 FOR LINUX 32BIT (46) (patch.log) fails with:
SKIPPING_COMPONENT=oracle.webdb,10.1.2.0.1

没有一个补丁能适用于Oracle Home.

原因

自定义函数get_icportal_pagepath无效

检查无效的对象：

SQL> column object_name format A18 heading "Object name"
column object_type format A12 heading "Type"
column referenced_owner format A12 heading "Owner"
SQL> SELECT object_name, object_type, owner, status
FROM dba_objects
WHERE status='INVALID';

因为自定义函数不能用，就会调用备份的函数

解决方案：

执行以下步骤来解决：

1.检查所有的无效对象

2.重新编译

a）根据对象类型使用以下命令：

(i) Package SQL> alter package .
compile;
(ii) Package body SQL> alter package .
compile body;
(iii) View SQL> alter view . compile;
(iv) Trigger SQL> alter trigger compile;

b）如果编译时有警告，使用以下脚本来查看错误：

SQL> show errors

或者

SQL> select * from user_errors where name = '

3.对于任何一个没有使用的无效对象，使用备份

4.再次尝试安装补丁参考相关产品的信息 Middleware > Enterprise 2.0 and Portals > Portal > Portal