Shulou(Shulou.com)05/31 Report--

Editor to share with you the example analysis of upgrading 10g to 11.2.0.4 and installing patch 11.2.0.4.19 in windows and linux environment. I hope you will get something after reading this article. Let's discuss it together.

I. backup

Upgrading the database is a very dangerous thing, on the production database, it is best to make a full backup before upgrading, so that the database can be restored if the upgrade fails. Stop all business systems related to this database, such as middleware. Make sure there is no business running. After the database is shut down normally, you also need to back up the Oracle home directory in order to restore the database software to the pre-upgrade version if the upgrade fails.

1 move business-related tables in system,sysaux to other tablespaces

Backing up parameter files through create pfile from spfile;

2 shut down the database and monitor

3 shut down all services related to ORACLE

4 backup data backup data files, log files, archive redo files, parameter files, password files and other database files

5 backup directory

The key catalogs are:

ORACLE_HOME/dbs

ORACLE_HOME/network/admin

ORACLE_HOME/hostname_dbname

ORACLE_HOME/oc4j/j2ee/OC4J_DBConsole_hostname_dbname

# you can directly back up the files under $ORACLE_BASE

Download the software and decompress it

Three running software

In the unzipped directory, under the database directory, run setup:

1 configure security updates

Do you not want to be notified of serious security issues in the configuration? Yes

2 application software update

Because patch has been downloaded, choose to skip the software update

3 installation options

Select upgrade existing Database

4 product language

Choose simplified Chinese and English

5 choose the enterprise version of the database version

6 installation location

ORACLE base directory unknown unchanged E:\ app\ Administrator

Software unknown by: e:\ app\ Administrator\ product\ 11.2.0\ dbhome_2

Change it to: e:\ app\ Administrator\ product\ 11.2.0.4bhome_2

7 prerequisite check

8 Summary

9 install the product

ORACLE NETCA program appears when the progress reaches 80%. Configure listening.

Select perform typical configuration

10. DBUA upgrade program appears to 90%

Click next

11. There is a warning, which can be ignored if it is not important.

Four database upgrades

1 upgrade selected

Select "recompile invalid objects after upgrade", "upgrade time zone version and timestamp with timezone data" and "backup database" to avoid accidents

2 specify whether to move database files during the upgrade process

Select do not move database files during upgrade

3 specify the location of the database file to be created

Select "all database files use a common location" default: e:\ app\ Administrator\ oradata

Warning: the following files will be overwritten during database creation

View the overwritten files, including: system.dbf,susaut.dbf,undotbs.dbf,usersdbf

Temp.dbf,control.ctl,redo.log and other files, if there is a table in the table space established by the above data file, it is best to move the table to another table space and overwrite the operation.

4 recovery and diagnostic location

Default: e:\ app\ Administrator\ flash_recovery_area

5 Summary

Click finish to start the upgrade

At the end of the upgrade to view the upgrade results report, you can use the "configure database password" to see if any upgrade users are locked.

5 check the upgrade situation

1 select * from v$version

2 select comp_name,version,status from dba_registry

Linux OPatch

Oracle RAC automatically patches Opatch auto notes:

After 11.2.0.2, patches can be made by root users, but not before.

Patch considerations:

Patches need to be patched in the order in which the software is installed

When patching software, you need to close the corresponding software. For example, when you install the GI patch, you need to shut down GI.

OPatch steps:

1. Install the latest version of Optach

2. Update the Opatch files of gird and oracle users

Unzip p6880880_112000_Linux-x86-64.zip-d / oracle/11.2.0/grid

Unzip p6880880_112000_Linux-x86-64.zip-d / oracle/app/oracle/product/11.2.0/db_1

3. Generate response file

Cd / oracle/11.2.0/grid/OPatch/ocm/bin

. / emocmrsp

4. Download the latest psu patch set and extract it to the / oracle/media/psu directory, the permissions of the main directory

5. Patch automatically, and grid will restart automatically when patching.

Database startup status su-root

/ oracle/11.2.0/grid/OPatch/opatch auto / oracle/media/psu-ocmrf / oracle/11.2.0/grid/OPatch/ocm/bin/ocm.rsp

Note: auto is a cluster opatch option, single instance uses apply

6, verify the installation

Select * from v$version

Select * from dba_registry_history

BUG hint:

After the root user enters the patch command, the following error is prompted:

Patch / tmp/psu/78889734/ apply failed for home / u01/app/oracle/product/11.2.0/db_1

This indicates that the database patch installation failed because of a BUG

Solution:

Stop the database first. You can stop GI directly.

Cd $ORACLE_HOME/OPatch/

. / opatch / temp/psu/..../

During this period, if you are prompted: follwing exectables is active: / u01 scarp, or oracle,

Windows single instance installation

1. Opatch environment variable setting

C:\ app\ Administrator\ product\ 11.2.0\ dbhome_2\ bin;%SystemRoot%\ system32;%SystemRoot%;%SystemRoot%\ System32\ Wbem;C:\ app\ Administrator\ product\ 11.2.0\ dbhome_2\ OPatch

ORACLE_HOME environment variable setting

When setting the ORACLE_HOME environment variable, ORACLE_HOME=C:\ app\ Administrator\ product\ 11.2.0\ dbhome_2\ must not be followed by a semicolon

2. Decompress the patch package. Patch path: / psu/21691487

3. To install the patch, stop the library and stop the service.

4. Create an ocm.rsp response file using ocmrsp.bat

5. Installation prerequisite check

Opatch prereq CheckConflictAgainstOHWithDetail-phBaseDir C:/psu/20485808/

6. Install the patch

Opatch apply / psu/21691487-ocmrf C:/app/Administrator/product/11.2.0/dbhome_2/OPatch/ocm/bin/ocm.rsp

7. Update the patch version of the data dictionary, otherwise you will not be able to query the updated patches

SQL > @? / rdbms/admin/catbundle psu apply

Select * from dba_registry_hisrotry

After reading this article, I believe you have some understanding of "sample analysis of upgrading 10g to 11.2.0.4 and installing patch 11.2.0.4.19 in windows and linux environment". If you want to know more about it, welcome to follow the industry information channel, thank you for reading!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.