Oracle errorstack 工具 说明

Errorstack oradebug 命令类似,都是帮助我们诊断错误信息。有关oradebug 参考我的Blog

Oracle oradebug 命令 使用说明

http://blog.youkuaiyun.com/tianlesoftware/archive/2011/06/04/6525628.aspx

Errorstack事件:dump 错误栈信息,通常Oracle发生错误时前台进程将得到一条错误信息,但某些情况下得不到错误信息,可以采用这种方式得到Oracle错误。

使用errorstack 步骤:

1. 启用:

SQL> alter system set events='1438 trace name errorstack forever,level 10';

--表示当出现ORA-1438错误时,dump 错误栈和进程栈。

--在这里,我们关注哪些错误,就写上对应的代码就ok了。

2. 执行相关的SQL,获取跟踪文件

3. 关闭:

SQL> alter system set events='1438 trace name errorstack off';

或者使用oradebug

--启用

SQL> oradebug event 1000 trace name errorstack level 10;

Statement processed.

--关闭

SQL> oradebug event 1000 trace name errorstack off;

Statement processed.

示例:

SQL> alter system set events='600 trace name errorstack forever,level 10';

System altered.

SQL> select * from dba_data_files;

ERROR:

ORA-00600: internal error code, arguments: [ktfbhget-4], [6], [5], [], [], [],

[], []

no rows selected

SQL> alter system set events='600 trace name errorstack off';

System altered.

---获取trace name

SQL> oradebug setmypid

Statement processed.

SQL> oradebug tracefile_name

/u01/app/oracle/admin/dave1/udump/dave1_ora_29181.trc

SQL>

这里使用的是oradebug,这个比较方便,之前还有一个获取tracenamesql脚本,参考我的Blog

Oracle SQL Trace 10046 事件

http://blog.youkuaiyun.com/tianlesoftware/archive/2010/09/02/5857023.aspx

然后根据trace,分析相关的原因。

ITPUB 论坛上的一个完整示例:

一次ora-01438错误的处理

http://www.itpub.net/thread-956435-1-1.html

-------------------------------------------------------------------------------------------------------

Blog http://blog.youkuaiyun.com/tianlesoftware

Email: dvd.dba@gmail.com

DBA1 群:62697716(); DBA2 群:62697977() DBA3 群:62697850()

DBA 超级群:63306533(); DBA4 群: 83829929 DBA5群: 142216823

DBA6 群:158654907 聊天 群:40132017 聊天2群:69087192

--加群需要在备注说明Oracle表空间和数据文件的关系,否则拒绝申请

0 info it worked if it ends with ok 1 verbose cli [ 1 verbose cli 'E:\\nodeNvm\\nodejs\\node.exe', 1 verbose cli 'E:\\nodeNvm\\nodejs\\node_modules\\npm\\bin\\npm-cli.js', 1 verbose cli 'run', 1 verbose cli 'dev' 1 verbose cli ] 2 info using npm@6.14.13 3 info using node@v14.17.3 4 verbose run-script [ 'predev', 'dev', 'postdev' ] 5 info lifecycle ruoyi@3.8.5~predev: ruoyi@3.8.5 6 info lifecycle ruoyi@3.8.5~dev: ruoyi@3.8.5 7 verbose lifecycle ruoyi@3.8.5~dev: unsafe-perm in lifecycle true 8 verbose lifecycle ruoyi@3.8.5~dev: PATH: E:\nodeNvm\nvm\v14.17.3\node_modules\npm\node_modules\npm-lifecycle\node-gyp-bin;E:\work\communalization_manage_sxyd\node_modules\.bin;C:\ProgramData\Oracle\Java\javapath;C:\Windows\System32\HWAudioDriver;C:\Windows\system32;C:\Windows;C:\Windows\System32\Wbem;C:\Windows\System32\WindowsPowerShell\v1.0\;C:\Windows\System32\OpenSSH\;C:\Users\Administrator\AppData\Local\Microsoft\WindowsApps;E:\maven\apache-maven-3.9.6\bin;E:\Java\jdk1.8.0_73\bin;E:\MySQL\MySQL Server 8.0\bin;E:\Redis;E:\VScode\Microsoft VS Code\bin;E:\Xshell\;E:\Java\jdk1.8.0_73\jre\bin;E:\GIT\Git\cmd;E:\Tencent\微信web开发者工具\dll;C:\WINDOWS\system32;C:\WINDOWS;C:\WINDOWS\System32\Wbem;C:\WINDOWS\System32\WindowsPowerShell\v1.0\;C:\WINDOWS\System32\OpenSSH\;E:\Xftp\;E:\nodeNvm\nvm;E:\nodeNvm\nodejs;E:\nodeNvm\nvm\node_global;C:\Users\22782\AppData\Local\Microsoft\WindowsApps;E:\nodeNvm\nvm;E:\nodeNvm\nodejs; 9 verbose lifecycle ruoyi@3.8.5~dev: CWD: E:\work\communalization_manage_sxyd 10 silly lifecycle ruoyi@3.8.5~dev: Args: [ 10 silly lifecycle '/d /s /c', 10 silly lifecycle 'set NODE_OPTIONS=--openssl-legacy-provider & vue-cli-service serve' 10 silly lifecycle ] 11 silly lifecycle ruoyi@3.8.5~dev: Returned: code: 9 signal: null 12 info lifecycle ruoyi@3.8.5~dev: Failed to exec dev script 13 verbose stack Error: ruoyi@3.8.5 dev: `set NODE_OPTIONS=--openssl-legacy-provider & vue-cli-service serve` 13 verbose stack Exit status 9 13 verbose stack at EventEmitter.<anonymous> (E:\nodeNvm\nvm\v14.17.3\node_modules\npm\node_modules\npm-lifecycle\index.js:332:16) 13 verbose stack at EventEmitter.emit (events.js:375:28) 13 verbose stack at ChildProcess.<anonymous> (E:\nodeNvm\nvm\v14.17.3\node_modules\npm\node_modules\npm-lifecycle\lib\spawn.js:55:14) 13 verbose stack at ChildProcess.emit (events.js:375:28) 13 verbose stack at maybeClose (internal/child_process.js:1055:16) 13 verbose stack at Process.ChildProcess._handle.onexit (internal/child_process.js:288:5) 14 verbose pkgid ruoyi@3.8.5 15 verbose cwd E:\work\communalization_manage_sxyd 16 verbose Windows_NT 10.0.26100 17 verbose argv "E:\\nodeNvm\\nodejs\\node.exe" "E:\\nodeNvm\\nodejs\\node_modules\\npm\\bin\\npm-cli.js" "run" "dev" 18 verbose node v14.17.3 19 verbose npm v6.14.13 20 error code ELIFECYCLE 21 error errno 9 22 error ruoyi@3.8.5 dev: `set NODE_OPTIONS=--openssl-legacy-provider & vue-cli-service serve` 22 error Exit status 9 23 error Failed at the ruoyi@3.8.5 dev script. 23 error This is probably not a problem with npm. There is likely additional logging output above. 24 verbose exit [ 9, true ] 解决方法
最新发布
03-20
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值