oracle INVENTORY 詳解
inventory是oracle安裝工具OUI用來管理oracle安裝目錄的。inventory裡註冊了某個ORACLE_HOME下安裝的資料庫的元件及其版本,存放的是oracle軟體安裝的目錄資訊。oracle資料庫軟體的升級、增刪元件,都需要使用inventory。oracle OUI會建立一個有oraInst.ora檔案指定的全域性inventory。
oraInst.ora檔案所在的目錄:
AIX 或 linux作業系統平臺:/etc/oraInst.ora
HP UNIX或Solaris作業系統平臺/var/opt/oracle/oraInst.loc
oraInst.ora檔案內容:
[oracle@ora11g ~]$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory------oraInvetory所在目錄
inst_group=oinstall-----OUI安裝ORACLE的作業系統組
模擬手動建立全域性inventory
模擬資料庫的版本
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
刪除當前的oraInventory
[oracle@ora11g app]$ mv oraInventory/ /tmp
檢視當前系統狀態
[oracle@ora11g OPatch]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-08-05_06-18-47AM.log
OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
OPatch failed with error code 73
生成全域性inventory
[oracle@ora11g bin]$ ./attachHome.sh
oraInst.ora檔案所在的目錄:
AIX 或 linux作業系統平臺:/etc/oraInst.ora
HP UNIX或Solaris作業系統平臺/var/opt/oracle/oraInst.loc
oraInst.ora檔案內容:
[oracle@ora11g ~]$ cat /etc/oraInst.loc
inventory_loc=/u01/app/oraInventory------oraInvetory所在目錄
inst_group=oinstall-----OUI安裝ORACLE的作業系統組
模擬手動建立全域性inventory
模擬資料庫的版本
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
PL/SQL Release 11.2.0.3.0 - Production
CORE 11.2.0.3.0 Production
TNS for Linux: Version 11.2.0.3.0 - Production
NLSRTL Version 11.2.0.3.0 - Production
刪除當前的oraInventory
[oracle@ora11g app]$ mv oraInventory/ /tmp
檢視當前系統狀態
[oracle@ora11g OPatch]$ ./opatch lsinventory
Invoking OPatch 11.2.0.1.7
Oracle Interim Patch Installer version 11.2.0.1.7
Copyright (c) 2011, Oracle Corporation. All rights reserved.
Oracle Home : /u01/app/oracle/product/11.2.0/dbhome_1
Central Inventory : /u01/app/oraInventory
from : /etc/oraInst.loc
OPatch version : 11.2.0.1.7
OUI version : 11.2.0.3.0
Log file location : /u01/app/oracle/product/11.2.0/dbhome_1/cfgtoollogs/opatch/opatch2013-08-05_06-18-47AM.log
OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
LsInventorySession failed: OPatch failed to locate Central Inventory.
Possible causes are:
The Central Inventory is corrupted
The oraInst.loc file specified is not valid.
OPatch failed with error code 73
生成全域性inventory
[oracle@ora11g bin]$ ./attachHome.sh
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/223653/viewspace-2128117/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle SCN詳解Oracle
- oracle rowid詳解Oracle
- ORACLE -詳解SCNOracle
- ORACLE的HINT詳解Oracle
- Oracle練習詳解Oracle
- oracle oradebug使用詳解Oracle
- ORACLE基礎之oracle鎖(oracle lock mode)詳解Oracle
- oracle: default role 詳解(轉)Oracle
- Oracle中job的使用詳解Oracle
- 一、oracle 高水位線詳解Oracle
- Oracle GoldenGate常用引數詳解OracleGo
- oracle rac 核心引數詳解Oracle
- Oracle中pivot函式詳解Oracle函式
- 【RECYCLEBIN】Oracle回收站詳解Oracle
- oracle 密碼詳解以及破解Oracle密碼
- oracle連線查詢詳解Oracle
- Oracle的表空間quota詳解Oracle
- Oracle SCN機制詳細解讀Oracle
- 詳解oracle資料庫閃回Oracle資料庫
- Ansible 進階 | 動態 Inventory
- 【INDEX】Oracle分割槽索引技術詳解IndexOracle索引
- 【DATAGUARD】Oracle Dataguard體系架構詳解Oracle架構
- ORACLE中Cursor_sharing引數詳解Oracle
- Ansible: No inventory was passed, only implicit localhost is availablelocalhostAI
- Oracle minus用法詳解及應用例項Oracle
- oracle中的processes,session,transaction引數詳解OracleSession
- 詳解Oracle AWR執行日誌分析工具Oracle
- oracle partition by group by,詳解partition by和group by對比Oracle
- 打補丁時重建Inventory目錄
- ORA-20001: Latest xml inventory is not loaded into tableXML
- 19_深入解析Oracle undo原理(3)_ktuxe詳解OracleUX
- 20_深入解析Oracle undo原理(4)_ktuxc詳解OracleUX
- Oracle資料庫備份還原詳解XKUSOracle資料庫
- Oracle 18c新特性詳解:In-Memory 專題Oracle
- oracle正規表示式regexp_like的用法詳解Oracle
- Oracle中的正規表示式(及函式)詳解Oracle函式
- 理論+實驗 詳解Oracle安裝部署過程Oracle
- Oracle完全檢查點和增量檢查點詳解Oracle
- Oracle分析函式之開窗函式over()詳解Oracle函式