Upgrade Oracle 10 Gb to 10.2.0.4 in CentOS

Single-instance Environment

Vmware Server 1.0.6 + CentOS 5.2 + Oracle 10g

1. Stop the process

2. Install patches

3. Upgrade the database

1> stop all Oracle-related processes

[Oracle @ node2 Disk1] $ emctl stop dbconsole

[Oracle @ node2 Disk1] $ lsnrctl stop

SQL> shutdown immediate

2> Install patches

Upgrade to 10.2.0.4

P6810189_10204_Linux-x86 package:

Use DBUA to upgrade.

[Oracle @ linux Disk1 ~] $./RunInstaller

Install the image interface.

Run the root. sh script

[Root @ node2 db] # sh root. sh

Running Oracle10 root. sh script...

The following environment variables are set:

ORACLE_OWNER = oracle

ORACLE_HOME =/u01/app/oracle/product/10.2.0/db

Enter the full pathname of the local bin directory: [/usr/local/bin]: y

The file "dbhome" already exists in y. Overwrite it? (Y/n)

[N]: y

Copying dbhome to y...

The file "oraenv" already exists in y. Overwrite it? (Y/n)

[N]: y

Copying oraenv to y...

The file "coraenv" already exists in y. Overwrite it? (Y/n)

[N]: y

Copying coraenv to y...

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.

3> Upgrade the database.

1 2 Next Page