Re: Hanganalyze not working on 11.1.0.7 on Windows
From: Ron Chennells <ron.chennells_at_parkwestit.com>
Date: Tue, 09 Nov 2010 13:59:46 +0000
Message-ID: <20101109135946.5c4suq6bs4ooowss_at_webmail.cluster.switchmedia.co.uk>
Not used this on windows
But the -prelim worked fine on UNIX platforms in RAC enviroments as in the script below.
Date: Tue, 09 Nov 2010 13:59:46 +0000
Message-ID: <20101109135946.5c4suq6bs4ooowss_at_webmail.cluster.switchmedia.co.uk>
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_at_gmail.com>:
-- http://www.freelists.org/webpage/oracle-lReceived on Tue Nov 09 2010 - 07:59:46 CST