社区
基础和管理
帖子详情
关于TRC文件
hjj316
2011-04-21 02:35:20
系统是SOLARIS 9,机器为SUN-FIRE-440,数据库是ORACLE 10G 10.2.0.1.0-64bit,log_archive_start,sql_trace两个参数都设置为false,也做了归档处理。但是还是在/home/oracle/admin/orcl/udump目录下产生后缀为trc的文件,那位帮帮忙看怎么处理啊!先行谢过了!
...全文
323
13
打赏
收藏
关于TRC文件
系统是SOLARIS 9,机器为SUN-FIRE-440,数据库是ORACLE 10G 10.2.0.1.0-64bit,log_archive_start,sql_trace两个参数都设置为false,也做了归档处理。但是还是在/home/oracle/admin/orcl/udump目录下产生后缀为trc的文件,那位帮帮忙看怎么处理啊!先行谢过了!
复制链接
扫一扫
分享
转发到动态
举报
写回复
配置赞助广告
用AI写文章
13 条
回复
切换为时间正序
请发表友善的回复…
发表回复
打赏红包
hjj316
2011-04-23
打赏
举报
回复
01 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 c0 b3 8f 00 00 00 19 51 ff ff
ff ff 7b 34 09 c8 ff ff ff ff 7b 32 71 c8 ff ff ff ff 7b 33 9e 48 ff ff ff
ff 7b 34 4c 48 10 b3 8f 00 00 00 19 29 00 00 00 00 00 00 00 00 00 00 00 01
05 f1 1f e8 00 00 00 00 00 00 00 00 00 00 00 02 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00 00
hjj316
2011-04-23
打赏
举报
回复
我贴一下TRC文件的内容,高手帮我分析下
/home/oracle/admin/orcl/udump/orcl_ora_14199.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
ORACLE_HOME = /home/oracle/product/10g
System name: SunOS
Node name: dbsvr1
Release: 5.9
Version: Generic_117171-17
Machine: sun4u
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 14199, image: oracleorcl@dbsvr1
*** SERVICE NAME:(orcl) 2011-03-29 09:02:11.860
*** SESSION ID:(93.54979) 2011-03-29 09:02:11.859
oer 8102.2 - obj# 11458, rdba: 0x0140aa99(afn 5, blk# 43673)
kdk key 8102.2:
ncol: 1, len: 13
key: (13): 0c 4b 73 67 33 35 33 34 57 6e 20 20 20
mask: (4096):
hjj316
2011-04-23
打赏
举报
回复
[Quote=引用 8 楼 inthirties 的回复:]
呵呵呵,trc没有一定的根基和对Oracle深入的了解,是看不明白的。
[/Quote]
就是因为了解的不深,所以看的头大了,该怎么看啊!
zty598416146
2011-04-22
打赏
举报
回复
[Quote=引用 7 楼 hjj316 的回复:]
引用 2 楼 tianlesoftware 的回复:
可以根据trace 文件里的内容来判断下是哪种类型的trace。
之前遇到过一个bug。 每隔一段时间会产生一个trace文件。
那怎么查看TRACE文件中的有用的内容啊?哪个文件十几M,里面全是英文,数字,ASC码,看的头都大了!
[/Quote]
你跟着看一下基本上问题就能看明白了吧,一般都是写的比较清楚的。
inthirties
2011-04-22
打赏
举报
回复
呵呵呵,trc没有一定的根基和对Oracle深入的了解,是看不明白的。
hjj316
2011-04-22
打赏
举报
回复
[Quote=引用 2 楼 tianlesoftware 的回复:]
可以根据trace 文件里的内容来判断下是哪种类型的trace。
之前遇到过一个bug。 每隔一段时间会产生一个trace文件。
[/Quote]
那怎么查看TRACE文件中的有用的内容啊?哪个文件十几M,里面全是英文,数字,ASC码,看的头都大了!
inthirties
2011-04-22
打赏
举报
回复
trace文件,进行跟踪分析的。
hjj316
2011-04-22
打赏
举报
回复
那怎么样查看TRC文件里的内容,就是如何把一些不必要的内容剔除掉,只看有用的部分?
shadow1986a
2011-04-21
打赏
举报
回复
正常的,如果数据库内部某些对象出错,如表存在问题,数据文件出现坏块等都会有日志在这里记下 的。
Dave
2011-04-21
打赏
举报
回复
可以根据trace 文件里的内容来判断下是哪种类型的trace。
之前遇到过一个bug。 每隔一段时间会产生一个trace文件。
hjj316
2011-04-21
打赏
举报
回复
没有知道的吗?
.
trc
文件
转换工具,.
trc
转换为.asc工具
.
trc
文件
转换工具,.
trc
转换为.asc,特别实用
CAN网络报文
TRC
格式转ASC格式工具
CAN网络报文
TRC
格式转ASC格式工具
光时域反射仪OTDR光缆测试仿真软件:exfo otdr、可以打开sor,
trc
等
文件
格式,并进行断点、损耗等功能分析!
光时域反射仪OTDR光缆测试仿真软件:exfo otdr、可以打开sor,
trc
等
文件
格式,并进行断点、损耗等功能分析!
trc
等
文件
定时清理脚本.zip_oracle_thinqhz_归档及
trc
文件
自动清理脚本
Oracle数据库归档,
trc
,监听log自动清理脚本
dev_rfc.
trc
dev_rfc.
trc
基础和管理
17,377
社区成员
95,128
社区内容
发帖
与我相关
我的任务
基础和管理
Oracle 基础和管理
复制链接
扫一扫
分享
社区描述
Oracle 基础和管理
社区管理员
加入社区
获取链接或二维码
近7日
近30日
至今
加载中
查看更多榜单
社区公告
暂无公告
试试用AI创作助手写篇文章吧
+ 用AI写文章