My Oracle Support Banner

DBMS_INTERNAL_LOGSTDBY Is No Longer Valid After Upgrade To 10.2.0.5 (Doc ID 1631835.1)

Last updated on AUGUST 04, 2018

Applies to:

Oracle Database - Enterprise Edition - Version 10.2.0.5 to 10.2.0.5 [Release 10.2]
Information in this document applies to any platform.

Symptoms

Package DBMS_INTERNAL_LOGSTBY is invalid after upgrade to 10.2.0.5.
Trying to use this package results in errors:

ORA-06502: PL/SQL: numeric or value error: host bind array too small
ORA-06512: at line 1

 The catupgrd.sql script output contains error ORA-01950 no privileges on tablespace 'SYSAUX' when creating the following objects:

create index system.logstdby$events_ind                             
       on system.logstdby$events (event_time asc) tablespace SYSAUX;

create table system.logstdby$skip_support (                                       
  action          number not null,    /* number as seen in sys.audit_actions */   
                   /* reserving actions 0 & -1 for internal skip schema list */   
  name            varchar2(30) not null,         /* action to skip or schema */   
  spare1          number,                                /* Future expansion */   
  spare2          number,                                /* Future expansion */   
  spare3          varchar2(2000)                         /* Future expansion */   
) tablespace SYSAUX    

 There may be subsequent ORA-942 errors recorded, due to subsequent SQL or PL/SQL statements that reference table system.logstdby$skip_support.                                                       

 

Changes

 An upgrade to 10.2.0.5 has taken place.

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.