假设.bash_profile中oracle相关环境变量如下:
$ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1
$ORACLE_BASE=/u01/app/oracle
$ORACLE_SID=orcl1.监听 TNS等配置文件位置1.1linux
$ORACLE_HOME/network/admin/u01/app/oracle/product/11.2.0/db_1/network/admin1.2windows%ORACLE_HOME%\network/admin2.初始静态参数文件位置2.1linux
$ORACLE_BASE/admin/$ORACLE_SID/spfile/u01/app/oracle/admin/orcl/pfile2.2windows%ORACLE_BASE%\admin\dw\spfile3.动态参数文件位置3.1linux
$ORACLE_HOME/dbs/u01/app/oracle/product/11.2.0/db_1/dbs3.2windows%ORACLE_HOME%\dbs4.审计信息4.1linux
$ORACLE_BASE/admin/$ORACLE_SID/adump/u01/app/oracle/admin/orcl/adump4.2windows%ORACLE_BASE%\admin\dw\adump5.EM配置\监听配置\数据库创建的日志5.1linux/u01/app/oracle/cfgtoollogs5.2windows%ORACLE_BASE%\cfgtoollogs6.会话跟踪文件-即trace文件6.1linuxselect value from v$diag_info where name ='Diag Trace';/u01/app/oracle/diag/rdbms/orcl/orcl/trace6.2windows%ORACLE_BASE%\diag\rdbms\dw\dw\trace7.数据库alert警告日志7.1linuxselect value from v$diag_info where name ='Diag Alert';/u01/app/oracle/diag/rdbms/orcl/orcl/alert
通过adr 查看日志:
[oracle@TEST144239/]$ adrci
ADRCI: Release11.2.0.3.0 - Production on Fri Oct 16 14:38:36 2015Copyright (c)1982, 2011, Oracle and/or its affiliates. All rights reserved.
ADRbase = "/u01/app/oracle"adrci>show alert7.2windows%ORACLE_BASE%\diag\rdbms\dw\dw\alert
8.oracle自带监控排错脚本
8.1 linux
$ORACLE_HOME/rdbms/admin
/u01/app/oracle/product/11.2.0/db_1/rdbms/admin
8.2 windows
%ORACLE_HOME%\RDBMS\ADMIN
9.数据库备份恢复默认位置
9.1 linux
$ORACLE_BASE/fast_recovery_area/ORCL
/u01/app/oracle/fast_recovery_area/ORCL/autobackup
/u01/app/oracle/fast_recovery_area/ORCL/backupset
/u01/app/oracle/fast_recovery_area/ORCL/onlinelog
/u01/app/oracle/fast_recovery_area/orcl/control02.ctl
9.2 windows
%ORACLE_BASE%\flash_recovery_area\dw
10.数据库备份恢复默认位置
show parameter db_recovery_file_dest;
select * from v$recovery_file_dest;
11.TNS日志与监听日志位置:
11.1 linux TNS监听日志:
$ORACLE_BASE/diag/tnslsnr/机器名/listener/trace
$ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/trace
windows TNS监听日志:
/u01/app/oracle/diag/tnslsnr/机器名/listener/trace
11.2 linux 监听日志:
$ORACLE_BASE/diag/tnslsnr/机器名/listener/alert/log.xml
windows 监听日志:
/u01/app/oracle/diag/lsnrctl