ADRCI tool useful commands in Oracle

ADRCI tool for check the alert log, create incident and problem packages

ADRCI utility is launched in Oracle 11G version for checking the alert log files error through command based utility.
It is very helping tool for DBA to analysis the incident, problem and also help to upload trace files for oracle support.
Instead of searching the incident in alert log file by searching.

For login to ADRCI utility

1. Just get the session of the server.

2. Set the oracle_home and oracle_sid parameter for database.

3. Execute the adrci utility command.

#adrci
oracle@localhost/u01/app/oracle# adrci
ADRCI: Release 11.2.0.2.0 - Production on Tue Jul 23 15:25:00 2013
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
ADR base = "/u01/app/oracle"
adrci>

4. Check the present homes on the server with following commands.

#show homes
adrci> show homes
ADR Homes:
diag/rdbms/darvel/11
diag/tnslsnr/darvel/listener_11

5. You need to set the home which you want to check log file. In Oracle 11g, LISTENER and RDBMS home is at different location.

adrci> set homepath diag/tnslsnr/darvel/11

6. Check the alert log file error on the home location.

---For check the last lines of alert log
adrci> show alert –tail
--For checking last 200 line of alert log
adrci> show alert -tail 200
--For check the error message present in the alert log file
adrci> show alert -p "message_text like '%ORA-%' "
--For check the last 30 days error present in alert log file
adrci> show alert -p "message_text like '%ORA-%' and originating_timestamp > systimestamp-30"

7. For Purge diagnostic data that is over 1 day old (1440 minutes).

adrci> PURGE -age 1440 -type ALERT
--For purging incident data older than 1 day
adrci> purge -age 1440 -type incident
adrci> PURGE [[-i id1 | start_id end_id] | [-age mins [-type ALERT|INCIDENT|TRACE|CDUMP|HM|UTSCDMP]

8. Show all the incident happening in database.

adrci> show incident
adrci> show incident -p "incident_id = 40165 or incident_id = 145"
adrci> show incident -mode detail
adrci> show incident -mode detail -p "incident_id=33"
adrci> show incident -p "CREATE_TIME > '2011-09-18 21:35:25.012579 +00:00'"
adrci> show incident -p "problem_key='ORA 600 [ksmnfy2]'"
adrci> show incident -p "problem_key='ORA 700 [kfnReleaseASM1]'" -mode basic -last -all

9. Show the problem happening in database.

adrci> show problem
adrci> show problem -all
adrci> show problem -p "problem_id=44"
adrci> show problem -p "problem_key='ORA 600 [krfw_switch_4]'"

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.