Maintenance - Revision history

Stuart at 12:48, 31 October 2018

2018-10-31T12:48:35Z

2016-12-13T14:03:54Z

2016-12-13T14:03:38Z

2013-10-10T11:42:38Z

2013-09-05T08:41:15Z

New page

* [[Purging trace and dump files in 11g with adrci]]

← Older revision		Revision as of 12:48, 31 October 2018
Line 2:		Line 2:
	* [[Rotate alert logs (alertlog) with shell script]]		* [[Rotate alert logs (alertlog) with shell script]]
	* [[Patching]]		* [[Patching]]
		+
		+	===Rotate the listener logs===
		+	Get hold of the listener log files using a method that should be usable for all versions from 9i. This can then be fed into the rotate script.
		+	<pre>
		+	#!/usr/bin/ksh
		+
		+	ps -ef \| grep tnslsnr \| grep inherit \| grep -v grep \| while read -r psline
		+	do
		+	listener_name=$(echo ${psline} \| awk '{print $(NF-1)}')
		+	listener_process=$(echo ${psline} \| awk '{print $(NF-2)}')
		+	ORACLE_HOME="$(echo ${listener_process} \| sed -e 's;/bin/tnslsnr;;')"
		+	export TNS_ADMIN=$(echo ${ORACLE_HOME}/network/admin)
		+
		+	listener_log_file=$(${ORACLE_HOME}/bin/lsnrctl status ${listener_name} \| awk '/Listener Log File/ {print $NF}')
		+	if [[ -r "${listener_log_file}" ]]; then
		+	echo rotate_listener_log "${listener_log_file}"
		+	else
		+	echo "No listener log file found for ${listener_name}, skipping."
		+	fi
		+	done
		+	</pre>

@@ Line 1: / Line 1: @@
 * [[Purging trace and dump files in 11g with adrci]]
 * [[Rotate alert logs (alertlog) with shell script]]
-* [Patching]
+* [[Patching]]

← Older revision		Revision as of 14:03, 13 December 2016
Line 1:		Line 1:
	* [[Purging trace and dump files in 11g with adrci]]		* [[Purging trace and dump files in 11g with adrci]]
	* [[Rotate alert logs (alertlog) with shell script]]		* [[Rotate alert logs (alertlog) with shell script]]
		+	* [Patching]

← Older revision		Revision as of 11:42, 10 October 2013
Line 1:		Line 1:
	* [[Purging trace and dump files in 11g with adrci]]		* [[Purging trace and dump files in 11g with adrci]]
		+	* [[Rotate alert logs (alertlog) with shell script]]