11.2.0.1 Catupgrd.sql Hangs While Running Procedure POPULATE_DBID_AUDIT (Doc ID 1062993.1)

Last updated on MAY 30, 2014

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 to 11.2.0.1 [Release 11.2]
Oracle Database - Enterprise Edition - Version 9.2.0.7 to 9.2.0.7 [Release 9.2]
Information in this document applies to any platform.

Symptoms

When upgrading from 10.2 or 11.1 to 11.2.0.1,  catupgrd.sql calls c1101000.sql, which hangs while running the following commands:

populate_dbid_audit(schema, 'AUD$');
populate_dbid_audit('SYS', 'FGA_LOG$');


The catupgrd.sql spool file ends with below sql statements:

SQL> declare
2    schema     varchar2(32);
3  begin
4     -- First, check where is AUD$ present
5     select u.name into schema from obj$ o, user$ u
6            where o.name = 'AUD$' and
7                  o.type#=2 and
8                  o.owner# = u.user# and
9                  o.remoteowner is NULL and
10                  o.linkname is NULL and
11                  u.name in ('SYS', 'SYSTEM');
12
13     populate_dbid_audit(schema, 'AUD$');
14     populate_dbid_audit('SYS', 'FGA_LOG$');
15  end;
16  /


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms