Shulou(Shulou.com)05/31 Report--

This article shows you the common configuration of Oracle 11g R2 and the file location of the log. The content is concise and easy to understand, which will definitely brighten your eyes. I hope you can get something through the detailed introduction of this article.

Suppose the oracle-related environment variables in .bash _ profile are as follows:

$ORACLE_HOME=/oracle/ora11gR2/product/11.2.0/dbhome_1

$ORACLE_BASE= / oracle/ora11gR2

$ORACLE_SID=secooler

1. Monitor configuration file locations such as TNS

1.1 linux

$ORACLE_HOME/network/admin

/ oracle/ora11gR2/product/11.2.0/dbhome_1/network/admin

1.2 windows

% ORACLE_HOME%\ network\ admin

two。 Initial static parameter file location

2.1 linux

$ORACLE_BASE/admin/$ORACLE_SID/spfile

2.2 windows

% ORACLE_BASE%\ admin\ $ORACLE_SID\ spfile

3. Dynamic parameter file location

3.1 linux

$ORACLE_HOME/dbs

3.2 windows

% ORACLE_HOME%\ database

4. Audit information

4.1 linux

$ORACLE_BASE/admin/$ORACLE_SID/adump

/ u01/app/oracle/admin/orcl/adump

4.2 windows

% ORACLE_BASE%\ admin\ dw\ adump

5.EM configuration\ listening configuration\ logs created by the database

5.1 linux

/ u01/app/oracle/cfgtoollogs

5.2 windows

% ORACLE_BASE%\ cfgtoollogs

6. Session tracking file-that is, trace file

The tracking information is written to two directories.

Information related to the background process is written to the directory specified by the initialization parameter DIAGNOSTIC_DEST.

Information related to the server process is written to the directory specified by the initialization parameter USER_DUMP_DEST.

The name of the trace file varies from operating system to operating system, but the name of each trace file contains the name of the process (such as LGWR).

7. Database alert alert file

7.1 linux/windows

SQL > show parameter background_dump_dest

Background_dump_dest string / oracle/ora11gR2/diag/rdbms/secooler/secooler/trace

You can see the alert file for the database in this directory: alert_secooler.log alert_sid.log

8.oracle comes with a monitoring and troubleshooting script

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. Default location for database backup recovery

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. Default location for database backup recovery

Show parameter db_recovery_file_dest

Select * from v$recovery_file_dest

11.TNS log and snooping log location:

11.1 linux TNS snooping log:

$ORACLE_BASE/diag/tnslsnr/ machine name / listener/trace

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

Windows TNS snooping log:

/ u01/app/oracle/diag/tnslsnr/ machine name / listener/trace

11.2 linux snooping log:

$ORACLE_BASE/diag/tnslsnr/ machine name / listener/alert/log.xml

Windows snooping log:

/ u01/app/oracle/diag/lsnrctl

The above is the common configuration of Oracle 11g R2 and what the file location of the log is. Have you learned the knowledge or skills? If you want to learn more skills or enrich your knowledge reserve, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.