11.2.0.3 database異機升級至11.2.0.4
A、B兩臺主機，A上安裝的是11.2.0.3單機版，B上安裝的是11.2.0.4單機版，為有效利用主機資源，欲將A上的資料庫遷移到B機上執行，假設A上的資料檔案所在儲存已經能在B機上認到。要完成遷移其實就是將A上的資料庫從11.2.0.3升級至11.2.0.4，實施步驟如下：
/////////////////
// 執行@$ORACLE_HOME/rdbms/admin/utlu112i.sql
/////////////////
startup upgrade
SQL> @$ORACLE_HOME/rdbms/admin/utlu112i.sql
DECLARE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [], [], [], [], [], [],
[], [], [], []
同時發現alert.log裡有如下的報錯，大致的意思是時區有關的檔案無法找到：
Failed to find timezone data file # 18 (DST_4)
SQL> select NAME, VALUE$ from SYS.PROPS$ where NAME like ('DST_%_TT_VERSION')
2 ;
NAME VALUE$
------------------------------ ----------------------------------------
DST_PRIMARY_TT_VERSION 18
DST_SECONDARY_TT_VERSION 0
按照MOS 362036.1 必須確保$ORACLE_HOME/oracore/zoneinfo/目錄下有timezone_18.dat、timezlrg_18.dat兩個檔案，檢視本機上果然沒有，從其它主機上覆制過來後解決
SQL> @$ORACLE_HOME/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 09-01-2015 13:18:42
Script Version: 11.2.0.4.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: RWDDB
--> version: 11.2.0.3.0
--> compatible: 11.2.0
--> blocksize: 8192
--> platform: AIX-Based Systems (64-bit)
--> timezone file: V18
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 1174 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 1562 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 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:
-- No update parameter changes are required.
.
--> If Target Oracle is 64-Bit, refer here for Update Parameters:
WARNING: --> "sga_target" needs to be increased to at least 620 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]
**********************************************************************
-- No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] INVALID
--> Oracle Packages and Types [upgrade] INVALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] INVALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] INVALID
--> OLAP Catalog [upgrade] VALID
--> Oracle Label Security [upgrade] VALID
... To successfully upgrade Oracle Label Security, choose
... 'Select Options' in Oracle installer and then select
... Oracle Label Security.
--> 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
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle Application Express [upgrade] VALID
... APEX will only be upgraded if the version of APEX in
... the target Oracle home is higher than the current one.
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database is using a timezone file greater than version 14.
.... BEFORE upgrading the database, patch the 11gR2
.... $ORACLE_HOME/oracore/zoneinfo/ with a timezone data file of the
.... same version as the one used in the 11.2.0.3.0 release database.
WARNING: --> Database contains INVALID objects prior to upgrade.
.... The list of invalid SYS/SYSTEM objects was written to
.... registry$sys_inv_objs.
.... The list of non-SYS/SYSTEM objects was written to
.... registry$nonsys_inv_objs.
.... Use utluiobj.sql after the upgrade to identify any new invalid
.... objects due to the upgrade.
.... USER ETL has 1 INVALID objects.
.... USER AINEWAWARD has 42 INVALID objects.
WARNING: --> Your recycle bin contains 789 object(s).
.... It is REQUIRED that the recycle bin is empty prior to upgrading
.... your database. The command:
PURGE DBA_RECYCLEBIN
.... must be executed immediately prior to executing your upgrade.
WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER APEX_030200 has dependent objects.
.
**********************************************************************
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 removing all hidden parameters prior to upgrading.
To view existing hidden parameters execute the following command
while connected AS SYSDBA:
SELECT name,description from SYS.V$PARAMETER WHERE name
LIKE '\_%' ESCAPE '\'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
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.
/////////////////
// 清空回收站
/////////////////
purge dba_recyclebin;
/////////////////
// 重啟到upgradate
/////////////////
shutdown abort
startup upgrade
/////////////////
// 執行$ORACLE_HOME/rdbms/admin/catupgrd.sql
/////////////////
SQL>@$ORACLE_HOME/rdbms/admin/catupgrd.sql
Oracle Database 11.2 Post-Upgrade Status Tool 09-01-2015 14:00:13
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. VALID 11.2.0.4.0 00:08:31
JServer JAVA Virtual Machine
. VALID 11.2.0.4.0 00:04:37
Oracle Real Application Clusters
. INVALID 11.2.0.4.0 00:00:00
Oracle Workspace Manager
. VALID 11.2.0.4.0 00:00:33
OLAP Analytic Workspace
. VALID 11.2.0.4.0 00:00:42
OLAP Catalog
. VALID 11.2.0.4.0 00:00:34
Oracle OLAP API
. VALID 11.2.0.4.0 00:00:23
Oracle Label Security
. OPTION OFF 11.2.0.3.0 00:00:00
Oracle Enterprise Manager
. VALID 11.2.0.4.0 00:02:09
Oracle XDK
. VALID 11.2.0.4.0 00:00:41
Oracle Text
. VALID 11.2.0.4.0 00:00:21
Oracle XML Database
. VALID 11.2.0.4.0 00:02:10
Oracle Database Java Packages
. VALID 11.2.0.4.0 00:00:18
Oracle Multimedia
. VALID 11.2.0.4.0 00:02:27
Spatial
. VALID 11.2.0.4.0 00:02:16
Oracle Expression Filter
. VALID 11.2.0.4.0 00:00:07
Oracle Rules Manager
. VALID 11.2.0.4.0 00:00:06
Oracle Application Express
. VALID 3.2.1.00.12
Final Actions
. 00:00:00
Total Upgrade Time: 00:26:05
PL/SQL procedure successfully completed.
SQL>
SQL> SET SERVEROUTPUT OFF
SQL> SET VERIFY ON
SQL> commit;
Commit complete.
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
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>#
SQL>
SQL> Rem Set errorlogging off
SQL> SET ERRORLOGGING OFF;
SQL>
SQL> REM END OF CATUPGRD.SQL
SQL>
SQL> REM bug 12337546 - Exit current sqlplus session at end of catupgrd.sql.
SQL> REM This forces user to start a new sqlplus session in order
SQL> REM to connect to the upgraded db.
SQL> exit
/////////////////
// 重啟資料庫到正常狀態後執行utlrp.sql
/////////////////
startup
SQL> select count(*) from dba_invalid_objects;
COUNT(*)
----------
388
@$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> select count(*) from dba_invalid_objects;
COUNT(*)
----------
30
***列出invalid object
select owner,object_name,object_type,status from dba_invalid_objects;
***檢視哪些物件原來是valid在upgrade後變成了invalid，如果有就要解決一下了
SQL> @$ORACLE_HOME/rdbms/admin/utluiobj.sql
.
Oracle Database 11.2 Post-Upgrade Invalid Objects Tool 09-01-2015 14:22:15
.
This tool lists post-upgrade invalid objects that were not invalid
prior to upgrade (it ignores pre-existing pre-upgrade invalid objects).
.
Owner Object Name Object Type
.
PL/SQL procedure successfully completed.
/////////////////
// 執行utlu112s.sql檢查各元件的升級用時及結果
/////////////////
SQL> @$ORACLE_HOME/rdbms/admin/utlu112s.sql
.
Oracle Database 11.2 Post-Upgrade Status Tool 09-01-2015 14:25:10
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. VALID 11.2.0.4.0 00:08:31
JServer JAVA Virtual Machine
. VALID 11.2.0.4.0 00:04:37
Oracle Real Application Clusters
. INVALID 11.2.0.4.0 00:00:00
Oracle Workspace Manager
. VALID 11.2.0.4.0 00:00:33
OLAP Analytic Workspace
. VALID 11.2.0.4.0 00:00:42
OLAP Catalog
. VALID 11.2.0.4.0 00:00:34
Oracle OLAP API
. VALID 11.2.0.4.0 00:00:23
Oracle Label Security
. OPTION OFF 11.2.0.3.0 00:00:00
Oracle Enterprise Manager
. VALID 11.2.0.4.0 00:02:09
Oracle XDK
. VALID 11.2.0.4.0 00:00:41
Oracle Text
. VALID 11.2.0.4.0 00:00:21
Oracle XML Database
. VALID 11.2.0.4.0 00:02:10
Oracle Database Java Packages
. VALID 11.2.0.4.0 00:00:18
Oracle Multimedia
. VALID 11.2.0.4.0 00:02:27
Spatial
. VALID 11.2.0.4.0 00:02:16
Oracle Expression Filter
. VALID 11.2.0.4.0 00:00:07
Oracle Rules Manager
. VALID 11.2.0.4.0 00:00:06
Oracle Application Express
. VALID 3.2.1.00.12
Final Actions
. 00:00:00
Total Upgrade Time: 00:26:05
PL/SQL procedure successfully completed.
使用語句
select substr(comp_id,1,15) comp_id,substr(comp_name,1,30),comp_name,substr(version,1,10) version,status from dba_registry order by modified
也可以達到相同的效果
/////////////////////////////////////////
//執行$ORACLE_HOME/rdbms/admin/catuppst.sql
/////////////////////////////////////////
$ORACLE_HOME/rdbms/admin/catuppst.sql的用途是：migrate the Baseline data
@$ORACLE_HOME/rdbms/admin/catuppst.sql
This script will migrate the Baseline data on a pre-11g database
to the 11g database.
... ...
... Completed Moving the Baseline Data ...
... ...
... If there are no Move BL Data messages ...
... above, then there are no renamed ...
... baseline tables in the system. ...
... ...
... ...
... 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. ...
... ...
。。。。省略部分輸出
/////////////////
// 執行@$ORACLE_HOME/rdbms/admin/utlu112i.sql
/////////////////
startup upgrade
SQL> @$ORACLE_HOME/rdbms/admin/utlu112i.sql
DECLARE
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [qcisSetPlsqlCtx:tzi init], [], [], [], [], [], [], [],
[], [], [], []
同時發現alert.log裡有如下的報錯，大致的意思是時區有關的檔案無法找到：
Failed to find timezone data file # 18 (DST_4)
SQL> select NAME, VALUE$ from SYS.PROPS$ where NAME like ('DST_%_TT_VERSION')
2 ;
NAME VALUE$
------------------------------ ----------------------------------------
DST_PRIMARY_TT_VERSION 18
DST_SECONDARY_TT_VERSION 0
按照MOS 362036.1 必須確保$ORACLE_HOME/oracore/zoneinfo/目錄下有timezone_18.dat、timezlrg_18.dat兩個檔案，檢視本機上果然沒有，從其它主機上覆制過來後解決
SQL> @$ORACLE_HOME/rdbms/admin/utlu112i.sql
Oracle Database 11.2 Pre-Upgrade Information Tool 09-01-2015 13:18:42
Script Version: 11.2.0.4.0 Build: 001
.
**********************************************************************
Database:
**********************************************************************
--> name: RWDDB
--> version: 11.2.0.3.0
--> compatible: 11.2.0
--> blocksize: 8192
--> platform: AIX-Based Systems (64-bit)
--> timezone file: V18
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 1174 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 1562 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 400 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 60 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:
-- No update parameter changes are required.
.
--> If Target Oracle is 64-Bit, refer here for Update Parameters:
WARNING: --> "sga_target" needs to be increased to at least 620 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]
**********************************************************************
-- No obsolete parameters found. No changes are required
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] INVALID
--> Oracle Packages and Types [upgrade] INVALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Real Application Clusters [upgrade] INVALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] INVALID
--> OLAP Catalog [upgrade] VALID
--> Oracle Label Security [upgrade] VALID
... To successfully upgrade Oracle Label Security, choose
... 'Select Options' in Oracle installer and then select
... Oracle Label Security.
--> 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
--> Expression Filter [upgrade] VALID
--> Rule Manager [upgrade] VALID
--> Oracle Application Express [upgrade] VALID
... APEX will only be upgraded if the version of APEX in
... the target Oracle home is higher than the current one.
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database is using a timezone file greater than version 14.
.... BEFORE upgrading the database, patch the 11gR2
.... $ORACLE_HOME/oracore/zoneinfo/ with a timezone data file of the
.... same version as the one used in the 11.2.0.3.0 release database.
WARNING: --> Database contains INVALID objects prior to upgrade.
.... The list of invalid SYS/SYSTEM objects was written to
.... registry$sys_inv_objs.
.... The list of non-SYS/SYSTEM objects was written to
.... registry$nonsys_inv_objs.
.... Use utluiobj.sql after the upgrade to identify any new invalid
.... objects due to the upgrade.
.... USER ETL has 1 INVALID objects.
.... USER AINEWAWARD has 42 INVALID objects.
WARNING: --> Your recycle bin contains 789 object(s).
.... It is REQUIRED that the recycle bin is empty prior to upgrading
.... your database. The command:
PURGE DBA_RECYCLEBIN
.... must be executed immediately prior to executing your upgrade.
WARNING: --> Database contains schemas with objects dependent on DBMS_LDAP package.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
.... USER APEX_030200 has dependent objects.
.
**********************************************************************
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 removing all hidden parameters prior to upgrading.
To view existing hidden parameters execute the following command
while connected AS SYSDBA:
SELECT name,description from SYS.V$PARAMETER WHERE name
LIKE '\_%' ESCAPE '\'
Changes will need to be made in the init.ora or spfile.
**********************************************************************
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.
/////////////////
// 清空回收站
/////////////////
purge dba_recyclebin;
/////////////////
// 重啟到upgradate
/////////////////
shutdown abort
startup upgrade
/////////////////
// 執行$ORACLE_HOME/rdbms/admin/catupgrd.sql
/////////////////
SQL>@$ORACLE_HOME/rdbms/admin/catupgrd.sql
Oracle Database 11.2 Post-Upgrade Status Tool 09-01-2015 14:00:13
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. VALID 11.2.0.4.0 00:08:31
JServer JAVA Virtual Machine
. VALID 11.2.0.4.0 00:04:37
Oracle Real Application Clusters
. INVALID 11.2.0.4.0 00:00:00
Oracle Workspace Manager
. VALID 11.2.0.4.0 00:00:33
OLAP Analytic Workspace
. VALID 11.2.0.4.0 00:00:42
OLAP Catalog
. VALID 11.2.0.4.0 00:00:34
Oracle OLAP API
. VALID 11.2.0.4.0 00:00:23
Oracle Label Security
. OPTION OFF 11.2.0.3.0 00:00:00
Oracle Enterprise Manager
. VALID 11.2.0.4.0 00:02:09
Oracle XDK
. VALID 11.2.0.4.0 00:00:41
Oracle Text
. VALID 11.2.0.4.0 00:00:21
Oracle XML Database
. VALID 11.2.0.4.0 00:02:10
Oracle Database Java Packages
. VALID 11.2.0.4.0 00:00:18
Oracle Multimedia
. VALID 11.2.0.4.0 00:02:27
Spatial
. VALID 11.2.0.4.0 00:02:16
Oracle Expression Filter
. VALID 11.2.0.4.0 00:00:07
Oracle Rules Manager
. VALID 11.2.0.4.0 00:00:06
Oracle Application Express
. VALID 3.2.1.00.12
Final Actions
. 00:00:00
Total Upgrade Time: 00:26:05
PL/SQL procedure successfully completed.
SQL>
SQL> SET SERVEROUTPUT OFF
SQL> SET VERIFY ON
SQL> commit;
Commit complete.
SQL>
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
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>#
SQL>
SQL> Rem Set errorlogging off
SQL> SET ERRORLOGGING OFF;
SQL>
SQL> REM END OF CATUPGRD.SQL
SQL>
SQL> REM bug 12337546 - Exit current sqlplus session at end of catupgrd.sql.
SQL> REM This forces user to start a new sqlplus session in order
SQL> REM to connect to the upgraded db.
SQL> exit
/////////////////
// 重啟資料庫到正常狀態後執行utlrp.sql
/////////////////
startup
SQL> select count(*) from dba_invalid_objects;
COUNT(*)
----------
388
@$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> select count(*) from dba_invalid_objects;
COUNT(*)
----------
30
***列出invalid object
select owner,object_name,object_type,status from dba_invalid_objects;
***檢視哪些物件原來是valid在upgrade後變成了invalid，如果有就要解決一下了
SQL> @$ORACLE_HOME/rdbms/admin/utluiobj.sql
.
Oracle Database 11.2 Post-Upgrade Invalid Objects Tool 09-01-2015 14:22:15
.
This tool lists post-upgrade invalid objects that were not invalid
prior to upgrade (it ignores pre-existing pre-upgrade invalid objects).
.
Owner Object Name Object Type
.
PL/SQL procedure successfully completed.
/////////////////
// 執行utlu112s.sql檢查各元件的升級用時及結果
/////////////////
SQL> @$ORACLE_HOME/rdbms/admin/utlu112s.sql
.
Oracle Database 11.2 Post-Upgrade Status Tool 09-01-2015 14:25:10
.
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
.
Oracle Server
. VALID 11.2.0.4.0 00:08:31
JServer JAVA Virtual Machine
. VALID 11.2.0.4.0 00:04:37
Oracle Real Application Clusters
. INVALID 11.2.0.4.0 00:00:00
Oracle Workspace Manager
. VALID 11.2.0.4.0 00:00:33
OLAP Analytic Workspace
. VALID 11.2.0.4.0 00:00:42
OLAP Catalog
. VALID 11.2.0.4.0 00:00:34
Oracle OLAP API
. VALID 11.2.0.4.0 00:00:23
Oracle Label Security
. OPTION OFF 11.2.0.3.0 00:00:00
Oracle Enterprise Manager
. VALID 11.2.0.4.0 00:02:09
Oracle XDK
. VALID 11.2.0.4.0 00:00:41
Oracle Text
. VALID 11.2.0.4.0 00:00:21
Oracle XML Database
. VALID 11.2.0.4.0 00:02:10
Oracle Database Java Packages
. VALID 11.2.0.4.0 00:00:18
Oracle Multimedia
. VALID 11.2.0.4.0 00:02:27
Spatial
. VALID 11.2.0.4.0 00:02:16
Oracle Expression Filter
. VALID 11.2.0.4.0 00:00:07
Oracle Rules Manager
. VALID 11.2.0.4.0 00:00:06
Oracle Application Express
. VALID 3.2.1.00.12
Final Actions
. 00:00:00
Total Upgrade Time: 00:26:05
PL/SQL procedure successfully completed.
使用語句
select substr(comp_id,1,15) comp_id,substr(comp_name,1,30),comp_name,substr(version,1,10) version,status from dba_registry order by modified
也可以達到相同的效果
/////////////////////////////////////////
//執行$ORACLE_HOME/rdbms/admin/catuppst.sql
/////////////////////////////////////////
$ORACLE_HOME/rdbms/admin/catuppst.sql的用途是：migrate the Baseline data
@$ORACLE_HOME/rdbms/admin/catuppst.sql
This script will migrate the Baseline data on a pre-11g database
to the 11g database.
... ...
... Completed Moving the Baseline Data ...
... ...
... If there are no Move BL Data messages ...
... above, then there are no renamed ...
... baseline tables in the system. ...
... ...
... ...
... 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. ...
... ...
。。。。省略部分輸出
來自 “ ITPUB部落格 ” ，連結：http://blog.itpub.net/53956/viewspace-1788835/，如需轉載，請註明出處，否則將追究法律責任。
相關文章
- oracle rac 11.2.0.3 升級到11.2.0.4Oracle
- oracle資料庫升級11.2.0.3升級到11.2.0.4Oracle資料庫
- Oracle 10.2.0.5升級至11.2.0.4Oracle
- oracle資料庫11.2.0.3升級到11.2.0.4Oracle資料庫
- Oracle資料庫異機升級（10.2.0.5 --> 11.2.0.4）Oracle資料庫
- 探索Oracle之資料庫升級二 11.2.0.3升級到11.2.0.4完整步驟Oracle資料庫
- 探索Oracle之資料庫升級三 回退升級操作(11.2.0.4Downgrade 11.2.0.3)Oracle資料庫
- 如何升級Oracle Grid Infrastructure和RAC從11.2.0.3到11.2.0.4？OracleASTStruct
- Oracle 11.2.0.4 RAC psu補丁升級至11.2.0.4.2Oracle
- 單例項環境下Oracle 11.2.0.3升級到11.2.0.4的過程單例Oracle
- 【UP_ORACLE】使用AutoUpgrade工具升級Oracle 11.2.0.4至12.2.0.1Oracle
- oracle11.2.0.3升級到11.2.0.4出現查詢效能問題，分析處理Oracle
- 升級到 11.2.0.3/11.2.0.4 GI/ASM 前需要考慮的事情 (文件 ID 1623280.1)ASM
- Oracle 11.2.0.1 升級到11.2.0.3Oracle
- ORACLE 11.2.0.1升級到11.2.0.3Oracle
- Oracle 11.2.0.1升級到11.2.0.3Oracle
- 圖形化升級單機oracle 11.2.0.1 到 11.2.0.4Oracle
- 圖形化升級單機oracle 11.2.0.4 到 12.2.0.1Oracle
- Oracle 11.2.0.4升級到12.2.0.1Oracle
- ORACLE11.2.0.1升級到11.2.0.3Oracle
- MongoDB 3.2 升級至 3.4.6MongoDB
- Twitter API升級至1.1API
- oracle for windows 11.2.0.1升級到11.2.0.4OracleWindows
- Oracle Database 10.2.0.5.0 升級OracleDatabase
- oracle版本升級：從11.2.0.1到11.2.0.3Oracle
- 單機升級11.2.0.4到12.1.0.2的實戰__catupgrd.sqlSQL
- 單機升級11.2.0.1到11.2.0.4的實戰__DBUA視窗
- 靜默升級oracle 11g （從11.2.0.1升級到11.2.0.4）Oracle
- php5.6 升級至7.2.7PHP
- ThinkPHP升級至 5.1.18 版本PHP
- Windows升級到oracle 11g的異機物理升級文件（冷備）WindowsOracle
- Oracle：Oracle RAC 11.2.0.4 升級為 19cOracle
- RAC升級11.2.0.1到11.2.0.4的實戰
- postgresql9.5.0升級至10.3SQL
- oracle 資料庫從10.2.0.4升級到11.2.0.3Oracle資料庫
- 資料庫版本升級(upgrade 9.2.0.1 to11.2.0.3)資料庫
- 如何Fedora 24升級至Fedora 25版？Fedora24升級至Fedora25版的詳細教程
- 【XTTS】Oracle XTTS V4--Oracle11.2.0.4+ 遷移升級TTSOracle