32位 xp oracle 11gR2安装升级

安装包：p10404530_112030_WINNT_1of6.zip，p10404530_112030_WINNT_2of6.zip解压

环境:xp sp3,32 bit

升级版本前后:10.2.0.5.0=>11.2.0.3.0

--------------------------------------------下载地址-------------------------------------------------------------

http://115.com/file/e7qt7lyb#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part01.rar
http://115.com/file/dpqmpi8v#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part02.rar
http://115.com/file/c2932zzn#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part03.rar
http://115.com/file/ansun9nv#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part04.rar
http://115.com/file/e7qt7w0f#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part05.rar
http://115.com/file/e7qt7hd6#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part06.rar
http://115.com/file/ansunhiy#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part07.rar
http://115.com/file/bepghtrc#
Oracle_Database_11g_r_2_(11.2.0.3)_32bit.part08.rar

--------------------------------------------参考-------------------------------------------------------------

参考半天

http://blog.csdn.net/robin_he/article/details/7345842

http://www.cnblogs.com/snake-hand/archive/2012/04/16/2452219.html

http://onlineappsdba.com/index.php/2009/01/22/upgrade-oracle-database-10g-to-11g-r1-111x/

http://docs.oracle.com/cd/E11882_01/server.112/e10819/intro.htm#i1008374

一天没搞定

结果最后用oracle11g自带的duba居然就升级好了,泪奔啊,Manual upgrade太难了

--------------------------------------------升级------------------------------------------------------------

Oracle Database 11g Release 2 (11.2) supports the following tools and methods for upgrading a database to the new release:

• Database Upgrade Assistant (DBUA)

  Provides a graphical user interface that guides you through the upgrade of a database. DBUA can be launched during installation with theOracle Universal Installer, or you can launch DBUA as a standalone tool at any time in the future.

  Note:

  DBUA is the recommended method for performing a major release upgrade or patch release upgrade.

• Manual upgrade using SQL scripts and utilities

  Enables upgrades to be performed at the command line with SQL scripts and utilities.

• Export and Import utilities

  Uses Oracle Data Pump utilities, or the native Export and Import features within Oracle Database. These utilities perform a full or partial export from your database, followed by a full or partial import into the new Oracle Database 11g. Export/Import can copy a subset of the data, leaving the database unchanged.

• CREATE TABLE AS SQL statement

  Copies data from a database into a new Oracle Database 11g database. Data copying can copy a subset of the data, leaving the database unchanged.

--------下面转自http://onlineappsdba.com/index.php/2009/01/22/upgrade-oracle-database-10g-to-11g-r1-111x/----------------------------------------------------------------------------------

Upgrade Steps

1. Prepare to Upgrade

1.1 Install 11g in different (new) ORACLE_HOME with following consideration
a) When prompted for Upgrade an Existing Database (Select NO)

b) On Select Configuration Option  select Install Software Only

.
Use Installation Guide from here
1.2 Analyze database using pre-upgrade information tool ( utlu111i.sql sql script available at 11g_oracle_homne/rdbms/admin/utlu111i.sql run it from source database i.e. 10g)

sqlplus “/as sysdba”
SQL>spool upgrade_info.log
SQL>@/11g_oracle_home/rdbms/admin/utlu111i.sql

1.3 Check the output of the Pre-Upgrade Information Tool in upgrade_info.log and fix any issues

Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**************************************************
–> “background_dump_dest” replaced by  “diagnostic_dest”
–> “user_dump_dest” replaced by  “diagnostic_dest”
–> “core_dump_dest” replaced by  “diagnostic_dest”

To fix this obsolete parameter, comment out from initialization parameter file and replace with new parameter likecomment above three deprecated parameters and add *.diagnostic_dest

WARNING: –> Database is using an old timezone file version.
…. Patch the 10.2.0.1.0 database to timezone file version 4
…. BEFORE upgrading the database.  Re-run utlu111i.sql after
…. patching the database to record the new timezone file version.

To find time zone file version on source database (10g) run
SQL> select * from v$timezone_file;
If time zone file version is less than 4 then apply time zone patch  5632264 manually for 10.2.0.1 database (more on How to manually upgrade time zone file version on database coming soon … )

1.4 Check invalid objects
SQL> select object_name, owner, object_type from all_objects where status like ‘INVALID’;

1.5 Check version & status of all database components
SQL>select comp_name,version, status from dba_registry;

1.6 Take backup of source database i.e. 10g database

1.7 If you are using spfile, create pfile
SQL> create pfile from spfile ;

This will create pfile in 10g $ORACLE_HOME/dbs/init[SID].ora

1.8 Copy initialization file (pfile) from source (10g) to target (11g)

1.9 Adjust initialization parameter specific to 11g like

a) Remove *.background_dump_dest, *.core_dump_dest, *.user_dump_dest and add
*.diagnostic_dest=’/11g_base’  (11g Base Directory)
b) Change
*.compatible=’10.2.0.1.0′
to
*.compatible=’11.1.0′

2. duba吧，囧

参考：http://space.itpub.net/22821701/viewspace-702468

由于参考http://www.cnblogs.com/snake-hand/archive/2012/04/16/2452219.html处理一系列升级准备，所以duba没报错

3.升级结果

C:\Documents and Settings\Administrator>sqlplus "/ as sysdba"

SQL*Plus: Release 11.2.0.3.0 Production on 星期六 9月 8 21:16:12 2012

Copyright (c) 1982, 2011, Oracle.  All rights reserved.


连接到:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> select version from v$instance;

VERSION
-----------------
11.2.0.3.0

SQL>

--------------------------------------------错误-------------------------------------------------------------

错误1：

oracle 11g安装先决条件检查，警告和失败如下：

物理内存 - 此先决条件将测试系统物理内存总量是否至少为 922MB (944128.0KB)。  错误:
 -
PRKN-1019 : 无法在节点 "de584f4f5021434" 上创建目录 "C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\\oraremservice\", 错误: "0|ÕҲ»µ½ÍøÂç·¾¶¡£ "。  - Cause: 问题的原因不可用  - Action: 用户操作不可用

 详细资料:
 -
PRVF-7531 : 无法在节点 "de584f4f5021434" 上执行物理内存检查  - Cause:  无法在指示的节点上执行物理内存检查。  - Action:  确保可以访问指定的节点并可以查看内存信息

解决办法：

开始运行

首先保证 Server 服务开启
然后在 命令提示符下 键入 “net share c$=c:” 回车
C盘的默认共享，问题解决了。
原因：不打开默认共享，oracle无法检查环境的可用性！

PS:我的电脑貌似直接重新检查条件不行，关了安装界面重新打开才好

参考：http://topic.csdn.net/u/20100516/23/6f8bc6f8-776d-493e-acc0-22441af09353.html

感谢siyan_1981

错误2:这只是我自己本人的电脑升级，公司或者客户的真正的升级一定要exp或expdp备份啊