在Redhat5.6环境下安装9i,并升级到10.2.0.1、10.2.0.4、11R2的过程

Oracle9i升级到11gR2

前期准备工作

将虚拟机redhat 5.6 32bit安装好，并将所需要的软件挂载到虚拟机。

第一部分9i环境安装

安装oracle 9i软件

根据升级要求 9i的数据库要升级到9.2.0.4或者更高版本才可以升级到10g

安装9.2.0.4步骤如下：

1 禁用防火墙和selinux

[root@localhost ~]# cat /etc/selinux/

cat: /etc/selinux/: Is a directory

[root@localhost ~]# cat /etc/selinux/config

config config,v

[root@localhost ~]# cat /etc/selinux/config

# This file controls the state of SELinux on the system.

# SELINUX= can take one of these three values:

# enforcing - SELinux security policy is enforced.

# permissive - SELinux prints warnings instead of enforcing.

# disabled - SELinux is fully disabled.

SELINUX=disabled

# SELINUXTYPE= type of policy in use. Possible values are:

# targeted - Only targeted network daemons are protected.

# strict - Full SELinux protection.

SELINUXTYPE=targeted

[root@localhost ~]# service ipstable status

ipstable: unrecognized service

[root@localhost ~]# service iptables status

Firewall is stopped.

2 检查安装包

[root@localhost ~]# rpm -qa | grep libXpm-3.5.5-3

libXpm-3.5.5-3

[root@localhost ~]# rpm -qa | grep libXpm-devel-3.5.5-3

libXpm-devel-3.5.5-3

[root@localhost ~]# rpm -qa | grep libXp-1.0.0-8

libXp-1.0.0-8.1.el5

[root@localhost ~]# rpm -qa | grep libXp-devel-1.0.0-8

libXp-devel-1.0.0-8.1.el5

[root@localhost ~]# rpm -qa | grep compat-binutils

[root@localhost ~]# rpm -qa | grep compat-libcwait

[root@localhost ~]# rpm -qa | grep compat-libstdc++-egcs

[root@localhost ~]# rpm -qa | grep openmotif

openmotif22-2.2.3-18

openmotif-devel-2.3.1-5.el5_5.1

openmotif-2.3.1-5.el5_5.1

[root@localhost ~]# rpm -qa | grep compat-oracle

[root@localhost ~]#

[root@localhost 9iinstall]# rpm -ivh compat-binutils215-2.15.92.0.2-24.i386.rpm

Preparing... ########################################### [100%]

1:compat-binutils215 ########################################### [100%]

[root@localhost 9iinstall]# rpm -ivh compat-libcwait-2.1-1.i386.rpm

Preparing... ########################################### [100%]

cat: /etc/ld.so.preload: No such file or directory

1:compat-libcwait ########################################### [100%]

[root@localhost 9iinstall]# rpm -ivh compat-libstdc++-egcs-1.1.2-1.i386.rpm

Preparing... ########################################### [100%]

1:compat-libstdc++-egcs ########################################### [100%]

[root@localhost 9iinstall]# rpm -ivh openmotif21-2.1.30-11.EL5.i386.rpm

Preparing... ########################################### [100%]

1:openmotif21 ########################################### [100%]

[root@localhost 9iinstall]# rpm -ivh compat-oracle-el5-1.0-5.i386.rpm

Preparing... ########################################### [100%]

1:compat-oracle-el5 ########################################### [100%]

3 设置内核参数

[root@localhost 9iinstall]# sysctl -p

net.ipv4.ip_forward = 0

net.ipv4.conf.default.rp_filter = 1

net.ipv4.conf.default.accept_source_route = 0

kernel.sysrq = 0

kernel.core_uses_pid = 1

net.ipv4.tcp_syncookies = 1

kernel.msgmnb = 65536

kernel.msgmax = 65536

kernel.shmmax = 4294967295

kernel.shmall = 268435456

kernel.sysrq = 0

kernel.core_uses_pid = 1

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

fs.file-max = 65536

net.ipv4.ip_local_port_range = 1024 65000

4 设置pam shell limit认证

添加下面的内容，使shell limit生效：

vi /etc/pam.d/login

session required /lib/security/pam_limits.so

vi /etc/security/limits.conf

oracle hard nofile 65536

oracle soft nofile 65536

oracle hard nproc 16384

oracle soft nproc 16384

5 设置profile

6 创建用户和组

groupadd oinstall

groupadd dba

useradd oracle -g oinstall -G dba

passwd oracle

7 创建相关文件夹

mkdir /opt/oracle

mkdir /opt/oracle/product

mkdir -p /opt/oracle/product/9.2.0

chown -R oracle.oinstall /opt/oracle

chmod -R 755 /opt/oracle/

8 设置环境变量

[oracle@localhost ~]$ vim .bash_profile

# .bash_profile

# Get the aliases and functions

if [ -f ~/.bashrc ]; then

. ~/.bashrc

# User specific environment and startup programs

PATH=$PATH:$HOME/bin

export PATH

export ORACLE_BASE=/opt/oracle

export ORACLE_HOME=/opt/oracle/product/9.2.0

export ORACLE_SID=demo

export ORACLE_TERM=xterm

#export NLS_LANG=american_america.ZHS16GBK;

export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/local/lib

export PATH=$PATH:$ORACLE_HOME/bin;

CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib

export CLASSPATH=$CLASSPATH:$ORACLE_HOME/network/jlib

export LANG=en_US

".bash_profile" 23L, 643C written

[oracle@localhost ~]$ . .bash_profile

9 安装9i图解

[oracle@localhost Disk1]$ ./runInstaller

[oracle@localhost Disk1]$

[oracle@localhost Disk1]$ Initializing Java Virtual Machine from /tmp/OraInstall2013-01-17_11-00-05AM/jre/bin/java. Please wait...

Font specified in font.properties not found [--symbol-medium-r-normal--*-%d-*-*-p-*-adobe-fontspecific]

Warning: Cannot convert string "<Key>Escape,_Key_Cancel" to type VirtualBinding

Warning: Cannot convert string "<Key>Home,_Key_Begin" to type VirtualBinding

Warning: Cannot convert string "<Key>F1,_Key_Help" to type VirtualBinding

Warning: Cannot convert string "Shift<Key>F10,_Key_Menu" to type VirtualBinding

Warning: Cannot convert string "<Key>F10,Shift_Key_Menu" to type VirtualBinding

Warning: Cannot convert string "<Key>KP_Enter,_Key_Execute" to type VirtualBinding

Warning: Cannot convert string "Alt<Key>Return,Alt_Key_KP_Enter" to type VirtualBinding

[root@localhost 9iinstall]# cd /tmp/

[root@localhost tmp]# . or

orainstRoot.sh orbit-root/

[root@localhost tmp]# . orainstRoot.sh

Creating Oracle Inventory pointer file (/etc/oraInst.loc)

Changing groupname of /opt/oracle/oraInventory to dba.

[root@localhost 9iinstall]# cd /tmp/

[root@localhost tmp]# . or

orainstRoot.sh orbit-root/

[root@localhost tmp]# . orainstRoot.sh

Creating Oracle Inventory pointer file (/etc/oraInst.loc)

Changing groupname of /opt/oracle/oraInventory to dba.

[root@localhost tmp]# cd /opt/oracle/

doc/ jre/ oraInventory/ oui/ product/

[root@localhost tmp]# cd /opt/oracle/product/9.2.0/

[root@localhost 9.2.0]# . root.sh

Running Oracle9 root.sh script...

\nThe following environment variables are set as:

ORACLE_OWNER= oracle

ORACLE_HOME= /opt/oracle/product/9.2.0

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

Copying dbhome to /usr/local/bin ...

Copying oraenv to /usr/local/bin ...

Copying coraenv to /usr/local/bin ...

\nCreating /etc/oratab file...

Adding entry to /etc/oratab file...

Entries will be added to the /etc/oratab file as needed by

Database Configuration Assistant when a database is created

Finished running generic part of root.sh script.

Now product-specific root actions will be performed.

[oracle@localhost Disk1]$ dbca

/opt/oracle/jre/1.1.8/bin/../lib/i686/green_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)

Unable to initialize threads: cannot find class java/lang/Thread

Could not create Java VM

[oracle@localhost Disk1]$ netca

/opt/oracle/jre/1.1.8/bin/../lib/i686/native_threads/libzip.so: symbol errno, version GLIBC_2.0 not defined in file libc.so.6 with link time reference (libzip.so)

Unable to initialize threads: cannot find class java/lang/Thread

Could not create Java VM

[root@localhost 9.2.0]# su - oracle

[oracle@localhost ~]$ cd $ORACLE_HOME

[oracle@localhost 9.2.0]$ ls

Apache classes demo hs javavm JRE md ocommon oracore plsql root.sh sqlplus weboamlib

assistants ctx dm install jdbc jsp mgw ocs4j ord precomp slax syndication wwg

BC4J cwmlite doc inventory jdk ldap network oem_webstage otrace rdbms soap sysman xdk

bin dbs ds jar jlib lib oci olap owm relnotes sqlj ultrasearch

[oracle@localhost 9.2.0]$ mv JRE JRE.bak

[oracle@localhost 9.2.0]$ ls $ORACLE_BASE

doc jre oraInventory oui product

[oracle@localhost 9.2.0]$ ln -s $ORACLE_BASE/jre/1.3.1 $ORACLE_HOME/JRE

[oracle@localhost 9.2.0]$ cd $ORACLE_BASE/jre/1.3.1/bin

[oracle@localhost bin]$ ln -s $ORACLE_BASE/jre/1.3.1/bin/.java_wrapper jre

[oracle@localhost bin]$ cd i386/native_threads

[oracle@localhost native_threads]$ ls

java java_vm keytool policytool rmid rmiregistry tnameserv

[oracle@localhost native_threads]$ ln -s java jre

Netca: