Upgrade-Open Vision Oracle Graphical upgrade (DBCA upgrade) -10.2.0.1.0 L to 10.2.0.5.0

Statement ************************************************************** *********

Original works, from the "Blue Blog" blog, Welcome to reprint, please be sure to indicate the source, otherwise hold the copyright legal responsibility.

There are errors in the presentation. Please leave a message or email ([email protected]) to indicate that it is appreciated.

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

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

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

Prerequisite: After installing Oracle software, DBCA built the library  

Goal: Complete Oracle software upgraded from 10.2.0.1.0 to 10.2.0.5.0

1. View database status, version number

[Email protected] ~]$ sqlplus '/as sysdba '

Sql*plus:release 10.2.0.1.0-production on Wed Sep 17 18:27:42 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> select Instance_name,status from V$instance;

instance_name STATUS

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

Hyldb OPEN

Sql> select Comp_name,version,status from Dba_registry;

2. Unzip the installation package

Locate the upgrade installation package for oracle10g, as seen in the following:

Unpack the Tarball

[Email protected] soft]# Unzip P8202632_10205_linux-x86-64.zip

3. Close the database

[Email protected] ~]$ sqlplus '/as sysdba '

Sql*plus:release 10.2.0.1.0-production on Mon Sep 29 10:23:51 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;

--Guanqu

Database closed.

Database dismounted.

ORACLE instance shut down.

[Email protected] ~]$ Lsnrctl statuse

--Verify that the monitoring has stopped

Lsnrctl for linux:version 10.2.0.1.0-production on 29-sep-2014 10:30:51

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

Connecting to (Address= (PROTOCOL=TCP) (host=) (port=1521))

STATUS of the LISTENER

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

Alias LISTENER

Version Tnslsnr for Linux:version 10.2.0.1.0-production

Start Date 29-sep-2014 09:54:36

Uptime 0 days 0 hr. Min. sec

Trace level off

Security on:local OS Authentication

SNMP OFF

Listener Log File/u01/app/oracle/product/10.2.0/db_1/network/log/listener.log

Listening Endpoints Summary ...

(Description= (address= (protocol=tcp) (host=hyl) (port=1521)))

The listener supports no services

The command completed successfully

4. Data Backup

A backup is required here in the production environment. In case the upgrade fails to cause data loss, this article is omitted.

5. Upgrading Oracle software

Remote invocation of the graphical interface. For example, take the following example:

Skip the requirement pack check here and click Yes to continue. For example, with:

[Email protected] ~]#/u01/app/oracle/product/10.2.0/db_1/root.sh

--run the script as prompted

Running Oracle 10g root.sh script ...

The following environment variables is set as:

Oracle_owner= Oracle

Oracle_home=/u01/app/oracle/product/10.2.0/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:

The file "Dbhome" already exists in/usr/local/bin. Overwrite it?

(y/n)

[n]: y

Copying dbhome To/usr/local/bin ...

The file "Oraenv" already exists in/usr/local/bin. Overwrite it? (y/n)

[n]: y

Copying oraenv To/usr/local/bin ...

The file "Coraenv" already exists in/usr/local/bin. Overwrite it?

(y/n)

[n]: y

Copying coraenv To/usr/local/bin ...

Entries'll be added to The/etc/oratab file as needed by

Database Configuration Assistant When a database is created

Finished running generic part of root.sh script.

Now product-specific root actions would be performed.

After running the script, click on the interface OK. Go to the end interface, such as the following:

6. Upgrading the Database

[Email protected] ~]$ sqlplus '/as sysdba '

Sql*plus:release 10.2.0.5.0-production on Mon Sep 29 11:05:28 2014

Copyright (c) 1982, Oracle. All rights Reserved.

Connected to an idle instance.

Boot to upgrade state

Sql> startup upgrade;

ORACLE instance started.

Total System Global area 167772160 bytes

Fixed Size 2094800 bytes

Variable Size 75499824 bytes

Database buffers 83886080 bytes

Redo buffers 6291456 bytes

Database mounted.

Database opened.

Upgrade Data dictionary

Sql> spool/u01/app/oracle/update_log/cpu_up.log//The script information into a log file.

Sql> @?/rdbms/admin/catupgrd.sql//start running script. Upgrade the data dictionary. Approx. 10 min.

Sql> spool off; --End log file

sql> shutdown immediate; --Guanqu

Database closed.

Database dismounted.

ORACLE instance shut down.

Sql> Startup --Normal Qicu

ORACLE instance started.

Total System Global area 167772160 bytes

Fixed Size 2094800 bytes

Variable Size 150997296 bytes

Database buffers 8388608 bytes

Redo buffers 6291456 bytes

Database mounted.

Database opened.

Sql> @?/rdbms/admin/utlrp.sql--run the script

Sql> select * from Utl_recomp_errors;

Sql> Col comp_name for A30

Sql> col status for A20

Sql> Col VERSION for A10

Sql> Set Linesize 200

Sql> select Comp_name,version,status from Dba_registry;

Sql> Show Parameter Comp

Change compatibility

Sql> alter system set compatible= ' 10.2.0.5.0 ' scope=spfile;

sql> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

So far. The database is finished upgrading from 10.2.0.1.0 to the 10.2.0.5.0 version number.

7. Complete

[Email protected] ~]$ sqlplus '/as sysdba '

--Landing database

Sql*plus:release 10.2.0.5.0-production on Mon Sep 29 11:57:49 2014

Copyright (c) 1982, Oracle. All rights Reserved.

Connected to:

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

With the partitioning, OLAP, Data Mining and Real application testing options

Summary

The process of upgrading the CPU before and after the DBCA is established, the obvious difference is found:

1, did not carry on the DBCA to build the storehouse, only need to carry on the software upgrade, the upgrade constructs the storehouse to be possible;

2, DBCA after the library (that is, the existence of the database), after upgrading the software. Need to upgrade data dictionary, change compatibility.

Jane's Mind

CPU Upgrade (10.2.0.1.0-10.2.0.5.0)
Conditions	Operation	Maybe
No libraries exist	Upgrade software	Maybe build a library.
Existence Library	Upgrade Software + data dictionary + compatibility	After upgrade, direct access to the library

Statement ************************************************************** *********

Original work, from the "Deep Blue Blog" blog. Welcome reprint, please be sure to indicate the source when reproduced, otherwise hold the copyright legal responsibility.

Please leave a message or email ([email protected]) to indicate the error.

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

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

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

Upgrade-Open Vision Oracle Graphical upgrade (DBCA upgrade) -10.2.0.1.0 L to 10.2.0.5.0