Upgrade Oracle Database in Linux AS4

The first upgrade is actually a bank production database, which is under heavy pressure and hard to work and has been prepared for a week. on that day, the Bank gave me five hours of time, which is really insufficient. no way, just stick your head to it, and it's just like death or life. I spent 300 minutes in the dark. it is not easy to leave the system. but let's look back and think about it. The steps are just a few simple and clear. I will give it for your reference today.

Task: Upgrade Oracle10.2.0.2 to Oracle10.2.0.3

System: LinuxAS4

Oracle version: 10.2.0.2

Oracle: a single INSTANCE with around GB Data

Upgrade package: P5337014_10203_LINUX.zip (download from https://metalink.oracle.com)

Steps:

Confirm that the backup is the latest. Otherwise, you need to back up the backup again ).

Check the database environment ($ Oracle_HOME, SID, BASE ).

Notify the system administrator to stop all applications connected to Oracle. stop all applications in Oracle HOME. For example: $ emctl stop dbconsole $ isqlplusctl stop

Close Oracle SQL> SHUTDOWN IMMEDIATE.

Stop listening.

Decompress the upgrade package in the $ HOME path (to facilitate subsequent SQL export ).

$ Xhost + (enable graphical interface, I use a X-MANAGER ).

$./RunInstaller (executed by Oracle Users)

This shows that you can use the ROOT user to execute root. sh. Execute it under the root user. (Of course not all of them have been completed yet ).

Start listening $ lsnrctl start

UPGRADE Database SQL> startup upgrade SQL> SPOOL patch. log SQL> @? /Rdbms/admin/catupgrd. SQL SQL> SPOOL OFF check whether patch. log has a fatal error.

Restart Database

Check whether the environment is running normally.

Restart all services.

Success.