注意：指定OracleHome目录时，依然指定为旧路径.如原ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1，升级时依然指定为该目录.
[root@leo-10g-ogg~]# /u01/app/oracle/product/10.2.0/db_1/root.sh
RunningOracle10 root.sh script...
Thefollowing environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/10.2.0/db_1
Enter thefull pathname of the local bin directory: [/usr/local/bin]:
The file"dbhome" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file"oraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
The file"coraenv" already exists in /usr/local/bin. Overwrite it? (y/n)
[n]:
Entrieswill be added to the /etc/oratab file as needed by
DatabaseConfiguration Assistant when a database is created
Finishedrunning generic part of root.sh script.
Nowproduct-specific root actions will be performed.
You havemail in /var/spool/mail/root
点击“exit”.
2.3、数据字典更新数据字典.
SQL>startup upgrade
ORACLEinstance started.
TotalSystem Global Area 1224736768 bytes
FixedSize 2083560 bytes
VariableSize 318768408 bytes
DatabaseBuffers 889192448 bytes
RedoBuffers 14692352 bytes
Databasemounted.
Databaseopened.
SQL>spool patch.log
SQL>@?/rdbms/admin/catupgrd.sql --注9i 使用catpatch.sql，耗时9分钟.
2.4、编译失效对象SQL>shutdown immediate;
Databaseclosed.
Databasedismounted.
ORACLEinstance shut down.
SQL>startup
ORACLEinstance started.
TotalSystem Global Area 1224736768 bytes
FixedSize 2083560 bytes
VariableSize 385877272 bytes
DatabaseBuffers 822083584 bytes
RedoBuffers 14692352 bytes
Databasemounted.
Databaseopened.
SQL>@?/rdbms/admin/utlrp.sql
3、验证升级后验证.
SQL>col comp_name for a40
SQL>col version for a15
SQL>select comp_name,version,status from dba_registry
COMP_NAME VERSION STATUS
------------------------------------------------------- ---------------
OracleDatabase Catalog Views 10.2.0.4.0 VALID
OracleDatabase Packages and Types 10.2.0.4.0 VALID
OracleWorkspace Manager 10.2.0.4.3 VALID
JServerJAVA Virtual Machine 10.2.0.4.0 VALID
OracleXDK 10.2.0.4.0 VALID
OracleDatabase Java Packages 10.2.0.4.0 VALID
OracleExpression Filter 10.2.0.4.0 VALID
OracleData Mining 10.2.0.4.0 VALID
OracleText 10.2.0.4.0 VALID
OracleXML Database 10.2.0.4.0 VALID
OracleRule Manager 10.2.0.4.0 VALID
COMP_NAME VERSION STATUS
------------------------------------------------------- ---------------
OracleinterMedia 10.2.0.4.0 VALID
OLAPAnalytic Workspace 10.2.0.4.0 VALID
OracleOLAP API 10.2.0.4.0 VALID
OLAPCatalog 10.2.0.4.0 VALID
Spatial 10.2.0.4.0 VALID
OracleEnterprise Manager 10.2.0.4.0 VALID
17 rowsselected.
SQL>select * from utl_recomp_errors;
no rowsselected
4、补充操作--修改兼容性参数
SQL>show parameter compatible
NAME TYPE VALUE
----------------------------------------------- ------------------------------
compatible string 10.2.0.1.0
SQL>alter system set compatible='10.2.0.4.0' scope=spfile;
Systemaltered.
--重启数据库
SQL>shutdown immediate;
Databaseclosed.
Databasedismounted.
ORACLEinstance shut down.
SQL>startup
ORACLEinstance started.
TotalSystem Global Area 1224736768 bytes
FixedSize 2083560 bytes
VariableSize 385877272 bytes
DatabaseBuffers 822083584 bytes
RedoBuffers 14692352 bytes
Databasemounted.
Databaseopened.
--如果使用了恢复目录，还需执行以下命令.
$ rman catalog username/password@alias
RMAN> UPGRADE CATALOG;
--升级回退
SQL> STARTUP DOWNGRADE
SQL> SPOOL downgrade.log
SQL> @catdwgrd.sql
Sql>spool off
Sql>shutdown immediate
| 欢迎光临 重庆思庄Oracle、Redhat认证学习论坛 (http://bbs.cqsztech.com/) | Powered by Discuz! X3.2 |