16,以SYSDBA身份登陆SQLPLUS,以UPGRADE的方式启动数据库:
SQL> start upgrade
这里我没有出现如文档里面提到的错误,执行过程很顺利。
17,执行脚本D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\catupgrd.sql(根据数据库大小而定,在本机上执行过程为两个小时),脚本执行完毕之后如下:
Oracle Database 10.2 Upgrade Status Utility 01-12-2008 21:03:24
.
Component Status Version HH:MM:SS
Oracle Database Server VALID 10.2.0.1.0 00:18:15
JServer JAVA Virtual Machine VALID 10.2.0.1.0 00:23:30
Oracle XDK VALID 10.2.0.1.0 00:02:22
Oracle Database Java Packages VALID 10.2.0.1.0 00:01:12
Oracle Text VALID 10.2.0.1.0 00:01:25
Oracle XML Database VALID 10.2.0.1.0 00:08:30
Oracle Workspace Manager VALID 10.2.0.1.0 00:01:27
Oracle Data Mining VALID 10.2.0.1.0 00:00:31
OLAP Analytic Workspace VALID 10.2.0.1.0 00:00:34
OLAP Catalog VALID 10.2.0.1.0 00:01:39
Oracle OLAP API VALID 10.2.0.1.0 00:01:16
Oracle interMedia VALID 10.2.0.1.0 00:09:36
Spatial VALID 10.2.0.1.0 00:07:46
Oracle Ultra Search NO SCRIPT 9.2.0.1.0 00:00:00
.
Total Upgrade Time: 01:22:57
PL/SQL 过程已成功完成。
DOC>#######################################################################
DOC>#######################################################################
DOC>
DOC> The above PL/SQL lists the SERVER components in the upgraded
DOC> database, along with their current version and status.
DOC>
DOC> Please review the status and version columns and look for
DOC> any errors in the spool log file. If there are errors in the spool
DOC> file, or any components are not VALID or not the current version,
DOC> consult the Oracle Database Upgrade Guide for troubleshooting
DOC> recommendations.
DOC>
DOC> Next shutdown immediate, restart for normal operation, and then
DOC> run utlrp.sql to recompile any invalid application objects.
DOC>
DOC>#######################################################################
DOC>#######################################################################
18,待catupgrd.sql脚本执行完成,shutdown immediate关闭数据库;
19,startup启动数据库,执行脚本D:\oracle\product\10.2.0\db_1\RDBMS\ADMIN\utlrp.sql;
20,执行完毕后执行查询所有重新编译错误
SQL> select * from utl_recomp_errors;
未选定行(这里说明没有错误)
21,执行检查:
SQL> select name from v$database确认ORACLE_SID正确,为ora
SQL> show user确认当前使用者为SYS
SQL> select tablespace_name, bytes from dba_data_files对系统表空间大小进行确认。
全文结束。
阅读(2024) | 评论(0) | 转发(0) |