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 laterInformation 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'
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'
*
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 |