Upgrade _ Oracle graphical upgrade (dbca database creation after upgrade)-upgrade 10.2.0.1.0 to 10.2.0.5.0 and dbca10.2.0.5.0

Upgrade _ Oracle graphical upgrade (dbca database creation after upgrade)-upgrade 10.2.0.1.0 to 10.2.0.5.0 and dbca10.2.0.5.0

**************************************** ******************************** **************

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

This article reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39673551

Deep Blue blog:Http://blog.csdn.net/huangyanlong

**************************************** **************************************** *******************

After the oracle software is installed, continue to install the upgrade package, which saves the steps for upgrading the data dictionary as follows:

 

Verify the software version

[Oracle @ hyldb bin] $ sqlplus '/as sysdba'

SQL * Plus: Release 10.2.0.1.0-Production on Sat Sep 20 15:00:00 2014

Copyright (c) 1982,200 5, Oracle. All rights reserved.

Connected to an idle instance.

 

Upload upgrade package

Oracle software upgraded from 10.2.0.1 to 10.2.0.5

[Oracle @ hyldb soft] $ unzip p8202632_10205_Linux-x86-64.zip

-- Unzip the upgrade installation package

[Oracle @ hyldb soft] $ ls

README.htm

Disk1 p8202632_10205_Linux-x86-64.zip

[Oracle @ hyldb soft] $ cd Disk1

[Oracle @ hyldb Disk1] $ ls

Install patch_note.htm response runInstaller stage

[Oracle @ hyldb Disk1] $./runInstaller

-- Execute Installation

Go to the graphical interface, and the next step is very simple, as shown in the following figure. The process is as follows:

Click Finish.

 

Login verification

We can see that the oracle software version has been successfully upgraded from 10.2.0.1.0 to 10.2.0.5.0. The following operations are performed:

[Oracle @ hyldb ~] $ Sqlplus '/as sysdba'

SQL * Plus: Release 10.2.0.5.0-Production on Sat Sep 20 15:10:05 2014

Copyright (c) 1982,201 0, Oracle. All Rights Reserved.

Connected to an idle instance.

 

Next, you can use dbca to create a database, as shown below:

[Oracle @ hyldb ~] # Xhost +

[Oracle @ hyldb ~] $ Dbca

Next, we can create a Graphical Database. Here we will not give an example.

Summary

When you use the oracle software package to upgrade the oracle software from 10.2.0.1.0 to 10.2.0.5.0, you can directly complete the upgrade after installing the software, which saves some of the operations and is relatively simple.

If you want to upgrade the oracle software from 10.2.0.1.0 to 10.2.0.5.0 based on the database you have already created, refer to the following article:

Http://blog.csdn.net/huangyanlong/article/details/41077103.

**************************************** ******************************** **************

Original Works are from the blog of "Deep Blue blog". You are welcome to repost them. Please indicate the source when you repost them. Otherwise, the copyright will be held legally responsible.

Please leave a message or email (hyldba@163.com) indicating that there is an error. Thank you very much.

This article reprint must be kept here: http://blog.csdn.net/huangyanlong/article/details/39673551

Deep Blue blog:Http://blog.csdn.net/huangyanlong

**************************************** **************************************** *******************

How many redhat as is required for upgrading ORACLE102010 to 102050?

If you need to purchase redhat, you can deduct me.