Oracle：OFA中比较重要的几个路径
在OFA标准中，有这么几个目录是比较重要的：
Oracle清单目录
Oracle基础目录
Oracle主目录
Oracle网络文件目录
Oracle自动诊断库目录
清单目录：OraIventory。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 |
[oracle@oel71 ~]$ cd /u01/app/oraInventory/ [oracle@oel71 oraInventory]$ ll total 8 drwxrwx--- 2 oracle oinstall 57 Dec 4 00:21 ContentsXML drwxrwx--- 2 oracle oinstall 136 Dec 3 23:07 logs -rw-rw---- 1 oracle oinstall 56 Dec 4 00:21 oraInst.loc -rwxrwx--- 1 oracle oinstall 1620 Dec 4 00:21 orainstRoot.sh drwxrwx--- 2 oracle oinstall 21 Dec 3 23:08 oui [oracle@oel71 oraInventory]$ [oracle@oel71 oraInventory]$ cat oraInst.loc inventory_loc=/u01/app/oraInventory inst_group=oinstall [oracle@oel71 oraInventory]$ |
Oracle基础目录：$ORACLE_BASE
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
[oracle@oel71 oraInventory]$ env | grep --color ORACLE_BASE ORACLE_BASE=/u01/app/oracle [oracle@oel71 oraInventory]$ cd $ORACLE_BASE [oracle@oel71 oracle]$ pwd /u01/app/oracle [oracle@oel71 oracle]$ ll total 4 drwxr-x--- 3 oracle oinstall 17 Dec 4 23:02 admin drwxr-x--- 3 oracle oinstall 17 Dec 4 23:07 audit drwxr-xr-x 4 oracle oinstall 33 Dec 4 23:07 cfgtoollogs drwxr-xr-x 2 oracle oinstall 6 Dec 4 00:22 checkpoints drwxrwxr-x 19 oracle oinstall 4096 Dec 4 00:21 diag drwxr-x--- 3 oracle oinstall 17 Dec 4 23:04 fast_recovery_area drwxr-x--- 3 oracle oinstall 17 Dec 4 23:02 oradata drwxr-xr-x 3 oracle oinstall 15 Dec 3 23:00 product [oracle@oel71 oracle]$ |
Oracle主目录：$ORACLE_HOME
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 |
[oracle@oel71 oracle]$ env | grep --color ORACLE_HOME ORACLE_HOME=/u01/app/oracle/product/12/db_1 [oracle@oel71 oracle]$ cd $ORACLE_HOME [oracle@oel71 db_1]$ pwd /u01/app/oracle/product/12/db_1 [oracle@oel71 db_1]$ ls addnode dbhadoop inventory oc4j plugins sqlpatch apex dbs javavm odbc precomp sqlplus assistants dc_ocm jdbc olap QOpatch srvm bin deinstall jdk OPatch R sysman ccr demo jlib opmn racg ucp cdata diagnostics ldap oracore rdbms usm cfgtoollogs dmu lib oraInst.loc relnotes utl clone dv log ord root.sh wwg crs has md oui scheduler xdk css hs mgw owm slax ctx install network perl sqldeveloper cv instantclient nls plsql sqlj [oracle@oel71 db_1]$ |
Oracle网络文件目录：$TNS_ADMIN。
一般TNS_ADMIN的路径为：$ORACLE_HOME/network/admin
|
1 2 3 4 5 6 |
[oracle@oel71 db_1]$ cd $ORACLE_HOME/network/admin [oracle@oel71 admin]$ pwd /u01/app/oracle/product/12/db_1/network/admin [oracle@oel71 admin]$ ls samples shrept.lst [oracle@oel71 admin]$ |
在MS Windows中，有时候是：%ORACLE_HOME%/NETWORK/ADMIN。
自动诊断库：$ADR_HOME
自动诊断库的路径可以通过SQL查询：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 |
[oracle@oel71 admin]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.1.0 Production on Wed Dec 16 20:53:30 2015 Copyright (c) 1982, 2013, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> desc v$diag_info; Name Null? Type ----------------------------------------- -------- ---------------------------- INST_ID NUMBER NAME VARCHAR2(64) VALUE VARCHAR2(512) CON_ID NUMBER SQL> SQL> col name for a13 SQL> col value for a38 SQL> set linesize 400 SQL> SQL> select * from v$diag_info where name='ADR Home'; INST_ID NAME VALUE CON_ID ---------- ------------- -------------------------------------- ---------- 1 ADR Home /u01/app/oracle/diag/rdbms/orcl/orcl 0 SQL> |
进入自动诊断库目录查看一下：
|
1 2 3 4 5 |
[oracle@oel71 admin]$ cd /u01/app/oracle/diag/rdbms/orcl/orcl [oracle@oel71 orcl]$ ls alert hm incpkg lck metadata metadata_pv sweep cdump incident ir log metadata_dgif stage trace [oracle@oel71 orcl]$ |
————————————————
Done。
