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

Upgrade _ Oracle graphical upgrade with a wider vision (upgrade after dbca database creation)-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/39677103

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

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

Prerequisites: After the oracle software is installed, the dbca database is created.

Objective: To Upgrade oracle software from 10.2.0.1.0 to 10.2.0.5.0

1. view the database status and version

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

SQL * Plus: Release 10.2.0.1.0-Production on Wed Sep 17 18:27:42 2014

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

Connected:

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

Find the oracle10g upgrade installation package, as shown below:

Decompress the package

[Root @ hyl soft] # unzip p8202632_10205_Linux-x86-64.zip

3. Shut down the database

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

SQL * Plus: Release 10.2.0.1.0-Production on Mon Sep 29 10:23:51 2014

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

Connected:

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

With the Partitioning, OLAP and Data Mining options

 

SQL> shutdown immediate;

-- Close the database

Database closed.

Database dismounted.

ORACLE instance shut down.

 

[Oracle @ hyl ~] $ Lsnrctl statuse

-- Check that the listener has stopped

LSNRCTL for Linux: Version 10.2.0.1.0-Production on 29-SEP-2014 10:30:51

Copyright (c) 1991,200 5, 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. 36 min. 14 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 for the production environment to avoid data loss when the upgrade fails. This article is omitted.

5. Upgrade oracle software

Remotely call the graphical interface, for example:

Skip the request package check and click yes to continue, as shown in the following figure:

[Root @ hyl ~] #/U01/app/oracle/product/10.2.0/db_1/root. sh

-- Execute the script as prompted

Running Oracle 10g root. sh script...

The following environment variables are set:

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 will be added to the/etc/oratab file as needed

Database Configuration Assistant when a database is created

Finished running generic part of root. sh script.

Now product-specific root actions will be saved med.

After the script is executed, click OK to go to the end page, as shown below:

6. Upgrade the database

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

SQL * Plus: Release 10.2.0.5.0-Production on Mon Sep 29 11:05:28 2014

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

Connected to an idle instance.

Starting to upgrade status

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.

 

Update Data Dictionary

SQL> spool/u01/app/oracle/update_log/cpu_up.log // enter the script information into a log file.

SQL> @? /Rdbms/admin/catupgrd. SQL // start running the script and upgrade the data dictionary for about 10 minutes

SQL> spool off; -- end the log file

SQL> shutdown immediate; -- close the database

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup -- normal database startup

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 -- execute this 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

Modify 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 has been upgraded from 10.2.0.1.0 to 10.2.0.5.0.

7. Complete

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

-- Log on to the database

SQL * Plus: Release 10.2.0.5.0-Production on Mon Sep 29 11:57:49 2014

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

Connected:

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

Compared with the cpu upgrade process before and after dbca database creation, the following obvious differences are found:

1. dbca database creation is not performed. You only need to upgrade the software and then create the database;

2. After the dbca database is created (that is, when the database exists), after the software is upgraded, You need to upgrade the data dictionary and modify the compatibility.

Simple note

Cpu upgrade (10.2.0.1.0-10.2.0.5.0)
Condition	Operation	Follow-up
Existing Library	Upgrade software	Subsequent database creation
Library does not exist	Upgrade software + Data Dictionary + compatibility	Complete upgrade and access the database directly

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

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/39677103

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

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

In oracle 10201 linux, after the software is installed and 10204 is upgraded, an EM error is reported when dbca creates a database. How can this problem be solved?

This does not matter, the database can be used, but EM has a problem, you can re-configure EM through the emca script:
Specific script location:
/U01/app/oracle/product/10.2.0/db_1/bin/emca

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

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