怎么升级oracle_怎么升级orange os4

如何升级oracle版本

① 先检查数据库当前版本：SELECT * FROM v$version;

这一步非常非常重要,因升级到数据部分时,虚拟机没空间了,导致VM崩溃,升级失败.orcl库也挂了,不得不从另一台Oracle上创建了一个Orcl,然后,冷备迁移过来,才得以重新升级.

如何将 Oracle 11g 升级到 Orcale 12c

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

oracle怎么升级10.2.0.5

对当前环境的查询

查看磁盘空间使用情况

Filesystem Size Used Avail Use% Mounted on

查看操作系统版本

查看当前数据库版本

SQL select * from v$version;

select * from v$version;

BANNER

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

SQL

查看oracle用户环境变量

# .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 PATH=$ORACLE_HOME/bin:$PATH

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

export ORACLE_SID=fengzi

export NLS_DATA_LANGUAGE="AMERICAN"

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

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

关闭当前数据库

fengzi

Connected to:

With the Partitioning, OLAP and Data Mining options

SQL shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

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

connected to target database (not started)

RMANstartup mount

database is already started

database mounted

备份当前控制文件

RMAN backup current controlfile;

allocated channel: ORA_DISK_1

channel ORA_DISK_1: starting full datafile backupset

channel ORA_DISK_1: specifying datafile(s) in backupset

including current control file in backupset

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

using channel ORA_DISK_1

RMAN

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

如何将oracle11.2.0.1升级到11.2.0.4

以上就是土嘎嘎小编为大家整理的怎么升级oracle相关主题介绍,如果您觉得小编更新的文章只要能对粉丝们有用,就是我们最大的鼓励和动力,不要忘记讲本站分享给您身边的朋友哦！！