首页 > 数据库 > Oracle > Upgrade Oracle from To

Upgrade Oracle from To

原创 Oracle 作者:kenchendz 时间:2009-02-25 06:24:09 0 删除 编辑
Steps to Upgrade Oracle from To[@more@]

1. Patch Set Overview
Patch set release Before installing this patch set you must be need version.
2. Requirements
Oracle DB : Oracle (later) Operating System: Windows

3. Pre - Installation Tasks
1. Identify prior installation
Before installing this patch you must install oracle (or later version)
2. Download Patch set
Download 6810189 patch set installation archive to a directory that is not the Oracle home directory or under the Oracle home directory.
3. Shutdown oracle database.
C:>set oracle_sid= GOLDLINK
C:>sqlplus /nolog
SQL*Plus: Release - Production on Tue Nov 13 10:49:26 2007
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> connect sys@GOLDLINK as sysdba Enter password: Connected.
SQL> SHUTDOWN Database closed. Database dismounted. ORACLE instance shut down.
4. Stop all services
C:>set oracle_sid=GoldLink
C:>net stop OracleDBConsoleGOLDLINK The OracleDBConsoleGOLDLINK service is stopping................ The OracleDBConsoleGOLDLINK service was stopped successfully.

C:>net stop OracleServiceGOLDLINK The OracleServiceGOLDLINK service is stopping. The OracleServiceGOLDLINK service was stopped successfully.

C:>net stop OracleOraDB10g_Home1iSQL*Plus.. The OracleOraDb10g_home1iSQL*Plus service was stopped successfully.
C:>net stop OracleOraDB10g_Home1TNSListener The OracleOraDb10g_home1TNSListener service is stopping. The OracleOraDb10g_home1TNSListener service was stopped successfully.
Note: while patch installation time If you face Distributed Transaction Coordinator still running. You should be stop this service
C:>net stop msdtc The Distributed Transaction Coordinator service is stopping. The Distributed Transaction Coordinator service was stopped successfully.
4. Backup your database.
Oracle recommends that you create a backup of the Oracle 10g installation before you install the patch set.
5. Check Tablespace Sizes and Set Parameter Values

Review the following sections before upgrading a database.

8. Upgrade the Database

After you install the patch set, you must perform the following steps on every database associated with the upgraded Oracle home:

1. Start all services

2. Connect sys user
C:> sqlplus /NOLOG
3. Enter the following SQL*Plus commands:
SQL> SPOOL patch.log
SQL> @ORACLE_BASEORACLE_HOMErdbmsadmincatupgrd.sql
Review the patch.log file for errors and inspect the list of components that is displayed at the end of catupgrd.sql script.
This list provides the version and status of each SERVER component in the database.
If necessary, rerun the catupgrd.sql script after correcting any problems.
4. Restart the database:

5. Compile Invalid Objects
Run the utlrp.sql script to recompile all invalid PL/SQL packages now instead of when the packages are accessed for the first time. This step is optional but recommended.
SQL> @ORACLE_BASEORACLE_HOMErdbmsadminutlrp.sql
SQL> select * from v$version;
BANNER ---------------------------------------------------------------- Oracle Database 10g Release - Production PL/SQL Release - Production CORE Production TNS for 32-bit Windows: Version - Production NLSRTL Version - Production

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
  • 博文量
  • 访问量