Introduction
Steps to use adrci tool in 11g
Posted by Sakthi Sethu Perumal
Oracle 11g introduces adrci tool. This tool is used to examine contents of ADR repository and also to package information related to a specific problem into a compressed (zip) file to send it to Oracle support.
To invoke the tool, log in as the Oracle software owner and type Adrci in the command line.
To list the tool command line commands, type the following:
adrci –help
To display the tool commands, type the following command in the
Adrci command line:
adrci>help
To obtain guiding information about specific command, type the following:
adrci>help show incident
adrci commands will run on the ADR root (known when dealing with this toolas ADR base).
To display the ADR base directory the tool is handling, type the following in the adrci command:
adrci>show base
adrci tool can deal with all the Oracle homes under the ADR base. If you want to specify which home should be handled by the tool, you must specify the current homepath
. If you do not specify the current homepath, all the homes will be handled by the tool.
To display homes under the ADR root, issue the following command:
adrci>show homes
To display the current ADR homepath, issue the following command:
adrci>show homepath
To set the current ADR home, issue the following command:
adrci>set homepath diag\rdbms\ora11g\ora11g
Note
You can specify multiple homes as current homepaths. In this case, adrci tool will deal with all the
specified current homepaths. However, not all adrci commands can work with multiple current
homepaths.
Any text output from adrci can be captured and saved in an external text file using spool command:
adrci>spool /u01/myfiles/myadrci.txt
adrci> …
adrci>spool off
Using adrci to View the Alert Log
By default, adrci displays the alert log in your default editor. You can use the SET EDITOR
command to change your default editor.
adrci>set editor notepad.exe
To display contents of the alert log file (xml tags will be excluded), issue the following command:
adrci>show alert
To see only the last 30 messages in the alert, modify the command as follows:
adrci>show alert –tail 30
To display messages containing ORA-600 errors, issue the following command:
adrci>show alert –p “MESSAGE TEXT LIKE ‘%ORA-600%’*
Using adrci to List Trace Files
Trace files can be listed in adrci using the following command:
adrci>show tracefile
Using adrci to View Incidents
Use the following command to obtain a report about all the incidents in the current homepath(s):
adrci>show incident
If you want to obtain further details about an incident, issue the command with –p(predicate string) option:
adrci>show incident –mode detail –p “incident_id=112564”
You can use many fields in the predicate options.To list all available fields, issue the command
describe incident
Using adrci to Package Incidents
With adrci tool, you can package all the diagnostic files related to specific problems into a ZIP file to submit it to Oracle support. To do so, you use special commands called IPS as shown in the following steps:
- Create a logical package: useips create package command to create an empty logical package as shown in the example below. The package will be given a serially generated number.
adrci>ips create package
- Add diagnostic data to the logical package: this is done byips add incidentcommand as shown below:
adrci>ips add incident 112564 package 1
Actually, there are formats of the ips create package command which enables you to perform the steps 1 and 2 in one command. Following are those command formats:
O ips create package problem
O ips create package problem key
O ips create package incident
O ips create package time
- Generate the physical package. The files related to the incident will be collected in a ZIP file. Thefollowing example shows the command to perform this task:
adrci>ips generate package 1 in /u01/myfiles/incidents
If you decide to add or change any diagnostic data later, you can do so by generating an
Incremental ZIP file. Modify the command as follows to achieve that:
adrci>ips generate package 1 in /u01/myfiles/incidents incremental
You will notice that the generated file has the phase INC in its name indicating that it is an incremental ZIP file.
ips commands behavior is controlled by various configuration options. To display those configuration
options, use the command ips show configuration
