首先下载Oracle 11.2.0.3 Patchset
创新互联专注于鼓楼网站建设服务及定制，我们拥有丰富的企业做网站经验。 热诚为您提供鼓楼营销型网站建设，鼓楼网站制作、鼓楼网页设计、鼓楼网站官网定制、微信平台小程序开发服务，打造鼓楼网络公司原创品牌,更为您提供
鼓楼网站排名全网营销落地服务。
http://yunpan.cn/cHgQuIuxUTThS
访问密码 043f
将Patchset上传至服务器
[oracle@localhost ~]$ ls
p10404530_112030_Linux-x86-64_1of7.zip p10404530_112030_Linux-x86-64_2of7.zip
解压安装包
[oracle@localhost ~]$ unzip p10404530_112030_Linux-x86-64_1of7.zip
[oracle@localhost ~]$ unzip p10404530_112030_Linux-x86-64_2of7.zip
进入安装目录
[oracle@localhost ~]$ cd database/
[oracle@localhost database]$ ls
doc install readme.html response rpm runInstaller sshsetup stage welcome.html
一、安装11.2.0.3 只安装软件软件
运行runInstaller
[oracle@localhost database]$ export ORACLE_HOME="/u01/app/oracle/product/11.2.0.3/db_1"
[oracle@localhost database]$ ./runInstaller
选择只安装软件选项
选择新的ORACLE_HOME
二、安装完毕11.2.0.3后，需要运行脚本执行升级前的预检查。
[root@localhost ~]# su - oracle
[oracle@localhost ~]$ export | grep ORACLE_HOME
declare -x ORACLE_HOME="/u01/app/oracle/product/11.2.0.1/db_1"
注意，使用旧版本登录数据库
SQL> SPOOL upgrade_info.log
SQL> @/u01/app/oracle/product/11.2.0.3/db_1/rdbms/admin/utlu112i.sql
SQL> SPOOL OFF
日志如下
Oracle Database 11.2 Pre-Upgrade Information Tool 09-17-2015 22:13:08
Script Version: 11.2.0.3.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: ORCL
--> version: 11.2.0.1.0
--> compatible: 11.2.0.0.0
--> blocksize: 8192
--> platform: Linux x86 64-bit
--> timezone file: V11
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 681 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 468 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 64-bit database.
**********************************************************************
--> If Target Oracle is 32-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.
--> If Target Oracle is 64-Bit, refer here for Update Parameters:
-- No update parameter changes are required.
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or spfile]
**********************************************************************
-- No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle Application Express [upgrade] VALID
... APEX will only be upgraded if the version of APEX in
... the target Oracle home is higher than the current one.
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 11.2.0.1.0 database timezone version
.... to the latest version which comes with the new release.
WARNING: --> Your recycle bin is turned on and currently contains no objects.
.... Because it is REQUIRED that the recycle bin be empty prior to upgrading
.... and your recycle bin is turned on, you may need to execute the command:
PURGE DBA_RECYCLEBIN
.... prior to executing your upgrade to confirm the recycle bin is empty.
WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER APEX_030200 has dependent objects.
.
**********************************************************************
Recommendations
**********************************************************************
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
**********************************************************************
Oracle recommends reviewing any defined events prior to upgrading.
To view existing non-default events execute the following commands
while connected AS SYSDBA:
Events:
SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2
WHERE UPPER(name) ='EVENT' AND isdefault='FALSE'
Trace Events:
SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2
WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
按照日志要求，执行数据库字典统计
EXECUTE dbms_stats.gather_dictionary_stats;SQL> SELECT (translate(value,chr(13)||chr(10),' ')) FROM sys.v$parameter2 WHERE UPPER(name) ='EVENT' AND isdefault='FALSE';
no rows selectedSQL> SELECT (translate(value,chr(13)||chr(10),' ')) from sys.v$parameter2 WHERE UPPER(name) = '_TRACE_EVENTS' AND isdefault='FALSE';
no rows selected
三、配置新版的LISTENER
[oracle@localhost bin]$ export ORACLE_HOME=/u01/app/oracle/product/11.2.0.3/db_1
[oracle@localhost bin]$ export TNS_ADMIN="/u01/app/oracle/product/11.2.0.3/db_1/network/admin"
[oracle@localhost ~]$ cd /u01/app/oracle/product/11.2.0.3/db_1/bin/
[oracle@localhost bin]$ ./netmgr
[oracle@localhost bin]$ cd /u01/app/oracle/product/11.2.0.3/db_1/network/admin
[oracle@localhost admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = orcl)
(ORACLE_HOME = /u01/app/oracle/product/11.2.0.3/db_1)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.199.240)(PORT = 1521))
)
ADR_BASE_LISTENER = /u01/app/oracle
关闭旧listener
[oracle@localhost ~]$ lsnrctl stop
LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 17-SEP-2015 22:54:22
Copyright (c) 1991, 2009, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.199.240)(PORT=1521)))
The command completed successfully
启动新listener
[oracle@localhost admin]$ cd /u01/app/oracle/product/11.2.0.3/db_1/bin/
[oracle@localhost bin]$ ./lsnrctl start
LSNRCTL for Linux: Version 11.2.0.3.0 - Production on 17-SEP-2015 22:52:47
Copyright (c) 1991, 2011, Oracle. All rights reserved.
Starting /u01/app/oracle/product/11.2.0.3/db_1/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 11.2.0.3.0 - Production
System parameter file is /u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.199.240)(PORT=1521)))
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.199.240)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.3.0 - Production
Start Date 17-SEP-2015 22:52:47
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/11.2.0.3/db_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/localhost/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.199.240)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
四、执行dbua
[oracle@localhost bin]$ pwd
/u01/app/oracle/product/11.2.0.3/db_1/bin
[oracle@localhost bin]$ ./dbua
点击Next
点击Next
点击Yes
你可以选择进行Timezone更新，也可以选择备份数据库。点击Next
点击Next
点击Next
点击Finish
点击OK
检查升级结果，如果没有错误，升级完成。
修改ORACLE_HOME环境变量，指向新的Oracle home
[oracle@localhost ~]$ vi .bash_profile
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1
修改/etc/oratab
[oracle@localhost ~]$ vi /etc/oratab
orcl:/u01/app/oracle/product/11.2.0.3/db_1:N
另外有需要云服务器可以了解下创新互联cdcxhl.cn，海内外云服务器15元起步，三天无理由+7*72小时售后在线，公司持有idc许可证，提供“云服务器、裸金属服务器、高防服务器、香港服务器、美国服务器、虚拟主机、免备案服务器”等云主机租用服务以及企业上云的综合解决方案，具有“安全稳定、简单易用、服务可用性高、性价比高”等特点与优势，专为企业上云打造定制，能够满足用户丰富、多元化的应用场景需求。
网站名称：Oracledatabase11.2.0.1升级至11.2.0.3-创新互联
URL标题：
http://www.cdkjz.cn/article/dsogjh.html
