11.2.0.4 补丁号: 13390677,直接在mos中搜即可。
新特性:http://docs.oracle.com/cd/E11882_01/server.112/e41360/chapter1_11204.htm#NEWFT379
一共有7个文件,升级DB只需要1和2, 下载1和2即可:
1&2 db
3 grid
4 client
5 gateways
6 examples
7 deinstall
unzip解压
[oracle@localhost u02]$ ls -l
total 2466108
-rw-r--r-- 1 oracle dba 1380374377 Jan 7 17:34 p13390677_112040_LINUX_1of7.zip
-rw-r--r-- 1 oracle dba 1142436991 Jan 7 17:27 p13390677_112040_LINUX_2of7.zip
[oracle@localhost u02]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 7 15:54:51 2014
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 418484224 bytes
Fixed Size 1336932 bytes
Variable Size 314575260 bytes
Database Buffers 96468992 bytes
Redo Buffers 6103040 bytes
Database mounted.
Database opened.
查看数据库信息
SQL> select * from v$version;
BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
PL/SQL Release 11.2.0.1.0 - Production
CORE 11.2.0.1.0 Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production
SQL> show parameter name
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_file_name_convert string
db_name string ORASQL
db_unique_name string ORASQL
global_names boolean FALSE
instance_name string orasql
lock_name_space string
log_file_name_convert string
service_names str