详细可以参考：http://blog.****.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;
###########以下为参考文章：##############
|
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! |
|
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)
|
|
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 |
|
1
|
[root@rac1 ~]# echo 54322 > /proc/sys/vm/hugetlb_shm_group
|
|
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
|
要修改的地方如下：
#------------------------------------------------------------------------------
#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 MYORACLESUPPORT_USERNAME=email@qq.com 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 MYORACLESUPPORT_USERNAME=email@qq.com 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 |