|
12cR1升级至19C,DBUA运行时报错:All default tablespaces storing Oracle-maintained dictionary objects must allow write operations during database upgrade.
--------------------------------------------------------------
环境:
OS:centos 7.8
DBMS:oracle 12.1.0.2
---------------------------------------------------------------
原因:是由于原数据库在升级前存在只读或者离线的表空间
解决办法:修改表空间为读写
[oracle@dbserver ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Mon Oct 19 03:01:59 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved
Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options
SQL> alter tablespace users read write;
Tablespace altered.
|
|