数据库版本:Release 11.1.0.6.0 - Production
错误代码:ora-03137
导致结果:业务访问不了;
暂时解决办法:重启监听;
数据库ip: 192.168.0.66
下面是我的log的内容:Errors in file /opt/
oracle11g/diag/rdbms/mmm/mmm/trace/mmm_ora_7098.trc:
ORA-03137: TTC protocol internal error : [1010] [] [] [] [] [] [] []
这个故障,已经出现了两次了;
我的思路:ora 03137是ORA-03137: TTC protocol internal error。ttc是负责字符集转换的,加上又是protocol的错误,而且监听重启就好,锁定是监听的问题。我觉得两个可能:
(1) 用11g版本的数据库的监听去连接其他版本的(比如10g)的数据库,在字符集转换的时候,监听出错。
(2) oracle本身的bug,需要到metalink上下载新的补丁,或者在metalink上面求助。按照这个思路,我把tsname.ora找出来:test =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = **.**.**.**(也就是172.20.1.66对应的外网ip))(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mmm)
)
)
172.20.1.59 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.59)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = ORCL)
)
)
172.20.1.63 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.63)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mmm)
)
)
172.20.1.66 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 172.20.1.66)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = mmm)
)
)
并且:172.20.1.59:
Release 11.1.0.6.0 - Production
172.20.1.66
Release 11.1.0.6.0 - Production
172.20.1.63
Release 11.1.0.6.0 - Production
发现版本其实是一致的,那么我的第一个思路不符合这个情况。可是我11g目前又没有metalink帐户可以使用,希望老大有知道这个错误的帮忙看看!
本站仅提供存储服务,所有内容均由用户发布,如发现有害或侵权内容,请
点击举报。