暂无图片
暂无图片
1
暂无图片
暂无图片
暂无图片

linux下oracle 11.2.0.1升级到11.2.0.4

原创 章芋文 2014-06-10
2765
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解压
[code][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.[/code]
查看数据库信息
[code]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 string ORASQL[/code]
清空回收站
[code]SQL> purge DBA_RECYCLEBIN;

DBA Recyclebin purged.

SQL> select count(*) from DBA_RECYCLEBIN;

COUNT(*)
----------
0 [/code]
查看无效对象
[code]SQL> select count(*) from dba_objects where status<>'VALID';

COUNT(*)
----------
0[/code]
备份数据库关闭数据库,关闭监听
[code]SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
[oracle@localhost u02]$ lsnrctl status

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 07-JAN-2014 16:09:28

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))
TNS-12541: TNS:no listener
TNS-12560: TNS:protocol adapter error
TNS-00511: No listener
Linux Error: 111: Connection refused
[oracle@localhost u02]$[/code]
修改环境变量中指定11.2.0.4,并用source生效
[code]export ORACLE_BASE=/u02
export ORACLE_HOME=/u02/product/database [/code]
运行,Patchset 中的runInstaller升级软件
[code][oracle@localhost u02]$ cd database/
[oracle@localhost database]$ ls
install response runInstaller stage
readme.html rpm sshsetup welcome.html
[oracle@localhost database]$ ./runInstaller[/code]
[img]http://www.orasql.com/bbs/download/file.php?id=140[/img]
[img]http://www.orasql.com/bbs/download/file.php?id=141[/img]
[img]http://www.orasql.com/bbs/download/file.php?id=144[/img]
[img]http://www.orasql.com/bbs/download/file.php?id=142[/img]
运行root脚本
[code][oracle@localhost ~]$ su -
Password:
[root@localhost ~]# cd /u02/product/database/
[root@localhost database]# sh root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u02/product/database

Enter the full pathname of the local bin directory: [/usr/local/bin]:
The contents of "dbhome" have not changed. No need to overwrite.
The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying oraenv to /usr/local/bin ...
The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]: y
Copying coraenv to /usr/local/bin ...

Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@localhost database]#[/code]
不需要配置监听
[img]http://www.orasql.com/bbs/download/file.php?id=143[/img]
运行升级后的脚本
[code][oracle@localhost ~]$ export ORACLE_HOME=/oracle/product/database/
[oracle@localhost ~]$ $ORACLE_HOME/bin/sqlplus / as sysdba

SQL*Plus: Release 11.2.0.1.0 Production on Tue Jan 7 19:09:38 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> @/u02/product/database/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 01-07-2014 19:12:02
Script Version: 11.2.0.4.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: ORASQL
--> version: 11.2.0.1.0
--> compatible: 11.2.0
--> blocksize: 8192
--> platform: Linux IA (32-bit)
--> timezone file: V11
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
WARNING: --> SYSTEM tablespace is not large enough for the upgrade.
.... currently allocated size: 400 MB
.... minimum required size: 442 MB
.... increase current size by: 42 MB
.... tablespace is NOT AUTOEXTEND ENABLED.
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 449 MB
--> TEMPTS1 tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
--> UNDOTBS2 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
.
**********************************************************************
Flashback: OFF
**********************************************************************
**********************************************************************
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile]
Note: Pre-upgrade tool was run on a lower version 32-bit database.
**********************************************************************
--> If Target Oracle is 32-Bit, refer here for Update Parameters:
WARNING: --> "memory_target" needs to be increased to at least 436 MB
.

--> If Target Oracle is 64-Bit, refer here for Update Parameters:
WARNING: --> "memory_target" needs to be increased to at least 620 MB
.
**********************************************************************
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
.
**********************************************************************
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.
.
**********************************************************************
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.

********************************************************************** [/code]
根据检查,增大system表空间
[code]SQL> alter database datafile '/oracle/oradata/orasql/datafile/system01.dbf' resize 450m;[/code]
收集数据字典状态
[code]SQL> EXECUTE dbms_stats.gather_dictionary_stats;

startup UPGRADE pfile=‘/oracle/product/database/dbs/intorasql.ora’


@catupgrd.sql[/code]
输出省略
大概15min
里面有shutdown命令
[code]
create spfile from memory

startup
@utlu112s.sql


SQL> @?/rdbms/admin/utlu112s.sql
.
Oracle Database 11.2 Post-Upgrade Status Tool 01-07-2014 20:27:23
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. VALID 11.2.0.4.0 00:16:14
Final Actions
. 00:00:01
Total Upgrade Time: 00:16:16

PL/SQL procedure successfully completed.[/code]
失效对象:
[code]@?/rdbms/admin/utlrp.sql[/code]

查看升级后的版本信息:
[code]SQL> shutdown
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 418484224 bytes
Fixed Size 1365040 bytes
Variable Size 306187216 bytes
Database Buffers 104857600 bytes
Redo Buffers 6074368 bytes
Database mounted.
Database opened.

SQL> show parameter golden

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
enable_goldengate_replication boolean FALSE
SQL> select * from v$version;

BANNER
--------------------------------------------------------------------------------
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - Production
PL/SQL Release 11.2.0.4.0 - Production
CORE 11.2.0.4.0 Production
TNS for Linux: Version 11.2.0.4.0 - Production
NLSRTL Version 11.2.0.4.0 - Production

SQL> select instance_name,status from v$instance;

INSTANCE_NAME STATUS
---------------- ------------
orasql OPEN [/code]
「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论