My Oracle Support Banner

datapatch Fails with Error: ORA-01950: no privileges on 'SYSAUX' & 'SYSTEM' (Doc ID 2738629.1)

Last updated on OCTOBER 04, 2023

Applies to:

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

Symptoms

Executing datapatch after applying 19.8 DB RU  or 19.9 DB RU to ORACLE_HOME,  fails with error:

Validating logfiles...done
Patch 35320081 apply: WITH ERRORS
  logfile: /oracle/cfgtoollogs/sqlpatch/35320081/25314491/35320081_apply_DB_<timestamp>.log (errors)
  -> Error at line 3250: script rdbms/admin/catlmnr.sql
      - ORA-01950: no privileges on tablespace 'SYSAUX'
  -> Error at line 8959: script rdbms/admin/catschv.sql
      - ORA-01950: no privileges on tablespace 'SYSTEM'
  -> Error at line 8977: script rdbms/admin/catschv.sql
      - ORA-01950: no privileges on tablespace 'SYSTEM'

 

35320081_apply_DB_<timestamp>.log shows:

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


SELECT * FROM system.scheduler_program_args WHERE 0=1
                      *
ERROR at line 2:
ORA-01950: no privileges on tablespace 'SYSTEM'

SELECT * FROM system.scheduler_job_args WHERE 0=1
                      *
ERROR at line 2:
ORA-01950: no privileges on tablespace 'SYSTEM'

 

 

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.