Error when upgrade Oracle client 9.2.0.5.0 to 9.2.0.5.3
756850Feb 28 2010 — edited Mar 1 2010Hi all,
I'm new with Oracle community so I hope you guys can help me and give me some suggestion with my case.
I got an error when upgrade Oracle client 9.2.0.5.0 to 9.2.0.5.3
I tried many times but can’t do upgrade successfully
This the error message I got when doing the job:
[ http://picasaweb.google.com/hoagao84/Oracle#5443442931867670386]
Appreciate your help.
Log files:
Command arguments are: apply
OPatch version is: 1.0.0.0.48
Using ORACLE_HOME/oui to look up oui libs...
Oracle Home = d:\oracle\ora92
Location of Oracle Inventory = D:\oracle\ora92\inventory
Oracle Universal Installer shared library = D:\oracle\ora92\oui\lib\win32\oraInstaller.dll
Path to Java = "D:\oracle\ora92\jdk\jre\bin\java.exe"
Location of Oracle Inventory Pointer = N/A
Location of Oracle Universal Installer components = D:\oracle\ora92\oui
Required Jar File under Oracle Universal Installer = jlib\OraInstaller.jar
Checking if this is a RAC system...
Accessing inventory... This may take up to 300 seconds.
(retry 10 times, delay 30 seconds each time)
System Command: ""D:\oracle\ora92\jdk\jre\bin\java.exe" -Dopatch.retry=10 -Dopatch.delay=30 -classpath "D:\oracle\ora92\oui\jlib\OraInstaller.jar;D:\oracle\ora92\oui\jlib\srvm.jar;D:\oracle\ora92\opatch\jlib\opatch.jar;D:\oracle\ora92\oui\jlib\xmlparserv2.jar;D:\oracle\ora92\oui\jlib\share.jar;.:D:\oracle\ora92\jlib\srvm.jar" opatch/O2O "d:\oracle\ora92" "D:\oracle\ora92\oui" opatch.pl 1.0.0.0.48"
Result:
output to OPatch:
IS_CLUSTER=0
CHECK_CLUSTER=1
NODE_LIST=NULL
NODE_COUNT=0
LOCAL_NODE=NULL
IS_CFS=0
RAC_CODE=0
HOME_INDEX=1
This is not a RAC system
Interim Patch ID: 3738339
Checking the patch inventory.
Component Name: oracle.rdbms
Component Version: 9.2.0.5.0
Component Name: oracle.rsf.rdbms_rsf
Component Version: 9.2.0.5.0
Component Name: oracle.rsf.oracore_rsf
Component Version: 9.2.0.5.0
Component Name: oracle.rsf.xdk_rsf
Component Version: 9.2.0.5.0
Component Name: oracle.rsf.dbjava_rsf
Component Version: 9.2.0.5.0
Component Name: oracle.java.javavm.javatools
Component Version: 9.2.0.5.0
Component Name: oracle.cartridges.context
Component Version: 9.2.0.5.0
Component Name: oracle.cartridges.locator
Component Version: 9.2.0.5.0
Component Name: oracle.rsf.net_rsf
Component Version: 9.2.0.5.0
Component Name: oracle.rsf.ldap_rsf
Component Version: 9.2.0.5.0
Component Name: oracle.emprod.oemagent.base_oemagent
Component Version: 9.2.0.5.0
Component Name: oracle.isearch.is_common
Component Version: 9.2.0.5.0
Component Name: oracle.options.olap.cwmlite
Component Version: 9.2.0.5.0
Component Name: oracle.rsf.nlsrtl_rsf
Component Version: 9.2.0.5.0
Bugs fixed by this patch 3738339:
3741539 : LOGICAL STANDBY FAILS ORA-1422 MERGING PARTITIONS WITH LOB COLUMN
2800494 : KCBZIB XHINT FORCES SINGLE BLOCK READS INADVERTENTLY FOR SINGLE INSTANCE
3239873 : EXTREMELY HIGH PARSING TIMES WITH AND BETWEEN IN ORACLE 9.2.0
2918138 : ORA-600 (KOHDTF048) WHEN USING PIPELINED PL/SQL TABLE FUNCTIONS
3575743 : 2004-S144E
3554319 : APPSST; ORA-00600 [KQLUDP2] RUN DURING APPS UPGRADE
3666502 : ORA-00600 [1236] RANDOMLY OCCURING
3752406 : MERGE LABEL REQUEST ON TOP OF 9.2.0.5 FOR BUGS LISTED BELOW
3528282 : 2004S075E
3412818 : REPEATED MESSAGES IN LGWR TRACE
2690205 : 2003-S190E
3543125 : 2004-S089E
3571233 : 2004-S141E
3458446 : 2004S059E
2810394 : LNXN2PD RETURNS SCALE OF 42 WHEN COVERTING ORACLE NUMBER 0. TO PACKED
3323435 : 2003-S126E
3356103 : ORA-600 [OPIBND0; OACCSID] IN PARALLEL QUERY SERVER P001 EXECUTING OLAP QUERY
3668224 : CBO CALCULATE LOWER CMPTD CDN AND LEADS TO BAD EXECUTION PLAN.
3492040 : ORA-600 [KGHFRF1] SELECTING FROM V$LOGMNR_CONTENTS
3150750 : SM; (DBMS_STATS/AUTO_SAMPLE_SIZE) ESTIMATED NDV IS WRONG WITH HIGH SKEWS
3566469 : 2004-S138E
3320622 : 2003-S191E
3749394 : SCORE() FOR FUZZY TEXT OPERATOR DIFFERENT FOR FUNCTIONAL VERSUS INDEX ACCESS
3609791 : PSR 9.2.0.5.0 BREAKS CALL DB2 STORED PROCEDURE WITH DECIMAL PARM. SQLCODE -310
3698501 : CGS/IMR GENERATES SAME SEQ/INCARNATION NUMBER AFTER RECONFIG
3668572 : ORA-979 WHEN CURSOR_SHARING=FORCE OR SIMILAR
3179637 : UNABLE TO CREATE AN ORACLECONTEXT ON AD UNDER A CHILD DOMAIN
3571226 : 2004-S140E
3240280 : JOBS SUDDENLY STOP ALTHOUGH NEXT_DATE <= SYSDATE
2964252 : LPX-00252 WHEN PARSING VALID XML / DTD FILE
3617519 : TRANSFORMATION FAILING WITH ORA-932 INCONSISTENT DATATYPE
3172282 : ORACLE CORE DUMPS WHEN TRY TO LIST ALL ACES FOR A SPECIFIC ACL
3637624 : WRONG RESULTS WITH DISTINCT COUNT AND UNNESTED EXISTS SUBQUERY
3542588 : SAME EVENT 38041 USED FOR BUG FIXES 3444115 AND 3131551
3358490 : ORA-00600 [KQSCCCK;1],[],[],[],[],[],[],[]
3177513 : WRONG PLAN - JOIN NOT AVOIDED USING BITMAP JOIN INDEX IF UNIQUE INDEX TOO
3509265 : SHUTDOWN DID NOT COMPLETE WITH WAITING FOR INSTANCES TO LEAVE; 2
3516951 : BAD EXECUTION PLAN WITH MERGE JOIN CARTESIAN IN TEMP TABLE
2954891 : ORA-600 KJMXMPM;DIFFUS], [990307644], [990307644], [3304659678]
3388633 : LOGICAL STANDBY APPLY STOPPED WITH ORA-00600; [17090]
3371796 : EXPLAIN PLAN HANGS ON KKORMINL
3622875 : ORA-1499 AND ANALYZE TABLE VALIDATE STRUCTURE CASCADE ONLINE
3412136 : BAD EXECUTION WITH MERGE JOIN CARTESIAN IN ORACLE 9.2.0.4 AND MERGEFIX 3363655
3540576 : 2004-S083E
3575747 : 2004-S145E
3566813 : CTAS WITH UNION ALL AND ORDER BY RESULTS IN ORA-3113
3811906 : MERGE LABEL REQUEST ON TOP OF 9.2.0.5
2824035 : FXD; ORA-22921 CAUSING 4 DIFS IN LRGXG2.
3354470 : 2003-S195E
3518909 : UGA MEMORY NOT RELEASED AFTER USING XMLPARSER
3617042 : BAD PLAN FOR SCH-XMLTYPE BASED WITH COLLECTIONS MAPPED TO OCT
3583686 : MEMORY ALLOCATION ERROR DURING SPATIAL QUERY
3597640 : MERGE LABEL REQUEST ON TOP OF 9.2.0.5.0
3559212 : WRONG RESULTS RETURNED WITH 9.2.0.4 AND CBO
3625370 : CGS/IMR RECONFIGURATION GOT HUNG DURING A NEW MEMBER JOINING
3475932 : CROSS INSTANCE ARCHIVE LOG NOT GENERATED REMOTELY
3635177 : PSRC; ORA-7445 [KXCCUIN] POSSIBLE FROM DML
3430832 : ORA-600 [25012] AFTER CREATE OF INDEX ONLINE PARALLEL ON PART TABLE
2338704 : FXD; 1; QUERIES ON COLLECTIONS STORED IN OUT-OF-LINE TABLES ARE NOT VIEW MERGED
3253770 : 9I-GSI-CRITICAL PROGRAMS TIME OUT WAITING FOR LIBRARY CACHE PIN
Reading patch XML files and doing sanity checks.
Read the command to action file map.
Performing initial safety check.
Checking active processes:
Accessing inventory... This may take up to 300 seconds.
(retry 10 times, delay 30 seconds each time)
System Command: ""D:\oracle\ora92\jdk\jre\bin\java.exe" -Dopatch.retry=10 -Dopatch.delay=30 -classpath "D:\oracle\ora92\oui\jlib\OraInstaller.jar;D:\oracle\ora92\oui\jlib\srvm.jar;D:\oracle\ora92\opatch\jlib\opatch.jar;D:\oracle\ora92\oui\jlib\xmlparserv2.jar;D:\oracle\ora92\oui\jlib\share.jar;." opatch/CheckConflict "D:\oracle\ora92\oui" "d:\oracle\ora92" opatch.pl 1.0.0.0.48 3738339 "3253770 2338704 3430832 3635177 3475932 3625370 3559212 3597640 3583686 3617042 3518909 3354470 2824035 3811906 3566813 3575747 3540576 3412136 3622875 3371796 3388633 2954891 3516951 3509265 3177513 3358490 3542588 3637624 3172282 3617519 2964252 3240280 3571226 3179637 3668572 3698501 3609791 3749394 3320622 3566469 3150750 3492040 3668224 3356103 3323435 2810394 3458446 3571233 3543125 2690205 3412818 3528282 3752406 3666502 3554319 3575743 2918138 3239873 2800494 3741539 " C:\TEMP\patch92053\3738339\etc\config\actions"
Result:
d:\oracle\ora92\opatch\opatch.pl version: 1.0.0.0.48
Copyright (c) 2001,2002,2003 Oracle Corporation. All Rights Reserved.
Error in executing Java program to check conflict
ERROR: OPatch failed during pre-reqs check.