【expdp/impdp】 ORA-06502、ORA-39077 修復補丁安裝與回退操作
expdp/impdp操作報錯資訊如下：
ORA-31626: job does not exist
ORA-31638: cannot attach to job SYS_EXPORT_TABLE_01 for user SYS
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPV$FT_INT", line 428
ORA-39077: unable to subscribe agent KUPC$A_1_191136568928000 to queue "KUPC$C_1_20140807191136"
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPC$QUE_INT", line 250
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
錯誤資訊分析為datapump元件中sequence數值大於6位數導致。參考MOS文件1550344.1分析，此錯誤由oracle Bug 16473783導致,在Oracle 12.2版本中被修復。建議安裝Patch 16928674修復此bug。
安裝環境：
OS:RHEL 5.5 x86 64bit
Oracle版本:11.2.0.3
Opatch版本：p6880880
Patch版本：Patch 16928674
補丁安裝操作
1.檢視當前opatch版本
[oracle@ENMOEDU dmp]$ cd /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/
[oracle@ENMOEDU OPatch]$ ./opatch version
Invoking OPatch 11.2.0.1.7
OPatch Version: 11.2.0.1.7
OPatch succeeded.
2.上傳最新Opath到$ORACLE_HOME目錄
[oracle@ENMOEDU dbhome_1]$ ls -trl
-rw-r--r-- 1
root root 32995358 Aug 8 11:17 p6880880_112000_Linux-x86-64.zip
3.備份原Opath目錄
[oracle@ENMOEDU
dbhome_1]$ mv OPatch/ OPatch.bak
4.解壓最新Opath
[oracle@ENMOEDU
dbhome_1]$ unzip p6880880_112000_Linux-x86-64.zip
5.檢視opatch版本
[oracle@ENMOEDU dbhome_1]$ cd OPatch
[oracle@ENMOEDU OPatch]$ ./opatch version
OPatch Version: 11.2.0.3.5
OPatch succeeded.
6.上傳補丁
[oracle@ENMOEDU tmp]$ cd /u01/
[oracle@ENMOEDU u01]$ mkdir patch
[oracle@ENMOEDU u01]$ cd patch
[oracle@ENMOEDU patch]$ ls
p16928674_112030_Generic.zip
7.解壓補丁
[oracle@ENMOEDU
patch]$ unzip p16928674_112030_Generic.zip
8.檢查補丁
[oracle@ENMOEDU patch]$ ls
16928674 p16928674_112030_Generic.zip
[oracle@ENMOEDU patch]$ cd 16928674/
[oracle@ENMOEDU16928674]$ /u01/app/oracle/product/11.2.0/dbhome_1/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -ph ./
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
PREREQ session
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-08-08_11-26-35AM_1.log
Invoking prereq "checkconflictagainstohwithdetail"
Prereq "checkConflictAgainstOHWithDetail" passed.
OPatch succeeded.
9.安裝補丁
[oracle@ENMOEDU 16928674]$ $ORACLE_HOME/OPatch/opatch apply
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/16928674_Aug_08_2014_11_28_27/apply2014-08-08_11-28-27AM_1.log
Applying interim patch '16928674' to OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Verifying environment and performing prerequisite checks...
All checks passed.
Provide your email address to be informed of security issues, install and
initiate Oracle Configuration Manager. Easier for you if you use your My
Oracle Support Email address/User Name.
Visit for details.
Email address/User Name:
You have not provided an email address for notification of security issues.
Do you wish to remain uninformed of security issues ([Y]es, [N]o) [N]: y
Backing up files...
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
Verifying the update...
Patch 16928674 successfully applied
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/16928674_Aug_08_2014_11_28_27/apply2014-08-08_11-28-27AM_1.log
OPatch succeeded.
10.檢查安裝結果
[oracle@ENMOEDU 16928674]$ $ORACLE_HOME/OPatch/opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-08-08_11-30-08AM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-08-08_11-30-08AM.txt
----------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 16928674 : applied on Fri Aug 08 11:28:51 CST 2014
Unique Patch ID: 17483843
Created on 2 Apr 2014, 04:20:57 hrs PST8PDT
Bugs fixed:
16928674
----------------------------------------------------------------------------
OPatch succeeded.
11.檢視補丁執行指令碼路徑
[oracle@ENMOEDU 16928674]$ ls
etc files postinstall.sql README.txt
[oracle@ENMOEDU 16928674]$ pwd
/u01/patch/16928674
12.執行補丁指令碼
[oracle@ENMOEDU OPatch]$ sqlplus / as sysdba
SQL> @/u01/patch/16928674/postinstall
Calling rdbms/admin/prvtbpci.plb on 08-AUG-14 11.34.01.504642 AM +08:00
Package body created.
Package body created.
補丁回退操作
1.檢視補丁狀態
[oracle@ENMOEDU OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-08-08_15-17-56PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-08-08_15-17-56PM.txt
----------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
Interim patches (1) :
Patch 16928674 : applied on Fri Aug 08 11:28:51 CST 2014
Unique Patch ID: 17483843
Created on 2 Apr 2014, 04:20:57 hrs PST8PDT
Bugs fixed:
16928674
---------------------------------------------------------------------------
2.執行回退操作
[oracle@ENMOEDU OPatch]$ ./opatch rollback -id 16928674
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/16928674_Aug_08_2014_15_57_17/rollback2014-08-08_15-57-17PM_1.log
RollbackSession rolling back interim patch '16928674' from OH '/u01/app/oracle/product/11.2.0/dbhome_1'
Patching component oracle.rdbms.dbscripts, 11.2.0.3.0...
RollbackSession removing interim patch '16928674' from inventory
Log file location: /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/16928674_Aug_08_2014_15_57_17/rollback2014-08-08_15-57-17PM_1.log
OPatch succeeded.
3.檢視補丁狀態
[oracle@ENMOEDU OPatch]$ ./opatch lsinventory
Oracle Interim Patch Installer version 11.2.0.3.5
Copyright (c) 2013, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /u01/app/oracle/product/11.2.0/dbhome_1/oraInst.loc
OPatch version : 11.2.0.3.5
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2014-08-08_15-59-13PM_1.log
Lsinventory Output file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/lsinv/lsinventory2014-08-08_15-59-13PM.txt
----------------------------------------------------------------------------
Installed Top-level Products (1):
Oracle Database 11g 11.2.0.3.0
There are 1 products installed in this Oracle Home.
There are no Interim patches installed in this Oracle Home.
----------------------------------------------------------------------------
OPatch succeeded.
4.執行回退指令碼
[oracle@ENMOEDU OPatch]$ sqlplus / as sysdba
SQL> @/u01/patch/16928674/postinstall
Calling rdbms/admin/prvtbpci.plb on 08-AUG-14 04.05.47.030762 PM +08:00
Package body created.
Package body created.
----------------end----------------
DBA_建瑾
2014.8.9
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/29324876/viewspace-1248199/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- 【expdp/impdp】 ORA-06502、ORA-39077 錯誤分析與解決方案
- windows10補丁安裝失敗如何處理_win10無法安裝補丁修復方法WindowsWin10
- 【RAC】11gR2 rac 上滾動安裝/回退補丁
- expdp/impdp操作例項
- Oracle 安裝補丁Oracle
- win10安裝KB4566782補丁藍屏怎麼辦 win10安裝KB4566782補丁時藍屏如何修復Win10
- tinker熱修復——補丁載入合成
- 怎麼樣安裝AIX 補丁或者補丁集AI
- win10更新補丁解除安裝怎麼操作_解除安裝win10更新補丁詳細步驟Win10
- win10無法安裝kb4560960補丁怎麼辦_win10系統kb4560960補丁安裝失敗如何修復Win10
- win10安裝KB4566782補丁藍色畫面怎麼辦 win10安裝KB4566782補丁時藍色畫面如何修復Win10
- tinker熱修復——dex補丁載入過程
- weblogic 12 補丁安裝Web
- oracle安裝補丁失敗Oracle
- was6.1補丁包安裝
- EBS R12系統補丁實施快速回退(恢復)措施
- 【Rhino 8.12下載與安裝教程 含補丁】
- 微軟修復Bug的補丁產生了新的Bug微軟
- Android 熱補丁動態修復框架小結Android框架
- tinker熱修復——資源補丁載入過程
- win10怎麼解除安裝補丁_解除安裝win10已安裝更新補丁的方法Win10
- exp/imp與expdp/impdp區別
- 【Mastercam 2025下載與安裝教程 含補丁】AST
- 微軟11月補丁日，修復12個關鍵漏洞微軟
- 安卓App熱補丁動態修復技術介紹安卓APP
- Ubuntu釋出PHP重要補丁修復多個PHP漏洞UbuntuPHP
- 修復Windows漏洞 微軟預釋出11個補丁(轉)Windows微軟
- impdp/expdp 示例
- oracle expdp and impdpOracle
- Oracle CRS Database安裝10.2.0.5.0補丁OracleDatabase
- 到底打還是不打補丁：安裝第三方補丁(轉)
- Openssl多個安全補丁簡易分析危害及修復方案
- oracle 版本修復的bug列表和打補丁注意事項Oracle
- exp/expdp與imp/impdp的區別
- 【EXPDP/IMPDP】使用 EXPDP/IMPDP工具“模糊”匯出和匯入
- Oracle資料庫PSU補丁安裝Oracle資料庫
- SQL Server安裝補丁注意點--記錄SQLServer
- PSU補丁安裝不全的問題