cancel
Showing results for 
Search instead for 
Did you mean: 

OCI DB Link causes Oracle to dump core. Anyone seen this?

Level 2 Adventurer

OCI DB Link causes Oracle to dump core. Anyone seen this?

One of my developers is trying to get his queries to work through an Oracle link. This is what he gets:

 

psqldb=> insert into ebi.STU_MULT_PLN_WITH_MULT_CLS_T select * from STU_MULT_PLN_WITH_MULT_CLS_T@oracledb;
ERROR: OCI error: ORA-03114: not connected to ORACLE

 

And this is what I get on the Oracle side:

 

Errors in file /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/trace/DTR1STG_ora_17782.trc (incident=456641):
ORA-00600: internal error code, arguments: [kposclobrcbk-8], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/incident/incdir_456641/DTR1STG_ora_17782_i456641.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue May 29 10:00:06 2018
Dumping diagnostic data in directory=[cdmp_20180529100006], requested by (instance=1, osid=17782), summary=[incident=456641].
Errors in file /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/trace/DTR1STG_ora_17782.trc (incident=456642):
ORA-00600: internal error code, arguments: [17114], [0x7F0F5FF64368], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kposclobrcbk-8], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/incident/incdir_456642/DTR1STG_ora_17782_i456642.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Tue May 29 10:00:06 2018
Sweep [inc][456641]: completed
Sweep [inc][456642]: completed
Sweep [inc2][456641]: completed
Tue May 29 10:00:07 2018
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x7F0F642EB4D0] [PC:0xC66B4B0, kghfrh_internal()+448] [flags: 0x0, count: 1]
Errors in file /opt/oracle/diag/rdbms/dtr1stg/DTR1STG/trace/DTR1STG_ora_17782.trc (incident=456643):
ORA-07445: exception encountered: core dump [kghfrh_internal()+448] [SIGSEGV] [ADDR:0x7F0F642EB4D0] [PC:0xC66B4B0] [Address not mapped to object] []
ORA-00600: internal error code, arguments: [17114], [0x7F0F5FF64368], [], [], [], [], [], [], [], [], [], []
ORA-00600: internal error code, arguments: [kposclobrcbk-8], [], [], [], [], [], [], [], [], [], [], []

 

Three core dumps to one query. They are new errors in the ORA600 Diagnostic Tool. So I opend SR's for all three.

 

Anyone seen anything like this? 

 

The extension used to create the DB LINK is EDB_DBLINK_OCI

--Mark 

3 REPLIES
Highlighted
EDB Team Member

Re: OCI DB Link causes Oracle to dump core. Anyone seen this?

Hi Mark,

 

Error you metioned is found when network connectivity is poor or they server and client and gets disconnected in middle. Moreover, Is this only query you find issue with? In case, It's not only query then Oracle may answer this question.

 

Thanks & Regds,

Ninad Shah

Level 2 Adventurer

Re: OCI DB Link causes Oracle to dump core. Anyone seen this?

Nope. Not a poor network.

 

So far this is the only query causing the issue. The query runs fine in Oracle without any problems. 

 

There are three SR's open with Oracle and right now it is generating errors they have never seen before. And my favortie says file #203 is corrupt. And there IS NO file #203. 

 

--Mark 

EDB Team Member

Re: OCI DB Link causes Oracle to dump core. Anyone seen this?

Hi Mark,

 

Thank you for your response. Althought, It could be probably a corruption with oracle dictionaries about file 203 detail. However, I hardly think that could be related with error returned by query. This error seems quite different here. I assume this error repeats at every execution.

 

I referred line "ORA-07445: exception encountered: core dump [kghfrh_internal()+448] [SIGSEGV] [ADDR:0x7F0F642EB4D0] [PC:0xC66B4B0] ". This line speaks of segmentation fault(signal 11 in linux). This signal is majorly found in case of fault memory. Still, This could be a different case. It would be better If Oracle may answer this query first.

 

Meanwhile, If It's feasible for you to share table definition along with data at both oracle and EPAS ends then It would be really helpful.

 

Thanks & Regards,

Ninad Shah