详细可以参考:http://blog.csdn.net/chenfeng898/article/details/8782679

直接执行如下yum安装命令后,如果再出错,跳到2

yum -y install compat-db compat-gcc-34 compat-gcc-34-c++ compat-libstdc++-33 glibc-* glibc-*.i686 libXpm-*.i686 libXp.so.6 libXt.so.6 libXtst.so.6 libgcc_s.so.1 ksh libXp libaio-devel numactl numactl-devel unixODBC unixODBC-devel

2 oracle安装出现libXp.so无法找到,libXt.so无法找到异常:

安装如下包:

libXp

libXp-devel

libXp.i686

libXt

libXt-devel

libXt.i686

gcc (否则会出现ntcontab.o找不到的错误)

gcc-c++ (否则会出现ntcontab.o找不到的错误)

glibc

glibc-devel

glibc.i686

glibc-devel.i686(否则会出现找不到ctl.o的错误)

#######以下为完整的安装文件########

检测以下系统包是否已经安装(未经验证)

binutils-2.15.92.0.2-13.EL4

compat-db-4.1.25-9

compat-libstdc++-296-2.96-132.7.2

control-center-2.8.0-12

gcc-3.4.3-22.1.EL4

gcc-c++-3.4.3-22.1.EL44

glibc-2.3.4-2.9

glibc-common-2.3.4-2.9

gnome-libs-1.4.1.2.90-44.1

libstdc++-3.4.3-22.1

libstdc++-devel-3.4.3-22.1

make-3.80-5

pdksh-5.2.14-30

sysstat-5.0.5-1

xscreensaver-4.18-5.rhel4.2

setarch-1.6-1

#################

oracle相关环境变量:

export ORACLE_BASE=/opt/oracle;

export ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1;  
export ORACLE_SID=orcl;  
export PATH=$PATH: $ORACLE_HOME/bin ;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

###########以下为参考文章:##############

oracle 10 R2 静默安装 + psu
 
1. 安装前准备工作
  增加以下包

 
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
[root@rac1 ~]# yum provides libXp.so.6
Loaded plugins: refresh-packagekit, security
libXp-1.0.0-15.1.el6.i686 : X.Org X11 libXp runtime library
Repo        : ol6_latest
Matched from:
Other       : libXp.so.6
libXp-1.0.0-15.1.el6.i686 : X.Org X11 libXp runtime library
Repo        : installed
Matched from:
Other       : Provides-match: libXp.so.6
  
  
  
[root@rac1 ~]# yum search libXp
Loaded plugins: refresh-packagekit, security
============================================= N/S Matched: libXp =============================================
libXp.i686 : X.Org X11 libXp runtime library
libXp.x86_64 : X.Org X11 libXp runtime library
libXp-devel.i686 : X.Org X11 libXp development package
libXp-devel.x86_64 : X.Org X11 libXp development package
libXpm.i686 : X.Org X11 libXpm runtime library
libXpm.x86_64 : X.Org X11 libXpm runtime library
libXpm-devel.i686 : X.Org X11 libXpm development package
libXpm-devel.x86_64 : X.Org X11 libXpm development package
  
  Name and summary matches only, use "search all" for everything.
    
    
[root@rac1 disk]# yum install libXp.i686
Loaded plugins: refresh-packagekit, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package libXp.i686 0:1.0.0-15.1.el6 will be installed
--> Finished Dependency Resolution
  
Dependencies Resolved
  
==============================================================================================================
 Package               Arch                 Version                          Repository                  Size
==============================================================================================================
Installing:
 libXp                 i686                 1.0.0-15.1.el6                   ol6_latest                  22 k
  
Transaction Summary
==============================================================================================================
Install       1 Package(s)
  
Total download size: 22 k
Installed size: 33 k
Is this ok [y/N]: y
Downloading Packages:
libXp-1.0.0-15.1.el6.i686.rpm                                                          |  22 kB     00:00     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Installing : libXp-1.0.0-15.1.el6.i686                                                                  1/1 
  Verifying  : libXp-1.0.0-15.1.el6.i686                                                                  1/1 
  
Installed:
  libXp.i686 0:1.0.0-15.1.el6                                                                                 
  
Complete!
  
  
          
  
[root@rac1 oracle]# yum install libXt.i686 libXtst.i686
Loaded plugins: refresh-packagekit, security
Setting up Install Process
Resolving Dependencies
--> Running transaction check
---> Package libXt.i686 0:1.0.7-1.el6 will be installed
--> Processing Dependency: libICE.so.6 for package: libXt-1.0.7-1.el6.i686
--> Processing Dependency: libSM.so.6 for package: libXt-1.0.7-1.el6.i686
---> Package libXtst.i686 0:1.0.99.2-3.el6 will be installed
--> Processing Dependency: libXi.so.6 for package: libXtst-1.0.99.2-3.el6.i686
--> Running transaction check
---> Package libICE.i686 0:1.0.6-1.el6 will be installed
---> Package libSM.i686 0:1.1.0-7.1.el6 will be installed
--> Processing Dependency: libuuid.so.1(UUID_1.0) for package: libSM-1.1.0-7.1.el6.i686
--> Processing Dependency: libuuid.so.1 for package: libSM-1.1.0-7.1.el6.i686
---> Package libXi.i686 0:1.3-3.el6 will be installed
--> Running transaction check
---> Package libuuid.x86_64 0:2.17.2-12.7.el6 will be updated
--> Processing Dependency: libuuid = 2.17.2-12.7.el6 for package: util-linux-ng-2.17.2-12.7.el6.x86_64
--> Processing Dependency: libuuid = 2.17.2-12.7.el6 for package: libblkid-2.17.2-12.7.el6.x86_64
---> Package libuuid.i686 0:2.17.2-12.7.el6_3 will be installed
---> Package libuuid.x86_64 0:2.17.2-12.7.el6_3 will be an update
--> Running transaction check
---> Package libblkid.x86_64 0:2.17.2-12.7.el6 will be updated
---> Package libblkid.x86_64 0:2.17.2-12.7.el6_3 will be an update
---> Package util-linux-ng.x86_64 0:2.17.2-12.7.el6 will be updated
---> Package util-linux-ng.x86_64 0:2.17.2-12.7.el6_3 will be an update
--> Finished Dependency Resolution
  
Dependencies Resolved
  
==============================================================================================================
 Package                    Arch                Version                         Repository               Size
==============================================================================================================
Installing:
 libXt                      i686                1.0.7-1.el6                     ol6_latest              168 k
 libXtst                    i686                1.0.99.2-3.el6                  ol6_latest               21 k
Installing for dependencies:
 libICE                     i686                1.0.6-1.el6                     ol6_latest               52 k
 libSM                      i686                1.1.0-7.1.el6                   ol6_latest               25 k
 libXi                      i686                1.3-3.el6                       ol6_latest               31 k
 libuuid                    i686                2.17.2-12.7.el6_3               ol6_latest               65 k
Updating for dependencies:
 libblkid                   x86_64              2.17.2-12.7.el6_3               ol6_latest              111 k
 libuuid                    x86_64              2.17.2-12.7.el6_3               ol6_latest               65 k
 util-linux-ng              x86_64              2.17.2-12.7.el6_3               ol6_latest              1.5 M
  
Transaction Summary
==============================================================================================================
Install       6 Package(s)
Upgrade       3 Package(s)
  
Total download size: 2.0 M
Is this ok [y/N]: y
Downloading Packages:
(1/9): libICE-1.0.6-1.el6.i686.rpm                                                     |  52 kB     00:00     
(2/9): libSM-1.1.0-7.1.el6.i686.rpm                                                    |  25 kB     00:00     
(3/9): libXi-1.3-3.el6.i686.rpm                                                        |  31 kB     00:00     
(4/9): libXt-1.0.7-1.el6.i686.rpm                                                      | 168 kB     00:00     
(5/9): libXtst-1.0.99.2-3.el6.i686.rpm                                                 |  21 kB     00:00     
(6/9): libblkid-2.17.2-12.7.el6_3.x86_64.rpm                                           | 111 kB     00:00     
(7/9): libuuid-2.17.2-12.7.el6_3.i686.rpm                                              |  65 kB     00:00     
(8/9): libuuid-2.17.2-12.7.el6_3.x86_64.rpm                                            |  65 kB     00:00     
(9/9): util-linux-ng-2.17.2-12.7.el6_3.x86_64.rpm                                      | 1.5 MB     00:05     
--------------------------------------------------------------------------------------------------------------
Total                                                                         137 kB/s | 2.0 MB     00:15     
Running rpm_check_debug
Running Transaction Test
Transaction Test Succeeded
Running Transaction
  Updating   : libuuid-2.17.2-12.7.el6_3.x86_64                                                          1/12 
  Installing : libICE-1.0.6-1.el6.i686                                                                   2/12 
  Updating   : libblkid-2.17.2-12.7.el6_3.x86_64                                                         3/12 
  Installing : libuuid-2.17.2-12.7.el6_3.i686                                                            4/12 
  Installing : libSM-1.1.0-7.1.el6.i686                                                                  5/12 
  Installing : libXi-1.3-3.el6.i686                                                                      6/12 
  Updating   : util-linux-ng-2.17.2-12.7.el6_3.x86_64                                                    7/12 
  Installing : libXtst-1.0.99.2-3.el6.i686                                                               8/12 
  Installing : libXt-1.0.7-1.el6.i686                                                                    9/12 
  Cleanup    : util-linux-ng-2.17.2-12.7.el6.x86_64                                                     10/12 
  Cleanup    : libblkid-2.17.2-12.7.el6.x86_64                                                          11/12 
  Cleanup    : libuuid-2.17.2-12.7.el6.x86_64                                                           12/12 
  Verifying  : libICE-1.0.6-1.el6.i686                                                                   1/12 
  Verifying  : libXi-1.3-3.el6.i686                                                                      2/12 
  Verifying  : libSM-1.1.0-7.1.el6.i686                                                                  3/12 
  Verifying  : libuuid-2.17.2-12.7.el6_3.x86_64                                                          4/12 
  Verifying  : libuuid-2.17.2-12.7.el6_3.i686                                                            5/12 
  Verifying  : libXt-1.0.7-1.el6.i686                                                                    6/12 
  Verifying  : util-linux-ng-2.17.2-12.7.el6_3.x86_64                                                    7/12 
  Verifying  : libXtst-1.0.99.2-3.el6.i686                                                               8/12 
  Verifying  : libblkid-2.17.2-12.7.el6_3.x86_64                                                         9/12 
  Verifying  : libuuid-2.17.2-12.7.el6.x86_64                                                           10/12 
  Verifying  : util-linux-ng-2.17.2-12.7.el6.x86_64                                                     11/12 
  Verifying  : libblkid-2.17.2-12.7.el6.x86_64                                                          12/12 
  
Installed:
  libXt.i686 0:1.0.7-1.el6                            libXtst.i686 0:1.0.99.2-3.el6                           
  
Dependency Installed:
  libICE.i686 0:1.0.6-1.el6                libSM.i686 0:1.1.0-7.1.el6         libXi.i686 0:1.3-3.el6        
  libuuid.i686 0:2.17.2-12.7.el6_3        
  
Dependency Updated:
  libblkid.x86_64 0:2.17.2-12.7.el6_3                      libuuid.x86_64 0:2.17.2-12.7.el6_3                
  util-linux-ng.x86_64 0:2.17.2-12.7.el6_3                
  
Complete!
注意: libXt.i686 libXtst.i686 这两个rpm包一定要安装否则会在oracle静默安装时会出现以下错误
1
2
3
4
5
6
7
8
9
10
11
12
Command = /u01/app/oracle/product/10.2.0/db_1/jdk/jre//bin/java has failed 
 Execution Error : Exception in thread "main" java.lang.UnsatisfiedLinkError: /u01/app/oracle/product/10.2.0/db_1/jdk/jre/lib/i386/libawt.so: libXp.so.6: cannot open shared object file: No such file or directory
        at java.lang.ClassLoader$NativeLibrary.load(Native Method)
        at java.lang.ClassLoader.loadLibrary0(ClassLoader.java:1586)
        at java.lang.ClassLoader.loadLibrary(ClassLoader.java:1503)
        at java.lang.Runtime.loadLibrary0(Runtime.java:788)
        at java.lang.System.loadLibrary(System.java:834)
        at sun.security.action.LoadLibraryAction.run(LoadLibraryAction.java:50)
        at java.security.AccessController.doPrivileged(Native Method)
        at sun.awt.NativeLibLoader.loadLibraries(NativeLibLoader.java:38)
        at sun.awt.DebugHelper.<clinit>(DebugHelper.java:29)
        at java.awt.Component.<clinit>(Component.java:506)
 
2. 设置环境变量
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
[oracle@rac1 ~]$ cat .bash_profile
# .bash_profile
  
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
        . ~/.bashrc
fi
  
# User specific environment and startup programs
  
PATH=$PATH:$HOME/bin
  
export PATH
  
# Oracle Settings 
  
TMP=/tmp; export TMP 
  
TMPDIR=$TMP; export TMPDIR 
  
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE 
  
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db_1; export ORACLE_HOME 
  
ORACLE_SID=orcl; export ORACLE_SID 
  
ORACLE_TERM=xterm; export ORACLE_TERM 
  
PATH=/usr/sbin:$PATH; export PATH 
  
PATH=$ORACLE_HOME/bin:$PATH; export PATH 
  
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH 
  
CLASSPATH=$ORACLE_HOME/jre:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH 
  
if [ $USER = "oracle" ]; then 
  
if [ $SHELL = "/bin/ksh" ]; then 
  
ulimit -p 16384 
  
ulimit -n 65536 
  
else 
  
ulimit -u 16384 -n 65536 
  
fi 
  
fi
3.更改系统参数
1
[root@rac1 ~]# echo 54322 > /proc/sys/vm/hugetlb_shm_group
注意这个参数一定要修改,否则安装过程中会报错
 
4. 创建文件夹
1
2
3
4
[oracle@rac1 ~]$ id oracle
uid=54321(oracle) gid=54321(oinstall) groups=54321(oinstall),54322(dba)
[root@rac1 ~]# mkdir -p /u01/app/oracle
[root@rac1 ~]# chown -R oracle.oinstall /u01/app/oracle
5. 设置静默安装文件
 
 在安装软件database/response目录下有如下文件:custom.rsp, dbca.rsp,emca.rsp,enterprise.rsp,netca.rsp,standard.rsp。 看到文件的名字就知道他的作用了。  我们选择enterprise.rsp,修改相关参数后即可安装。

要修改的地方如下:

#------------------------------------------------------------------------------

#Name       : ORACLE_HOME

#Datatype   : String

#Description: Complete path of the Oracle Home.

#Example    : ORACLE_HOME = "/product/10.2.0/db_1"

#------------------------------------------------------------------------------

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

#------------------------------------------------------------------------------

#Name       : ORACLE_HOME_NAME

#Datatype   : String

#Description: Oracle Home Name. Used in creating folders and services.

#Example    : ORACLE_HOME_NAME = "OraDbHome1"

#------------------------------------------------------------------------------

ORACLE_HOME_NAME=ORACLE_HOME

#------------------------------------------------------------------------------

# Name       : n_configurationOption

# Datatype   : Number

# Description: Determines the type of configuration to perform for the session.

#

#              This entry should be specified as an number.  The valid values

#              that you can use map to the following options:

#              1 - Create a Database

#              2 - Configure an ASM instance

#              3 - Install Software Only

#

# Example    : n_configurationOption=1

#------------------------------------------------------------------------------

n_configurationOption=1

#------------------------------------------------------------------------------

# Name       : n_dbType

# Datatype   : Number

# Description: Determines the type of database to create.

#

#              This entry should be specified as a number.  The valid values

#              you can specify map to the following options:

#              1 - General Purpose Starter Database

#              2 - Transaction Processing Starter Database

#              3 - Data Warehouse Starter Database

#              4 - Advanced Configuration

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#

# Example    : n_dbType=1

#------------------------------------------------------------------------------

n_dbType=1

#------------------------------------------------------------------------------

# Name       : s_responseFileName

# Datatype   : String

# Description: Stores the location of the DBCA response file for an Advanced

#              Configuration.

#

#              If you chose to perform a silent Advanced Configuration by

#              specifying n_dbType=4 above, then you need to specify a number

#              of additional Advanced Configuration parameters in a response

#              file that is used by the DBCA.  A template of this response file

#              can be found on the installation media in response/dbca.rsp.  Use

#              this file to completely customize the silent database

#              configuration, and set s_responseFileName to the location of

#              this response file.

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType=4

#

# Example    : oracle.assistants.server:s_responseFileName = "/tmp/dbca.rsp"

#------------------------------------------------------------------------------

oracle.assistants.server:s_responseFileName=/mnt/10201_database_linux32_FromOracle/database/response/dbca.rsp

#------------------------------------------------------------------------------

# Name       : s_globalDBName

# Datatype   : String

# Description: The Starter Database Global Database Name

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#

# Example     : s_globalDBName = "mydb.mydomain.com"

#------------------------------------------------------------------------------

s_globalDBName=orcl

#------------------------------------------------------------------------------

# Name       : s_dbSid

# Datatype   : String

# Description: The Starter Database SID.

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#

# Example    : s_dbSid = "orcl"

#------------------------------------------------------------------------------

s_dbSid=orcl

#------------------------------------------------------------------------------

# Name       : n_dbStorageType

# Datatype   : Number

# Description: Determines the type of storage to use for the the database.

#

#              This entry should be specified as an number.  The valid values

#              that you can use map to the following options:

#              1 - Place the data files on a file system

#              2 - Use Automatic Storage Management (ASM)

#              3 - Place the datafiles on raw partitions

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#

#------------------------------------------------------------------------------

n_dbStorageType=1

#------------------------------------------------------------------------------

# Name       : s_dlgRBORecoveryLocation

# Datatype   : String

# Description: If using a file system for storing backup and recovery files,

#              this entry is used for specifying the location on the file

#              system for storing these files..

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#  b_enableAutoBackup=true

#  b_useFileSystemForRecovery=true

#

# Example     : s_dlgRBORecoveryLocation="/u01/app/oracle/flash_recovery_area"

#------------------------------------------------------------------------------

s_dlgRBORecoveryLocation="/u01/app/oracle/flash_recovery_area"

#------------------------------------------------------------------------------

# Name       : s_dlgRBOUsername

# Datatype   : String

# Description: Regardless of the type of storage you choose for backup and

#              recovery, if you decide to enable automated backups, a job will

#              be scheduled to run daily at 2:00 AM to backup your database.

#

#              This job will run as the operating system user that you specify

#              using this entry.

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#  b_enableAutoBackup=true

#

# Example     : s_dlgRBOUsername = "oracle"

#------------------------------------------------------------------------------

s_dlgRBOUsername=oracle

#------------------------------------------------------------------------------

# Name       : s_superAdminSamePasswd

# Datatype   : String

# Description: Stores the password to be used for all accounts.

#

#              NOTE: In order to perform the silent install successfully, you

#              must specify the same password in both variables:

#              - s_superAdminSamePasswd

#              - s_superAdminSamePasswdAgain

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#  b_useSamePassword=true

#

#------------------------------------------------------------------------------

s_superAdminSamePasswd=admin

#------------------------------------------------------------------------------

# Name       : s_superAdminSamePasswdAgain

# Datatype   : String

# Description: Stores the password to be used for all accounts.

#

#              NOTE: In order to perform the silent install successfully, you

#              must specify the same password in both variables:

#              - s_superAdminSamePasswd

#              - s_superAdminSamePasswdAgain

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#  b_useSamePassword=true

#

#------------------------------------------------------------------------------

s_superAdminSamePasswdAgain=admin

#------------------------------------------------------------------------------

# Name       : s_superAdminSamePasswd

# Datatype   : String

# Description: Stores the password to be used for each of the database schemas

#              SYS, SYSTEM, SYSMAN, and DBSNMP.

#

#              NOTE: In order to perform the silent install successfully, you

#              must specify the same passwords for each schema using both:

#              - sl_superAdminSamePasswds

#              - sl_superAdminSamePasswdsAgain

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#  b_useSamePassword=false

#

# Example    : sl_superAdminPasswds = {"<password for SYS>","<password for SYSTEM>","<password for SYSMAN>","<password for DBSNMP>"}

#------------------------------------------------------------------------------

sl_superAdminPasswds=admin

#------------------------------------------------------------------------------

# Name       : s_superAdminSamePasswdAgain

# Datatype   : String

# Description: Stores the password to be used for each of the database schemas

#              SYS, SYSTEM, SYSMAN, and DBSNMP.

#

#              NOTE: In order to perform the silent install successfully, you

#              must specify the same passwords for each schema using both:

#              - sl_superAdminSamePasswds

#              - sl_superAdminSamePasswdsAgain

#

# Pre-requsites for setting this variable:

#  n_configurationOption=1

#  n_performUpgrade=0

#  n_dbType = 1, 2, or 3

#  b_useSamePassword=false

#

# Example    : sl_superAdminPasswdsAgain = {"<password for SYS>","<password for SYSTEM>","<password for SYSMAN>","<password for DBSNMP>"}

#------------------------------------------------------------------------------

sl_superAdminPasswdsAgain=admin

其他的一切默认。

6. 进行安装

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
[oracle@rac1 database]$ ./runInstaller -silent -responseFile /home/oracle/database/response/enterprise.rsp
Starting Oracle Universal Installer...
  
Checking installer requirements...
  
Checking operating system version: must be redhat-3, SuSE-9, redhat-4, UnitedLinux-1.0, asianux-1 or asianux-2
                                      Passed
  
  
All installer requirements met.
  
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-01-31_11-38-21AM. Please wait ...[oracle@rac1 database]$ Oracle Universal Installer, Version 10.2.0.1.0 Production
Copyright (C) 1999, 2005, Oracle. All rights reserved.
  
You can find a log of this install session at:
 /u01/app/oracle/oraInventory/logs/installActions2013-01-31_11-38-21AM.log
.................................................................................................... 100% Done.
  
  
Loading Product Information
..................................................................................................................... 100% Done.
  
  
Analyzing dependencies 
.........................................................
Starting execution of Prerequisites...
Total No of checks: 11
  
Performing check for CertifiedVersions
Checking operating system requirements ...
Expected result: One of redhat-3,redhat-4,SuSE-9
Actual Result: redhat-3
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for Packages
Checking operating system package requirements ...
Checking for make-3.79; found make-1:3.81-20.el6.       Passed
Checking for binutils-2.14; found binutils-2.20.51.0.2-5.34.el6.        Passed
Checking for gcc-3.2; found gcc-4.4.6-4.el6.    Passed
Checking for libaio-0.3.96; found libaio-0.3.107-10.el6.        Passed
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for Kernel
Checking kernel parameters
Checking for semmsl=250; found semmsl=250.      Passed
Checking for semmns=32000; found semmns=32000.  Passed
Checking for semopm=100; found semopm=100.      Passed
Checking for semmni=128; found semmni=128.      Passed
Checking for shmmax=536870912; found shmmax=4398046511104.      Passed
Checking for shmmni=4096; found shmmni=4096.    Passed
Checking for shmall=2097152; found shmall=1073741824.   Passed
Checking for file-max=65536; found file-max=6815744.    Passed
Checking for VERSION=2.4.21; found VERSION=2.6.39-200.24.1.el6uek.x86_64.       Passed
Checking for ip_local_port_range=1024 - 65000; found ip_local_port_range=9000 - 65500.  Failed <<<<
Checking for rmem_default=262144; found rmem_default=262144.    Passed
Checking for rmem_max=262144; found rmem_max=4194304.   Passed
Checking for wmem_default=262144; found wmem_default=262144.    Passed
Checking for wmem_max=262144; found wmem_max=1048576.   Passed
Check complete. The overall result of this check is: Failed <<<<
  
  
Check complete: Failed <<<<
Problem: The kernel parameters do not meet the minimum requirements (see above).
Recommendation: Perform operating system specific instructions to update the kernel parameters.
  
=======================================================================
Performing check for GLIBC
Checking Recommended glibc version
Expected result: ATLEAST=2.3.2-95.30 
Actual Result: 2.12-1.80.el6
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for TotalMemory
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 2004MB
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 3006MB
Actual Result: 2046MB
Check complete. The overall result of this check is: Failed <<<<
  
  
Check complete: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.
  
=======================================================================
Performing check for DetectIfDHCPAssignedIP
Checking Network Configuration requirements ...
Check complete. The overall result of this check is: Not executed <<<<
  
  
Check complete: Not executed <<<<
Recommendation: Oracle supports installations on systems with DHCP-assigned public IP addresses.  However, the primary network interface on the system should be configured with a static IP address in order for the Oracle Software to function properly.  See the Installation Guide for more details on installing the software on systems configured with DHCP.
  
=======================================================================
Performing check for OracleBase
Validating ORACLE_BASE location (if set) ...
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for OracleHomeSpace
Checking Oracle Home path for spaces...
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for DetectAnyInvalidASMHome
Checking for proper system clean-up....
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for CompatibilityChecks
Checking for Oracle Home incompatibilities ....
Actual Result: NEW_HOME
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
PrereqChecks complete
  
........................................... 100% Done.
  
  
-----------------------------------------------------------------------------
Summary
Global Settings
    Source: /home/oracle/database/stage/products.xml
    Oracle Home: /u01/app/oracle/product/10.2.0/db_1 (ORACLE_HOME)
    Installation Type: Enterprise Edition
Product Languages
   English
Space Requirements
   / Required 1.74GB (includes 130MB temporary) : Available 11.28GB
New Installations (109 products)
   Oracle Database 10g 10.2.0.1.0 
   Enterprise Edition Options 10.2.0.1.0 
   Oracle Partitioning 10.2.0.1.0 
   Oracle Spatial 10.2.0.1.0 
   Oracle OLAP 10.2.0.1.0 
   Oracle Enterprise Manager Console DB 10.2.0.1.0 
   Oracle Net Services 10.2.0.1.0 
   Oracle Database 10g 10.2.0.1.0 
   Oracle Net Listener 10.2.0.1.0 
   HAS Files for DB 10.2.0.1.0 
   Oracle Internet Directory Client 10.2.0.1.0 
   Oracle Call Interface (OCI) 10.2.0.1.0 
   Oracle Programmer 10.2.0.1.0 
   Oracle interMedia 10.2.0.1.0 
   Enterprise Manager Agent Core 10.2.0.1.0 
   Oracle JVM 10.2.0.1.0 
   Database Configuration and Upgrade Assistants 10.2.0.1.0 
   Oracle interMedia Locator 10.2.0.1.0 
   Oracle XML Development Kit 10.2.0.1.0 
   Oracle Text 10.2.0.1.0 
   Oracle Database Utilities 10.2.0.1.0 
   Generic Connectivity Common Files 10.2.0.1.0 
   Oracle Advanced Security 10.2.0.1.0 
   Enterprise Manager Repository Core 10.2.0.1.0 
   PL/SQL 10.2.0.1.0 
   Oracle Net 10.2.0.1.0 
   Assistant Common Files 10.2.0.1.0 
   Oracle Notification Service 10.1.0.3.0 
   Enterprise Manager plugin Common Files 10.2.0.1.0 Beta
   Buildtools Common Files 10.2.0.1.0 
   Installation Common Files 10.2.0.1.0 
   Oracle LDAP administration 10.2.0.1.0 
   Oracle Java Client 10.2.0.1.0 
   Oracle Recovery Manager 10.2.0.1.0 
   SQL*Plus 10.2.0.1.0 
   iSQL*Plus 10.2.0.1.0 
   Enterprise Manager plugin Common Files 10.2.0.1.0 
   Oracle Help for the  Web 1.1.10.0.0 
   HAS Common Files 10.2.0.1.0 
   Oracle Clusterware RDBMS Files 10.2.0.1.0 
   Oracle Wallet Manager 10.2.0.1.0 
   Enterprise Manager Minimal Integration 10.2.0.1.0 
   Oracle Database User Interface 2.2.13.0.0 
   Precompiler Common Files 10.2.0.1.0 
   Secure Socket Layer 10.2.0.1.0 
   Oracle ODBC Driver 10.2.0.1.0 
   Database SQL Scripts 10.2.0.1.0 
   OLAP SQL Scripts 10.2.0.1.0 
   PL/SQL Embedded Gateway 10.2.0.1.0 
   Required Support Files 10.2.0.1.0 
   Character Set Migration Utility 10.2.0.1.0 
   LDAP Required Support Files 10.2.0.1.0 
   Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0 
   Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0 
   Oracle interMedia Client Option 10.2.0.1.0 
   Oracle Required Support Files 32 bit 10.2.0.0.0 
   Oracle Code Editor 1.2.1.0.0I 
   Oracle Globalization Support 10.2.0.1.0 
   JDBC Common Files 10.2.0.1.0 
   Oracle Locale Builder 10.2.0.1.0 
   Oracle Containers for Java 10.2.0.1.0 
   Database Workspace Manager 10.2.0.1.0 
   Oracle Core Required Support Files 10.2.0.1.0 
   Platform Required Support Files 10.2.0.1.0 
   Oracle interMedia Locator RDBMS Files 10.2.0.1.0 
   Oracle JDBC/OCI Instant Client 10.2.0.1.0 
   Oracle interMedia Annotator 10.2.0.1.0 
   SQLJ Runtime 10.2.0.1.0 
   Oracle interMedia Java Advanced Imaging 10.2.0.1.0 
   Oracle Database 10g interMedia Files 10.2.0.1.0 
   Oracle Data Mining RDBMS Files 10.2.0.1.0 
   Enterprise Manager Baseline 10.2.0.1.0 
   Oracle Help For Java 4.2.6.1.0 
   Oracle UIX 2.1.22.0.0 
   XML Parser for Java 10.2.0.1.0 
   Precompiler Required Support Files 10.2.0.1.0 
   XML Parser for Oracle JVM 10.2.0.1.0 
   Oracle Database 10G 32 bit 10.2.0.1.0 
   Oracle Message Gateway Common Files 10.2.0.1.0 
   Oracle Starter Database 10.2.0.1.0 
   Sample Schema Data 10.2.0.1.0 
   Parser Generator Required Support Files 10.2.0.1.0 
   Agent Required Support Files 10.2.0.1.0 
   Oracle RAC Required Support Files-HAS 10.2.0.1.0 
   RDBMS Required Support Files 10.2.0.1.0 
   RDBMS Required Support Files for Instant Client 10.2.0.1.0 
   XDK Required Support Files 10.2.0.1.0 
   Oracle OLAP API 10.2.0.1.0 
   Oracle OLAP RDBMS Files 10.2.0.1.0 
   DBJAVA Required Support Files 10.2.0.1.0 
   SQL*Plus Required Support Files 10.2.0.1.0 
   Oracle JFC Extended Windowing Toolkit 4.2.33.0.0 
   Oracle Ice Browser 5.2.3.6.0 
   regexp 2.1.9.0.0 
   Oracle Extended Windowing Toolkit 3.4.38.0.0 
   Enterprise Manager Common Files 10.2.0.1.0 
   Enterprise Manager Agent DB 10.2.0.1.0 
   Oracle Net Required Support Files 10.2.0.1.0 
   Enterprise Manager Repository DB 10.2.0.1.0 
   Oracle Display Fonts 9.0.2.0.0 
   SSL Required Support Files for InstantClient 10.2.0.1.0 
   Bali Share 1.1.18.0.0 
   Perl Interpreter 5.8.3.0.2 
   Oracle Universal Installer 10.2.0.1.0 
   Oracle One-Off Patch Installer 10.2.0.1.0 
   Installer SDK Component 10.2.0.1.0 
   Java Runtime Environment 1.4.2.0.8 
   Java 2 SDK 1.4.2.0.8 
   Sun JDK extensions 10.1.2.0.0 
-----------------------------------------------------------------------------
  
  
Installation in progress (Thu Jan 31 11:38:38 CST 2013)
...............................................................  10% Done.
...............................................................  20% Done.
...............................................................  30% Done.
...............................................................  40% Done.
...............................................................  50% Done.
................................................                 57% Done.
Install successful
  
Linking in progress (Thu Jan 31 11:40:27 CST 2013)
.                                                                57% Done.
Link successful
  
Setup in progress (Thu Jan 31 11:43:01 CST 2013)
.........................                                       100% Done.
Setup successful
  
End of install phases.(Thu Jan 31 11:43:05 CST 2013)
Starting to execute configuration assistants
Configuration assistant "Oracle Net Configuration Assistant" succeeded 
Configuration assistant "Oracle Database Configuration Assistant" succeeded 
Configuration assistant "iSQL*Plus Configuration Assistant" succeeded 
WARNING:The following configuration scripts 
/u01/app/oracle/product/10.2.0/db_1/root.sh
need to be executed as root for configuring the system. If you skip the execution of the configuration tools, the configuration will not be complete and the product wont function properly. In order to get the product to function properly, you will be required to execute the scripts and the configuration tools after exiting the OUI.
   
The installation of Oracle Database 10g was successful.
Please check '/u01/app/oracle/oraInventory/logs/silentInstall2013-01-31_11-38-21AM.log' for more details.

7.安装后检查

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
[oracle@rac1 database]$ sqlplus " / as sysdba"
  
SQL*Plus: Release 10.2.0.1.0 - Production on Thu Jan 31 11:50:04 2013
  
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
  
  
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
  
SQL> select * from v$version;
  
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bi
PL/SQL Release 10.2.0.1.0 - Production
CORE    10.2.0.1.0      Production
TNS for Linux: Version 10.2.0.1.0 - Production
NLSRTL Version 10.2.0.1.0 - Production

8. 解压PSU补丁

1
2
3
4
5
6
7
8
9
10
11
12
13
14
[oracle@rac1 ~]$ unzip p8202632_10205_Linux-x86-64.zip
Archive:  p8202632_10205_Linux-x86-64.zip
   creating: Disk1/
   creating: Disk1/stage/
   creating: Disk1/stage/prereq/
   creating: Disk1/stage/prereq/oui/
....................   
  inflating: Disk1/install/unzip     
  inflating: Disk1/install/oraparamsilent.ini  
  inflating: Disk1/patch_note.htm    
  inflating: Disk1/runInstaller      
   creating: Disk1/response/
  inflating: Disk1/response/patchset.rsp  
  inflating: README.htm

9. 停止oracle服务和监听

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
[oracle@rac1 Disk1]$ sqlplus " / as sysdba"
  
SQL*Plus: Release 10.2.0.1.0 - Production on Mon Feb 4 15:37:37 2013
  
Copyright (c) 1982, 2005, Oracle.  All rights reserved.
  
  
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
  
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - 64bit Production
With the Partitioning, OLAP and Data Mining options
[oracle@rac1 Disk1]$ lsnrctl stop
  
LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 04-FEB-2013 15:38:22
  
Copyright (c) 1991, 2005, Oracle.  All rights reserved.
  
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC2)))
The command completed successfully

10.修改psu中的patchset.rsp

#-----------------------------------------------------------------------------
# Name          : UNIX_GROUP_NAME
# Datatype      : String
# Description   : Unix group which will have write permissions on the
#                 installer inventory directory
# Valid values  : Any Unix group to which the current user belongs
# value : None
# Mandatory     : No
#-----------------------------------------------------------------------------

UNIX_GROUP_NAME=oinstall

#-----------------------------------------------------------------------------
# Name          : FROM_LOCATION
# Datatype      : String
# Description   : Complete path of the products.xml file from the staging area
#                 where you untared your patch set. 
# Valid values  : Full path ending in "products.xml"
# Example value : "/patchset/oracle10g/stage/products.xml"
# Default value : "../stage/products.xml"
# Mandatory     : Yes
#-----------------------------------------------------------------------------

FROM_LOCATION=/home/oracle/Disk1/stage/products.xml

#-----------------------------------------------------------------------------
# Name          : ORACLE_HOME
# Datatype      : String
# Description   : Full path of existing Oracle Home directory to use for 
#                 installing Oracle patch set, i.e. the target "Oracle Home"
# Valid values  : Directory path
# Example value : "/u01/app/oracle/products/10.2.0.5.0"
# Default value : none
# Mandatory     : Yes
#-----------------------------------------------------------------------------

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

#-----------------------------------------------------------------------------
# Name          : ORACLE_HOME_NAME
# Datatype      : String
# Description   : Oracle Home Name. Used in creating folders and services.
# Valid values  : any string not used for any Oracle HOME
# Example value : ORACLE_HOME_NAME = "OHOME1"
# Default value : OHOME1 
# Mandatory     : Yes
#-----------------------------------------------------------------------------

ORACLE_HOME_NAME=ORACLE_HOME

11.进行psu安装

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
[oracle@rac1 Disk1]$ ./runInstaller -silent -responseFile /home/oracle/Disk1/response/patchset.rsp [email protected] DECLINE_SECURITY_UPDATES=true
Starting Oracle Universal Installer...
  
Checking installer requirements...
  
Checking operating system version: must be redhat-3, SuSE-9, SuSE-10, redhat-4, redhat-5, redhat-6, UnitedLinux-1.0, asianux-1, asianux-2, asianux-3, enterprise-4, enterprise-5 or SuSE-11
                                      Passed
  
  
All installer requirements met.
  
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2013-02-04_03-38-28PM. Please wait ...[oracle@rac1 Disk1]$ Oracle Universal Installer, Version 10.2.0.5.0 Production
Copyright (C) 1999, 2010, Oracle. All rights reserved.
  
You can find a log of this install session at:
 /u01/app/oracle/oraInventory/logs/installActions2013-02-04_03-38-28PM.log
.................................................................................................... 100% Done.
  
  
Loading Product Information
.................................................................................................................. 100% Done.
  
  
Starting execution of Prerequisites...
Total No of checks: 8
  
Performing check for CertifiedVersions
Checking operating system requirements ...
Expected result: One of redhat-6,redhat-5,redhat-4,redhat-3,SuSE-11,SuSE-10,SuSE-9,asianux-3,asianux-2,asianux-1
Actual Result: redhat-6
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for Packages
Checking operating system package requirements ...
Check complete. The overall result of this check is: Not executed <<<<
  
  
Check complete: Not executed <<<<
OUI-11108:  Packages information not specified.
Recommendation: Install the required packages before continuing with the installation.
  
=======================================================================
Performing check for Kernel
Checking kernel parameters
Checking for semmsl=250; found semmsl=250.      Passed
Checking for semopm=100; found semopm=100.      Passed
Checking for semmni=128; found semmni=128.      Passed
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for GLIBC
Checking Recommended glibc version
Expected result: 
Actual Result: 2.12-1.80.el6
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for TotalMemory
Checking physical memory requirements ...
Expected result: 922MB
Actual Result: 2004MB
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for SwapSpace
Checking available swap space requirements ...
Expected result: 3006MB
Actual Result: 1998MB
Check complete. The overall result of this check is: Failed <<<<
  
  
Check complete: Failed <<<<
Problem: The system does not have the required swap space.
Recommendation: Make more swap space available to perform the install.
  
=======================================================================
Performing check for checkToInstallCCR
Checking the Components installed in Oracle Home
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
Performing check for CompatibilityChecks
Checking for Oracle Home incompatibilities ...
Check complete. The overall result of this check is: Passed
  
  
Check complete: Passed
=======================================================================
PrereqChecks complete
  
  
Analyzing dependencies 
...................................................................................................... 100% Done.
  
  
-----------------------------------------------------------------------------
Summary
Global Settings
    Source: /home/oracle/Disk1/stage/products.xml
    Oracle Home: /u01/app/oracle/product/10.2.0/db_1 (ORACLE_HOME)
Product Languages
   English
Space Requirements
   / Required 1.49GB (includes 54MB temporary) : Available 6.31GB
New Installations (86 products)
   Oracle Notification Service Patch 10.2.0.5.0 
   Database Configuration and Upgrade Assistants Patch 10.2.0.5.0 
   Character Set Migration Utility Patch 10.2.0.5.0 
   Oracle Database 10g Patch 10.2.0.5.0 
   Oracle JDBC/OCI Instant Client Patch 10.2.0.5.0 
   Oracle Database 10g Patch 10.2.0.5.0 
   Enterprise Manager plugin Common Files Patch 10.2.0.5.0 
   SQL*Plus 10.2.0.5.0 
   HAS Common Files Patch 10.2.0.5.0 
   HAS Files for DB Patch 10.2.0.5.0 
   Oracle Java Client Patch 10.2.0.5.0 
   Oracle JVM Patch 10.2.0.5.0 
   Oracle Internet Directory Client Patch 10.2.0.5.0 
   iSQL*Plus 10.2.0.5.0 
   Oracle Advanced Security Patch 10.2.0.5.0 
   Oracle Net Patch 10.2.0.5.0 
   Oracle Net Listener Patch 10.2.0.5.0 
   Oracle Wallet Manager Patch 10.2.0.5.0 
   Precompiler Common Files Patch 10.2.0.5.0 
   Secure Socket Layer Patch 10.2.0.5.0 
   Oracle ODBC Driver Patch 10.2.0.5.0 
   Oracle OLAP Patch 10.2.0.5.0 
   Oracle OLAP API Patch 10.2.0.5.0 
   OLAP SQL Scripts Patch 10.2.0.5.0 
   Oracle interMedia Client Option Patch 10.2.0.5.0 
   Oracle Database 10g interMedia Files Patch 10.2.0.5.0 
   Oracle interMedia Patch 10.2.0.5.0 
   PL/SQL Embedded Gateway Patch 10.2.0.5.0 
   Oracle XML Development Kit Patch 10.2.0.5.0 
   Oracle Text Patch 10.2.0.5.0 
   Oracle Clusterware RDBMS Files Patch 10.2.0.5.0 
   Database SQL Scripts Patch 10.2.0.5.0 
   Oracle Data Mining RDBMS Files Patch 10.2.0.5.0 
   Generic Connectivity Common Files Patch 10.2.0.5.0 
   Oracle Net Required Support Files Patch 10.2.0.5.0 
   Oracle Starter Database Patch 10.2.0.5.0 
   Sample Schema Data Patch 10.2.0.5.0 
   Oracle interMedia Locator RDBMS Files Patch 10.2.0.5.0 
   Oracle Call Interface (OCI) Patch 10.2.0.5.0 
   Oracle OLAP RDBMS Files Patch 10.2.0.5.0 
   PL/SQL 10.2.0.5.0 
   Oracle Recovery Manager Patch 10.2.0.5.0 
   Oracle Database Utilities Patch 10.2.0.5.0 
   Oracle interMedia Locator Patch 10.2.0.5.0 
   XML Parser for Java Patch 10.2.0.5.0 
   Assistant Common Files Patch 10.2.0.5.0 
   Oracle JDBC Thin Driver for JDK 1.2 Patch 10.2.0.5.0 
   Oracle JDBC Thin Driver for JDK 1.4 Patch 10.2.0.5.0 
   Oracle interMedia Java Advanced Imaging Patch 10.2.0.5.0 
   SQLJ Runtime Patch 10.2.0.5.0 
   XML Parser for Oracle JVM Patch 10.2.0.5.0 
   Enterprise Manager Agent DB 10.2.0.5.0 
   Enterprise Manager Baseline 10.2.0.5.0 
   Oracle Enterprise Manager Console DB 10.2.0.5.0 
   XDK Required Support Files Patch 10.2.0.5.0 
   Agent Required Support Files Patch 10.2.0.5.0 
   DBJAVA Required Support Files Patch 10.2.0.5.0 
   LDAP Required Support Files Patch 10.2.0.5.0 
   Precompiler Required Support Files Patch 10.2.0.5.0 
   Oracle RAC Required Support Files-HAS Patch 10.2.0.5.0 
   RDBMS Required Support Files for Instant Client Patch 10.2.0.5.0 
   RDBMS Required Support Files Patch 10.2.0.5.0 
   SQL*Plus Required Support Files Patch 10.2.0.5.0 
   SSL Required Support Files for InstantClient Patch 10.2.0.5.0 
   Installation Common Files Patch 10.2.0.5.0 
   Oracle Globalization Support Patch 10.2.0.5.0 
   Oracle Core Required Support Files Patch 10.2.0.5.0 
   Platform Required Support Files 10.2.0.5.0 
   Oracle Message Gateway Common Files Patch 10.2.0.5.0 
   Enterprise Manager Agent Core Patch 10.2.0.5.0a 
   Enterprise Manager Common Core Patch 10.2.0.5.0a 
   Enterprise Manager Repository Core patch 10.2.0.5.0a 
   Oracle Containers for Java 10.2.0.5.0 
   Enterprise Manager Repository DB 10.2.0.5.0 
   Oracle LDAP administration patch 10.2.0.5.0 
   Oracle Required Support Files 32 bit Patch 10.2.0.5.0 
   JDBC Common Files 10.2.0.5.0 
   Database Workspace Manager 10.2.0.5.0 
   Oracle interMedia Annotator 10.2.0.5.0 
   Enterprise Manager Minimal Integration 10.2.0.5.0 
   Parser Generator Required Support Files 10.2.0.5.0 
   Buildtools Common Files 10.2.0.5.0 
   Oracle UIX 2.2.24.6.0 
   Bali Share 1.1.19.0.0 
   Oracle Real Application Testing 10.2.0.5.0 
   Oracle Configuration Manager 10.3.2.1.0 
Upgrades (5 products)
   Oracle Universal Installer 10.2.0.5.0 
   Oracle One-Off Patch Installer 10.2.0.4.2 
   Installer SDK Component 10.2.0.5.0 
   Java Runtime Environment 1.4.2.14.0 
   Sun JDK 1.4.2.14.05 
Already Installed (84 products)
   Oracle Notification Service 10.1.0.3.0 
   Database Configuration and Upgrade Assistants 10.2.0.1.0 
   Character Set Migration Utility 10.2.0.1.0 
   Oracle Database 10g 10.2.0.1.0 
   Oracle JDBC/OCI Instant Client 10.2.0.1.0 
   Oracle Database 10g 10.2.0.1.0 
   Enterprise Manager plugin Common Files 10.2.0.1.0 
   SQL*Plus 10.2.0.1.0 
   HAS Common Files 10.2.0.1.0 
   HAS Files for DB 10.2.0.1.0 
   Oracle Java Client 10.2.0.1.0 
   Oracle JVM 10.2.0.1.0 
   Oracle Internet Directory Client 10.2.0.1.0 
   iSQL*Plus 10.2.0.1.0 
   Oracle Advanced Security 10.2.0.1.0 
   Oracle Net 10.2.0.1.0 
   Oracle Net Listener 10.2.0.1.0 
   Oracle Wallet Manager 10.2.0.1.0 
   Precompiler Common Files 10.2.0.1.0 
   Secure Socket Layer 10.2.0.1.0 
   Oracle ODBC Driver 10.2.0.1.0 
   Oracle OLAP 10.2.0.1.0 
   Oracle OLAP API 10.2.0.1.0 
   OLAP SQL Scripts 10.2.0.1.0 
   Oracle interMedia Client Option 10.2.0.1.0 
   Oracle Database 10g interMedia Files 10.2.0.1.0 
   Oracle interMedia 10.2.0.1.0 
   PL/SQL Embedded Gateway 10.2.0.1.0 
   Oracle XML Development Kit 10.2.0.1.0 
   Oracle Text 10.2.0.1.0 
   Oracle Clusterware RDBMS Files 10.2.0.1.0 
   Database SQL Scripts 10.2.0.1.0 
   Oracle Data Mining RDBMS Files 10.2.0.1.0 
   Generic Connectivity Common Files 10.2.0.1.0 
   Oracle Net Required Support Files 10.2.0.1.0 
   Oracle Starter Database 10.2.0.1.0 
   Sample Schema Data 10.2.0.1.0 
   Oracle interMedia Locator RDBMS Files 10.2.0.1.0 
   Oracle Call Interface (OCI) 10.2.0.1.0 
   Oracle OLAP RDBMS Files 10.2.0.1.0 
   PL/SQL 10.2.0.1.0 
   Oracle Recovery Manager 10.2.0.1.0 
   Oracle Database Utilities 10.2.0.1.0 
   Oracle interMedia Locator 10.2.0.1.0 
   XML Parser for Java 10.2.0.1.0 
   Assistant Common Files 10.2.0.1.0 
   Oracle JDBC Thin Driver for JDK 1.2 10.2.0.1.0 
   Oracle JDBC Thin Driver for JDK 1.4 10.2.0.1.0 
   Oracle interMedia Java Advanced Imaging 10.2.0.1.0 
   SQLJ Runtime 10.2.0.1.0 
   XML Parser for Oracle JVM 10.2.0.1.0 
   Enterprise Manager Agent DB 10.2.0.1.0 
   Enterprise Manager Baseline 10.2.0.1.0 
   Oracle Enterprise Manager Console DB 10.2.0.1.0 
   XDK Required Support Files 10.2.0.1.0 
   Agent Required Support Files 10.2.0.1.0 
   DBJAVA Required Support Files 10.2.0.1.0 
   LDAP Required Support Files 10.2.0.1.0 
   Precompiler Required Support Files 10.2.0.1.0 
   Oracle RAC Required Support Files-HAS 10.2.0.1.0 
   RDBMS Required Support Files for Instant Client 10.2.0.1.0 
   RDBMS Required Support Files 10.2.0.1.0 
   SQL*Plus Required Support Files 10.2.0.1.0 
   SSL Required Support Files for InstantClient 10.2.0.1.0 
   Installation Common Files 10.2.0.1.0 
   Oracle Globalization Support 10.2.0.1.0 
   Oracle Core Required Support Files 10.2.0.1.0 
   Platform Required Support Files 10.2.0.1.0 
   Oracle Message Gateway Common Files 10.2.0.1.0 
   Enterprise Manager Agent Core 10.2.0.1.0 
   Enterprise Manager Common Files 10.2.0.1.0 
   Enterprise Manager Repository Core 10.2.0.1.0 
   Oracle Containers for Java 10.2.0.1.0 
   Enterprise Manager Repository DB 10.2.0.1.0 
   Oracle LDAP administration 10.2.0.1.0 
   Oracle Required Support Files 32 bit 10.2.0.0.0 
   JDBC Common Files 10.2.0.1.0 
   Database Workspace Manager 10.2.0.1.0 
   Oracle interMedia Annotator 10.2.0.1.0 
   Enterprise Manager Minimal Integration 10.2.0.1.0 
   Parser Generator Required Support Files 10.2.0.1.0 
   Buildtools Common Files 10.2.0.1.0 
   Oracle UIX 2.1.22.0.0 
   Bali Share 1.1.18.0.0 
-----------------------------------------------------------------------------
  
  
Deinstall in progress (Monday, February 4, 2013 3:38:47 PM CST)
...............................................................   0% Done.
...............................................................  14% Done.
...............................................................  28% Done.
...............................................................  42% Done.
...............................................................  56% Done.
...............................................................  70% Done.
...............................................................  85% Done.
...                                                             100% Done.
  
Deinstall successful
  
Installation in progress (Monday, February 4, 2013 3:38:48 PM CST)
...............................................................  14% Done.
...............................................................  28% Done.
...............................................................  42% Done.
...............................................................  56% Done.
...............................................................  70% Done.
...............................................................  85% Done.
.............                                                    88% Done.
Install successful
  
Linking in progress (Monday, February 4, 2013 3:41:15 PM CST)
...                                                              88% Done.
Link successful
  
Setup in progress (Monday, February 4, 2013 3:42:31 PM CST)
...........                                                     100% Done.
Setup successful
  
End of install phases.(Monday, February 4, 2013 3:42:39 PM CST)
Starting to execute configuration assistants
Configuration assistant "Oracle Configuration Manager Configuration" succeeded 
WARNING:
The following configuration scripts need to be executed as the "root" user.
#!/bin/sh
#Root script to run
/u01/app/oracle/product/10.2.0/db_1/root.sh
To execute the configuration scripts:
    1. Open a terminal window
    2. Log in as "root"
    3. Run the scripts
  
The installation of Oracle Database 10g Release 2 Patch Set 4 was successful.
Please check '/u01/app/oracle/oraInventory/logs/silentInstall2013-02-04_03-38-28PM.log' for more details.

注意:

10.2.0.5安装出现
SEVERE:无法从命令行或响应文件中获取以下变量的值:
  MYORACLESUPPORT_USERNAME(MyOracleSupportUsername)
无法继续进行无提示安装。
解决办法是:在安装命令之后加上两个参数就可以了
./runInstaller -silent -responseFile /data/oracle/Disk1/response/patchset.rsp [email protected] DECLINE_SECURITY_UPDATES=true

12. 升级后续工作

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
[oracle@rac1 ~]$ sqlplus " / as sysdba"
  
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Feb 4 15:44:52 2013
  
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
  
Connected to an idle instance.
  
SQL> startup upgrade 
ORACLE instance started.
  
Total System Global Area  599785472 bytes
Fixed Size                  2098112 bytes
Variable Size             171969600 bytes
Database Buffers          419430400 bytes
Redo Buffers                6287360 bytes
Database mounted.
Database opened.
SQL> @?/rdbms/admin/catupgrd.sql 
  
SQL> @?/rdbms/admin/utlrp.sql 
  
  
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit

13. 打10.2.0.5后续p6880880_102000_Linux补丁,升级opatch版本

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
[oracle@rac1 ~]$ cp p6880880_102000_Linux-x86-64.zip $ORACLE_HOME
[oracle@rac1 ~]$ cd $ORACLE_HOME
  
[oracle@rac1 db_1]$ unzip p6880880_102000_Linux-x86-64.zip
Archive:  p6880880_102000_Linux-x86-64.zip
   creating: OPatch/
   creating: OPatch/ocm/
 extracting: OPatch/ocm/ocm.zip      
   creating: OPatch/ocm/lib/
  inflating: OPatch/ocm/lib/osdt_jce.jar  
  inflating: OPatch/ocm/lib/osdt_core3.jar  
  inflating: OPatch/ocm/lib/emocmclnt-14.jar  
  inflating: OPatch/ocm/lib/emocmutl.jar
    
  inflating: OPatch/README.txt       
[oracle@rac1 db_1]$ ll OPatch
  
[oracle@rac1 db_1]$ ll OPatch
total 80
drwxr-xr-x. 3 oracle oinstall  4096 Nov  3  2010 crs
drwxr-xr-x. 2 oracle oinstall  4096 Nov  3  2010 docs
-rw-r--r--. 1 oracle oinstall 23695 Nov  3  2010 emdpatch.pl
drwxr-xr-x. 2 oracle oinstall  4096 Nov  3  2010 jlib
drwxr-xr-x. 4 oracle oinstall  4096 Nov  3  2010 ocm
-r-x--x---. 1 oracle oinstall 13252 Nov  3  2010 opatch
-rwxr-xr-x. 1 oracle oinstall  8085 Nov  3  2010 opatch.bat
-rw-r--r--. 1 oracle oinstall    49 Nov  3  2010 opatch.ini
-rw-r--r--. 1 oracle oinstall  2576 Nov  3  2010 opatch.pl
drwxr-xr-x. 4 oracle oinstall  4096 Nov  3  2010 opatchprereqs
-rw-r--r--. 1 oracle oinstall  2417 Nov  3  2010 README.txt
[oracle@rac1 db_1]$ cd OPatch
[oracle@rac1 OPatch]$ ./opatch version
Invoking OPatch 10.2.0.5.1
  
OPatch Version: 10.2.0.5.1
  
OPatch succeeded.
  
  
[oracle@rac1 OPatch]$ export PATH=$PATH:$ORACLE_HOME/OPatch

14.解压p14275629_10205_Linux-x86-64.zip补丁

1
2
3
4
5
6
7
8
9
10
11
12
[oracle@rac1 ~]$ unzip p14275629_10205_Linux-x86-64.zip
Archive:  p14275629_10205_Linux-x86-64.zip
   creating: p14275629_10205_Linux-x86-64/
   creating: p14275629_10205_Linux-x86-64/14275629/
  inflating: p14275629_10205_Linux-x86-64/14275629/README.html  
 extracting: p14275629_10205_Linux-x86-64/14275629/README.txt  
   creating: p14275629_10205_Linux-x86-64/14275629/custom/
   creating: p14275629_10205_Linux-x86-64/14275629/custom/scripts/
  inflating: p14275629_10205_Linux-x86-64/14275629/custom/scripts/pre  
   creating: p14275629_10205_Linux-x86-64/14275629/etc/
   creating: p14275629_10205_Linux-x86-64/14275629/etc/config/
  inflating: p14275629_10205_Linux-x86-64/14275629/etc/config/actions  

15.optach前准备工作

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
[oracle@rac1 ~]$ cd p14275629_10205_Linux-x86-64
[oracle@rac1 p14275629_10205_Linux-x86-64]$ ls
14275629
  
oracle@rac1 p14275629_10205_Linux-x86-64]$ $ORACLE_HOME/OPatch/opatch prereq CheckConflictAgainstOHWithDetail -phBaseDir 14275629
Invoking OPatch 10.2.0.5.1
  
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
  
PREREQ session
  
Oracle Home       : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2013-02-04_23-39-18PM.log
  
Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
  
Invoking prereq "checkconflictagainstohwithdetail"
  
Prereq "checkConflictAgainstOHWithDetail" passed.
  
OPatch succeeded.

16.进行optach

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
oracle@rac1 14275629]$ opatch apply          
Invoking OPatch 10.2.0.5.1
  
Oracle Interim Patch Installer version 10.2.0.5.1
Copyright (c) 2010, Oracle Corporation.  All rights reserved.
  
  
Oracle Home       : /u01/app/oracle/product/10.2.0/db_1
Central Inventory : /u01/app/oracle/oraInventory
   from           : /etc/oraInst.loc
OPatch version    : 10.2.0.5.1
OUI version       : 10.2.0.5.0
OUI location      : /u01/app/oracle/product/10.2.0/db_1/oui
Log file location : /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch2013-02-04_23-44-17PM.log
  
Patch history file: /u01/app/oracle/product/10.2.0/db_1/cfgtoollogs/opatch/opatch_history.txt
  
ApplySession applying interim patch '14275629' to OH '/u01/app/oracle/product/10.2.0/db_1'
  
Running prerequisite checks...
Patch 14275629: Optional component(s) missing : [ oracle.rdbms.dv, 10.2.0.5.0 ] , [ oracle.rdbms.dv.oc4j, 10.2.0.5.0 ] , [ oracle.network.cman, 10.2.0.5.0 ] 
  
OPatch detected non-cluster Oracle Home from the inventory and will patch the local system only.
  
  
Please shutdown Oracle instances running out of this ORACLE_HOME on the local system.
(Oracle Home = '/u01/app/oracle/product/10.2.0/db_1')
  
  
Is the local system ready for patching? [y|n]
y
User Responded with: Y
Backing up files and inventory (not for auto-rollback) for the Oracle Home
Backing up files affected by the patch '14275629' for restore. This might take a while...
Backing up files affected by the patch '14275629' for rollback. This might take a while...
Execution of 'sh /home/oracle/p14275629_10205_Linux-x86-64/14275629/custom/scripts/pre -apply 14275629 ':
  
  
Return Code = 0
  
Patching component oracle.rdbms, 10.2.0.5.0...
  
  
The local system has been patched and can be restarted.
  
  
OPatch succeeded.

17.optach后续动作

1
2
3
4
5
6
7
8
cd $ORACLE_HOME/rdbms/admin
sqlplus /nolog
SQL> CONNECT / AS SYSDBA
SQL> STARTUP
SQL> @catbundle.sql psu apply
SQL> -- Execute the next statement only if this is the first PSU applied for 10.2.0.5 or this is the first PSU applied since 10.2.0.5.3.
SQL> @utlrp.sql
SQL> QUIT

18.补丁版本检查

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
[oracle@rac1 14275629]$ sqlplus " / as sysdba"
  
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Feb 4 23:52:20 2013
  
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
  
  
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
  
SQL>  select substr(action_time,1,30)action_time, 
  2  substr(id,1,10) id
  3  substr(action,1,10) action, 
  4  substr(version,1,8) version, 
  5  substr(BUNDLE_SERIES,1,6)bundle, 
  6  substr(comments,1,20) comments 
  7  from registry$history
  
ACTION_TIME                    ID         ACTION     VERSION  BUNDLE
------------------------------ ---------- ---------- -------- ------
COMMENTS
--------------------
04-FEB-13 04.12.05.437338 PM   8289601    VIEW RECOM
view recompilation
  
04-FEB-13 04.12.05.496207 PM              UPGRADE    10.2.0.5
Upgraded from 10.2.0
  
04-FEB-13 11.49.27.701551 PM   9          APPLY      10.2.0.5 PSU
PSU 10.2.0.5.9
  
SQL> select * from v$version;
  
BANNER
----------------------------------------------------------------
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi
PL/SQL Release 10.2.0.5.0 - Production
CORE    10.2.0.5.0      Production
TNS for Linux: Version 10.2.0.5.0 - Production
NLSRTL Version 10.2.0.5.0 - Production
  
SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
  
COMP_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ -----------
Oracle Enterprise Manager
10.2.0.5.0                     VALID
  
Spatial
10.2.0.5.0                     VALID
  
Oracle interMedia
10.2.0.5.0                     VALID
  
  
COMP_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ -----------
OLAP Catalog
10.2.0.5.0                     VALID
  
Oracle XML Database
10.2.0.5.0                     VALID
  
Oracle Text
10.2.0.5.0                     VALID
  
  
COMP_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ -----------
Oracle Expression Filter
10.2.0.5.0                     VALID
  
Oracle Rule Manager
10.2.0.5.0                     VALID
  
Oracle Workspace Manager
10.2.0.5.0                     VALID
  
  
COMP_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ -----------
Oracle Data Mining
10.2.0.5.0                     VALID
  
Oracle Database Catalog Views
10.2.0.5.0                     VALID
  
Oracle Database Packages and Types
10.2.0.5.0                     VALID
  
  
COMP_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ -----------
JServer JAVA Virtual Machine
10.2.0.5.0                     VALID
  
Oracle XDK
10.2.0.5.0                     VALID
  
Oracle Database Java Packages
10.2.0.5.0                     VALID
  
  
COMP_NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
VERSION                        STATUS
------------------------------ -----------
OLAP Analytic Workspace
10.2.0.5.0                     VALID
  
Oracle OLAP API
10.2.0.5.0                     VALID
  
  
17 rows selected.
  
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@rac1 14275629]$ $ORACLE_HOME/OPatch/opatch version
Invoking OPatch 10.2.0.5.1
  
OPatch Version: 10.2.0.5.1
  
OPatch succeeded.
[oracle@rac1 14275629]$ $ORACLE_HOME/OPatch/opatch lsinv -bugs_fixed|grep PSU
                                                    ENCAPSULATED BY EXCEPTION HANDLING
9952230    14275629  Mon Feb 04 23:47:09 CST 2013   DATABASE PSU 10.2.0.5.1 (INCLUDES CPUOCT2010)
10248542   14275629  Mon Feb 04 23:47:09 CST 2013   DATABASE PSU 10.2.0.5.2 (INCLUDES CPUJAN2011)
11724962   14275629  Mon Feb 04 23:47:09 CST 2013   DATABASE PSU 10.2.0.5.3 (INCLUDES CPUAPR2011)
12419392   14275629  Mon Feb 04 23:47:09 CST 2013   DATABASE PSU 10.2.0.5.4 (INCLUDES CPUJUL2011)
12827745   14275629  Mon Feb 04 23:47:09 CST 2013   DATABASE PSU 10.2.0.5.5 (INCLUDES CPUOCT2011)
13343471   14275629  Mon Feb 04 23:47:09 CST 2013   DATABASE PSU 10.2.0.5.6 (INCLUDES CPUJAN2012)
13349665   14275629  Mon Feb 04 23:47:09 CST 2013   ORA-600 [KKSLMTL-VALNOTFOUND] WITH PSU 10.2.0.5.5
13775862   14275629  Mon Feb 04 23:47:09 CST 2013   AFTER TO APPLY PSU PATCH DVA FAILS WITH 500 
                                                    TOP OF PSUS >= 10.2.0.5.3
14269955   14275629  Mon Feb 04 23:47:09 CST 2013   MISSING KFD.O IN PSU 10.2.0.5.6 10.2.0.5.7 10.2.0.
  
[oracle@rac1 14275629]$ sqlplus " / as sysdba"
  
SQL*Plus: Release 10.2.0.5.0 - Production on Mon Feb 4 23:52:20 2013
  
Copyright (c) 1982, 2010, Oracle.  All Rights Reserved.
  
  
Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
  
SQL>  select substr(action_time,1,30)action_time, 
  2  substr(id,1,10) id
  3  substr(action,1,10) action, 
  4  substr(version,1,8) version, 
  5  substr(BUNDLE_SERIES,1,6)bundle, 
  6  substr(comments,1,20) comments 
  7  from registry$history
  
ACTION_TIME                    ID         ACTION     VERSION  BUNDLE
------------------------------ ---------- ---------- -------- ------
COMMENTS
--------------------
04-FEB-13 04.12.05.437338 PM   8289601    VIEW RECOM
view recompilation
  
04-FEB-13 04.12.05.496207 PM              UPGRADE    10.2.0.5
Upgraded from 10.2.0
  
04-FEB-13 11.49.27.701551 PM   9          APPLY      10.2.0.5 PSU
 
 
 
 
 
05-11 13:02