Adrci - Revision history

Stuart at 14:03, 28 November 2018

2018-11-28T14:03:56Z

2018-11-28T13:29:17Z

‎Create a package to send to Oracle Support

2018-11-28T13:28:32Z

‎Create a package to send to Oracle Support

2018-11-28T13:24:59Z

‎Shell script to purge ADR data

2018-11-28T13:16:44Z

‎adrci

2018-11-28T13:10:32Z

‎Purging trace and dump files in 11g with adrci

2018-11-28T13:09:17Z

‎adrci

2018-11-28T13:07:53Z

2018-07-23T10:27:22Z

‎Use command line interface from shell

2017-08-30T13:45:30Z

‎adrci

@@ Line 1: / Line 1: @@
 * [http://intermediatesql.com/oracle/oracle-11g-xml-alert-logs-surprise-they-are-actually-more-convenient-to-work-with/ Convenient access to adrci log files]
 * [http://arup.blogspot.co.uk/2013/04/switching-back-to-regular-listener-log.html Switch back to old-style listener log file - not using adr]
 The new way to package problems and their incidents up for Oracle Support.<br />
 A useful way to keep the purging of trace files under control.<br />

@@ Line 110: / Line 110: @@
 ===Create a package to send to Oracle Support===
 A problem may consist of one or more incidents.
-* Find the problem id
+====Find the problem id====
 <pre>
 show incident -mode detail -p "incident_id=<incident_id>"
 </pre>
-* create a package containing all incidents for this problem
+====Create a package containing all incidents for this problem====
 <pre>
 ips create package problem <proble_id> correlate all
 </pre>
-* generate a zipped package file
+====Generate a zipped package file====
 <pre>
 ips generate package <proble_id> in "/tmp"
 </pre>

@@ Line 111: / Line 111: @@
 A problem may consist of one or more incidents.
 * Find the problem id
 * create a package containing all incidents for this problem
 * generate a zipped package file

← Older revision		Revision as of 13:24, 28 November 2018
Line 108:		Line 108:
	echo “INFO: adrci purge finished at `date`”		echo “INFO: adrci purge finished at `date`”
	</pre>		</pre>
		+	===Create a package to send to Oracle Support===
		+	A problem may consist of one or more incidents.
		+	* Find the problem id
		+	* create a package containing all incidents for this problem
		+	* generate a zipped package file

@@ Line 1: / Line 1: @@
 * [http://intermediatesql.com/oracle/oracle-11g-xml-alert-logs-surprise-they-are-actually-more-convenient-to-work-with/ Convenient access to adrci log files]
 * [http://arup.blogspot.co.uk/2013/04/switching-back-to-regular-listener-log.html Switch back to old-style listener log file - not using adr]
 The new way to package problems and their incidents up for Oracle Support.<br />
 A useful way to keep the purging of trace files under control.<br />
@@ Line 56: / Line 55: @@
 adrci> show control
 </pre>
 ===Purging trace and dump files in 11g with adrci===
 SHORTP_POLICY and LONGP_POLICY are number of hours to keep trace files and alert files respectively. These can be changed by typing:

← Older revision	Revision as of 13:07, 28 November 2018
(No difference)

@@ Line 71: / Line 71: @@
 </pre>
-===Use command line interface from shell===
+===Use ADR command line interface from shell===
 <pre>
 adrci exec="show homes"
@@ Line 77: / Line 77: @@
 adrci exec="set home diag/tnslsnr/ravjde01/listener_ravjde1;set control (shortp_policy=360,longp_policy=720);purge;show control;"
 </pre>
 ===Shell script to purge ADR data===
 Found [http://www.dadbm.com/oracle-database-housekeeping-methods-adr-files-purge/ here]

@@ Line 25: / Line 25: @@
 </pre>
 tail the alert log (adrci reads the XML version of the alert log)
-</pre>
+<pre>
 show alert -tail -f
 </pre>