Monday, September 1, 2014
Using adrci Tool in 11g
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:
To display the tool commands, type the following command in the
Adrci command line:
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 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:
To display the current ADR homepath, issue the following command:
To set the current ADR home, issue the following command:
adrci>set homepath diag\rdbms\ora11g\ora11g
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
Any text output from adrci can be captured and saved in an external text file using spool command:
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:
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:
Using adrci to View Incidents
Use the following command to obtain a report about all the incidents in the current homepath(s):
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
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:
1. Create a logical package: use ips 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
2. Add diagnostic data to the logical package: this is done by ips add incident command 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
3. Generate the physical package. The files related to the incident will be collected in a ZIP file. The following 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 configurationoptions, use the command ips show configuration