Script Version: 11. 2. 0. 3. 0 Build: 001
.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Database:
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
- - > name: ZH10G
- - > version: 10. 2. 0. 4. 0
- - > compatible: 10. 2. 0. 3. 0
- - > blocksize: 8192
- - > platform: Microsoft Windows x86 64 - bit
- - > timezone file: V4
.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Tablespaces: [make adjustments in the current environment]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
- - > SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 725 MB
- - > UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
- - > SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 452 MB
- - > TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 MB
- - > EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 78 MB
.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Flashback: OFF
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Update Parameters: [ Update Oracle Database 11. 2 init.ora or spfile]
Note: Pre -upgrade tool was run on a lower version 64 - bit database.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
- - > If Target Oracle is 32 - Bit, refer here for Update Parameters:
WARNING: - - > "sga_target" needs to be increased to at least 412 MB
.
- - > If Target Oracle is 64 - Bit, refer here for Update Parameters:
WARNING: - - > "sga_target" needs to be increased to at least 596 MB
.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Renamed Parameters: [ Update Oracle Database 11. 2 init.ora or spfile]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
- - No renamed parameters found. No changes are required.
.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Obsolete /Deprecated Parameters: [ Update Oracle Database 11. 2 init.ora or spfile]
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
- - > background_dump_dest 11. 1 DEPRECATED replaced by "diagnostic_dest"
- - > user_dump_dest 11. 1 DEPRECATED replaced by "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
- - > OLAP Analytic Workspace [upgrade] VALID
- - > OLAP Catalog [upgrade] VALID
- - > EM Repository [upgrade] VALID
- - > Oracle Text [upgrade] VALID
- - > Oracle XML Database [upgrade] VALID
- - > Oracle Java Packages [upgrade] VALID
- - > Oracle interMedia [upgrade] VALID
- - > Spatial [upgrade] VALID
- - > Data Mining [upgrade] VALID
- - > Expression Filter [upgrade] VALID
- - > Rule Manager [upgrade] VALID
- - > Oracle OLAP API [upgrade] VALID
.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Miscellaneous Warnings
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
WARNING: - - > Database is using a timezone file older than version 14.
.... After the release migration, it is recommended that DBMS_DST package
.... be used to upgrade the 10. 2. 0. 4. 0 database timezone version
.... to the latest version which comes with the new release.
WARNING: - - > EM Database Control Repository exists in the database.
.... Direct downgrade of EM Database Control is not supported. Refer to the
.... Upgrade Guide for instructions to save the EM data prior to upgrade.
WARNING: - - > Your recycle bin is turned on and currently contains no objects.
.... Because it is REQUIRED that the recycle bin be empty prior to upgrading
.... and your recycle bin is turned on, you may need to execute the command:
PURGE DBA_RECYCLEBIN
.... prior to executing your upgrade to confirm the recycle bin is empty.
.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Recommendations
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Oracle recommends gathering dictionary statistics prior to
upgrading the database.
To gather dictionary statistics execute the following command
while connected as SYSDBA:
EXECUTE dbms_stats.gather_dictionary_stats;
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Oracle recommends reviewing any defined events prior to upgrading.
To view existing non - default events execute the following commands
while connected AS SYSDBA:
Events:
SELECT ( translate( value,chr( 13)||chr( 10), ' ')) FROM sys.v$parameter2
WHERE UPPER( name) = 'EVENT' AND isdefault = 'FALSE'
Trace Events:
SELECT ( translate( value,chr( 13)||chr( 10), ' ')) from sys.v$parameter2
WHERE UPPER( name) = '_TRACE_EVENTS' AND isdefault = 'FALSE'
Changes will need to be made in the init.ora or spfile.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
C:\ >RMAN TARGET /
恢复管理器: Release 11. 2. 0. 3. 0 - Production on 星期二 12月 3 16: 46: 13 2013
Copyright ( c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
已连接到目标数据库 (未启动)
RMAN > STARTUP NOMOUNT
启动失败: ORA - 01078: failure in processing system parameters
LRM - 00109: ???????????????? 'D:\APP\ADMINISTRATOR\PRODUCT\11.2.0\DBHOME_1\DATABASE\INITZH10G.ORA'
在没有参数文件的情况下启动 Oracle 实例以检索 spfile
Oracle 实例已启动
系统全局区域总计 158662656 字节
Fixed Size 2253296 字节
Variable Size 104861200 字节
Database Buffers 46137344 字节
Redo Buffers 5410816 字节
RMAN > restore spfile to pfile 'D:\app\Administrator\product\11.2.0\dbhome_1\database\initZH10G.ora' from 'D:\03_DB_02OQJMH9_1_1_12M03D';
启动 restore 于 03 - 12月 - 13
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID = 249 设备类型 =DISK
通道 ORA_DISK_1: 正在从 AUTOBACKUP D:\ 03_DB_02OQJMH9_1_1_12M03D 还原 spfile
通道 ORA_DISK_1: 从 AUTOBACKUP 还原 SPFILE 已完成
完成 restore 于 03 - 12月 - 13
RMAN >
*.background_dump_dest = 'D:\app\Administrator\admin\zh10g\bdump'
* .compatible = '10.2.0.3.0'
* .control_files = 'D:\app\Administrator\oradata\zh10g\control01.ctl' , 'D:\app\Administrator\oradata\zh10g\control02.ctl' , 'D:\app\Administrator\oradata\zh10g\control03.ctl'
*.core_dump_dest = 'D:\app\Administrator\admin\zh10g\cdump'
* .db_block_size = 8192
* .db_domain = ''
* .db_file_multiblock_read_count = 16
* .db_name = 'zh10g'
* .job_queue_processes = 10
* .open_cursors = 300
* .pga_aggregate_target = 96468992
* .processes = 150
* .remote_login_passwordfile = 'EXCLUSIVE'
* .sga_target = 290455552
* .undo_management = 'AUTO'
* .undo_tablespace = 'UNDOTBS1'
*.user_dump_dest = 'D:\app\Administrator\admin\zh10g\udump'
ORA-32004: obsolete or deprecated parameter(s) specified for rdbms instance
解决方案:
PFILE参数剔除USER_DUMP_DEST与BACKGROUND_DUMP_DEST
恢复管理器: Release 11. 2. 0. 3. 0 - Production on 星期二 12月 3 17: 09: 58 2013
Copyright ( c) 1982, 2011, Oracle and / or its affiliates. All rights reserved.
已连接到目标数据库: ZH10G (未装载)
RMAN > restore controlfile from 'D:\03_DB_02OQJMH9_1_1_12M03D';
启动 restore 于 03 - 12月 - 13
使用目标数据库控制文件替代恢复目录
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID = 63 设备类型 =DISK
通道 ORA_DISK_1: 正在还原控制文件
通道 ORA_DISK_1: 还原完成, 用时: 00:00: 03
输出文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\CONTROL01.CTL
输出文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\CONTROL02.CTL
输出文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\CONTROL03.CTL
完成 restore 于 03 - 12月 - 13
已连接到目标数据库 (未启动)
Oracle 实例已启动
数据库已装载
系统全局区域总计 292278272 字节
Fixed Size 2254584 字节
Variable Size 109054216 字节
Database Buffers 176160768 字节
Redo Buffers 4808704 字节
RMAN > run
2 > {
3 > set newname for datafile 1 to 'D:\app\Administrator\oradata\zh10g\SYSTEM01.DBF';
4 > set newname for datafile 3 to 'D:\app\Administrator\oradata\zh10g\SYSAUX01.DBF';
5 > set newname for datafile 2 to 'D:\app\Administrator\oradata\zh10g\UNDOTBS01.DBF';
6 > set newname for datafile 4 to 'D:\app\Administrator\oradata\zh10g\USERS01.DBF';
7 > set newname for datafile 5 to 'D:\app\Administrator\oradata\zh10g\EXAMPLE01.DBF';
8 > allocate channel c1 device type disk;
9 > allocate channel c2 device type disk;
10 > allocate channel c3 device type disk;
11 > restore database;
12 > switch datafile all;
13 > recover database;
14 > }
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
分配的通道: c1
通道 c1: SID = 191 设备类型 =DISK
分配的通道: c2
通道 c2: SID = 129 设备类型 =DISK
分配的通道: c3
通道 c3: SID = 193 设备类型 =DISK
启动 restore 于 03 - 12月 - 13
释放的通道: c1
释放的通道: c2
释放的通道: c3
RMAN - 00571: = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
RMAN - 00569: = = = = = = = = = = = = = = = ERROR MESSAGE STACK FOLLOWS = = = = = = = = = = = = = = =
RMAN - 00571: = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = = =
RMAN - 03002: restore 命令 (在 12 / 03 / 2013 17: 26: 07 上) 失败
RMAN - 06026: 有些目标没有找到 - 终止还原
RMAN - 06023: 没有找到数据文件 4的副本来还原
RMAN - 06023: 没有找到数据文件 3的副本来还原
RMAN - 06023: 没有找到数据文件 2的副本来还原
RMAN - 06023: 没有找到数据文件 1的副本来还原
RMAN > list backupset;
备份集列表
= = = = = = = = = = = = = = = = = = =
BS 关键字 类型 LV 大小 设备类型 经过时间 完成时间
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1 Full 119. 87M DISK 00:00: 23 03 - 12月 - 13
BP 关键字: 1 状态: EXPIRED 已压缩: YES 标记: TAG20131203T163632
段名: C:\ORABACKUP\ 03_DB_01OQJMGG_1_1_12M03D
备份集 1 中的数据文件列表
文件 LV 类型 Ckp SCN Ckp 时间 名称
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
1 Full 640653 03 - 12月 - 13 C:\ORACLE\PRODUCT\ 10. 2. 0\ORADATA\ZH10G\SYSTEM01.DBF
2 Full 640653 03 - 12月 - 13 C:\ORACLE\PRODUCT\ 10. 2. 0\ORADATA\ZH10G\UNDOTBS01.DBF
3 Full 640653 03 - 12月 - 13 C:\ORACLE\PRODUCT\ 10. 2. 0\ORADATA\ZH10G\SYSAUX01.DBF
4 Full 640653 03 - 12月 - 13 C:\ORACLE\PRODUCT\ 10. 2. 0\ORADATA\ZH10G\USERS01.DBF
5 Full 640653 03 - 12月 - 13 C:\ORACLE\PRODUCT\ 10. 2. 0\ORADATA\ZH10G\EXAMPLE01.DBF
RMAN > CROSSCHECK BACKUP;
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID = 191 设备类型 =DISK
交叉校验备份片段: 找到为 'AVAILABLE'
备份片段句柄 = C:\ORABACKUP\ 03_DB_01OQJMGG_1_1_12M03D RECID = 1 STAMP = 833214992
已交叉检验的 1 对象
RMAN > run
2 > {
3 > set newname for datafile 1 to 'D:\app\Administrator\oradata\zh10g\SYSTEM01.DBF';
4 > set newname for datafile 3 to 'D:\app\Administrator\oradata\zh10g\SYSAUX01.DBF';
5 > set newname for datafile 2 to 'D:\app\Administrator\oradata\zh10g\UNDOTBS01.DBF';
6 > set newname for datafile 4 to 'D:\app\Administrator\oradata\zh10g\USERS01.DBF';
7 > set newname for datafile 5 to 'D:\app\Administrator\oradata\zh10g\EXAMPLE01.DBF';
8 > allocate channel c1 device type disk;
9 > allocate channel c2 device type disk;
10 > allocate channel c3 device type disk;
11 > restore database;
12 > switch datafile all;
13 > recover database;
14 > }
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
正在执行命令: SET NEWNAME
释放的通道: ORA_DISK_1
分配的通道: c1
通道 c1: SID = 191 设备类型 =DISK
分配的通道: c2
通道 c2: SID = 129 设备类型 =DISK
分配的通道: c3
通道 c3: SID = 193 设备类型 =DISK
启动 restore 于 03 - 12月 - 13
通道 c1: 正在开始还原数据文件备份集
通道 c1: 正在指定从备份集还原的数据文件
通道 c1: 将数据文件 00001 还原到 D:\app\Administrator\oradata\zh10g\SYSTEM01.DBF
通道 c1: 将数据文件 00002 还原到 D:\app\Administrator\oradata\zh10g\UNDOTBS01.DBF
通道 c1: 将数据文件 00003 还原到 D:\app\Administrator\oradata\zh10g\SYSAUX01.DBF
通道 c1: 将数据文件 00004 还原到 D:\app\Administrator\oradata\zh10g\USERS01.DBF
通道 c1: 将数据文件 00005 还原到 D:\app\Administrator\oradata\zh10g\EXAMPLE01.DBF
通道 c1: 正在读取备份片段 C:\ORABACKUP\ 03_DB_01OQJMGG_1_1_12M03D
通道 c1: 段句柄 = C:\ORABACKUP\ 03_DB_01OQJMGG_1_1_12M03D 标记 = TAG20131203T163632
通道 c1: 已还原备份片段 1
通道 c1: 还原完成, 用时: 00:00: 35
完成 restore 于 03 - 12月 - 13
数据文件 1 已转换成数据文件副本
输入数据文件副本 RECID = 7 STAMP = 833218128 文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\SYSTEM01.DBF
数据文件 2 已转换成数据文件副本
输入数据文件副本 RECID = 8 STAMP = 833218128 文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\UNDOTBS01.DBF
数据文件 3 已转换成数据文件副本
输入数据文件副本 RECID = 9 STAMP = 833218128 文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\SYSAUX01.DBF
数据文件 4 已转换成数据文件副本
输入数据文件副本 RECID = 10 STAMP = 833218129 文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\USERS01.DBF
数据文件 5 已转换成数据文件副本
输入数据文件副本 RECID = 11 STAMP = 833218129 文件名 =D:\APP\ADMINISTRATOR\ORADATA\ZH10G\EXAMPLE01.DBF
启动 recover 于 03 - 12月 - 13
正在开始介质的恢复
RMAN - 08187: 警告: 完成到 SCN 640653 的介质恢复
完成 recover 于 03 - 12月 - 13
释放的通道: c1
释放的通道: c2
释放的通道: c3
RMAN >
启动 recover 于 03 - 12月 - 13
分配的通道: ORA_DISK_1
通道 ORA_DISK_1: SID = 191 设备类型 =DISK
正在开始介质的恢复
介质恢复完成, 用时: 00:00: 01
完成 recover 于 03 - 12月 - 13
ORA - 01109: 数据库未打开
已经卸载数据库。
ORACLE 例程已经关闭。
SYS@ zh10g SQL >STARTUP NOMOUNT
ORACLE 例程已经启动。
Total System Global Area 292278272 bytes
Fixed Size 2254584 bytes
Variable Size 109054216 bytes
Database Buffers 176160768 bytes
Redo Buffers 4808704 bytes
SYS@ zh10g SQL > CREATE CONTROLFILE REUSE DATABASE "ZH10G" RESETLOGS NOARCHIVELOG
2 MAXLOGFILES 16
3 MAXLOGMEMBERS 3
4 MAXDATAFILES 100
5 MAXINSTANCES 8
6 MAXLOGHISTORY 292
7 LOGFILE
8 GROUP 1 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\REDO01.LOG' SIZE 50M BLOCKSIZE 512,
9 GROUP 2 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\REDO02.LOG' SIZE 50M BLOCKSIZE 512,
10 GROUP 3 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\REDO03.LOG' SIZE 50M BLOCKSIZE 512
11 - - STANDBY LOGFILE
12 DATAFILE
13 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\SYSTEM01.DBF',
14 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\UNDOTBS01.DBF',
15 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\SYSAUX01.DBF',
16 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\USERS01.DBF',
17 'D:\APP\ADMINISTRATOR\ORADATA\ZH10G\EXAMPLE01.DBF'
18 CHARACTER SET AL32UTF8
19 ;
控制文件已创建。
ERROR:
ORA - 03114: 未连接到 ORACLE
alter database open
*
第 1 行出现错误:
ORA - 01092: ORACLE instance terminated. Disconnection forced
ORA - 00704: bootstrap process failure
ORA - 39700: database must be opened with UPGRADE option
进程 ID: 5144
会话 ID: 191 序列号: 1
SYS@ zh10g SQL > alter database open resetlogs upgrade;
ERROR:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
Database altered.
DOC >#######################################################################
DOC >#######################################################################
DOC >
DOC > The first time this script is run, there should be no error messages
DOC > generated; all normal upgrade error messages are suppressed.
DOC >
DOC > If this script is being re -run after correcting some problem, then
DOC > expect the following error which is not automatically suppressed:
DOC >
DOC > ORA - 00001: unique constraint ( < constraint_name >) violated
DOC > possibly in conjunction with
DOC > ORA - 06512: at "<procedure/function name>", line NN
DOC >
DOC > These errors will automatically be suppressed by the Database Upgrade
DOC > Assistant (DBUA) when it re -runs an upgrade.
DOC >
DOC >#######################################################################
DOC >#######################################################################
DOC >#
DOC >######################################################################
DOC >######################################################################
DOC > The following statement will cause an "ORA-01722: invalid number"
DOC > error if the user running this script is not SYS. Disconnect
DOC > and reconnect with AS SYSDBA.
DOC >######################################################################
DOC >######################################################################
DOC >#
no rows selected
ERROR:
ORA-04023: Object SYS.STANDARD could not be validated or authorized
Disconnected from Oracle Database 11g Enterprise Edition Release 11. 2. 0. 3. 0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Applies to:
Oracle Database Upgrade Assistant - Version 11.2.0.0 to 11.2.0.0 [Release 11.2]Information in this document applies to any platform.
Symptoms
Using DBUA to upgrade to 11GR2. Upgrade process stops with error :-
Object sys.standard could not validated or authorized when select a database for upgrade
Changes
One reason could be /etc/oratab has a wrong entry for the source DB location. Second reason could be that /etc/oratab entry has been modified to 11GR2 location before the upgrade is complete using DBUA.
Cause
The cause of the error is /etc/oratab has a wrong entry for the source DB location. Second reason could be that /etc/oratab entry has been modified to 11GR2 location before the upgrade is complete using DBUA.
Solution
The first thing is to refer to NOTE 729909.1 & see if it resolves the problem. The solution could be :-
SELECT COUNT(*) FROM obj$ WHERE owner#=0 AND type#=2 AND name='PUIU$DBUA';
If the query returns a value greater than 0 (zero), then remove the PUIU$DBUA table and run DBUA again.
If the above solution does not work, then re-check the entry in /etc/oratab. Make sure that then DB being upgraded has correct ORACLE_HOME & no duplicate lines for the same ORACLE_HOME.
References
NOTE:729909.1 - Upgrading To Oracle11g And DBUA Reports ORA-4023 On SYS.STANDARDSYS@ zh10g SQL > / * Step 10 - SHUTDOWN THE DATABASE..!!!!!
SYS@ zh10g SQL > * /
SYS@ zh10g SQL > / * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * /
SYS@ zh10g SQL >shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SYS@ zh10g SQL >
SYS@ zh10g SQL >
SYS@ zh10g SQL >
SYS@ zh10g SQL >DOC
DOC >#######################################################################
DOC >#######################################################################
DOC >
DOC > The above sql script is the final step of the upgrade. Please
DOC > review any errors in the spool log file. If there are any errors in
DOC > the spool file, consult the Oracle Database Upgrade Guide for
DOC > troubleshooting recommendations.
DOC >
DOC > Next restart for normal operation, and then run utlrp. sql to
DOC > recompile any invalid application objects.
DOC >
DOC > If the source database had an older time zone version prior to
DOC > upgrade, then please run the DBMS_DST package. DBMS_DST will upgrade
DOC > TIMESTAMP WITH TIME ZONE data to use the latest time zone file shipped
DOC > with Oracle.
DOC >
DOC >#######################################################################
DOC >#######################################################################
DOC >#
SYS@ zh10g SQL >
SYS@ zh10g SQL >Rem Set errorlogging off
SYS@ zh10g SQL > SET ERRORLOGGING OFF;
SYS@ zh10g SQL >
SYS@ zh10g SQL >REM END OF CATUPGRD. SQL
SYS@ zh10g SQL >
SYS@ zh10g SQL >REM bug 12337546 - Exit current sqlplus session at end of catupgrd. sql.
SYS@ zh10g SQL >REM This forces user to start a new sqlplus session in order
SYS@ zh10g SQL >REM to connect to the upgraded db.
SYS@ zh10g SQL >exit
从 Oracle Database 11g Enterprise Edition Release 11. 2. 0. 3. 0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options 断开
.
Oracle Database 11. 2 Post -Upgrade Status Tool 12 - 04 - 2013 17: 31:00
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. ORA - 00942: 表或视图不存在
. VALID 11. 2. 0. 3. 0 00: 11: 59
JServer JAVA Virtual Machine
. VALID 11. 2. 0. 3. 0 00: 08: 01
Oracle Workspace Manager
. VALID 11. 2. 0. 3. 0 00:00: 26
OLAP Analytic Workspace
. VALID 11. 2. 0. 3. 0 00:00: 19
OLAP Catalog
. VALID 11. 2. 0. 3. 0 00:00: 43
Oracle OLAP API
. VALID 11. 2. 0. 3. 0 00:00: 20
Oracle Enterprise Manager
. VALID 11. 2. 0. 3. 0 00: 08: 45
Oracle XDK
. VALID 11. 2. 0. 3. 0 00: 02: 03
Oracle Text
. VALID 11. 2. 0. 3. 0 00:00: 45
Oracle XML Database
. VALID 11. 2. 0. 3. 0 00: 03: 44
Oracle Database Java Packages
. VALID 11. 2. 0. 3. 0 00:00: 13
Oracle Multimedia
. VALID 11. 2. 0. 3. 0 00: 03: 03
Spatial
. VALID 11. 2. 0. 3. 0 00: 05: 39
Oracle Expression Filter
. VALID 11. 2. 0. 3. 0 00:00: 10
Oracle Rules Manager
. VALID 11. 2. 0. 3. 0 00:00: 08
Gathering Statistics
. 00: 02: 47
Total Upgrade Time: 00: 49: 17
PL / SQL 过程已成功完成。
COMP_ID VERSION STATUS
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - -
EM 11. 2. 0. 3. 0 VALID
AMD 11. 2. 0. 3. 0 VALID
SDO 11. 2. 0. 3. 0 VALID
ORDIM 11. 2. 0. 3. 0 VALID
XDB 11. 2. 0. 3. 0 VALID
CONTEXT 11. 2. 0. 3. 0 VALID
ODM 11. 2. 0. 3. 0 VALID
EXF 11. 2. 0. 3. 0 VALID
RUL 11. 2. 0. 3. 0 VALID
OWM 11. 2. 0. 3. 0 VALID
CATALOG 11. 2. 0. 3. 0 VALID
CATPROC 11. 2. 0. 3. 0 VALID
JAVAVM 11. 2. 0. 3. 0 VALID
XML 11. 2. 0. 3. 0 VALID
CATJAVA 11. 2. 0. 3. 0 VALID
APS 11. 2. 0. 3. 0 VALID
XOQ 11. 2. 0. 3. 0 VALID
已选择 17行。
TIMESTAMP
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
COMP_TIMESTAMP POSTUP_BGN 2013 - 12 - 04 17: 37: 38
PL / SQL 过程已成功完成。
This script will migrate the Baseline data on a pre - 11g database
to the 11g database.
Move BL Data "SYS". "WRH$_FILESTATXS" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SQLSTAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SYSTEM_EVENT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_WAITSTAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_LATCH" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_LATCH_CHILDREN" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_LATCH_PARENT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_LATCH_MISSES_SUMMARY" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_DB_CACHE_ADVICE" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_ROWCACHE_SUMMARY" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SGASTAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SYSSTAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_PARAMETER" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SEG_STAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_DLM_MISC" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SERVICE_STAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_TABLESPACE_STAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_OSSTAT" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SYS_TIME_MODEL" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_SERVICE_WAIT_CLASS" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_INST_CACHE_TRANSFER" ( 0 rows in 0 seconds)
Move BL Data "SYS". "WRH$_ACTIVE_SESSION_HISTORY" ( 0 rows in 0 seconds)
... ...
... Completed Moving the Baseline Data ...
... ...
... If there are no Move BL Data messages ...
... above, then there are no renamed ...
... baseline tables in the system. ...
... ...
Drop Renamed Baseline Table SYS. "WRH$_FILESTATXS_BR"
Drop Renamed Baseline Table SYS. "WRH$_SQLSTAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_SYSTEM_EVENT_BR"
Drop Renamed Baseline Table SYS. "WRH$_WAITSTAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_LATCH_BR"
Drop Renamed Baseline Table SYS. "WRH$_LATCH_CHILDREN_BR"
Drop Renamed Baseline Table SYS. "WRH$_LATCH_PARENT_BR"
Drop Renamed Baseline Table SYS. "WRH$_LATCH_MISSES_SUMMARY_BR"
Drop Renamed Baseline Table SYS. "WRH$_DB_CACHE_ADVICE_BR"
Drop Renamed Baseline Table SYS. "WRH$_ROWCACHE_SUMMARY_BR"
Drop Renamed Baseline Table SYS. "WRH$_SGASTAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_SYSSTAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_PARAMETER_BR"
Drop Renamed Baseline Table SYS. "WRH$_SEG_STAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_DLM_MISC_BR"
Drop Renamed Baseline Table SYS. "WRH$_SERVICE_STAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_TABLESPACE_STAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_OSSTAT_BR"
Drop Renamed Baseline Table SYS. "WRH$_SYS_TIME_MODEL_BR"
Drop Renamed Baseline Table SYS. "WRH$_SERVICE_WAIT_CLASS_BR"
Drop Renamed Baseline Table SYS. "WRH$_INST_CACHE_TRANSFER_BR"
Drop Renamed Baseline Table SYS. "WRH$_ACTIVE_SESSION_HISTORY_BR"
... ...
... Completed the Dropping of the ...
... Renamed Baseline Tables ...
... ...
... If there are no Drop Table messages ...
... above, then there are no renamed ...
... baseline tables in the system. ...
... ...
PL / SQL 过程已成功完成。
已创建 0 行。
提交完成。
表已创建。
已创建 2 行。
已更新 1 行。
已更新 2行。
已更新 0行。
表已删除。
提交完成。
已更新 0行。
提交完成。
已更新 0行。
提交完成。
已更新 0行。
提交完成。
已创建 0 行。
提交完成。
已创建 0 行。
提交完成。
PL / SQL 过程已成功完成。
TIMESTAMP
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
COMP_TIMESTAMP POSTUP_END 2013 - 12 - 04 17: 37: 42
PL / SQL 过程已成功完成。
PL / SQL 过程已成功完成。
PL / SQL 过程已成功完成。
Generating apply and rollback scripts...
Check the following file for errors:
D:\app\Administrator\cfgtoollogs\catbundle\catbundle_PSU_ZH10G_GENERATE_2013Dec04_17_37_49.log
Apply script: D:\app\Administrator\product\ 11. 2. 0\dbhome_1\rdbms\ admin\catbundle_PSU_ZH10G_APPLY. sql
Rollback script: D:\app\Administrator\product\ 11. 2. 0\dbhome_1\rdbms\ admin\catbundle_PSU_ZH10G_ROLLBACK. sql
PL / SQL 过程已成功完成。
Executing script file...
SYS@ zh10g SQL > COLUMN spool_file NEW_VALUE spool_file NOPRINT
SYS@ zh10g SQL > SELECT 'D:\app\Administrator\cfgtoollogs\catbundle\' || 'catbundle_PSU_' || name || '_APPLY_' || TO_CHAR(SYSDATE, 'YYYYMonDD_hh24_mi_ss', 'NLS_DATE_LANGUAGE=' 'AMERICAN' '') || '.log' AS
spool_file FROM v$ database;
SYS@ zh10g SQL >SPOOL &spool_file
SYS@ zh10g SQL > exec dbms_registry.set_session_namespace( 'SERVER')
PL / SQL 过程已成功完成。
SYS@ zh10g SQL > ALTER SESSION SET current_schema = SYS;
会话已更改。
SYS@ zh10g SQL >PROMPT Updating registry...
Updating registry...
SYS@ zh10g SQL > INSERT INTO registry$history
2 (action_time, action,
3 namespace, version, id,
4 bundle_series, comments)
5 VALUES
6 (SYSTIMESTAMP, 'APPLY',
7 SYS_CONTEXT( 'REGISTRY$CTX', 'NAMESPACE'),
8 '11.2.0.3',
9 0,
10 'PSU',
11 'Patchset 11.2.0.2.0');
已创建 1 行。
SYS@ zh10g SQL > COMMIT;
提交完成。
SYS@ zh10g SQL >SPOOL off
SYS@ zh10g SQL > SET echo off
Check the following log file for errors:
D:\app\Administrator\cfgtoollogs\catbundle\catbundle_PSU_ZH10G_APPLY_2013Dec04_17_37_51.log
COUNT( *)
- - - - - - - - - -
5954
COMP_NAME VERSION STATUS
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
Oracle Enterprise Manager 11. 2. 0. 3. 0 VALID
OLAP Catalog 11. 2. 0. 3. 0 VALID
Spatial 11. 2. 0. 3. 0 VALID
Oracle Multimedia 11. 2. 0. 3. 0 VALID
Oracle XML Database 11. 2. 0. 3. 0 VALID
Oracle Text 11. 2. 0. 3. 0 VALID
Oracle Data Mining 11. 2. 0. 3. 0 VALID
Oracle Expression Filter 11. 2. 0. 3. 0 VALID
Oracle Rules Manager 11. 2. 0. 3. 0 VALID
Oracle Workspace Manager 11. 2. 0. 3. 0 VALID
Oracle Database Catalog Views 11. 2. 0. 3. 0 VALID
Oracle Database Packages and Types 11. 2. 0. 3. 0 VALID
JServer JAVA Virtual Machine 11. 2. 0. 3. 0 VALID
Oracle XDK 11. 2. 0. 3. 0 VALID
Oracle Database Java Packages 11. 2. 0. 3. 0 VALID
OLAP Analytic Workspace 11. 2. 0. 3. 0 VALID
Oracle OLAP API 11. 2. 0. 3. 0 VALID
已选择 17行。