alert log on Oracle11g
About Oracle 11g, one of the first things that caught me by surprise with 11g, when I first started in the beta program, was that the default location for the alert log has moved. It is still placed under the traditional OFA structure, but not /u01/app/oracle/admin. There is a new directory called diag that resides in /u01/app/oracle as seen on one of my systems:
rac13 | PWICRM3 | /export/home/oracle > cd /u01/app/oracle/diag/rdbms/pwicrm/PWICRM3/trace/
rac13 | PWICRM3 | /u01/app/oracle/diag/rdbms/pwicrm/PWICRM3/trace > ll alert_PWICRM3.log
-rw-r----- 1 oracle dba 278929 Sep 15 08:39 alert_PWICRM3.log
In this case, my database is called PWICRM and the first instance is PWICRM3. To quickly locate alert logs associated with many different ORACLE_HOMEs simple execute the adrci command and then execute “show alert”
rac13 | PWICRM3 | /export/home/oracle > adrci
ADRCI: Release 11.1.0.7.0 - Production on Thu Sep 15 08:50:52 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show alert
Choose the alert log from the following homes to view:
1: diag/rdbms/pwiprv/PWICRM3
……………………………………
6: diag/asm/+asm/+ASM3
Q: to quit
Please select option:
Also, you can get more helpful information via "help show alert":
adrci> help show alert
Usage: SHOW ALERT [-p] [-term]
[ [-tail [num] [-f]] | [-file] ]
Purpose: Show alert messages.
Options:
[-p]: The predicate string must be double quoted.
The fields in the predicate are the fields:
ORIGINATING_TIMESTAMP timestamp
NORMALIZED_TIMESTAMP timestamp
ORGANIZATION_ID text(65)
COMPONENT_ID text(65)
HOST_ID text(65)
HOST_ADDRESS text(17)
MESSAGE_TYPE number
MESSAGE_LEVEL number
MESSAGE_ID text(65)
MESSAGE_GROUP text(65)
CLIENT_ID text(65)
MODULE_ID text(65)
PROCESS_ID text(33)
THREAD_ID text(65)
USER_ID text(65)
INSTANCE_ID text(65)
DETAILED_LOCATION text(161)
UPSTREAM_COMP_ID text(101)
DOWNSTREAM_COMP_ID text(101)
EXECUTION_CONTEXT_ID text(101)
EXECUTION_CONTEXT_SEQUENCE number
ERROR_INSTANCE_ID number
ERROR_INSTANCE_SEQUENCE number
MESSAGE_TEXT text(2049)
MESSAGE_ARGUMENTS text(129)
SUPPLEMENTAL_ATTRIBUTES text(129)
SUPPLEMENTAL_DETAILS text(129)
PROBLEM_KEY text(65)
[-tail [num] [-f]]: Output last part of the alert messages and
output latest messages as the alert log grows. If num is not specified,
the last 10 messages are displayed. If "-f" is specified, new data
will append at the end as new alert messages are generated.
[-term]: Direct results to terminal. If this option is not specified,
the results will be open in an editor.
By default, it will open in emacs, but "set editor" can be used
to set other editors.
[-file]: Allow users to specify an alert file which
may not be in ADR. must be specified with full path.
Note that this option cannot be used with the -tail option
Examples:
show alert
show alert -p "message_text like '%incident%'"
show alert -tail 20
We can also get info detail from following oracle link:
rac13 | PWICRM3 | /export/home/oracle > cd /u01/app/oracle/diag/rdbms/pwicrm/PWICRM3/trace/
rac13 | PWICRM3 | /u01/app/oracle/diag/rdbms/pwicrm/PWICRM3/trace > ll alert_PWICRM3.log
-rw-r----- 1 oracle dba 278929 Sep 15 08:39 alert_PWICRM3.log
In this case, my database is called PWICRM and the first instance is PWICRM3. To quickly locate alert logs associated with many different ORACLE_HOMEs simple execute the adrci command and then execute “show alert”
rac13 | PWICRM3 | /export/home/oracle > adrci
ADRCI: Release 11.1.0.7.0 - Production on Thu Sep 15 08:50:52 2011
Copyright (c) 1982, 2007, Oracle. All rights reserved.
ADR base = "/u01/app/oracle"
adrci> show alert
Choose the alert log from the following homes to view:
1: diag/rdbms/pwiprv/PWICRM3
……………………………………
6: diag/asm/+asm/+ASM3
Q: to quit
Please select option:
Also, you can get more helpful information via "help show alert":
adrci> help show alert
Usage: SHOW ALERT [-p
[ [-tail [num] [-f]] | [-file
Purpose: Show alert messages.
Options:
[-p
The fields in the predicate are the fields:
ORIGINATING_TIMESTAMP timestamp
NORMALIZED_TIMESTAMP timestamp
ORGANIZATION_ID text(65)
COMPONENT_ID text(65)
HOST_ID text(65)
HOST_ADDRESS text(17)
MESSAGE_TYPE number
MESSAGE_LEVEL number
MESSAGE_ID text(65)
MESSAGE_GROUP text(65)
CLIENT_ID text(65)
MODULE_ID text(65)
PROCESS_ID text(33)
THREAD_ID text(65)
USER_ID text(65)
INSTANCE_ID text(65)
DETAILED_LOCATION text(161)
UPSTREAM_COMP_ID text(101)
DOWNSTREAM_COMP_ID text(101)
EXECUTION_CONTEXT_ID text(101)
EXECUTION_CONTEXT_SEQUENCE number
ERROR_INSTANCE_ID number
ERROR_INSTANCE_SEQUENCE number
MESSAGE_TEXT text(2049)
MESSAGE_ARGUMENTS text(129)
SUPPLEMENTAL_ATTRIBUTES text(129)
SUPPLEMENTAL_DETAILS text(129)
PROBLEM_KEY text(65)
[-tail [num] [-f]]: Output last part of the alert messages and
output latest messages as the alert log grows. If num is not specified,
the last 10 messages are displayed. If "-f" is specified, new data
will append at the end as new alert messages are generated.
[-term]: Direct results to terminal. If this option is not specified,
the results will be open in an editor.
By default, it will open in emacs, but "set editor" can be used
to set other editors.
[-file
may not be in ADR.
Note that this option cannot be used with the -tail option
Examples:
show alert
show alert -p "message_text like '%incident%'"
show alert -tail 20
We can also get info detail from following oracle link:
來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/628922/viewspace-707619/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- Oracle11g 中使用ADRCI 檢視alert log檔案(xml格式)OracleXML
- Queries to view Alert Log content And Alert LocationView
- oracle11g之expdp產生library cache lock及tablespace autoextend off_alert logOracle
- Oracle11g_alert_logOracle
- alert log檔案的變化
- 警告日誌檔案alert_.log
- Alert Dialog "Done"按鈕定義.
- Linux : logrotate: ALERT exited abnormally with [1]LinuxlogrotateORM
- [Shell] monitor oracle alert.log file and sendmailOracleAI
- alert_log設定成external table
- Sskgxp_ip: Primary Interface Down In Alert Log
- 熟練使用alert.log日誌
- Manual Log Switching Causing Cannot Allocate New Log in Alert Log_435887.1
- Alert Log中回收站物件操作告警物件
- 8.Monitor oracle alert.log file and sendmailOracleAI
- PMON failed to acquire latch, see PMON dump in alert logAIUI
- Oracle清理trace、alert、aud、listener.log檔案Oracle
- console.log()和alert()區別
- Alert.log shows No Standby Redo Logfiles Of Size 153600 Blocks AvailableBloCAI
- [Shell] Monitor other host oracle instance alert.log and mailOracleAI
- Oracle 警告日誌 (alert log) 中包含哪些內容 ?Oracle
- Oracle11g使用LOGMNR挖掘日誌Oracle
- 9.Monitor other host oracle instance alert.log and mailOracleAI
- 'PMON failed to acquire latch, see PMON dump' in Alert Log-976714.1AIUI
- Failed to start the Clusterware. Last 20 lines of the alert log follow:AIAST
- Alert.log shows No stdby Redo Logfiles Of Size 153600 Blocks Available-405836.1BloCAI
- [Oracle] Oracle11g listener.log清除步驟Oracle
- 一個簡單的自動備份alert log指令碼指令碼
- [20150505]關於alert.log檔案.txt
- Alert Log中“Fatal NI connect error 12170”錯誤問題Error
- 從Alert_Log看Oracle資料庫啟動三階段Oracle資料庫
- JavaScript alert()JavaScript
- android漂亮的對話方塊專案sweet-alert-dialogAndroid
- Oracel 12c Alert日誌中的Creating new log segment
- [20140311]toad 12 alert log viewer.txtView
- 11g alert log中的automatic SQL Tuning及Resource Manager planSQL
- oracle alert日誌每天截斷truncate_alert.shOracle
- ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dgASMAI