oracle 10g 升级

查看原来的版本号

SQL> select version from v$timezone_file;

   VERSION
----------
         2

SQL> select version from v$instance;

VERSION
-----------------
10.2.0.1.0

停用数据库和所有服务，监听，如下

8.8.1 Stopping All Processes for a Single Instance Installation

Shut down the following Oracle Database 10g processes in the order specified before installing the patch set:

1. Shut down all processes in the Oracle home that might be accessing a database; for example, Oracle Enterprise Manager Database Control:

   $ emctl stop dbconsole
   $ lsnrctl stop
   

   Note:

   Before you shut down all processes that are monitored by Oracle Enterprise Manager Grid Control, set a blackout in Grid Control for the processes that you intend to shut down. This is necessary so that the availability records for these processes indicate that the shutdown was planned downtime rather than an unplanned system outage.

2. Shut down all database instances running in the Oracle home directory, where you need to install the patch set.

3. Shut down all listeners running in the Oracle home directory, where you need to install the patch set.

4. If there is an Automatic Storage Management instance present, then enter the following command to set the values for the environment variables$ORACLE_HOME and$ORACLE_SID:

   • Bourne, Bash, or Korn shell:

     $ export ORACLE_SID=+ASM
     $ export ORACLE_HOME=ASM_HOME
     

   • C shell:

     % setenv ORACLE_SID +ASM
     % setenv ORACLE_HOME ASM_HOME
     

   Enter the following command to shut down the Automatic Storage Management instance:

   cd $ORACLE_HOME/bin
   $ ./sqlplus /NOLOG
   SQL> CONNECT SYS AS SYSDBA
   Enter password:SYS_password
   SQL> SHUTDOWN IMMEDIATE
   

5. For Automatic Storage Management, as the root user enter the following command to shut down the Oracle Cluster Synchronization Services daemon:

   # $ORACLE_HOME/bin/crsctl stop crs

 修改升级包的用户和组

[root@localhost oracle]# chown -R oracle:oinstall p8202632_10205_LINUX.zip

进入oracle用户解压

[oracle@localhost ~]$ unzip p8202632_10205_LINUX.zip

执行