命令: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]$
总结
以上是生活随笔为你收集整理的OPatch cannot find a valid oraInst.loc file to locate Central Inventory的全部内容,希望文章能够帮你解决所遇到的问题。
如果觉得生活随笔网站内容还不错,欢迎将生活随笔推荐给好友。