The process of upgrading Oracle 10.2.0.5 x64 to 11.2.0.3 x64

Description: 11g database is now a lot of new deployments, for the 10g database, now clean up the 10g to 11g upgrade process. 10.2.0.2 above version can be upgraded to version 11.2.0.3.

Upgrade Note: 10.2.0.5 (->) upgraded to 11.2.0.3 (64)

First, the environment introduction

1. Database environment

Operating system version: OEL5.8 x64

Database version: 10.2.0.5 x64

Database SID Name: ORCL

1 Oracle 10g 10.2.0.5 (64bit) installation is installed according to the standard document environment.

/u01/app/oracle/product/10.2.0/db_1

/u01/app/oracle/admin/orcl/{adump,bdump,cdump,ddump,udump}

/u01/app/oracle/oradata/orcl

/u01/app/oracle/flash_recovery_area/orcl

2 Oracle 11g 11.2.0.3 (64bit) installation files

P10404530_112030_linux-x86-64_1of7.zip

P10404530_112030_linux-x86-64_2of7.zip

2. Upgrade Ideas

1 shut down the 10.2.0.5X64 database monitor and database on the database server.

2 Create Oracle 11.2.0.3 database related environment variables and directories.

3 Install Oracle 11.2.0.3x64 Database database software on the Oracle 10.2.0.5x64 database server.

4 Perform DBUA upgrades under Oracle 11.2.0.3 environment variables.

Ii. Pre-upgrade configuration

1. Close the 10g database

1) Close the database

# su-oracle

$ sqlplus/as sysdba;

sql> shutdown immediate;

Sql> quit

2) Close the monitor

$ lsnrctl Stop

2. View user groups and users

1 Create user groups and user commands as follows, the database user 10g has been created and is not required to be created here.

# ID Oracle

uid=500 (Oracle) gid=500 (oinstall) groups=500 (Oinstall), 501 (DBA)

2 Create Oracle 11g database directory

Mkdir-p/u01/app/oracle/product/11.2.0/db_1

Chmod-r 775/u01/app

Chown-r oracle:oinstall/u01

3. Modify 11g Kernel Support

Description: Comment out the 10g kernel parameters.

# vi/etc/sysctl.conf

FS.AIO-MAX-NR = 1048576

Fs.file-max = 6815744

Kernel.shmall = 2097152

Kernel.shmmax = 2147483648

Kernel.shmmni = 4096

Kernel.sem = 250 32000 100 128

Net.ipv4.ip_local_port_range = 9000 65500

Net.core.rmem_default = 262144

Net.core.rmem_max = 4194304

Net.core.wmem_default = 262144

Net.core.wmem_max = 1048586

# Sysctl-p execution takes effect

4. Modify and add a file descriptor

Cat >>/etc/security/limits.conf << EOF

Oracle Soft Nproc 2047

Oracle Hard Nproc 16384

Oracle Soft Nofile 1024

Oracle Hard Nofile 65536

Oracle Soft Stack 10240

Eof

5. Configure Oracle Environment variables

# su-oracle

$ vi. Bash_profile

Description: Comment out 11g environment variable, create 11g environment variable

Export Oracle_base=/u01/app/oracle

Export Oracle_home= $ORACLE _base/product/11.2.0/db_1

Export ORACLE_SID=ORCL

Export path= $ORACLE _home/bin: $PATH

Export nls_lang= "simplified Chinese_china. ZHS16GBK "

Export Lang=en_us

Export Lc_all=en_us

Export Ld_library_path=/lib:/usr/lib: $ORACLE _home/lib

Export classpath= $ORACLE _home/jre: $ORACLE _home/jlib: $ORACLE _home/rdbms/jlib

Alias sqlplus= "Rlwrap Sqlplus"

Alias rman= "Rlwrap Rman"

Umask 022

Effective 11g environment variable

# source. bash_profile

Third, upgrade the database

1. Copy Oracle 11g to Linux system

# MV p10404530_112030_linux-x86-64_1of7.zip/u01/app/

# MV p10404530_112030_linux-x86-64_2of7.zip/u01/app/

# Unzip P10404530_112030_linux-x86-64_1of7.zip

# Unzip P10404530_112030_linux-x86-64_2of7.zip

# Decompression under/u01/app/database

# Chown-r Oracle:oinstall/u01/app/database

2. Start the upgrade

Native installation method, using Oracle User Login

# Xhost +

Access control disabled, clients can connect to any host

$ su-oracle

$ cd/u01/app/database

$./dbua

Follow the wizard to upgrade and the upgrade process is more than 1 hours.

See more highlights of this column: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/