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.
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.
Oracle software owner and type Adrci in the command line.
To list the tool command line
commands, type the following:
commands, type the following:
adrci –help
To display the tool commands, type
the following command in the
the following command in the
Adrci command line:
adrci>help
To obtain guiding information about
specific command, type the following:
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).
when dealing with this toolas ADR base).
To display the ADR base directory
the tool is handling, type the following in the adrci
command:
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
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.
homepath, all the homes will be handled by the tool.
To display homes under the ADR root,
issue the following command:
issue the following command:
adrci>show homes
To display the current ADR homepath,
issue the following command:
issue the following command:
adrci>show homepath
To set the current ADR home, issue
the following command:
the following command:
adrci>set homepath diagrdbmsora11gora11g
Note
You can specify multiple homes as
current homepaths. In this case, adrci tool will deal with all the
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
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:
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
log in your default editor. You can use the SET EDITOR
command to change your default
editor.
editor.
adrci>set editor notepad.exe
To display contents of the alert log
file (xml tags will be excluded), issue the following command:
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:
the alert, modify the command as follows:
adrci>show alert –tail 30
To display messages containing
ORA-600 errors, issue the following command:
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 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):
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:
details about an incident, issue the command with –p(predicate string) option:
adrci>show incident –mode detail –p
“incident_id=112564”
“incident_id=112564”
You can use many fields in the
predicate options.To list all available fields, issue the command
predicate options.To list all available fields, issue the command
describe incident
.
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:
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.
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:
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:
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:
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
diagnostic data later, you can do so by generating an
Incremental ZIP file. Modify the
command as follows to achieve that:
command as follows to achieve that:
adrci>ips generate package 1 in /u01/myfiles/incidents
incremental
incremental
You will notice that the generated
file has the phase INC in its name indicating that it is an incremental ZIP file.
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
various configuration options. To display those configuration
options, use the command ips show configuration
Recent Posts
