Upgrade Oracle 10 in Linux

Environment: Virtual Machine

OS: Linux 5

Oracle version before Upgrade: 10.2.0.0.1

First shut down the database and listen

And then kill all oracle processes.

Ps-ef | grep oracle | grep-v grep | grep-v ef

Kill-9 process no.

Decompress the installation package and change the installation package to be owned by the oracle user.

Chown-R oracle: oinstall Disk1

When I run runInstaller, a subdirectory oui permission error is reported.

So I changed all the software packages to executable.

Chown-R 755 oracle: ointsll Disk1

Then make sure that the oracle user can open the graphical interface and run xhost + with the root user.

Run./opt/soft/Disk1/runInstaller as the oracle user.

After the graphical interface appears, it is the same as that on windows. If oracle_home has only one database, it will be used by default.

At the end of the script, you will be asked to run a root. sh script as the root user. The script will prompt whether to overwrite the existing Directory. The default value is no.

After the installation, open the database and listen in the upgrade mode. (otherwise, error 704 is reported)

Log On As A sys user and check the system tablespace.

Select tablespace_name, sum (bytes)/(1024*1024) as free_space

From dba_free_space

Where tablespace_name = 'system'

Group by tablespace_name;

If the value is less than 50, you need to increase the SYSTEM tablespace. Instead of using the resize method, we recommend that you add files.

Alter tablespace system add datafile '/opt/app/oradata/orcl/system02.dbf' size 300 m;

4). Check the shared_pool_size and java_pool_size to increase the size. Otherwise, the update script cannot be successfully upgraded due to insufficient pool space.

If Automatic sga management is enabled, make sure that sga_max_size and sga_target are above MB.

5 ). restart the database, run the upgrade script, and run catupgrd. SQL is a very time-consuming process. if the memory is sufficient, it takes about half an hour to run. We recommend that you close all other related programs during the running period. In addition, we recommend that you have MB of extra memory space.

Shutdown immediate

STARTUP upgrade

Spool/opt/app/patch. log

@ $ Javaske_home/rdbms/admin/catupgrd. SQL

SPOOL OFF

Check whether/opt/app/patch. log has an error. If necessary, run it again.

Run utlrp. SQL to recompile all invalid PL/SQL packages.

Spool/opt/app/utlrp. log

@ $ Export ke_home/rdbms/admin/utlrp. SQL

Spool off;

Check the execution status.

Utlrp. SQL, catupgrd. SQL, and utlu102i. The SQL is not executed in the order of sequence, and the upgrade is successful. I don't know if there is any problem in the future.

7) Adjust the SGA according to the actual situation

Shutdown immediate;

STARTUP;

8). view the upgrade result

Select * from v $ version;

Column comp_name format a30;

Column version format a20

Select comp_name, status, substr (version, 1, 10) as version from dba_registry;