[草稿版]
从Oracle11g 开始, Oracle的系统目录及相关Log目录等都发生了很大的
变化, 这里大概总结一下常用命令及文件所在的目录 .
首先列一下常用目录地址:
Oracle Alert LOG :
[root@wsjrac01 trace]# pwd
/u01/product/oracle/diag/rdbms/wsjdell/wsjdell1/trace
Oracle SQLNET.LOG :
在Oracle DB下面是关于sqlnet.log的文件:
[root@wsjrac01 network]# pwd
/u01/product/oracle/11.2.0/db_1/network
[root@wsjrac01 network]# ls
admin doc install jlib lib log mesg tools trace
[root@wsjrac01 network]# cd log/
[root@wsjrac01 log]# ls
sqlnet.log sqlnet.log.1
监听是作为clusterware的服务存在, 所以需要在grid目录下查找 :
[root@wsjrac01 trace]# ls
listener.log listener.log.1 listener.log.2
[root@wsjrac01 trace]# pwd
/u01/product/grid/crs/diag/tnslsnr/wsjrac01/listener/trace
Oracle 数据库tnsnames.ora 文件 :
[root@wsjrac01 admin]# pwd
/u01/product/oracle/11.2.0/db_1/network/admin
[root@wsjrac01 admin]# ls
samples shrept.lst tnsnames1106208AM4547.bak tnsnames.ora
--------------------------------------
Clusterware及RDBMS DB 软件安装目录 (HOME/BASE)
[grid@rac01 ~]$ env | grep ORA
ORA_NLS11=/u01/grid/11.2.0/nls/data
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/grid/crs
ORACLE_TERM=vt100
ORACLE_HOME=/u01/grid/11.2.0
[grid@rac01 ~]$
[oracle@rac01 ~]$ env | grep ORA
ORACLE_UNQNAME=racdb
ORA_NLS11=/u01/product/oracle/11.2.0/db_1/nls/data
ORACLE_SID=racdb1
ORACLE_BASE=/u01/product/oracle
ORACLE_TERM=vt100
ORACLE_HOME=/u01/product/oracle/11.2.0/db_1
[oracle@rac01 ~]$
--------------------
ORACLE_BASE
--------------------
[oracle@rac01 oracle]$ pwd
/u01/product/oracle
[oracle@rac01 oracle]$ ls
11.2.0/ admin/ cfgtoollogs/ checkpoints/ diag/
以上目录中 , 因 ORACLE_HOME=/u01/product/oracle/11.2.0/db_1 , 那么
11.2.0 目录是安装Oracle RDBMS软件的地方,
admin 目录应该类似Oracle10g或以前版本中的资料库的dump文件所在地,
不过还是有很大不同 。
[grid@rac01 admin]$ cd racdb/
[grid@rac01 racdb]$ ls
adump/ dpdump/ hdump/ pfile/
其中adump存放着审计(audit)信息, dpdump是存放登录信息的,
hdump ????? , pfile 是初始化参数文件initSID .
[grid@rac01 oracle]$ cd cfgtoollogs
[grid@rac01 cfgtoollogs]$ ls
dbca/ emca/ netca/
这些目录下存放的是 config tool (dbca, emca, netca)执行时候的logs .
[grid@rac01 checkpoints]$ pwd
/u01/product/oracle/checkpoints
checkpoints 目录 ?????
wsjrac01$ls
asm clients crs diagtool lsnrctl netcman ofm rdbms tnslsnr
目录diag下有asm 是asm诊断目录, clients 目录如下, 与客户端相关的trc或log:
diag 是一个重组之后的目录,详细看一下其中的子目录,基本上Oracle每个组件
都有了自己单独的目录,无论是asm还是crs还是rdbms,需要被用来诊断的log文件
都存放在了这个新的目录下。
wsjrac01$cd clients/
wsjrac01$ls
user_oracle
wsjrac01$cd user_oracle/
wsjrac01$ls
host_1999093026_80
wsjrac01$cd host_1999093026_80/
wsjrac01$ls
alert cdump incident incpkg lck metadata metadata_dgif metadata_pv stage sweep trace
wsjrac01$
CRS目录存储crs相关log .
wsjrac01$cd crs/
wsjrac01$ls
wsjrac01$
diagtool lsnrctl netcman ofm 等几个目录都没有内容 ?????
wsjrac01$cd rdbms/wsjdell/wsjdell1
wsjrac01$ls
alert cdump hm incident incpkg ir lck metadata metadata_dgif metadata_pv stage sweep trace
wsjrac01$ls -al
total 41184
drwxr-x--- 2 oracle asmadmin 4096 Dec 9 11:33 .
drwxr-x--- 15 oracle asmadmin 4096 Jun 17 12:16 ..
-rw-r----- 1 oracle asmadmin 10485919 Jul 5 16:41 log_1.xml
-rw-r----- 1 oracle asmadmin 10485863 Jul 7 11:09 log_2.xml
-rw-r----- 1 oracle asmadmin 10485849 Sep 9 18:19 log_3.xml
-rw-r----- 1 oracle asmadmin 10485846 Dec 9 11:32 log_4.xml
-rw-r----- 1 oracle asmadmin 134667 Dec 9 16:41 log.xml
alter 目录中存放的Log是类似linux的log循环存储的. 就是oracle的alertSID.log
文件 . 只是格式为 xml 格式, 需要使用ADRCI查看 .
wsjrac01$ls
wsjrac01$
cdump 存放core dmp .
wsjrac01$cd incident/
wsjrac01$ls
incdir_48449
wsjrac01$cd incdir_48449/
wsjrac01$ls
wsjdell1_dw00_31982_i48449.trc wsjdell1_dw00_31982_i48449.trm
[root@wsjrac01 trace]# pwd
/u01/product/oracle/diag/rdbms/wsjdell/wsjdell1/trace
[root@wsjrac01 trace]# ls
alert_wsjdell1.log wsjdell1_lgwr_9807.trm wsjdell1_ora_15612.trm
alert_wsjdell1.log.1 wsjdell1_lmd0_9786.trc wsjdell1_ora_17424.trc
alert_wsjdell1.log.2 wsjdell1_lmd0_9786.trm wsjdell1_ora_17424.trm
wsjdell1_arc0_9987.trc wsjdell1_lmhb_9798.trc wsjdell1_ora_18108.trc
关于网络相关的一些配置文件及log等 .
在Oracle DB下面是关于sqlnet.log的文件:
[root@wsjrac01 network]# pwd
/u01/product/oracle/11.2.0/db_1/network
[root@wsjrac01 network]# ls
admin doc install jlib lib log mesg tools trace
[root@wsjrac01 network]# ls
admin doc install jlib lib log mesg tools trace
[root@wsjrac01 network]# cd log/
[root@wsjrac01 log]# ls
sqlnet.log sqlnet.log.1
监听是作为clusterware的服务存在, 需要在grid目录下查找 :
[root@wsjrac01 trace]# ls
listener.log listener.log.1 listener.log.2
[root@wsjrac01 trace]# pwd
/u01/product/grid/crs/diag/tnslsnr/wsjrac01/listener/trace
Oracle 数据库tnsnames.ora 文件 :
[root@wsjrac01 admin]# pwd
/u01/product/oracle/11.2.0/db_1/network/admin
[root@wsjrac01 admin]# ls
samples shrept.lst tnsnames1106208AM4547.bak tnsnames.ora
---------------------
Grid Infrastructure 目录
---------------------
[grid@rac01 ~]$ env | grep ORA
ORA_NLS11=/u01/grid/11.2.0/nls/data
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/grid/crs
ORACLE_TERM=vt100
ORACLE_HOME=/u01/grid/11.2.0
[root@wsjrac01 grid]# pwd
/u01/product/grid
[root@wsjrac01 grid]# ls
11.2.0 crs oraInventory
[root@wsjrac01 crs]# ls
cfgtoollogs checkpoints Clusterware diag oradiag_oracle wsjrac01
11.2.0目录 下存放的是Grid Infrastructure的软件,
crs目录是存放 ????
[root@wsjrac01 11.2.0]# cd log/
[root@wsjrac01 log]# ls
crs diag wsjrac01
[root@wsjrac01 log]#
[root@wsjrac01 crs]# pwd
/u01/product/grid/crs
[root@wsjrac01 crs]# cd diag/
[root@wsjrac01 diag]# ls
asm tnslsnr
[root@wsjrac01 diag]#
[root@wsjrac01 crs]# pwd
/u01/product/grid/crs
[root@wsjrac01 crs]# ls
cfgtoollogs checkpoints Clusterware diag oradiag_oracle wsjrac01
[root@wsjrac01 crs]# cd diag/
[root@wsjrac01 diag]# ls
asm tnslsnr
crs/diag目录下存储asm及listener的相关log 文件。
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/35489/viewspace-713087/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/35489/viewspace-713087/