Oracle Upgrade (10.2.0.1-> 10.2.0.4) includes the upgrade package

Before you start, it is better to back up the original database. (Cold backup is enough)

Estimated Update Time: About 3 hours (this is only a typical value, depending on the actual situation)

10.2.0.4 upgrade package:

Ftp://updates.oracle.com/6810189/p6810189_10204_Win32.zip

After the download is complete, you can start upgrading.

1. Stop all current Oracle services.

Operation Method: Right-click my computer> Manage> services, find all services starting with Oracle, and stop

2. decompress the upgrade package

If an error is reported, you can click it several times.

3. Select the installation directory

Select the original directory for installation, such as % orcle_home % \ db_1.

After this step is completed, the upgrade is not completed.

4. Update the data dictionary (This section takes a long time, and other users cannot log on to the database during this process)

Log on to sysdba. (enter sqlplus/nolog in the command prompt and connect sys/pwd as sysdba ;);

   sql>startup upgrade   sql>spool patch.log   sql>@%ORACLE_HOME%\db_1\RDBMS\ADMIN\catupgrd.sql   SQL> SPOOL OFF

5. Close and restart

   SQL>shutdownimmediate   SQL>startup

6. Compile invalid objects

SQL>@%ORACLE_HOME%\db_1\RDBMS\ADMIN\utlprp.sql

7. Verification results

SELECT count(*) FROM dba_objects WHERE status='INVALID';

If the value is 0, the upgrade is successful.

If the value is greater than 0, run catupgrd. SQL again as described above until the value is 0.

(If you run it multiple times or if it is greater than 0, do not run it again. Try whether the database is normal. If it is found that it is greater than 0, the database can also run normally)

8. View version information

select * from v$version；

In addition to the above Manual updates, Oracle provides an update tool dbua

The dbua tool provides a visual interface, which serves to execute scripts such as catupgrd. SQL. The dbua tool can upgrade some Oracle components. After the component is upgraded, the tool automatically compiles invalid objects.

Yansheng Introduction

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

Update Data Dictionary

1. Why should I execute the script to upgrade the data dictionary? First, you need to know the role of Oracle Data dictionary.

If not updated,

A) The database cannot be opened and the ORA-00704: bootstrap process failure error is reported.

B) ORA-27468 error. Error details: errors in file/u01/APP/Oracle/admin/orcl/bdump/orcl1_j000_18724.trc: ORA-12012: Error on auto execute of job 42791 ORA-27468: "EXFSYS. rlm $ evtcleanup "is locked by another process, ORA-12012 In the mos document:" sys. purge_log"
Is locked by another process [ID 751884.1] describes this error.

The solution to the problem is simple. Execute catupgrd. SQL in idle time to complete subsequent operations on the Upgrade Component.

Http://www.oracledatabase12g.com/archives/%E6%B7%B1%E5%85%A5%E4%BA%86%E8%A7%A3oracle%E6%95%B0%E6%8D% AE %E5%AD%97%E5%85%B8%E5%8D%87%E7%BA%A7%E8%84%9A%E6%9C%ACcatupgrd-sql%E8%B0%83%E7%94%A8%E8%BF%87%E7%A8%8B.html

2. The Oracle spool command can be used to export data to a text file. The Oracle import/export command is effective for backup and recovery, but export is not useful or even unavailable for export of some temporary data volumes. Here, it is the place where spool plays its role.

Compile Invalid object

The utlrp. SQL script can be executed in the database running state to compile the invalid object in the database.

We recommend that you run utlrp. SQL once the database is migrated, upgraded, or downgraded to compile invalid objects.

The following is the upgrade link in Linux.

Http://jinyu345.blog.163.com/blog/static/67778922011112010368882/

Http://server.zol.com.cn/127/1274311.html