Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle service instance terminated when query contains OPTONAL clauses

630782Nov 3 2009 — edited Nov 18 2009
Hi,

I have a query containing the following clause together with a few other clauses:
OPTIONAL {?eClsId i:entrezId ?eEntrezId . ?eEntrezId i:geneBookId ?eGeneBookId}
OPTIONAL {?oClsId i:entrezId ?oEntrezId . ?oEntrezId i:geneBookId ?oGeneBookId}

When I executed the query the Oracle service instance will shut down abnormally. (OracleServiceORCL service terminated unexpectedly as shown in the Event log.)

I tried to remove one OPTIONAL clause from above and then the query can run. However I really need to have both of them.

I'm running Oracle 11.1.0.7 x64 with Patch set 7600122 installed.

Any idea what could be the cause here? Is there any walk-around? Thanks,

Weihua

Comments

Anilkumar Bhagavatula-Oracle

Try Softreset which will shutdown and will start again equivalent to reboot

1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Dec 16 2009
Added on Nov 3 2009
1 comment
2,670 views