Automatic Diagnostic Repository Command Interpreter (adrci)
Automatic Diagnostic Repository Command Interpreter (adrci) is the command line interpreter which we can work with the incidents
all the incidents are created in the directory knows as the incident.. to check the specific incident which is belonging to particular home then we need to set the home path to that incident directory..
fusion applications default uses ADR to diagnostic the problem the create the incident we can use the adrci with fusion applications and middle ware and database
To start the adrci from the fusion applictions go to the below path
/u01/oracle/fa/products/fusionapps/wlserver_10.3/server/adr
[oracle@fah adr]$ ./adrci
ADRCI: Release 11.1.0.7.0 - Production on Sun Sep 30 15:55:05 2012
Copyright (c) 1982, 2009, Oracle and/or its affiliates. All rights reserved.
No ADR base is set
adrci>
we need to set the ADR base before checking the incidents
SET BASE
SYNTAX: SET BASE <value of the oracle adr path>
SYNTAX: SET BASE <value of the oracle adr path>
we need to set the adr base according to the managed server which we are going to look for the diagnostics and the home for the managed servers will be automatically set when we are setting ADR Base
for example we need to look the issue in the general ledger server which is located under the Finance domain then we need to set the adr path for the general ledger server
for example we need to look the issue in the general ledger server which is located under the Finance domain then we need to set the adr path for the general ledger server
adrci> SET BASE /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr
adrci> show BASE
ADR base is "/u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr"
To check the trace files in all the incidents we can use the show trace file command which will display all the trace files belonging to the particular managed server which we had set during the ADR PATH
adrci> SHOW TRACEFILE
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/odl_quicktrace72_i25.dmp
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/dms_metrics71_i25.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/odl_logs73_i25.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/readme.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/jvm_threads70_i25.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_24/dms_metrics34_i24.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_24/odl_quicktrace35_i24.dmp
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_24/readme.txt
It will display all the incidents trace file
For Displaying All the trace files from one incident
we need to use the i option ... after the i option if we are giving incident names then it will display all the incident trace files which is under that particular incident's we give one or more incident numbers after the option i
SYNTAX : SHOW TRACEFILE -i <incident_number>
adrci> show tracefile -i 227
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/adf_ADFConfigDiagnosticDump366_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/jvm_threads360_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/diagnostic_image_GeneralLedgerServer_1_2012_08_26_16_29_41.zip
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_ecidctx365_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/odl_logs363_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/readme.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/odl_quicktrace362_i227.dmp
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_metrics361_i227.txt
For multiple incident numbers
we can specify the multiple incident numbers after the option i and it will display all the trace files belonging to that incidents
For displaying the trace files in the incident 227 and 25
SYNTAX : SHOW TRACEFILE -i <incident_number> <incident_number>
adrci> show tracefile -i 227 25
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/odl_quicktrace72_i25.dmp
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/dms_metrics71_i25.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/odl_logs73_i25.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/readme.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/jvm_threads70_i25.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/adf_ADFConfigDiagnosticDump366_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/jvm_threads360_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/diagnostic_image_GeneralLedgerServer_1_2012_08_26_16_29_41.zip
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_ecidctx365_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/odl_logs363_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/readme.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/odl_quicktrace362_i227.dmp
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_metrics361_i227.txt
Viewing the particular Trace file from all the incidents
we can select the particular trace files from all the incident's by using the %
Syntax SHOW TRACEFILE <%serch_value%>
adrci> show tracefile %metrics%
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_25/dms_metrics71_i25.txt
diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_24/dms_metrics34_i24.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_236/dms_metrics55_i236.txt
To view the Particular trace file from one incident
SYNTAX : SHOW TRACEFILE <%serch_value%> -i <incident_number>
adrci> show tracefile %metrics% -i 227
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_metrics361_i227.txt
Shorting the trace files according to the time stamp which is created or modified
There are two options we can use in shorting the the trace files
Option rt is used to reversed modified timestamps [desending order shot ]
SYNTAX: SHOW TRACEFILE <%serch_condition%> -i <indient_number>... <incident_number_n> -rt
adrci> show tracefile %metrics% -i 227 226 225 -rt
26-AUG-12 16:29:43 diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_metrics361_i227.txt
25-AUG-12 12:44:07 diag/ofm/fusionapps/LedgerApp/incident/incdir_226/dms_metrics353_i226.txt
25-AUG-12 12:40:09 diag/ofm/fusionapps/LedgerApp/incident/incdir_225/dms_metrics345_i225.txt
Option t is used for time stamp [ascending order ]
SYNTAX: SHOW TRACEFILE <%serch_condition%> -i <indient_number>... <incident _number_n> -t
adrci> show tracefile %metrics% -i 227 226 225 -t
25-AUG-12 12:40:09 diag/ofm/fusionapps/LedgerApp/incident/incdir_225/dms_metrics345_i225.txt
25-AUG-12 12:44:07 diag/ofm/fusionapps/LedgerApp/incident/incdir_226/dms_metrics353_i226.txt
26-AUG-12 16:29:43 diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_metrics361_i227.txt
SHOW PROBLEM Command in adrci
To display all the problems in the manged server which is set during the ADR PATH ... if it is using multiple homes then from each home it will display the problem separately
it will display the problem information. By default, this command will only show the last 50 problems
adrci> SHOW PROBLEM
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
7 DFW-99998 [java.net.SocketTimeoutException][oracle.bpel.ser 25 2012-08-31 18:27:38.590000 +04:00
10 DFW-99998 [oracle.adf.controller.ControllerException][oracl 22 2012-08-22 14:10:34.373000 +04:00
9 DFW-99998 [java.net.ProtocolException][oracle.bpel.services 21 2012-08-17 17:59:12.887000 +04:00
8 DFW-99998 [java.lang.IllegalStateException][oracle.security 20 2012-08-14 12:11:40.748000 +04:00
6 BEA-337 [WebLogicServer] 18 2012-07-27 13:30:33.255000 +04:00
5 BEA-101017 [HTTP][java.io.IOException] 17 2012-07-08 09:43:31.290000 +04:00
1 BEA-101017 [HTTP][javax.faces.FacesException] 14 2012-07-03 17:20:03.019000 +04:00
3 BEA-101017 [HTTP][javax.el.ELException] 13 2012-07-03 09:54:23.993000 +04:00
4 BEA-101017 [HTTP][weblogic.utils.NestedRuntimeException] 8 2012-07-01 23:08:43.399000 +04:00
2 BEA-101017 [HTTP][oracle.security.jps.JpsException] 6 2012-06-27 21:56:09.056000 +04:00
10 rows fetched
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/fusionapps/LedgerApp:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
8 DFW-99998 [javax.el.PropertyNotFoundException][oracle.adfin 260 2012-09-27 15:04:22.288000 +04:00
12 DFW-99998 [java.lang.NullPointerException][oracle.essbasedc 259 2012-09-27 14:55:01.854000 +04:00
7 ATK-3315012 [apps][atk.watchList.publicModel.applicationMod 258 2012-09-27 14:47:16.000000 +04:00
11 DFW-99998 [java.lang.NullPointerException][oracle.apps.fnd. 231 2012-08-29 10:28:38.217000 +04:00
10 DFW-99998 [java.util.MissingResourceException][oracle.javat 226 2012-08-25 12:44:05.946000 +04:00
6 DFW-99998 [oracle.adf.controller.ControllerException][oracl 221 2012-08-23 16:00:36.538000 +04:00
9 DFW-99998 [oracle.jbo.DeadEntityAccessException][oracle.jbo 213 2012-08-23 10:37:46.585000 +04:00
1 FUSIONAPPS-0 [apps][oracle.jbo.uicli.binding.JUFormBinding] 161 2012-07-09 14:55:08.370000 +04:00
2 FUSIONAPPS-0 [apps][fnd.applcore.messages.ExceptionHandlerB 159 2012-07-08 10:02:00.441000 +04:00
4 ATK-3315006 [apps][atk.watchList.protectedModel.view.AtkWat 120 2012-07-02 14:05:21.520000 +04:00
3 ATK-3315006 [apps][fnd.applcore.messages.messageService.app 119 2012-07-02 14:05:21.080000 +04:00
5 GL-781690 [apps][fnd.applcore.messages.messageService.appli 115 2012-07-02 13:52:04.574000 +04:00
12 rows fetched
To fetch the result for the specific problem id
In default it will display all the problem's belonging to the two oracle homes
SYNTAX :SHOW PROBLEM -p "problem_id"< relational oprator like < > = > <value of the problem id>
SHOW PROBLEM [-p <predicate_string>]
[-last <num> | -all]
[-orderby (field1, field2, ...) [ASC|DSC]]
To show the problem with the prediction option -p
we can use prediction option with the show problem command [-p <predicate_string>]: The predicate string must be double-quoted
SYNTAX SHOW PROBLEM -p "problem_id" [relational operator] [values]
adrci> show problem -p "problem_id>10"
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
0 rows fetched
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/fusionapps/LedgerApp:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
12 DFW-99998 [java.lang.NullPointerException][oracle.essbasedc 259 2012-09-27 14:55:01.854000 +04:00
11 DFW-99998 [java.lang.NullPointerException][oracle.apps.fnd. 231 2012-08-29 10:28:38.217000 +04:00
2 rows fetched
Show problem with the last option
This option allows users to either select the last <num> of qualified problems to display
Fetching the latest problem which the specified number if you want to fetch only the last 3 problem which belongs to the particular managed server then we need to use the parameter -last ans specify the value
SYNTAX SHOW PROBLEM -last <value in number>
adrci> show problem -last 3
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
7 DFW-99998 [java.net.SocketTimeoutException][oracle.bpel.ser 25 2012-08-31 18:27:38.590000 +04:00
10 DFW-99998 [oracle.adf.controller.ControllerException][oracl 22 2012-08-22 14:10:34.373000 +04:00
9 DFW-99998 [java.net.ProtocolException][oracle.bpel.services 21 2012-08-17 17:59:12.887000 +04:00
3 rows fetched
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/fusionapps/LedgerApp:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
8 DFW-99998 [javax.el.PropertyNotFoundException][oracle.adfin 260 2012-09-27 15:04:22.288000 +04:00
12 DFW-99998 [java.lang.NullPointerException][oracle.essbasedc 259 2012-09-27 14:55:01.854000 +04:00
7 ATK-3315012 [apps][atk.watchList.publicModel.applicationMod 258 2012-09-27 14:47:16.000000 +04:00
First 3 rows fetched (*** more available ***)
adrci order by statement
TO fetch the problem Related to the latest incident number then we need to specify the value as the LAST_INCIDENT if we specify the last incident and then use the DSC then it will display the problem which associated with the latest incident
if we are using the ASC as the parameter then it will display the problem which is generated first
SYNTAX :SHOW PROBLEM -last <value> -orderby <column name>
adrci> show problem -last 3 -orderby LAST_INCIDENT ASC
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
2 BEA-101017 [HTTP][oracle.security.jps.JpsException] 6 2012-06-27 21:56:09.056000 +04:00
4 BEA-101017 [HTTP][weblogic.utils.NestedRuntimeException] 8 2012-07-01 23:08:43.399000 +04:00
3 BEA-101017 [HTTP][javax.el.ELException] 13 2012-07-03 09:54:23.993000 +04:00
3 rows fetched
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/fusionapps/LedgerApp:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
5 GL-781690 [apps][fnd.applcore.messages.messageService.appli 115 2012-07-02 13:52:04.574000 +04:00
3 ATK-3315006 [apps][fnd.applcore.messages.messageService.app 119 2012-07-02 14:05:21.080000 +04:00
4 ATK-3315006 [apps][atk.watchList.protectedModel.view.AtkWat 120 2012-07-02 14:05:21.520000 +04:00
First 3 rows fetched (*** more available ***)
To display the problems which is latest then we need to use the dsc as the parameter with the LAST_INCIDENT ..
SYNTAX :SHOW PROBLEM -last <value> -orderby <column_name>dsc
adrci> show problem -last 3 -orderby LAST_INCIDENT dsc
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
7 DFW-99998 [java.net.SocketTimeoutException][oracle.bpel.ser 25 2012-08-31 18:27:38.590000 +04:00
10 DFW-99998 [oracle.adf.controller.ControllerException][oracl 22 2012-08-22 14:10:34.373000 +04:00
9 DFW-99998 [java.net.ProtocolException][oracle.bpel.services 21 2012-08-17 17:59:12.887000 +04:00
3 rows fetched
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/fusionapps/LedgerApp:
*************************************************************************
PROBLEM_ID PROBLEM_KEY LAST_INCIDENT LASTINC_TIME
-------------------- ----------------------------------------------------------- -------------------- ----------------------------------------
8 DFW-99998 [javax.el.PropertyNotFoundException][oracle.adfin 260 2012-09-27 15:04:22.288000 +04:00
12 DFW-99998 [java.lang.NullPointerException][oracle.essbasedc 259 2012-09-27 14:55:01.854000 +04:00
7 ATK-3315012 [apps][atk.watchList.publicModel.applicationMod 258 2012-09-27 14:47:16.000000 +04:00
First 3 rows fetched (*** more available ***)
Show Problem with incdir
TO show the incident directories which belongs to one managed server
SYNTAX :show incdir <id>
adrci> show incdir 227
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/fusionapps/LedgerApp:
*************************************************************************
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/adf_ADFConfigDiagnosticDump366_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/jvm_threads360_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/diagnostic_image_GeneralLedgerServer_1_2012_08_26_16_29_41.zip
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_ecidctx365_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/odl_logs363_i227.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/readme.txt
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/odl_quicktrace362_i227.dmp
diag/ofm/fusionapps/LedgerApp/incident/incdir_227/dms_metrics361_i227.txt
To show the incident directories between the two incident number
To display the incident directories between the two incident numbers
SYNTAX SHOW incdir <id> <id>
it will display all the incident directories between the 225 and 227
adrci> show incdir 225 227
Setting the browser from adrci
To display the reports in the browser we need to set the browser in the adrci
Syntax SET BROWSER <browser_program>
set browser mozilla
Show control command in adrci
The control command is used to set the purge policy of the adrci for one particular Home
SYNTAX SHOW CONTROL
adrci> SHOW CONTROL
DIA-48448: This command does not support multiple ADR homes
it will not support muliple homes
adrci> show home
ADR Homes:
diag/ofm/FinancialDomain/GeneralLedgerServer_1
diag/ofm/fusionapps/LedgerApp
set the home which you want to check
adrci> set home diag/ofm/FinancialDomain/GeneralLedgerServer_1
adrci> show home
ADR Homes:
diag/ofm/FinancialDomain/GeneralLedgerServer_1
adrci> show control
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2789093054 720 8760 2012-07-16 20:27:07.329903 +04:00 1 2 80 1 2012-03-05 10:33:45.523151 +04:00
1 rows fetched
SET CONTROL command in adrci
To set the purge policy for current oracle home we need to use the set control command
SYNTAX :SET CONTROL (<purge_policy>=<value>.........) the value is specified in hours
To set the purge policy we need to set the parameters SHORTP_POLICY or LONGP_POLICY
Setting the SHORTP_POLICY
The default value for the SHORTP_POLICY is 720 hours equal one month if we need to change the purging policy to one weak then we need to specify the value 168
set control (SHORTP_POLICY =168)
we can verify the setting by using the show control command
adrci> show control
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2789093054 168 8760 2012-10-01 11:39:57.924134 +04:00 1 2 80 1 2012-03-05 10:33:45.523151 +04:00
1 rows fetched
Setting the LONGP_POLICY
The default value for the longgp policy is one year and we can set according to our requirement
for setting the LONGGP policy for one month
set control ( LONGP_POLICY=720)
adrci> show control
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
ADRID SHORTP_POLICY LONGP_POLICY LAST_MOD_TIME LAST_AUTOPRG_TIME LAST_MANUPRG_TIME ADRDIR_VERSION ADRSCHM_VERSION ADRSCHMV_SUMMARY ADRALERT_VERSION CREATE_TIME
-------------------- -------------------- -------------------- ---------------------------------------- ---------------------------------------- ---------------------------------------- -------------------- -------------------- -------------------- -------------------- ----------------------------------------
2789093054 168 720 2012-10-01 11:48:33.861411 +04:00 1 2 80 1 2012-03-05 10:33:45.523151 +04:00
1 rows fetched
Show home command in adrci
To display the homes which is related to the ADR_PATH .. it may be a single home or multiple home which is related to that particular managed server
SYNTAX :SHOW HOME
adrci> show home
ADR Homes:
diag/ofm/FinancialDomain/GeneralLedgerServer_1
diag/ofm/fusionapps/LedgerApp
here there are two homes related too the general ledger server
Set Home command in adrci
To set the oracle home
SYNTAX : SET HOME <value for oracle home>
adrci> set home diag/ofm/FinancialDomain/GeneralLedgerServer_1
adrci> show home
ADR Homes:
diag/ofm/FinancialDomain/GeneralLedgerServer_1
SHOW ALERT command in adrci
To display the alert messages
it will open the vi editor with all the alert messages which belong to open particular oracle home
SYNTAX :SHOW ALERT
adrci> show alert
ADR Home = /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1:
*************************************************************************
Output the results to file: /tmp/alert_4219_13982_GeneralLedgerServer_1_1.ado
show alert with tail in adrci
To display the last particular number of alerts based on the number then we need to specify the number after the tail ommand
adrci> show alert -tail 5
2012-08-30 16:09:13.330000 +04:00
Errors in directory: /u02/oracle/fa/localconfig/domains/fahapp.oasiserp.com/FinancialDomain/servers/GeneralLedgerServer_1/adr/diag/ofm/FinancialDomain/GeneralLedgerServer_1/incident/incdir_24 (incident=24):
unhandled exception detected [java.net.SocketTimeoutException][oracle.bpel.services.workflow.client.worklist.util.WorkflowFilter.doFilter][LedgerApp]
.......................
Oracle Fusion Applications: Adrci Command In Fusion Applications >>>>> Download Now
ReplyDelete>>>>> Download Full
Oracle Fusion Applications: Adrci Command In Fusion Applications >>>>> Download LINK
>>>>> Download Now
Oracle Fusion Applications: Adrci Command In Fusion Applications >>>>> Download Full
>>>>> Download LINK r8