详细可以参考: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;
###########以下为参考文章:##############
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
|