"SELECT FOR UPDATE OF" Hangs in 11.2.0.1 [ID 1081727.1] of Oracle Database when creating an instance under CommandCentral Enterprise Reporter (CCER).

Article:TECH184551  |  Created: 2012-03-22  |  Updated: 2012-07-21  |  Article URL http://www.symantec.com/docs/TECH184551
Article Type
Technical Solution


Environment

Issue



A known issue exists under the Oracle database release 11GR2 and subsequent releases. Referred to as "SELECT FOR UPDATE OF" Hangs in 11.2.0.1 [ID 1081727.1], the oracle documentation requires a passworded user account for access and can be found under support.oracle.com/CSP/main/article.

 


Error



During the CCER schema creation in the Oracle 11.2.0x instance the process hangs:

No errors.

Creating/replacing trigger SAHARA.T_VOLUME_3AI...

No errors.

Creating/replacing trigger SAHARA.T_VOLUME_BVIEW_NODE_AIUD...

No errors.

Creating/replacing package body SAHARA.T2_TRIGGER_HELPER...

No errors.

Creating/replacing package body SAHARA.TH_ROLLUP_BATCH...

It does not return from this creation.


Environment



Oracle 11GR2.0x

CCER 5.2, Ru1, RU2, RU3

Solaris

Windows


Cause



Oracle references:

Bug 9278351 "SELECT FOR UPDATE OF" HANGS IN 11.2.0.1
Base Bug 9294110 LEFT OUTER JOIN WITH FOR UPDATE CLAUSE HANGS FOREVER


Solution



 

Applies to:

Oracle Server - Enterprise Edition - Version: 11.2.0.1 - Release: 11.2
Information in this document applies to any platform.

Symptoms

"SELECT FOR UPDATE OF" Hangs in 11.2.0.1.

Following the below scenario on 11.2.0.1, the SELECT FOR UPDATE hangs:

drop table table1;
drop table table2;
create table table1 ( id number, text1 varchar2(30),text2 varchar(30) );
create table table2 ( id number, text1 varchar2(30),text2 varchar(30) );

SELECT table1.rowid
FROM table1 JOIN table2 t2 ON table1.id = t2.id
FOR UPDATE OF table1.text1,table1.text2;
 

Prior to attempting to complete the creation of the Oracle database schema for the CCER instance please ensure the proper execution of the oracleinstance check script as documented in the installation guide and Please apply Oracle Patch 9294110.


This issue is fixed by the fix of bug9294110 (which is a regression caused by bug7481833).After back-porting the changes for bug9294110 to 11.2.0.1, the testcase, for this bug, no longer fails. There is also another known regression of bug7481833 which is bug9120088. It is recommended to apply that back-port as well.

The Oracle Critical Patch Update page is avaialble online from their webpage at www.oracle.com/technetwork/topics/security/alerts-086861.html.




Article URL http://www.symantec.com/docs/TECH184551


Terms of use for this information are found in Legal Notices