The Location of Alert log
At this article i will present the alert log's location. which is very important for DBAs.
First we are getting connect the Sqlplus.
SQL> sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Sun Jan 01 18:49:29 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
Looking our version...
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
Getting our Location
SQL> show parameter background
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
background_core_dump string partial
background_dump_dest string /u01/app/oracle/diag/rdbms/orcl/orcl/trace
And finding our ALERT log
SQL> !ls /u01/app/oracle/diag/rdbms/orcl/orcl/trace/a*
/u01/app/oracle/diag/rdbms/orcl/orcl/trace/alert_orcl.log
No comments:
Post a Comment