Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Upgrade 11.2.0.3 to 11.2.0.4 Failing

2819810Dec 11 2015 — edited Dec 17 2015

Oracle Enterprise 11.2.0.3 to 11.2.0.4 upgrade on Windows 2008 R2. I'm running the upgrade script manually sqlplus / as sysdba which has DBA role. Not sure what permissions I need to add. Both tablespaces have plenty of free space and set to maxsize unlimited.

Oracle Server
.   ORA-01950: no privileges on tablespace 'SYSTEM'
.   ORA-00942: table or view does not exist
.   ORA-00942: table or view does not exist
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSAUX'
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSAUX'
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSAUX'
.   ORA-00942: table or view does not exist
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSAUX'
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSAUX'
.   ORA-01950: no privileges on tablespace 'SYSAUX'
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSAUX'
.   ORA-01950: no privileges on tablespace 'SYSTEM'
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSTEM'
.   ORA-00942: table or view does not exist
.   ORA-01950: no privileges on tablespace 'SYSAUX' ORA-06512: at
"SYS.DBMS_LOGMNR_D", line 245
ORA-06512: at line 32

.   ORA-06512: at "SYS.DBMS_LOGMNR_D", line 245 ORA-06512: at line 32

.   ORA-06512: at line 32
.                                       INVALID      11.2.0.4.0  00:16:20
JServer JAVA Virtual Machine
.                                         VALID      11.2.0.4.0  00:10:26
Oracle Workspace Manager
.                                         VALID      11.2.0.4.0  00:00:51
OLAP Analytic Workspace
.   ORA-01950: no privileges on tablespace 'SYSTEM' ORA-06512: at line 14

.   ORA-06512: at line 14
.   ORA-00942: table or view does not exist
.                                         VALID      11.2.0.4.0  00:00:24
OLAP Catalog
.                                         VALID      11.2.0.4.0  00:01:09
Oracle OLAP API
.                                         VALID      11.2.0.4.0  00:00:35
Oracle Enterprise Manager
.                                         VALID      11.2.0.4.0  00:09:37
Oracle XDK
.                                         VALID      11.2.0.4.0  00:00:36
Oracle Text
.                                         VALID      11.2.0.4.0  00:00:53
Oracle XML Database
.                                         VALID      11.2.0.4.0  00:03:26
Oracle Database Java Packages
.                                         VALID      11.2.0.4.0  00:00:12
Oracle Multimedia
.                                         VALID      11.2.0.4.0  00:03:06
Spatial
.                                         VALID      11.2.0.4.0  00:06:51
Oracle Expression Filter
.                                         VALID      11.2.0.4.0  00:00:13
Oracle Rules Manager
.                                         VALID      11.2.0.4.0  00:00:11
Oracle Application Express
.                                         VALID     3.2.1.00.10
Final Actions
.                                                                00:00:01
Total Upgrade Time: 00:55:00

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jan 14 2016
Added on Dec 11 2015
3 comments
1,497 views