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:
adrci –help
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>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 diagrdbmsora11gora11g
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:
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
command to change your default
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
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:
1. Create a logical package: use  ips create
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
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
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

  • August 31, 2014 | 38 views