命令:opatch lsinventory用于查看数据库所打Patch的列表。但运行的时候发现错误:
- [oracle@bej301441 OPatch]$ opatch lsinventory
- Invoking OPatch 11.1.0.6.2
- Oracle Interim Patch Installer version 11.1.0.6.2
- Copyright (c) 2007, Oracle Corporation. All rights reserved.
- Oracle Home : /u01/oracle/mc3yd213/db/tech_st/11.1.0
- Central Inventory : n/a
- from :
- OPatch version : 11.1.0.6.2
- OUI version : 11.1.0.7.0
- OUI location : /u01/oracle/mc3yd213/db/tech_st/11.1.0/oui
- Log file location : n/a
- OPatch cannot find a valid oraInst.loc file to locate Central Inventory.
- OPatch failed with error code 104
解决方法:
原因是opatch在默认目录下找不到oraInst.loc文件,对于Unix系统来说oraInst.loc的默认位置是: /etc/oraInst.loc 或者 /var/opt/oracle/oraInst.loc 。
这里我们可以需要指定具体的oraInst.loc文件位置给opatch。
命令:opatch lsinventory -invPtrLoc /u01/oracle/mc3yd213/db/tech_st/11.1.0/oraInst.loc
(/u01/oracle/mc3yd213/db/tech_st/11.1.0为我数据库的ORACLE_HOME)
完整的输出:
- [oracle@bej301441 etc]$ opatch lsinventory -invPtrLoc /u01/oracle/mc3yd213/db/tech_st/11.1.0/oraInst.loc
- Oracle Interim Patch Installer version 1.0.0.0.58
- Copyright (c) 2007 Oracle Corporation. All Rights Reserved..
- We recommend you refer to the OPatch documentation under
- OPatch/docs for usage reference. We also recommend using
- the latest OPatch version. For the latest OPatch version
- and other support related issues, please refer to document
- 293369.1 which is viewable from metalink.oracle.com
- Oracle Home : /u01/oracle/mc3yd213/db/tech_st/11.1.0
- Oracle Home Inventory : /u01/oracle/mc3yd213/db/tech_st/11.1.0/inventory
- Central Inventory : /u01/oracle/mc3yd213/db/tech_st/11.1.0/admin/oui/mc3yd213_bej301441/oraInventory
- from : /u01/oracle/mc3yd213/db/tech_st/11.1.0/oraInst.loc
- OUI location : /u01/oracle/mc3yd213/db/tech_st/11.1.0/oui
- OUI shared library : /u01/oracle/mc3yd213/db/tech_st/11.1.0/oui/lib/linux/liboraInstaller.so
- Java location : /u01/oracle/mc3yd213/db/tech_st/11.1.0/jdk/jre/bin/java
- Log file location : /u01/oracle/mc3yd213/db/tech_st/11.1.0/.patch_storage/<patch ID>/*.log
- Creating log file "/u01/oracle/mc3yd213/db/tech_st/11.1.0/.patch_storage/LsInventory__05-10-2013_20-21-11.log"
- Result:
- Installed Patch List:
- =====================
- 1) Patch 8199107 applied on Thu Mar 26 07:53:06 PDT 2009
- [ Base Bug(s): 8199107 ]
- 2) Patch 7627743 applied on Thu Mar 26 07:52:01 PDT 2009
- [ Base Bug(s): 7627743 ]
- 3) Patch 7639602 applied on Thu Mar 26 07:50:56 PDT 2009
- [ Base Bug(s): 7639602 ]
- 4) Patch 7211965 applied on Thu Mar 26 07:49:52 PDT 2009
- [ Base Bug(s): 7211965 ]
- 5) Patch 7708501 applied on Thu Mar 26 07:48:13 PDT 2009
- [ Base Bug(s): 7708501 ]
- 6) Patch 7330434 applied on Thu Mar 26 07:47:02 PDT 2009
- [ Base Bug(s): 7330434 ]
- 7) Patch 7580744 applied on Thu Mar 26 07:45:56 PDT 2009
- [ Base Bug(s): 7580744 ]
- 8) Patch 7708340 applied on Thu Mar 26 07:44:38 PDT 2009
- [ Base Bug(s): 7708340 ]
- 9) Patch 7327166 applied on Thu Mar 26 07:43:37 PDT 2009
- [ Base Bug(s): 7327166 ]
- 10) Patch 7486407 applied on Thu Mar 26 07:42:26 PDT 2009
- [ Base Bug(s): 7486407 ]
- 11) Patch 7243270 applied on Thu Mar 26 07:41:19 PDT 2009
- [ Base Bug(s): 7243270 ]
- 12) Patch 7277741 applied on Thu Mar 26 07:41:07 PDT 2009
- [ Base Bug(s): 7277741 ]
- 13) Patch 7319922 applied on Thu Mar 26 07:39:56 PDT 2009
- [ Base Bug(s): 7319922 ]
- 14) Patch 4247037 applied on Thu Mar 26 07:38:44 PDT 2009
- [ Base Bug(s): 4247037 ]
- 15) Patch 6530141 applied on Thu Mar 26 07:38:31 PDT 2009
- [ Base Bug(s): 6530141 ]
- 16) Patch 6598432 applied on Thu Mar 26 07:37:26 PDT 2009
- [ Base Bug(s): 6598432 ]
- 17) Patch 6815733 applied on Thu Mar 26 07:36:21 PDT 2009
- [ Base Bug(s): 6815733 ]
- 18) Patch 6991626 applied on Thu Mar 26 07:35:16 PDT 2009
- [ Base Bug(s): 6991626 ]
- 19) Patch 7111245 applied on Thu Mar 26 07:34:12 PDT 2009
- [ Base Bug(s): 7111245 ]
- 20) Patch 7253531 applied on Thu Mar 26 07:31:41 PDT 2009
- [ Base Bug(s): 7253531 ]
- 21) Patch 7556778 applied on Thu Mar 26 07:30:41 PDT 2009
- [ Base Bug(s): 7556778 ]
- 22) Patch 7000281 applied on Thu Mar 26 07:29:31 PDT 2009
- [ Base Bug(s): 7000281 ]
- 23) Patch 6263237 applied on Thu Mar 26 07:28:20 PDT 2009
- [ Base Bug(s): 6263237 ]
- 24) Patch 6870937 applied on Thu Mar 26 07:27:07 PDT 2009
- [ Base Bug(s): 6870937 ]
- 25) Patch 7295298 applied on Thu Mar 26 07:26:01 PDT 2009
- [ Base Bug(s): 7295298 ]
- 26) Patch 6972189 applied on Thu Mar 26 07:24:42 PDT 2009
- [ Base Bug(s): 6972189 ]
- OPatch succeeded.
- [oracle@bej301441 etc]$