探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤 - 数据库编程

******************************************* Oracle recommends removingall hidden parameters prior to upgrading. To view existing hiddenparameters execute the following command while connected AS SYSDBA: SELECT name,description fromSYS.V$PARAMETER WHERE name LIKE '\_%' ESCAPE '\' Changes will need to be madein the init.ora or spfile. ********************************************************************** Oracle recommends reviewingany defined events prior to upgrading. To view existing non-defaultevents execute the following commands while connected AS SYSDBA: Events: SELECT (translate(value,chr(13)||chr(10),'')) FROM sys.v$parameter2 WHERE UPPER(name) ='EVENT' AND isdefault='FALSE' Trace Events: SELECT (translate(value,chr(13)||chr(10),'')) from sys.v$parameter2 WHERE UPPER(name) = '_TRACE_EVENTS' ANDisdefault='FALSE' Changes will need to be madein the init.ora or spfile.

10、修改不满足项

SQL> show parametershared

 
NAME                                 TYPE        VALUE
----------------------------------------------- ------------------------------
hi_shared_memory_address             integer     0
max_shared_servers                   integer
shared_memory_address                integer     0
shared_pool_reserved_size            big integer 8M
shared_pool_size                     big integer 160M
shared_server_sessions               integer
shared_servers                       integer     1

SQL> alter system setshared_pool_size=800m scope=spfile;

 
System altered.

 

SQL> shutdown immediate

Database closed.
Database dismounted.
ORACLE instance shut down.

SQL> startup mountl

SP2-0714: invalidcombination of STARTUP options

SQL> startup mount;

ORACLE instance started.
Total System Global Area2872786944 bytes
Fixed Size                  2256712 bytes
Variable Size            2634023096 bytes
Database Buffers          218103808 bytes
Redo Buffers               18403328 bytes

Database mounted.

SQL>




 alter databaseflashback on;

 
###创建一个回滚点
SQL> create restore pointmaclean_rollback guarantee flashback database;

 
Restore point created.

 

SQL> select * fromv$restore_point;

 

       SCN DATABASE_INCARNATION# GUASTORAGE_SIZE
------------------------------- --- ------------

TIME
---------------------------------------------------------------------------
RESTORE_POINT_TIME                                                         PRE
------------------------------------------------------------------------------
NAME
--------------------------------------------------------------------------------
   1187867                     2 YES     52428800

04-OCT-14 02.41.43.000000000AM

                                                                           YES
MACLEAN_ROLLBACK

 

再次运行检查：

SQL>@?/rdbms/admin/utlu112i.sql

Oracle Database 11.2Pre-Upgrade Information Tool 10-04-2014 03:26:20
Script Version: 11.2.0.4.0Build: 001

.
**********************************************************************
Database:
**********************************************************************

--> name:          WOO
--> version:       11.2.0.3.0
--> compatible:    11.2.0.0.0
--> blocksize:     8192
--> platform:      Linux x86 64-bit
--> timezone file: V14

.
**********************************************************************
Tablespaces: [makeadjustments in the current environment]
**********************************************************************

--> SYSTEM tablespace isadequate for the upgrade.
.... minimum required size:917 MB
--> SYSAUX tablespace isadequate for the upgrade.
.... minimum required size:646 MB
--> UNDOTBS1 tablespaceis adequate for the upgrade.
.

探索Oracle之数据库升级二11.2.0.3升级到11.2.0.4完整步骤(六)