一、先决条件

1。表空间需求

system表空间至少10M空间可用

2。系统参数

show parameter shared_pool_size

show prameter java_pool_size

alter system set shared_pool_size='200M' scope=spfile;

alter system set java_pool_size='200M' scope=spfile;

3、升级前的版本检查

select * from v$version

二、实施升级

1。停止实例

emctl stop dbconsole

isqlplusctl stop

shutdown immediate

lsnrctl stop

2。备份目录和数据库

tar -cvf $ORACEL/BASE /orabak/

cp *.dbf con*.ora redo*.log /orabak/

su - oracle

./runIstanller

4。更新字典

startup upgrade

spool pathc.log

@?/rdbms/admin/catupgrd.sql

spool off

!grep "ORA_|Error" path.log -i

shutdown immediate

startup

@?/rdbms/admin/utlrp.sql

alter system set compatible='10.2.0.4.0' scope=spfile

rman catalog username/password@hhps

upgrade catalog;

select comp_name,version,status from sys.dba_registry;

select * from registry$

select * from v$vesion

select * from product_componetnt_Version

select version from v$instance;

select * from x$ksuxsinst

SELECT KS.INST_ID,

KSUXSINS,

KSUXSSID,

KSUXSHST,

KSUXSVER,

KSUXSTIM,

DECODE(KSUXSSTS,

0,

'STARTED',

1,

'MOUNTED',

2,

'OPEN',

3,

'OPEN MIGRATE',

'UNKNOWN'),

DECODE(KSUXSSHR, 0, 'NO', 1, 'YES', 2, NULL),

KSUXSTHR,

DECODE(KSUXSARC, 0, 'STOPPED', 1, 'STARTED', 'FAILED'),

DECODE(KSUXSLSW,

0,

NULL,

2,

'ARCHIVE LOG',

3,

'CLEAR LOG',

4,

'CHECKPOINT',

5,

'REDO GENERATION'),

DECODE(KSUXSDBA, 0, 'ALLOWED', 'RESTRICTED'),

DECODE(KSUXSSHP, 0, 'NO', 'YES'),

DECODE(KVITVAL,

0,

'ACTIVE',

2147483647,

'SUSPENDED',

'INSTANCE RECOVERY'),

DECODE(KSUXSROL,

1,

'PRIMARY_INSTANCE',

2,

'SECONDARY_INSTANCE',

'UNKNOWN'),

DECODE(QUI_STATE,

0,

'NORMAL',

1,

'QUIESCING',

2,

'QUIESCED',

'UNKNOWN'),

DECODE(BITAND(KSUXSDST, 1), 0, 'NO', 1, 'YES', 'NO')

FROM X$KSUXSINST KS, X$KVIT KV, X$QUIESCE QU

WHERE KVITTAG = 'kcbwst';

shutdown startup

lsnrctl start

isqlplusctl start

emclt start dbconsole

回退

shutdown

startup downgrade

spool downgrade.log

@catdwgrd.sql

spool off

shutdown immiediate

ITPub博客

单实例升级到10.2.4

最新文章