10.2.0.4에서 발생
7354358 패치수행 -> 7603479 패치수행 -> 정상완료
Refresh From Metalink Job fails with ORA-12899 : value too large for column
"SYSMAN"."MGMT_ARU_PRODUCTS"."PRODUCT_NAME"
Checking Oracle MetaLink authorization.
MetaLink Username: **********
MetaLink Password: **********
Patch Search URL: http://updates.oracle.com
Updating OEM repository with latest release table data from Oracle MetaLink.
- Exception trying to access the repository. java.sql.SQLException: ORA-12899: value too large for column "SYSMAN"."MGMT_ARU_PRODUCTS"."PRODUCT_NAME" (actual: 55, maximum: 50)
패치 7354358
TRACKING BUG FOR EMDB PATCH UPLOADS FOR BUG 6512039
#-------------------------------------------------------------------------
# One-off patch for Base Bug : 7270327
#-------------------------------------------------------------------------
#
# DATE: Tue Aug 26 00:45:27 PDT 2008
# --------------------
# Platform Patch for : Generic
# Product Version # : 10.2.0.4
# Product Patched : Enterprise Manager For DB Control.
#
# Bugs Fixed by this patch:
# -------------------------
# 7270327 - NEED TO TRUNCATE ARU SEED DATA TO AVOID EXCEPTIONS WHILE INSERTING IN REPOS
# 7354358 - TRACKING BUG FOR EMDB PATCH UPLOADS
# Patch Installation Instructions:
# --------------------------------
#
# 1) Shutdown EM DB Console using the following command. Leave the database and its listener running.
# % $ORACLE_HOME/bin/emctl stop dbconsole
#
# In case of DB Console configured for a Cluster Database steps 2 and 3 should be run on all Oracle Homes
#
# 2) To apply the patch, unzip the PSE container file:
# % unzip p7270327_10204_GENERIC.zip
#
# 3) Set your current directory to the directory where the patch
# is located:
# % cd 7270327
#
# Ensure that the directory containing the opatch script appears in
# your $PATH; then enter the following command:
#
# % opatch apply
#
# 4) Start EM DB Console using the following command.
# % $ORACLE_HOME/bin/emctl start dbconsole
[7354358 패치후 다른 에러발생]
PROBLEM : Refresh from metalink job fails with "PLS-00201: identifier 'CPF_POLICY.RUN_CPF_POLICY_EVALUATION' must be declared"
Symptoms
After applying the patch 7354358 to the database 10.2.0.4.0 refresh from metalink job fails from Database control with following error message:
MetaLink Username: username
MetaLink Password: **********
Patch Search URL: http://updates.oracle.com
Updating OEM repository with latest release table data from Oracle MetaLink.
- Exception trying to access the repository. java.sql.SQLException: ORA-06550: line 1, column 11:
PLS-00201: identifier 'CPF_POLICY.RUN_CPF_POLICY_EVALUATION' must be declared
ORA-06550: line 1, column 11:
PL/SQL: Statement ignored
Solution
To resolve the issue download and apply the Patch 7603479 to the database oracle home. Please read the readme before applying the patch