假設(shè).bash_profile中oracle相關(guān)環(huán)境變量如下:

$ORACLE_HOME=/u01/app/oracle/product/11.2.0/db_1

$ORACLE_BASE=/u01/app/oracle

$ORACLE_SID=orcl1.監(jiān)聽 TNS等配置文件位置1.1linux

$ORACLE_HOME/network/admin/u01/app/oracle/product/11.2.0/db_1/network/admin1.2windows%ORACLE_HOME%\network/admin2.初始靜態(tài)參數(shù)文件位置2.1linux

$ORACLE_BASE/admin/$ORACLE_SID/spfile/u01/app/oracle/admin/orcl/pfile2.2windows%ORACLE_BASE%\admin\dw\spfile3.動態(tài)參數(shù)文件位置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配置\監(jiān)聽配置\數(shù)據(jù)庫創(chuàng)建的日志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.數(shù)據(jù)庫alert警告日志7.1linuxselect value from v$diag_info where name =‘Diag Alert‘;/u01/app/oracle/diag/rdbms/orcl/orcl/alert

通過adr 查看日志:

[[email?protected]/]$ 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自帶監(jiān)控排錯腳本

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.數(shù)據(jù)庫備份恢復(fù)默認位置

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.數(shù)據(jù)庫備份恢復(fù)默認位置

show parameter db_recovery_file_dest;

select * from v$recovery_file_dest;

11.TNS日志與監(jiān)聽日志位置:

11.1　　 linux? TNS監(jiān)聽日志:

$ORACLE_BASE/diag/tnslsnr/機器名/listener/trace

$ORACLE_BASE/diag/tnslsnr/$HOSTNAME/listener/trace

windows TNS監(jiān)聽日志:

/u01/app/oracle/diag/tnslsnr/機器名/listener/trace

11.2　　linux 監(jiān)聽日志：

$ORACLE_BASE/diag/tnslsnr/機器名/listener/alert/log.xml

windows 監(jiān)聽日志:

/u01/app/oracle/diag/lsnrctl

總結(jié)

以上是生活随笔為你收集整理的oracle 11g r2配置文件,Oracle 11g R2 常用配置与日志的文件位置的全部內(nèi)容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網(wǎng)站內(nèi)容還不錯，歡迎將生活随笔推薦給好友。