ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 单实例升级到10.2.4

单实例升级到10.2.4

原创 Linux操作系统 作者:hnhycwh 时间:2012-07-06 08:52:34 0 删除 编辑

一、先决条件

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博客 ” ,链接:http://blog.itpub.net/27131216/viewspace-734755/,如需转载,请注明出处,否则将追究法律责任。

下一篇: 软解析和硬解析
请登录后发表评论 登录
全部评论

注册时间:2012-07-05

  • 博文量
    14
  • 访问量
    3443