用户名:   自动登录 找回密码
密   码:    * 注册




发表新帖 回复这个主题  [ 1 篇帖子 ] 
作者 内容
 文章标题 : linux下oracle 11.2.0.1升级到11.2.0.4
帖子发表于 : 2014-06-10 13:07 
离线
头像

注册: 2011-05-01 9:15
帖子: 120
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                        string      ORASQL


清空回收站
代码:
SQL>  purge DBA_RECYCLEBIN;

DBA Recyclebin purged.

SQL> select count(*) from DBA_RECYCLEBIN;

  COUNT(*)
----------
         0


查看无效对象
代码:
SQL>  select count(*) from dba_objects where status<>'VALID';

  COUNT(*)
----------
         0


备份数据库关闭数据库,关闭监听
代码:
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]$


修改环境变量中指定11.2.0.4,并用source生效
export ORACLE_BASE=/u02
export ORACLE_HOME=/u02/product/database

运行,Patchset 中的runInstaller升级软件
[oracle@localhost u02]$ cd database/
[oracle@localhost database]$ ls
install response runInstaller stage
readme.html rpm sshsetup welcome.html
[oracle@localhost database]$ ./runInstaller
附件:
11.2.0.1 11.2.0.4 Image.2.jpeg
11.2.0.1 11.2.0.4 Image.2.jpeg [ 89.65 KiB | 被浏览 5560 次 ]

附件:
11.2.0.1 11.2.0.4 Image.jpeg
11.2.0.1 11.2.0.4 Image.jpeg [ 110.87 KiB | 被浏览 5560 次 ]

附件:
11.2.0.1 11.2.0.4 Image.1.jpeg
11.2.0.1 11.2.0.4 Image.1.jpeg [ 101.26 KiB | 被浏览 5560 次 ]

附件:
11.2.0.1 11.2.0.4 Image.3.jpeg
11.2.0.1 11.2.0.4 Image.3.jpeg [ 134.78 KiB | 被浏览 5560 次 ]

代码:
[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]#

不需要配置监听
附件:
11.2.0.1 11.2.0.4 Image.4.jpeg
11.2.0.1 11.2.0.4 Image.4.jpeg [ 150.14 KiB | 被浏览 5560 次 ]

代码:
[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.

**********************************************************************


根据检查,增大system表空间
代码:
SQL> alter database datafile '/oracle/oradata/orasql/datafile/system01.dbf' resize 450m;

收集数据字典状态
代码:
SQL> EXECUTE dbms_stats.gather_dictionary_stats;

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


@catupgrd.sql


输出省略
大概15min
里面有shutdown命令
代码:
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.



@?/rdbms/admin/utlrp.sql
失效对象


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


页首
 用户资料  
 
显示帖子 :  排序  
发表新帖 回复这个主题  [ 1 篇帖子 ] 


在线用户

注册用户: 没有注册用户


查找:
前往 :  
cron
Powered by OraSql © 2011, 2012, oracle_awen