暂无图片
分享
Squidward Tentacles
2019-05-10
查询报错03113


Trace file /u01/app/oracle/diag/rdbms/qjdb/qjdb4/trace/qjdb4_ora_21975.trc
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Advanced Analytics and Real Application Testing options
ORACLE_HOME = /u01/app/oracle/product/12.1.0/dbhome_1
System name: Linux
Node name: qjdb4
Release: 3.8.13-98.7.1.el7uek.x86_64
Version: #2 SMP Wed Nov 25 13:51:41 PST 2015
Machine: x86_64
Instance name: qjdb4
Redo thread mounted by this instance: 4
Oracle process number: 416
Unix process pid: 21975, image: oracle@qjdb4


*** 2019-05-10 16:44:44.838
*** SESSION ID:(1029.55543) 2019-05-10 16:44:44.838
*** CLIENT ID:() 2019-05-10 16:44:44.838
*** SERVICE NAME:(qjdb) 2019-05-10 16:44:44.838
*** MODULE NAME:(plsqldev.exe) 2019-05-10 16:44:44.838
*** CLIENT DRIVER:() 2019-05-10 16:44:44.838
*** ACTION NAME:() 2019-05-10 16:44:44.838
 
2019-05-10 16:44:44.837: [    GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:469] (:GPNP01002:)SlfFopen2
Internal Error Information:
  Category: SLF_SYSTEM(-8)
  Operation: lstat failed
  Location: slsfopen3
  Other:
  Dep: 13
  Dep Message: Permission denied
2019-05-10 16:44:44.838: [    GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:471] Result: (7) CLSGPNP_IO. (:GPNP01002:)Failed to open wallet file. dir 'peer' in '/u01/app/12.1.0/grid/gpnp/qjdb4/wallets/', cannot check wallet home.
2019-05-10 16:44:44.865: [    GPNP]clsgpnp_dbmsGetItem_profile: [at clsgpnp_dbms.c:345] Result: (0) CLSGPNP_OK. (:GPNP00401:)got ASM-Profile.Mode='legacy'
2019-05-10 16:44:45.008: [    GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:469] (:GPNP01002:)SlfFopen2
Internal Error Information:
  Category: SLF_SYSTEM(-8)
  Operation: lstat failed
  Location: slsfopen3
  Other:
  Dep: 13
  Dep Message: Permission denied
2019-05-10 16:44:45.009: [    GPNP]clsgpnpkwf_initwfloc: [at clsgpnpkwf.c:471] Result: (7) CLSGPNP_IO. (:GPNP01002:)Failed to open wallet file. dir 'peer' in '/u01/app/12.1.0/grid/gpnp/qjdb4/wallets/', cannot check wallet home.
2019-05-10 16:44:45.036: [    GPNP]clsgpnp_dbmsGetItem_profile: [at clsgpnp_dbms.c:345] Result: (0) CLSGPNP_OK. (:GPNP00401:)got ASM-Profile.Mode='legacy'
*** MODULE NAME:(PL/SQL Developer) 2019-05-10 16:44:45.278
*** CLIENT DRIVER:() 2019-05-10 16:44:45.278
*** ACTION NAME:(SQL 窗口 - SELECT occupant_name, occupant_desc, schema_name, mov) 2019-05-10 16:44:45.278
 

*** 2019-05-10 16:44:45.278
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4] [PC:0xCE25066, qcdlgcd()+70] [flags: 0x0, count: 1]
DDE: Problem Key 'ORA 7445 [qcdlgcd]' was flood controlled (0x2) (incident: 512039)
ORA-07445: 出现异常错误: 核心转储 [qcdlgcd()+70] [SIGSEGV] [ADDR:0x4] [PC:0xCE25066] [Address not mapped to object] []
Dumping swap information
Memory (Avail / Total) = 45261.64M / 515884.41M
Swap (Avail / Total) = 131072.00M /  131072.00M
ssexhd: crashing the process...
Shadow_Core_Dump = PARTIAL
ksdbgcra: writing core file to directory '/u01/app/oracle/diag/rdbms/qjdb/qjdb4/cdump'

收藏
分享
3条回答
默认
最新
Moone

匹配Bug 20830993 - ORA-7445 [qcdlgcd] reported while running select statement - superseded (文档 ID 20830993.8)

打补丁或者设置参数规避:

ORA-7445 [qcdlgcd] may be reported while running a select statement
Rediscovery Notes
If a query fails in qcdlgcd and the execution plan (or 10053 trace) shows
an index-join being accepted, then you might be hitting this issue
Workaround
alter session set "_index_join_enabled"=false;
Note:
This fix is superseded by the fix in bug 21131203. For interim patches use that fix
instead of this one to address both issues.

暂无图片 评论
暂无图片 有用 0
章芋文

应该是12.1.0.2上index-join的一个bug,可以尝试禁用掉,或者升级到12.2

alter session set "_index_join_enabled"=false;
暂无图片 评论
暂无图片 有用 0
章芋文
问题已关闭: 问题已经得到解决
暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏