My Oracle Support Banner

Database Upgrade fails with Error: ORA-01950: no privileges on tablespace 'SYSAUX' (Doc ID 2542005.1)

Last updated on JULY 20, 2024

Applies to:

Oracle Database - Standard Edition - Version 12.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Database upgrade to  12.2.0.1 release failed as below :


Oracle Server
  ORA-06550: line 6, column 40: PL/SQL: ORA-00942: table or view does not exist

ORA-06550: line 6, column 5:
PL/SQL: SQL Statement ignored
ORA-06550: line 11,
column 26:
PL/SQL: ORA-00942: table or view does not exist


  ORA-01950: no privileges on tablespace 'SYSAUX'
  ORA-01950: no privileges on tablespace 'SYSAUX'
  ORA-06550: line 11, column 26: PL/SQL: ORA-00942: table or view does not exist


catupgrd0.log shows below message :

CREATE TABLE SYSTEM.LOGMNR_PDB_INFO$ (
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSAUX'

CREATE TABLE SYSTEM.LOGMNR_DID$ (
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'SYSAUX'

   select count(1) into n from system.logmnr_did$;
                                      *
ERROR at line 6:
ORA-06550: line 6, column 40:
PL/SQL: ORA-00942: table or view does not exist 

Changes

 

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.