绑定完请刷新页面
取消
刷新

分享好友

×
取消 复制
A-00600 arguments: [kqlnrc_1]告警处理
2021-06-24 12:24:24

2021-06-23T15:42:xx.xx03237+08:00
Errors in file /oracle/diag/rdbms/xxxx28/xxxx282/trace/xxxx282_ora_413105.trc (incident=137235):
ORA-00600: internal error code, arguments: [kqlnrc_1], [0xBB1FFEDD8], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracle/diag/rdbms/xxxx28/xxxx282/incident/incdir_137235/xxxx282_ora_413105_i137235.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
2021-06-23T15:42:11.068080+08:00
*****************************************************************
An internal routine has requested a dump of selected redo.
This usually happens following a specific internal error, when
analysis of the redo logs will help Oracle Support with the
diagnosis.
It is recommended that you retain all the redo logs generated (by
all the instances) during the past 12 hours, in case additional
redo dumps are required to help with the diagnosis.
*****************************************************************


分析下trc文件
LibraryHandle: Address=0xbb1ffedd8 Hash=e144a9f7 LockMode=S PinMode=S LoadLockMode=0 Status=INVL
ObjectName: Name=HPJCGX.my107xx@TO_HDJK
FullHashValue=2d48ed64c43b11c473b06fd8e144a9f7 Namespace=TABLE/PROCEDURE(01) Type=SYNONYM(05) ContainerId=0 ContainerUid=0 Identifier=0 OwnerIdn=2147483644
/0xBB1FFEDD8
Size limits: 18446744073709551615
Size cbk: 0x2cf12d0
DDE alive update cbk: 0xd30b70
DDE alive start cbk: 0xd32910
DDE alive clear cbk: 0xd329f0
Custom Flood Control cbk: (nil)
----- END General DiagCtx Dump -----
----- DDE Diagnostic Information Dump -----
Depth: 1
DDE flags: 0x0
Heap: 0x7ffff7f1a328
Incident Context pointer in diag: 0x7fffffff1298
Incident ID Cache: 0x33a19a488
Invocation Context #: 0
----- Invocation Context Dump -----
Address: 0x7ffff7f1af48
Phase: 3
flags: 0x18E0001
Incident ID: 137235
Error Descriptor: ORA-600 [kqlnrc_1] [0xBB1FFEDD8] [] [] [] [] [] [] [] [] [] []

对象HPJCGX.my107xx@TO_HDJK失效

select object_name,object_type,owner from dba_objects where owner='HPJCGX' and segment_name='my107xx';


SQL> select username,host from dba_db_links where db_link='TO_HDJK' and username='HPJCGX';

USERNAME
--------------------
HOST
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
HPJCGX
(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.62.179)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xxxx121s) ) )

HPJCGX
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.190.85)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.190.86)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.190.96)(PORT = 1521))

USERNAME
--------------------
HOST
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
(ADDRESS = (PROTOCOL = TCP)(HOST = xx.xx.190.97)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = tmis1)
)
)

服务器到xx.xx.190.85/86/96/97不通

SQL> descIBMJCGX.my107xx@TO_HDJK;
ERROR:
ORA-02019: connection description for remote database not found


到62.179查询
SQL> select object_name,object_type,owner ,created from dba_objects where object_name='my107xx'

OBJECT_NAME OBJECT_TYPE OWNER CREATED
------------------------------ ----------------------- -------------------- -------------------
my107xx SYNONYM IBMJCGX 2019-10-18 14:51:51
my107xx TABLE IBMADMIN 2019-11-26 09:34:40

确认是同义词

SQL> select object_name,object_type,owner ,created,status from dba_objects where object_name='my107xx';

OBJECT_NAME OBJECT_TYPE OWNER CREATED STATUS
------------------------------ ----------------------- -------------------- ------------------- -------
my107xx SYNONYM IBMJCGX 2019-10-18 14:51:51 VALID
my107xx TABLE IBMADMIN 2019-11-26 09:34:40 VALID



同义词定义
SQL> set long 2000
SQL> select dbms_metadata.get_ddl(upper('SYNONYM'),upper('my107xx'),upper('HPJCGX')) METADATA from dual

METADATA
--------------------------------------------------------------------------------

CREATE OR REPLACE EDITIONABLE SYNONYM "HPJCGX"."my107xx" FOR "HPADMIN"."my107xx"

解决方式重新编译同义词,如果是非sys用户需要先删除同义词再重建的方式解决 。


SQL> alter synonym "HPJCGX"."my107xx" compile;

Synonym altered.

分享好友

分享这个小栈给你的朋友们,一起进步吧。

Oracle运维新鲜事-技术与管理各占半边天
创建时间:2020-08-04 11:34:57
本技术栈旨在分享技术心得,运维趣事,故障处理经验,调优案例,故障处理涉及集群,DG,OGG,大家生产中遇到的问题基本都会囊括了,我会发布生产库遇到的故障,希望在交流中互助互益,共同提高,也希望大家讨论,如果您有生产中遇到的集群问题,也可以在这里提出来,一起讨论,现实中也帮助不少同学解决了生产库的故障。
展开
订阅须知

• 所有用户可根据关注领域订阅专区或所有专区

• 付费订阅:虚拟交易,一经交易不退款;若特殊情况,可3日内客服咨询

• 专区发布评论属默认订阅所评论专区(除付费小栈外)

栈主、嘉宾

查看更多
  • Abraham林老师
    栈主
  • 小雨滴
    嘉宾
  • hawkliu
    嘉宾
  • u_97a59a25246404
    嘉宾

小栈成员

查看更多
  • 栈栈
  • dapan
  • 小菜鸟___
  • hwayw
戳我,来吐槽~