首页 数据库 mysql教程 用调试工具Dump Oracle系统状态

用调试工具Dump Oracle系统状态

Jun 07, 2016 pm 04:56 PM
oracle 数据

如果Oracle数据库hang了,对Oracle进行system dump或hang analyze,是研究和解决问题的有效方法。如果能够连接数据库,并进行

  如果Oracle数据库hang了,对Oracle进行system dump或hang analyze,是研究和解决问题的有效方法。如果能够连接数据库,并进行操作,则使用oradebug是最简单快捷的办法。

  但有的时候,数据库由于hang住,,sqlplus不能连接时(在10g可以尝试用sqlplus -prelim连接数据库),可以使用操作系统上的调试工具来dump oracle系统状态。因为我的环境是linux,所以我先从gdb来介绍。

  ①首先获得要dump的进程号

  ps -ef | grep LOCAL

  oracle    9015     1  0 12:28 ?        00:00:00 oracleretest (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))

  oracle    9110  8981  0 14:09 pts/4    00:00:00 grep LOCAL

  ②调用gdb进行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/libdbcfg10.so…done.

  Loaded symbols for /u01/app/oracle/product/10.1.0/db_1/lib/libdbcfg10.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

linux

本站声明
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn

热门文章

R.E.P.O.能量晶体解释及其做什么(黄色晶体)
2 周前 By 尊渡假赌尊渡假赌尊渡假赌
仓库:如何复兴队友
4 周前 By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒险:如何获得巨型种子
3 周前 By 尊渡假赌尊渡假赌尊渡假赌

热门文章

R.E.P.O.能量晶体解释及其做什么(黄色晶体)
2 周前 By 尊渡假赌尊渡假赌尊渡假赌
仓库:如何复兴队友
4 周前 By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island冒险:如何获得巨型种子
3 周前 By 尊渡假赌尊渡假赌尊渡假赌

热门文章标签

记事本++7.3.1

记事本++7.3.1

好用且免费的代码编辑器

SublimeText3汉化版

SublimeText3汉化版

中文版,非常好用

禅工作室 13.0.1

禅工作室 13.0.1

功能强大的PHP集成开发环境

Dreamweaver CS6

Dreamweaver CS6

视觉化网页开发工具

SublimeText3 Mac版

SublimeText3 Mac版

神级代码编辑软件(SublimeText3)

oracle数据库日志会保存多久 oracle数据库日志会保存多久 May 10, 2024 am 03:27 AM

oracle数据库日志会保存多久

oracle数据库启动步骤顺序为 oracle数据库启动步骤顺序为 May 10, 2024 am 01:48 AM

oracle数据库启动步骤顺序为

oracle中interval的用法 oracle中interval的用法 May 08, 2024 pm 07:54 PM

oracle中interval的用法

oracle中某个字符出现的次数怎么看出来 oracle中某个字符出现的次数怎么看出来 May 09, 2024 pm 09:33 PM

oracle中某个字符出现的次数怎么看出来

oracle需要多少内存 oracle需要多少内存 May 10, 2024 am 04:12 AM

oracle需要多少内存

oracle数据库服务器硬件配置要求 oracle数据库服务器硬件配置要求 May 10, 2024 am 04:00 AM

oracle数据库服务器硬件配置要求

用oracle数据库需要多大内存 用oracle数据库需要多大内存 May 10, 2024 am 03:42 AM

用oracle数据库需要多大内存

oracle定时任务每天都执行一次创建步骤 oracle定时任务每天都执行一次创建步骤 May 10, 2024 am 03:03 AM

oracle定时任务每天都执行一次创建步骤

See all articles