oracle 9.2.0.1 升級到oracle 9.2.0.8方法

  今天下午在家, 把自己本本上 oracle 9.2.0.1 for winxp 升級到了 oracle 9.2.0.8 簡單記錄了一下操作步驟

首先下載補丁包

To upgrade Oracle databases from a previous release directly to Oracle9i release 2 (9.2.0.8) follow the instructions in OracleMetalink note 214887.1, Upgrading Directly to a 9.2.0 Patch Set.

1: Required Postinstallation Tasks

Complete the following tasks after installing the patch set software:

•    

• 1.1.1 Check SYSTEM Tablespace Size

If JServer is part of the installation ensure that there is at least 10 MB of free space allocated to the SYSTEM tablespace.

1.1.3 Set the SHARED_POOL_SIZE and JAVA_POOL_SIZE Initialization Parameters

     If the system is using a server parameter file:

1. If necessary, set the value of the SHARED_POOL_SIZE initialization parameter to at least 150 MB:

   SQL> ALTER SYSTEM SET SHARED_POOL_SIZE='150M' SCOPE=spfile; 
   
   

2. If necessary, set the value of the JAVA_POOL_SIZE initialization parameter to at least 150 MB:

   SQL> ALTER SYSTEM SET JAVA_POOL_SIZE='150M' SCOPE=spfile; 

1.1.4 lsnrctl stop,

         停止oracle資料庫服務

         net stop oracleservicetest

          shutdown immediate;

2: Upgrade the Database

  2.1 安裝oracle 9.2.0.8 補丁包軟體 點setup.exe就可以了 注意選擇和oracle

   _home路徑一致,安裝完成後,進行下一步資料庫升級

  2.2  sqlplus "/as sysdba"

         SQL> STARTUP MIGRATE
         SQL> SPOOL patch.log
         SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\catpatch.sql
         SQL> SPOOL OFF

   2.3 Review the patch.log file for errors and inspect the list of components that is displayed at the end of catpatch.sql script

    2.4   This list provides the version and status of each SERVER component in the database.

    2.5    If necessary, rerun the catpatch.sql script. after correcting any problems.

     2.6    Restart the database:

             SQL> SHUTDOWN
             SQL> STARTUP
     

     2.7   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.

1. SQL> @ORACLE_BASE\ORACLE_HOME\rdbms\admin\utlrp.sql
   

升級成功後,用exp測試進行匯出後發現以下錯誤:
ORA-37002: Oracle OLAP failed to initialize. Please contact Oracle OLAP technical support.
ORA-33262: Analytic workspace EXPRESS does not exist.
解決方法:
在這種情況下，是因為OLAP被設定為ON但是卻沒有安裝OLAP的原因。我們可以透過以SYS使用者登入後，執行@?/olap/admin/olap.sql ;來建立OLAP
建立完成後,再exp 看log就正常了