oracle如何升级 oracle 升级

关于如何从oracle10g的10.2.0.1升级到10.2.0.2

我把其摘抄下来，通过测试，是成功的，供大家参考。 oracle 10.2.0.1升级到10.2.0.2步骤： (for win32，升级前推荐对数据做备份，确保system表空间和sysaux有50M以上的剩余表空间) 1,停止oracle服务； 2,运行setup升级文件包，下拉选择要升级的db。安装结束。记得安装前一定要关闭sqlplus。 3,重启oracle服务； sqlplus / as sysdba; STARTUP NOMOUNT; ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile; ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile;shutdown 4，停止oralc服务； 5，重启oracle服务； sqlplus / as sysdba; SQL STARTUP UPGRADE SQL SPOOL patch.log SQL @ORACLE_BASE/ORACLE_HOME/rdbms/admin/catupgrd.sql //如果提示找不到文件，则需要指定路径。一定要等本sql执行完，命令行出现SQL 标记再执行下面的sql命令。执行过程中绝对不能关闭sqlplus，否则，你去哭吧。 SQL SPOOL OFF 6，SQL SHUTDOWN SQL STARTUP SQL @ORACLE_BASE/ORACLE_HOME/rdbms/admin/utlrp.sql //如果提示找不到文件，则需要指定路径。 如果使用了rman的恢复目录来备份的，还需要执行： C:/ rman catalogusername/password@aliasRMAN UPGRADE CATALOG; 7，重启oracle服务；注意： 1，推荐在安装oracle时，不要创建启动数据库，安装完以后，再运行升级补丁的setup包。这样风险较小 2，oracle10.2.0.3的升级和上面操作类似。

成都创新互联是专业的衢州网站建设公司，衢州接单;提供网站设计制作、成都网站制作,网页设计,网站设计,建网站,PHP网站建设等专业做网站服务;采用PHP框架,可快速的进行衢州网站开发网页制作和功能扩展;专业做搜索引擎喜爱的网站,专业的做网站团队,希望更多企业前来合作!

如何将oracle11.2.0.1升级到11.2.0.4

如何将oracle11.2.0.1升级到11.2.0.4

环境下Oracle 11.2.0.1升级到11.2.0.3的过程，当然RAC的升级是会有所不同。但是他们每个版本之间升级步骤都是差不多的，先升级Database Software，再升级Oracle Instance。 Oracle 11.2.0.4的Patchset No:19852360下载需要有Oracle Support才可

如何升级oracle版本

环境下Oracle 11.2.0.1升级到11.2.0.3的过程，当然RAC的升级是会有所不同。但是他们每个版本之间升级步骤都是差不多的，先升级Database Software，再升级Oracle Instance。 Oracle 11.2.0.4的Patchset No:19852360下载需要有Oracle Support才可...

怎样单独升级oracle的客户端

简单点就把心版本装好，然后将旧版本卸载即可。主要设置好环境变量即可。

如何升级Oracle Grid Infrastructure和RAC从11.2.0.3到11.2.0.4

为新版本的GI新建一个新home目录，解压升级包 执行安装程序 会自动检测到正在运行的cluster,选升级选项 ，目录选新home ，后面的按提示完成升级 升级好后更改环境变量指向新home

oracle怎么升级10.2.0.5

ORACLE10G 10.2.0.1升级到10.2.0.5 2014-06-06 17:23:17

OS: linux redhat 4 U8 64bit

DB: oracle 10.2.0.1

升级：oracle 10.2.0.5

对当前环境的查询

查看磁盘空间使用情况

[root@dongyang ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda2 18G 11G 6.2G 64% /

/dev/sda1 988M 42M 896M 5% /boot

tmpfs 1002M 0 1002M 0% /dev/shm

/dev/sdb1 12G 2.3G 9.0G 21% /u01

[root@dongyang ~]#

查看操作系统版本

[root@dongyang ~]# cat /proc/version

Linux version 2.6.32-200.13.1.el5uek (mockbuild@ca-build9.us.oracle.com) (gcc version 4.1.2 20080704 (Red Hat 4.1.2-50)) #1 SMP Wed Jul 27 21:02:33 EDT 2011

[root@dongyang ~]# uname -r

2.6.32-200.13.1.el5uek

[root@dongyang ~]#

查看当前数据库版本

SQL select * from v$version;

select * from v$version;

BANNER

----------------------------------------------------------------

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi

PL/SQL Release 10.2.0.1.0 - Production

CORE 10.2.0.1.0 Production

TNS for Linux: Version 10.2.0.1.0 - Production

NLSRTL Version 10.2.0.1.0 - Production

SQL

查看oracle用户环境变量

[oracle@dongyang ~]$ cat .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

fi

# User specific environment and startup programs

alias uni="uniread sqlplus"

export PATH

unset USERNAME

export ORACLE_BASE=/u01/app/oracle

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1

export PATH=$ORACLE_HOME/bin:$PATH

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib

export ORACLE_SID=fengzi

export NLS_LANG=AMERICAN_AMERICA.ZHS16GBK

export NLS_DATA_FORMAT="YYYY-MM-DD HH24:MI:SS"

export NLS_DATA_LANGUAGE="AMERICAN"

export DISPLAY=192.168.56.1:0.0

要先对数据库进行冷备与软件备份

备份数据库软件（磁盘空间足够）

[root@dongyang ~]# df -h

Filesystem Size Used Avail Use% Mounted on

/dev/sda2 18G 11G 6.2G 64% /

/dev/sda1 988M 42M 896M 5% /boot

tmpfs 1002M 0 1002M 0% /dev/shm

/dev/sdb1 12G 2.3G 9.0G 21% /u01

[root@dongyang ~]#

[root@dongyang ~]# mkdir /u02

[root@dongyang ~]# cd /u01

[root@dongyang u01]# cp -r * /u02

关闭当前数据库

[oracle@dongyang ~]$ echo $ORACLE_SID

fengzi

[oracle@dongyang ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jun 5 13:46:04 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production

With the Partitioning, OLAP and Data Mining options

SQL shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL

登录RMAN 启动数据库到mount状态

[oracle@dongyang ~]$ rman target /

Recovery Manager: Release 10.2.0.1.0 - Production on Thu Jun 5 13:48:42 2014

Copyright (c) 1982, 2005, Oracle. All rights reserved.

connected to target database (not started)

RMANstartup mount

database is already started

database mounted

备份当前控制文件

RMAN backup current controlfile;

Starting backup at 05-JUN-14

allocated channel: ORA_DISK_1

channel ORA_DISK_1: sid=322 devtype=DISK

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

channel ORA_DISK_1: starting piece 1 at 05-JUN-14

channel ORA_DISK_1: finished piece 1 at 05-JUN-14

piece handle=+DATA/fengzi/backupset/2014_06_05/ncnnf0_tag20140605t140242_0.380.849448965 tag=TAG20140605T140242 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:05

Finished backup at 05-JUN-14

Starting Control File and SPFILE Autobackup at 05-JUN-14

piece handle=+DATA/fengzi/autobackup/2014_06_05/s_849447979.381.849448969 comment=NONE

Finished Control File and SPFILE Autobackup at 05-JUN-14

备份数据库到 /u01/backup/目录下

RMAN backup database format '/u01/backup/2014_06_01_%U';

Starting backup at 05-JUN-14

using channel ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00001 name=+DATA/fengzi/datafile/system.277.842187103

channel ORA_DISK_1: starting piece 1 at 05-JUN-14

channel ORA_DISK_1: finished piece 1 at 05-JUN-14

piece handle=/u01/backup/2014_06_01_27pa3431_1_1 tag=TAG20140605T140417 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:01:15

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00007 name=/u01/app/oracle/oradata/FENGZI/datafile/o1_mf_wer_9ns1wd2n_.dbf

input datafile fno=00008 name=/u01/app/oracle/oradata/yyyy12.dbf

input datafile fno=00009 name=/u01/app/oracle/oradata/tt.dbf

input datafile fno=00004 name=+DATA/fengzi/datafile/users2.dbf

input datafile fno=00005 name=+DATA/fengzi/datafile/undotbs.dbf

channel ORA_DISK_1: starting piece 1 at 05-JUN-14

channel ORA_DISK_1: finished piece 1 at 05-JUN-14

piece handle=/u01/backup/2014_06_01_28pa345d_1_1 tag=TAG20140605T140417 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:25

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00003 name=+DATA/fengzi/datafile/sysaux.279.842187235

channel ORA_DISK_1: starting piece 1 at 05-JUN-14

channel ORA_DISK_1: finished piece 1 at 05-JUN-14

piece handle=/u01/backup/2014_06_01_29pa3466_1_1 tag=TAG20140605T140417 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:45

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00002 name=+DATA/fengzi/datafile/undotbs1.dbf

channel ORA_DISK_1: starting piece 1 at 05-JUN-14

channel ORA_DISK_1: finished piece 1 at 05-JUN-14

piece handle=/u01/backup/2014_06_01_2apa347j_1_1 tag=TAG20140605T140417 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:26

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

input datafile fno=00006 name=+DATA/fengzi/datafile/users1.dbf

channel ORA_DISK_1: starting piece 1 at 05-JUN-14

channel ORA_DISK_1: finished piece 1 at 05-JUN-14

piece handle=/u01/backup/2014_06_01_2bpa348d_1_1 tag=TAG20140605T140417 comment=NONE

channel ORA_DISK_1: backup set complete, elapsed time: 00:00:07

Finished backup at 05-JUN-14

Starting Control File and SPFILE Autobackup at 05-JUN-14

piece handle=+DATA/fengzi/autobackup/2014_06_05/s_849447979.382.849449239 comment=NONE

Finished Control File and SPFILE Autobackup at 05-JUN-14

RMAN

停止所有oracle服务，太长请自己看http //blog.itpub.net/29532781/viewspace-1177188/