探索Oracle之数据库升级六11.2.0.4.3Upgrade12c(12.2.0.1) - 数据库编程

/woo/preupgrade/preupgrade_fixups.sql Post-Upgrade Fixup Script (run shortly after upgrade): /DBSoft/cfgtoollogs/woo/preupgrade/postupgrade_fixups.sql ************************************************************ Fixup scripts must be reviewed prior to being executed. ************************************************************ ************************************************************ ====>> USER ACTION REQUIRED <<==== ************************************************************ The following are *** ERROR LEVEL CONDITIONS *** that must be addressed prior to attempting your upgrade. Failure to do so will result in a failed upgrade. 1) Check Tag: PURGE_RECYCLEBIN Check Summary: Check that recycle bin is empty prior to upgrade Fixup Summary: \"The recycle bin will be purged.\" You MUST resolve the above error prior to upgrade ************************************************************ SQL>

在这里已经把需要修改的相关操作封装到了preupgrade_fixups.sql脚本中，执行该脚本按照提示修复存在的问题即可。

4.2 主要需要修复如下问题:

ALTER SYSTEM SET PROCESSES=300 SCOPE=SPFILE;

@$ORACLE_HOME/rdbms/admin/emremove.sql

@$ORACLE_HOME/olap/admin/catnoamd.sql

EXECUTE dbms_stats.gather_dictionary_stats;

4.3 执行dbupgdiag.sql收集升级前信息

如果有异常参考Metalink ID:556610.1进行修改。

[oracle@db01 ~]$ ll dbupgdiag.sql 
-rwxr-xr-x 1 oracle oinstall 24140 Nov 20 04:52 dbupgdiag.sql

[oracle@db01 ~]$ sqlplus / as sysdba @dbupgdiag.sql

SQL*Plus: Release 11.2.0.4.0 Production on Thu Nov 20 05:04:47 2014
Copyright (c) 1982, 2013, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

Enter location for Spooled output:

Enter value for 1: 
SP2-0137: DEFINE requires a value following equal sign

20_Nov_2014_0504 .log

woo_
Enter value for log_path: /home/oracle/diag/
SP2-0606: Cannot create SPOOL file \"/home/oracle/woo_upgrade_diag.log/db_upg_diag_woo_20_Nov_2014_0504.log\"


                          *** Start of LogFile ***

  Oracle Database Upgrade Diagnostic Utility 11-20-2014 05:05:16

===============
Hostname
===============

db01

===============
Database Name
===============

WOO

===============
Database Uptime
===============

00:34 20-NOV-14

=================
Database Wordsize
=================

This is a 64-bit database

================
Software Version
================

Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

=============
Compatibility
=============

Compatibility is set as 11.2.0.0.0

================
Archive Log Mode
================

Database log mode Archive Mode
Automatic archival Enabled
Archive destination USE_DB_RECOVERY_FILE_DEST
Oldest online log sequence 151
Next log sequence to archive 153
Current log sequence 153

================
Auditing Check
================

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /DBSoft/admin/woo/adump
audit_sys_operations boolean FALSE
audit_syslog_level string
audit_trail string DB

================
Cluster Check
================

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean FALSE
cluster_database_instances integer 1

DOC>################################################################
DOC>
DOC> If CLUSTER_DATABASE is set to TRUE, change it to FALSE before
DOC> upgrading the database
DOC>
DOC>################################################################
DOC>#

===========================================
Tables

探索Oracle之数据库升级六11.2.0.4.3Upgrade12c(12.2.0.1)(四)