Re: Hanganalyze not working on 11.1.0.7 on Windows

  • From: Ron Chennells <ron.chennells@xxxxxxxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 09 Nov 2010 13:59:46 +0000

Not used this on windows
But the -prelim worked fine on UNIX platforms in RAC enviroments as in the script below. 


#!/sbin/sh -x
#
# Script to generate trace file when an instance is hung and not accepting connections # Based on article in http://www.databasejournal.com/features/oracle/article.php/3619681/DBA-from-Crisis-to-Confidence.htm 
#
#

sqlplus -prelim / as sysdba <<EOF
oradebug setmypid
oradebug unlimit
oradebug -g all   hanganalyze 3
--wait a minute or two here...
!sleep 120
oradebug -g all   hanganalyze 3
exit
EOF







Quoting Taral Desai <taral.desai@xxxxxxxxx>:



--
//www.freelists.org/webpage/oracle-l

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 11-2010