探索Oracle之数据库升级九 12.1.0.1 Update 12.1.0.2

探索Oracle之数据库升级九

12.1.0.1 Update 12.1.0.2

一、检查当前数据库版本及系统信息

SQL> set line 300
SQL> set pagesize 1000
SQL> r 
  1* select * from v$version

BANNER CON_ID
-------------------------------------------------------------------------------- ----------
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production 0
PL/SQL Release 12.1.0.2.0 - Production 0
CORE 12.1.0.2.0 Production 0
TNS for Linux: Version 12.1.0.2.0 - Production 0
NLSRTL Version 12.1.0.2.0 - Production 0

十、检查各组件版本:

SQL> select comp_name,version,control,status from dba_server_registry;

COMP_NAME VERSION CONTROL STATUS
---------------------------------------- ------------- -------- ---------------
Oracle Database Vault 12.1.0.2.0 SYS VALID
Oracle Application Express 4.2.5.00.08 SYS VALID
Oracle Label Security 12.1.0.2.0 SYS VALID
Spatial 12.1.0.2.0 SYS VALID
Oracle Multimedia 12.1.0.2.0 SYS VALID
Oracle Text 12.1.0.2.0 SYS VALID
Oracle Workspace Manager 12.1.0.2.0 SYS VALID
Oracle XML Database 12.1.0.2.0 SYS VALID
Oracle Database Catalog Views 12.1.0.2.0 SYS VALID
Oracle Database Packages and Types 12.1.0.2.0 SYS VALID
JServer JAVA Virtual Machine 12.1.0.2.0 SYS VALID
Oracle XDK 12.1.0.2.0 SYS VALID
Oracle Database Java Packages 12.1.0.2.0 SYS VALID
OLAP Analytic Workspace 12.1.0.2.0 SYS VALID
Oracle OLAP API 12.1.0.2.0 SYS VALID
Oracle Real Application Clusters 12.1.0.2.0 SYS OPTION OFF

16 rows selected.

SQL> select owner, object_name, object_type, status from dba_objects where status=\'INVALID\' order by 1, 2,3;

no rows selected

SQL>

十一、open 所有PDBs，并查看PDBs状态

SQL> show pdbs 

    CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED READ ONLY NO
         3 PDB01 MOUNTED
         4 WOO_ORA11G MOUNTED
SQL> alter pluggable database all open;

Pluggable database altered.

SQL> show pdbs;

    CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED READ ONLY NO
         3 PDB01 READ WRITE NO
         4 WOO_ORA11G READ WRITE NO