DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




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:

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:

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 configuration
options, use the command ips show configuration

1 comment:

Sridevi K said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.