先把数据库升级到9.2.0.8 然后用dbca创建的数据库。
v$version 的输出是
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle 9i Enterprise Edition Release 9.2.0.8.0 - 64 bi t Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
DBA_REGISTRY 输出如下。我的数据库是否升级到了9.2.0.8了呢?
SQL> select comp_name,version from DBA_REGISTRY;
COMP_NAME VERSION
---------------------------------------- ------------------------------
Oracle9i Catalog Views 9.2.0.1.0
Oracle9i Packages and Types 9.2.0.1.0
Oracle Workspace Manager 9.2.0.1.0
JServer JAVA Virtual Machine 9.2.0.1.0
Oracle XDK for Java 9.2.0.2.0
Oracle9i Java Packages 9.2.0.1.0
Oracle interMedia 9.2.0.1.0
Spatial 9.2.0.1.0
Oracle Text 9.2.0.1.0
Oracle XML Database 9.2.0.1.0
Oracle Ultra Search 9.2.0.1.0
COMP_NAME VERSION
---------------------------------------- ------------------------------
Oracle Data Mining 9.2.0.1.0
v$version 的输出是
SQL> select * from v$version;
BANNER
----------------------------------------------------------------
Oracle 9i Enterprise Edition Release 9.2.0.8.0 - 64 bi t Production
PL/SQL Release 9.2.0.8.0 - Production
CORE 9.2.0.8.0 Production
TNS for HPUX: Version 9.2.0.8.0 - Production
NLSRTL Version 9.2.0.8.0 - Production
DBA_REGISTRY 输出如下。我的数据库是否升级到了9.2.0.8了呢?
SQL> select comp_name,version from DBA_REGISTRY;
COMP_NAME VERSION
---------------------------------------- ------------------------------
Oracle9i Catalog Views 9.2.0.1.0
Oracle9i Packages and Types 9.2.0.1.0
Oracle Workspace Manager 9.2.0.1.0
JServer JAVA Virtual Machine 9.2.0.1.0
Oracle XDK for Java 9.2.0.2.0
Oracle9i Java Packages 9.2.0.1.0
Oracle interMedia 9.2.0.1.0
Spatial 9.2.0.1.0
Oracle Text 9.2.0.1.0
Oracle XML Database 9.2.0.1.0
Oracle Ultra Search 9.2.0.1.0
COMP_NAME VERSION
---------------------------------------- ------------------------------
Oracle Data Mining 9.2.0.1.0
Oracle9i Real Application Clusters 9.2.0.1.0
原因是你先装9.2.0.1版本的软件,然后再升级9.2.0.8的软件,此时在dbca创建数据库时选择了including datafiles的方式,这种方式实际是用rman 调用“种子”模板,而“种子”模板是9.2.0.1的,所以会出现这个问题。 解决之道: 法一: 在dbca时,选择"custom database"或"new database" 来创建数据库,这种方式不会调用rman.也就不存在这种问题. 法二: dbca后,升级数据字典。 |