在linux环境下做了一下10.2.0.1到10.2.0.4升级下面把主要过程记录（record）一下：
一下载补丁
补丁为：p6810189_10204_Linux-x86.zip 可以到Oracle上去下载
二 升级安装（install）前准备工作
  1关闭数据(data)库所有服务
  1.关闭所有可能访问数据(data)库工具, 例如 Oracle Enterprise Manager Database Control or iSQL*Plus:
  2.[oracle@localhost ~]$emctl stop dbconsole
  3.[oracle@localhost ~]$isqlplusctl stop
  4.[oracle@localhost ~]$lsnrctl stop
  5.[oracle@localhost ~]$sqlplus /NOLOG
  6.SQL> CONNECT SYS AS SYSDBA
  7.Enter password:SYS_Password
  8.SQL> SHUTDOWN
  三备份(backup)系统
  备份(backup)内容包括： Oracle Inventory, Oracle 10g home 和 Oracle 10g Database.
  四安装（install）升级包软件
  1.以具有操作系统管理员权限（Authorization）用户（user）登陆系统.
  2.解压升级包运行./runInstall.
  3.除了需要指定你想升级Oracle home或者选择路径其他全部默认即可
  4.在安装（install）结束画面, 单击退出, 然后确认退出 Oracle Universal Installer至此ORACLE升级包软件安装（install）结束
  五运行脚本（script）升级数据(data)库
  如果只安装（install）了升级包没有进行数据(data)库字典信息升级启动数据(data)库将报
  ——ORA-01092 ORACLE 例程终止强行断开连接
  注：此时Google结果会给出多种解释除了检查SID和服务配置（configure）外还需要检查防火墙等
  而此时针对升级所产生错误（error）是正常
  1.进行数据(data)库字典信息升级Upgrading a Release 10.2 Database
  启动：lsnrctl start
  sqlplus /NOLOG
  SQL> CONNECT / AS SYSDBA
  STARTUP UPGRADE
  SQL> SPOOL c:/patch.log --设定跟踪文件
  SQL> @?/rdbms/admin/utlu102i.sql --运行数据(data)库预升级检查
  SQL> @?/rdbms/admin/catupgrd.sql --数据(data)库字典信息升级包
  SQL> SPOOL OFF
  检查 patch.log 文件如果有问题（problem）重新运行catupgrd.sql
  2.重启动数据(data)库:
  SQL> SHUTDOWN IMMEDIATE
  SQL> STARTUP
  3 运行utlrp.sql脚本（script）重新编译无效PL/SQL包
  SQL> @?/rdbms/admin/utlrp.sql
  4 运行命令（command）检查所有组件是否升级成功:
  SQL> SELECT COMP_NAME, VERSION, STATUS FROM SYS.DBA_REGISTRY;
  所有输出为 VALID表示升级成功.
  5 如果使用Oracle Recovery Manager catalog, 需要对catalog进行升级如下:
  [oracle@localhost ~]$ rman catalog username/password@alias
  RMAN> UPGRADE CATALOG;
  六检查基本数据(data)库工具可用性
  对数据(data
)库中用户（user）进行EXP和IMP操作对数据(data)库用RMAN进行备份(backup)和恢复操作确认备份(backup)恢复没问题（problem）
Oracle及补丁下载地址
直接用迅雷下载即可，无需metelink号码.
9.2.0.4 = 3095277
9.2.0.5 = 3501955
9.2.0.6 = 3948480
9.2.0.7 = 4163445
9.2.0.8 = 4547809（9i最终）
10.1.0.3 = 3761843
10.1.0.4 = 4163362
10.1.0.5 = 4505133
10.2.0.2 = 4547817
linux安装oracle图形化界面10.2.0.3 = 5337014
10.2.0.4 = 6810189
地址特征：只要知道是了补丁号 如p3948480_9206，则目录一般是在ftp://acle/3948480下，再把操作系统的特征的一些信息补充进去如_AIX64-5L，就可以了，自己试试.
oracle 9206 patchset:
ftp://acle/3948480/p3948480_9206_AIX64-5L.zip
ftp://acle/3948480/p3948480_9206_HP64.zip
ftp://acle/3948480/p3948480_9206_HPUX-IA64.zip
ftp://acle/3948480/p3948480_9206_LINUX.zip
ftp://acle/3948480/p3948480_9206_Linux-x86-64.zip
ftp://acle/3948480/p3948480_9206_MVS.zip
ftp://acle/3948480/p3948480_9206_SOLARIS.zip
ftp://acle/3948480/p3948480_9206_SOLARIS64.zip
ftp://acle/3948480/p3948480_9206_TRU64.zip
ftp://acle/3948480/p3948480_9206_WINNT.zip
ftp://acle/3948480/p3948480_9206_WINNT64.zip
oracle 9207patch set:
ftp://acle/4163445/p4163445_92070_AIX64-5L.zip
ftp://acle/4163445/p4163445_92070_HP64.zip
ftp://acle/4163445/p4163445_92070_HPUX-IA64.zip
ftp://acle/4163445/p4163445_92070_LINUX.zip
ftp://acle/4163445/p4163445_92070_Linux-IA64.zip
ftp://acle/4163445/p4163445_92070_Linux-x86-64.zip
ftp://acle/4163445/p4163445_92070_MVS.zip
ftp://acle/4163445/p4163445_92070_SOLARIS.zip
ftp://acle/4163445/p4163445_92070_SOLARIS64.zip
ftp://acle/4163445/p4163445_92070_WINNT.zip
ftp://acle/4163445/p4163445_92070_WINNT64.zip(无)
oracle 9208patch:
ftp://acle/4547809/p4547809_92080_AIX64-5L.zip
ftp://acle/4547809/p4547809_92080_HP64.zip
ftp://acle/4547809/p4547809_92080_HPUX-IA64.zip
ftp://acle/4547809/p4547809_92080_LINUX.zip
ftp://acle/4547809/p4547809_92080_Linux-IA64.zip
ftp://acle/4547809/p4547809_92080_Linux-x86-64.zip
ftp://acle/4547809/p4547809_92080_MVS.zip
ftp://acle/4547809/p4547809_92080_SOLARIS.zip
ftp://acle/4547809/p4547809_92080_SOLARIS64.zip
ftp://acle/4547809/p4547809_92080_WINNT.zip
ftp://acle/4547809/p4547809_92080_WINNT64.zip
oracle 10.2.0.2
ftp://acle/4547817/p4547817_10202_AIX64-5L.zip
ftp://acle/4547817/p4547817_10202_HP64.zip
ftp://acle/4547817/p4547817_10
202_HPUX-IA64.zip
ftp://acle/4547817/p4547817_10202_LINUX.zip
ftp://acle/4547817/p4547817_10202_Linux-IA64.zip
ftp://acle/4547817/p4547817_10202_Linux-x86-64.zip
ftp://acle/4547817/p4547817_10202_MVS.zip
ftp://acle/4547817/p4547817_10202_SOLARIS.zip
ftp://acle/4547817/p4547817_10202_SOLARIS64.zip
ftp://acle/4547817/p4547817_10202_WINNT.zip
ftp://acle/4547817/p4547817_10202_WINNT64.z
oracle 10.2.0.4
ftp://acle/6810189/p6810189_10204_AIX5L.zip
ftp://acle/6810189/p6810189_10204_HPUX-IA64.zip
ftp://acle/6810189/p6810189_10204_HPUX-64.zip
ftp://acle/6810189/p6810189_10204_Solaris-64.zip
ftp://acle/6810189/p6810189_10204_Linux-x86-64.zip
ftp://acle/6810189/p6810189_10204_Linux-x86.zip
ftp://acle/6810189/p6810189_10204_Win32.zip
ftp://acle/6810189/p6810189_10204_MSWIN-x86-64.zip
下载OTN上的这些软件，你需要一个OTN免费帐号，不过如果通过迅雷进行下载，就不用登陆OTN了：
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (32-bit)
acle/otn/nt/oracle10g/10201/10201_database_win32.zip
acle/otn/nt/oracle10g/10201/10201_client_win32.zip
acle/otn/nt/oracle10g/10201/10201_clusterware_win32.zip
acle/otn/nt/oracle10g/10201/10201_gateways_win32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Microsoft Windows (x64)
acle/otn/nt/oracle10g/10201/102010_win64_x64_database.zip
acle/otn/nt/oracle10g/10201/102010_win64_x64_client.zip
acle/otn/nt/oracle10g/10201/102010_win64_x64_clusterware.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86
acle/otn/linux/oracle10g/10201/10201_database_linux32.zip
acle/otn/linux/oracle10g/10201/10201_client_linux32.zip
acle/otn/linux/oracle10g/10201/10201_gateways_linux32.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Linux x86-64
acle/otn/linux/oracle10g/10201/10201_database_linux_x86_
acle/otn/linux/oracle10g/10201/10201_client_linux_x86_
acle/otn/linux/oracle10g/10201/10201_clusterware_linux_x86_
acle/otn/linux/oracle10g/10201/10201_gateways_linux_x86_
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for AIX5L
acle/otn/aix/oracle10g/10201/10gr2_aix5l64_
acle/otn/aix/oracle10g/10201/10gr2_aix5l64_
acle/otn/aix/oracle10g/10201/10gr2_aix5l64_
acle/otn/aix/oracle10g/10201/10gr2_aix5l64_
Oracle Database 10g Release 2 (10.2.0.2) Enterprise/Standard Edition for Solaris Operating System (x86)
acle/otn/solaris/oracle10g/10202/10202_database_solx86.zip
acle/otn/solaris/oracle10g/10202/10202_client_solx86.zip
acle/otn/solaris/oracle10g/10202/10202_clusterware_solx86.zip
Oracle Database 10g Release 2 (10.2.0.1.0) Enterprise/Standard Edition for Solaris Operating System (x86-64)
acle/otn/solaris/oracle10g/10201/x8664/10201_database_solx86_64.zip
acle/otn/solaris/oracle10g/10201/x8664/10201_client_solx86_64.zip
acle/otn/solaris/oracle10g/10201/x8664/10201_clusterware_solx86_64.zip
oracle 10.2.0.4 patch:
ftp://acle/6810189/p6810189_10204_AIX5L.zip
ftp://acle/6810189/p6810189_10204_HPUX-IA64.zip
ftp://acle/6810189/p6810189_10204_HPUX-64.zip
ftp://acle/6810189/p6810189_10204_Solaris-64.zip
ftp://acle/6810189/p6810189_10204_Linux-x86-64.zip
ftp://acle/6810189/p6810189_10204_Linux-x86.zip
ftp://acle/6810189/p6810189_10204_Win32.zip
ftp://acle/6810189/p6810189_10204_MSWIN-x86-64.zip
Oracle Database 10g\11g Release
acle/technology/software/products/database/index.html
Oracle Database 11g Release 1(11.1.0.6.0)
下载地址: acle/technology/software/products/database/index.html
文档：acle/technology/global/cn/documentation/index.html
Oracle9i下载地址
Oracle9i Database Release 2 Enterprise/Standard/Personal Edition for Windows NT/2000/XP
acle/otn/nt/oracle9i/9201/92010NT_Disk1.zip
acle/otn/nt/oracle9i/9201/92010NT_Disk2.zip
acle/otn/nt/oracle9i/9201/92010NT_Disk3.zip
Oracle9i Database Release 2 Enterprise/Standard/Personal/Client Edition for Windows XP 2003/Windows Server 2003 (64-bit)
acle/otn/nt/oracle9i/9202/92021Win64_Disk1.zip
acle/otn/nt/oracle9i/9202/92021Win64_Disk2.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Intel Linux
acle/otn/linux/oracle9i/9204/ship_9204_linux_
acle/otn/linux/oracle9i/9204/ship_9204_linux_
acle/otn/linux/oracle9i/9204/ship_9204_linux_
Oracle9i Database Release 2 (9.2.0.4) Enterprise/Standard Edition for Linux x86-64
acle/otn/linux/oracle9i/9204/amd64_db_9204_
acle/otn/linux/oracle9i/9204/amd64_db_9204_
acle/otn/linux/oracle9i/9204/amd64_db_9204_
Oracle9i Data
base Release 2 Enterprise/Standard Edition for AIX - Based 4.3.3 Systems (64-bit)
acle/otn/aix/oracle9i/9201/server_9201_AIX64_
acle/otn/aix/oracle9i/9201/server_9201_AIX64_
acle/otn/aix/oracle9i/9201/server_9201_AIX64_
acle/otn/aix/oracle9i/9201/server_9201_AIX64_
Oracle9i Database Release 2 Enterprise/Standard Edition for AIX- Based 5L Systems
acle/otn/aix/oracle9i/9201/A99331-01.zip
acle/otn/aix/oracle9i/9201/A99332-01.zip
acle/otn/aix/oracle9i/9201/A99333-01.zip
acle/otn/aix/oracle9i/9201/A99334-01.zip
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (32-bit)
acle/otn/solaris/oracle9i/9201/92010Sol_
acle/otn/solaris/oracle9i/9201/92010Sol_
acle/otn/solaris/oracle9i/9201/92010Sol_
Oracle9i Database Release 2 Enterprise/Standard Edition for Sun SPARC Solaris (64-bit)
acle/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.
acle/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.
acle/otn/solaris/oracle9i64/9201/solaris64_9.2.0.1.0.

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。