Using the debugging tool DumpOracle system status

If the Oracle database has hang, it is an effective method to study and solve the problem by running systemdump or hanganalyze on Oracle. If you can connect to the database and perform

If the Oracle database has hang, system dump or hang analyze is performed on Oracle, which is an effective method to study and solve the problem. If you can connect to the database and perform

If the Oracle database has hang, system dump or hang analyze is performed on Oracle, which is an effective method to study and solve the problem. If you can connect to the database and perform operations, using oradebug is the easiest and quickest way.

However, sometimes, when the database is hang and sqlplus cannot be connected (you can try to connect to the database with sqlplus-prelim at 10 Gb ), you can use the debugging tool on the operating system to dump the oracle system status. Because my environment is linux, I will first introduce it from gdb.

① First obtain the process number for dump

Ps-ef | grep LOCAL

Oracle 9015 1 0? 00:00:00 maid (DESCRIPTION = (LOCAL = YES) (ADDRESS = (PROTOCOL = beq )))

Oracle 9110 8981 0 00:00:00 pts/4 grep LOCAL

② Call gdb for dump

Gdb $ ORACLE_HOME/bin/oracle 9015

GNU gdb Red Hat Linux (6.1post-1.20040607.62rh)

Copyright 2004 Free Software Foundation, Inc.

GDB is free software, covered by the GNU General Public License, and you are

Welcome to change it and/or distribute copies of it under certain conditions.

Type "show copying" to see the conditions.

There is absolutely no warranty for GDB. Type "show warranty" for details.

This GDB was configured as "i386-RedHat-linux-gnu "... (No debugging symbols found )... Using host libthread_db library "/lib/tls/libthread_db.so.1 ″.

Attaching to program:/u01/app/oracle/product/10.1.0/db_1/bin/oracle, process 9015

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libskgxp10.so... (No debugging symbols found )... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libskgxp10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libhasgen10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libhasgen10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libskgxn2.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libskgxn2.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libocr10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libocr10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libocrb10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libocrb10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libocrutl10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libocrutl10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libjox10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libjox10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libclsra10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libclsra10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libdb1_10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libdb1_10.so

Reading symbols from/u01/app/oracle/product/10.1.0/db_1/lib/libnnz10.so... Done.

Loaded symbols for/u01/app/oracle/product/10.1.0/db_1/lib/libnnz10.so

Reading symbols from/usr/lib/libaio. so.1... Done.

Loaded symbols for/usr/lib/libaio. so.1

Reading symbols from/lib/libdl. so.2... Done.

Loaded symbols for/lib/libdl. so.2

Reading symbols from/lib/tls/libm. so.6... Done.

Loaded symbols for/lib/tls/libm. so.6

Reading symbols from/lib/tls/libpthread. so.0... Done.

[Thread debugging using libthread_db enabled]

[New Thread-1219938624 (LWP 3765)]

Loaded symbols for/lib/tls/libpthread. so.0

Reading symbols from/lib/libnsl. so.1... Done.

Loaded symbols for/lib/libnsl. so.1

Reading symbols from/lib/tls/libc. so.6... Done.

Loaded symbols for/lib/tls/libc. so.6

Reading symbols from/lib/ld-linux.so.2... Done.

Loaded symbols for/lib/ld-linux.so.2

Reading symbols from/lib/libnss_files.so.2... Done.

Loaded symbols for/lib/libnss_files.so.2

0 × 006967a2 in _ dl_sysinfo_int80 () from/lib/ld-linux.so.2

(Gdb) print ksudss (10)

[Switching to Thread-1219938624 (LWP 9015)]

$1 = 213658428

(Gdb) detach

Detaching from program:/u01/app/oracle/product/10.1.0/db_1/bin/oracle, process 9015

(Gdb) quit