Oracle version upgrade in Linux (10.2.0.1-10.2.0.4)

In linux, the upgrade from 10.2.0.1 to 10.2.0.4 is performed. The main process is recorded below:

1. Download patches

Patch: p6810189_10204_Linux-x86.zip can go to Oracle official website download

2. Preparations before Upgrade and Installation

1. Close all database services

1. Disable all tools that may access the Database, such as Oracle Enterprise Manager Database Control or iSQL * Plus:

2. [oracle @ localhost ~] $ Emctl stop dbconsole

3. [oracle @ localhost ~] $ Isqlplusctl stop

4. [oracle @ localhost ~] $ Lsnrctl stop

5. [oracle @ localhost ~] $ Sqlplus/NOLOG

6. SQL> CONNECT SYS AS SYSDBA

7. Enter password: SYS_Password

8. SQL> SHUTDOWN

　
Iii. Backup System

The backup content includes: Oracle Inventory, Oracle 10g home, and Oracle 10g Database.

4. Install the upgrade package software

1. log on to the system as an operating system administrator.

2. decompress the upgrade package and run./runInstall.

3. You only need to specify the Oracle home you want to upgrade, or select "path.

4. On the installation end screen, click "Exit" and then confirm to exit Oracle Universal Installer. At this point, the ORACLE Upgrade package software installation is complete.

5. run scripts to upgrade the database

If only the upgrade package is installed and the database dictionary information is not upgraded

-- ORA-01092 ORACLE routine termination. Force disconnect.

Note: In this case, Google's results will provide a variety of explanations. In addition to checking the SID and service configuration, you also need to check the firewall.

At this time, the upgrade errors are normal.

　　
1. Upgrade Database dictionary information (Upgrading a Release 10.2 Database)

Start listener: lsnrctl start

Sqlplus/NOLOG

SQL> CONNECT/AS SYSDBA

STARTUP UPGRADE

SQL> SPOOL c:/patch. log -- set the trace file

SQL> @? /Rdbms/admin/utlu102i. SQL -- run the Database Pre-upgrade check

SQL> @? /Rdbms/admin/catupgrd. SQL-database dictionary information upgrade package

SQL> SPOOL OFF

Check the patch. log file. If there is a problem, run catupgrd. SQL again.

2. Restart the database:

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP

3. Run the utlrp. SQL script to re-compile the invalid PL/SQL package.

SQL> @? /Rdbms/admin/utlrp. SQL

4. Run the following command to check whether all components have been successfully upgraded:

SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS. DBA_REGISTRY;

If all outputs are VALID, the upgrade is successful.

5. If you use the Oracle Recovery Manager catalog, you must upgrade the catalog as follows:

[Oracle @ localhost ~] $ Rman catalog username/password @ alias

RMAN> upgrade catalog;

6. Check the availability of basic database tools

Perform EXP and IMP operations on users in the database, and backup and restore the database using RMAN. Confirm that the backup is restored.

 

This article from the CSDN blog, reproduced please indicate the source: http://blog.csdn.net/gguxxing008/archive/2011/04/23/6347082.aspx