4
4
14
14
15
15
シノニムが、存在しないオブジェクトをポイントしているため発生
3. Utlu112i.sqlの実行例
SQL> @utlu112i
Oracle Database 11.2 Pre-Upgrade Information Tool 10-13-2009 16:09:12 . ******************************************************************** Database: ******************************************************************** --> name: O920C --> version: 9.2.0.8.0 --> compatible: 9.2.0.0.0 --> blocksize: 8192 --> timezone file: V1 ～中略～ . ******************************************************************** Tablespaces: [make adjustments in the current environment]
******************************************************************** --> SYSTEM tablespace is adequate for the upgrade.
現行環境のタイムゾーン
のバージョンを確認
35
～中略～ .
********************************************************************
COMPATIBLEパラメータ
を 10.1.0以上へ変更
Update Parameters: [Update Oracle Database 11.2 init.ora or spfile] ******************************************************************** WARNING: --> "compatible" must be set to at least 10.1.0
WARNING: --> "shared_pool_size" needs to be increased to at least 237 MB WARNING: --> "db_cache_size" needs to be increased to at least 50331648 bytes .
******************************************************************** Obsolete/Deprecated Parameters: [Update Oracle Database 11.2 init.ora or
spfile]
******************************************************************** --> hash_join_enabled 10.1 OBSOLETE
--> background_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"
--> user_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest"
--> core_dump_dest 11.1 DEPRECATED replaced by "diagnostic_dest" . ******************************************************************** C t [Th f ll i d t b t ill b d d i t ll d]
DIAGNOSTIC_DESTパ
ラメータへ変更
Components: [The following database components will be upgraded or installed] ********************************************************************
--> Oracle Catalog Views [upgrade] VALID --> Oracle Packages and Types [upgrade] VALID --> JServer JAVA Virtual Machine [upgrade] VALID --> Oracle XDK for Java [upgrade] VALID --> Oracle Workspace Manager [upgrade] VALID
ラメータへ変更
> p g [ pg ]
--> OLAP Analytic Workspace [upgrade] LOADED --> OLAP Catalog [upgrade] VALID --> Oracle Text [upgrade] VALID --> Oracle XML Database [upgrade] VALID --> Oracle Java Packages [upgrade] VALID --> Oracle interMedia [upgrade] VALID --> Spatial [upgrade] LOADED --> Data Mining [upgrade] LOADED --> Oracle Ultra Search [upgrade] VALID --> Oracle OLAP API [upgrade] LOADED .
～中略～ .
******************************************************************** Miscellaneous Warnings
******************************************************************** WARNING: --> Deprecated CONNECT role granted to some user/roles. .... CONNECT role after upgrade has only CREATE SESSION privilege. WARNING: --> Database is using a timezone file older than version 11. .... After the release migration, it is recommended that DBMS_DST package .... be used to upgrade the 9.2.0.8.0 database timezone version
.... to the latest version which comes with the new release.
WARNING: --> Database contains schemas with stale optimizer statistics. .... Refer to the Upgrade Guide for instructions to update
.... schema statistics prior to upgrading the database. .... Component Schemas with stale statistics:
SYS
SYSの統計情報
.... SYS
WARNING: --> Database contains schemas with objects dependent on network packages.
.... Refer to the Upgrade Guide for instructions to configure Network ACLs. .... USER MDSYS has dependent objects.
.
********************************************************************
取得を推奨
SYSAUX Tablespace:
[Create tablespace in the Oracle Database 11.2 environment]
******************************************************************** .... minimum required size for database upgrade: 500 MB
.
PL/SQLプロシージャが正常に完了しました PL/SQLプロシージャが正常に完了しました。
9. 移行先環境でデータベースを起動(編集したPFILEを使用)して、
SYSAUX表領域を作成
SQL> startup upgrade pfile=inito920c.ora
SQL> CREATE TABLESPACE SYSAUX
2 DATAFILE '/home/oradata/o920c/sysaux01.ora'
3 SIZE 500M EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO 4 ONLINE;
11. Utlu112s.sqlを実行してアップグレード後のステータスを確認
4 ONLINE;SQL> @?/rdbms/admin/utlu112s .
Oracle Database 11 2 Post Upgrade Status Tool 10 15 2009 11:53:06 Oracle Database 11.2 Post-Upgrade Status Tool 10-15-2009 11:53:06 .
Component Status Version HH:MM:SS .
Oracle Server
. VALID 11.2.0.1.0 00:25:51 JServer JAVA Virtual Machine
. VALID 11.2.0.1.0 00:04:48 Oracle Workspace Manager
. VALID 11.2.0.1.0 00:01:29 Oracle XDK . VALID 11.2.0.1.0 00:05:07 Oracle Text VALID 11 2 0 1 0 00:01:21 . VALID 11.2.0.1.0 00:01:21 Oracle XML Database . VALID 11.2.0.1.0 00:04:11 Oracle Database Java Packages
. VALID 11.2.0.1.0 00:00:40 Gathering Statistics
. 00:08:09 Total Upgrade Time: 00:51:41
PL/SQLプロシージャが正常に完了しました。
