探索Oracle之数据库升级八12cDowngrade11gR2 - 数据库编程

om bootstrap$; COUNT(*) ---------- 60 1 row selected. SQL> select count(*) from bootstrap$; COUNT(*) ---------- 60 1 row selected. SQL> select count(*) from bootstrap$mig; COUNT(*) ---------- 60 1 row selected. SQL> select count(*) from bootstrap$mig; COUNT(*) ---------- 60 1 row selected. SQL> select count(*) from bootstrap$mig; COUNT(*) ---------- 60 1 row selected. SQL> SQL> WHENEVER SQLERROR CONTINUE SQL> SQL> begin 2 3 -- Now we can do the swap. 4 declare 5 procedure swap_bootstrap(replacement_tbl_name IN VARCHAR2) 6 is language c library DBMS_DDL_INTERNAL_LIB 7 name "swap_bootstrap" 8 with context 9 parameters(context, replacement_tbl_name String, 10 replacement_tbl_name LENGTH ub2, 11 replacement_tbl_name INDICATOR sb2); 12 begin 13 swap_bootstrap('BOOTSTRAP$MIG'); 14 end; 15 16 -- We've completed the swap. 17 -- Remove the BOOTSTRAP_DOWNGRADE_ERROR entry in props$. 18 delete from props$ where name = 'BOOTSTRAP_DOWNGRADE_ERROR'; 19 commit; 20 end; 21 / PL/SQL procedure successfully completed. SQL> SQL> Rem *********************************************************************** SQL> Rem END catdwgrd.sql SQL> Rem *********************************************************************** SQL> SQL> SQL> shutdown immediate Database closed. Database dismounted. ORACLE instance shut down. SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@woo ~]
三、修改/etc/oratab 为Oracle 12gR2 HOME目录

[root@woo ~]# vi /etc/oratab
woo:/DBSoft/oracle/product/11.2.4/dbhome_1

四、修改系统环境变量

[root@woo oracle]# vi ~/.bash_profile
[oracle@woo ~]$ echo $ORACLE_HOME
/DBSoft/oracle/product/11.2.4/dbhome_1

五、启动到upgrade模式，从降级版本$ORACLE_HOME/rdbms/admin目录中执行catrelod脚本

[oracle@woo ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Tue Dec 23 18:13:17 2014

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to an idle instance.

SQL> startup upgrade;
ORACLE instance started.

Total System Global Area 5027385344 bytes
Fixed Size 2261888 bytes
Variable Size 1191185536 bytes
Database Buffers 3825205248 bytes
Redo Buffers 8732672 bytes
Database mounted.
Database opened.
SQL>SQL> $ORACLE_HOME/rdbms/admin/catrelod.sql
……..

SQL> r
  1 SELECT comp_name, status, substr(version,1,10) as version
  2* from dba_server_registry order by modified

COMP_NAME STATUS
----------------------------------- --------------------------------------------
VERSION
----------------------------------------
OWB VALID
11.2.0.4.0

Oracle Database Packages and Types VALID
11.2.0.4.0

Oracle Database Catalog Views INVALID
11.2.0.4.0

JServer JAVA Virtual Machine VALID
11.2.0.4.0

Oracle XDK VALID
11.2.0.4.0

Oracle Database Java Packages VALID
11.2.0.4.0

Oracle Text VALID
11.2.0.4.0

Oracle XML Database VALID
11.2.0.4.0

Oracle Workspace Manager VALID
11.2.0.4.0

OLAP Analytic Workspace VALID
11.2.0.4.0

Oracle OLAP API VALID
11.2.0.4.0

Oracle Multimedia VALID
11.2.0.4.0

Spatial INVALID
11.2.0.4.0

Oracle Application Express INVALID
3.2.1.00.1

六、执行utlrp.sql脚本重新编译先前处于INVALID状态的所有现有PL/SQL模块

SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> Rem
SQL> Rem $Header: utlrp.sql 2

探索Oracle之数据库升级八12cDowngrade11gR2(二)