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
- 【UP_ORACLE】使用AutoUpgrade工具升級Oracle 11.2.0.4至12.2.0.1Oracle
- 靜默升級oracle 11g （從11.2.0.1升級到11.2.0.4）Oracle
- Oracle：Oracle RAC 11.2.0.4 升級為 19cOracle
- Oracle database 升級（文件）to 10.2.0.4 from 10.2.0.1OracleDatabase
- ThinkPHP升級至 5.1.18 版本PHP
- MongoDB 3.2 升級至 3.4.6MongoDB
- Windows升級到oracle 11g的異機物理升級文件（冷備）WindowsOracle
- postgresql9.5.0升級至10.3SQL
- glibc2.12升級至2.15
- php5.6 升級至7.2.7PHP
- 【XTTS】Oracle XTTS V4--Oracle11.2.0.4+ 遷移升級TTSOracle
- openssh升級7.4p1至8.4p1、openssl升級至openssl-1.1.1h
- ORACLE 11.2.0.4 RAC RMAN異機恢復之ORA-15001Oracle
- 內網gitlab11.2升級至11.4.5內網Gitlab
- Linux平滑編譯升級php至5.5.0Linux編譯PHP
- 如何Fedora 24升級至Fedora 25版？Fedora24升級至Fedora25版的詳細教程
- oracle 11.2.0.4 rac節點異常當機之ORA-07445Oracle
- confluence 4.2 升級至 6.10.x 記錄
- 使用DBUA升級 Oracle 11.2.0.4到Oracle 19C的問題記錄Oracle
- iOS12升級與降級至iOS11.4./11.3.1教程 iOS12怎麼升級iOS
- 【邏輯DG滾動升級三】ORACLE11204 邏輯DG滾動升級至12C---正式升級Oracle
- mongodb單機從3.2升級到4.0.4升級MongoDB
- Centos7 升級至openssh-9.8p1CentOS
- 【資料庫】mysql5.6升級至5.7（物理方式）資料庫MySql
- windows10 MySQL5.7升級至MySQL8.0WindowsMySql
- MacMini 拆機與升級MacACM
- ORACLE 11.2.0.4 rac for linux 鏈路宕導致的單節點異常當機OracleLinux
- 華碩主機板升級bios教程 華碩主機板如何升級BIOS？iOS
- Piper Jaffray：使用者因等待5G機型而不願升級至iPhone 11iPhone
- 坑爹的Oracle 11.2.0.3Oracle
- ORACLE windows和linux環境下 10g升級到11.2.0.4 並安裝11.2.0.4.19補丁OracleWindowsLinux
- 升級openssh前安裝zlib報異常configure aborting
- Mac升級至macOS High Sierra後導致git無法使用MacGit
- 京東 vue3 元件庫震撼升級，如約而至！Vue元件
- win10升級伺服器異常怎麼解決_win10升級伺服器發生異常修復方法Win10伺服器
- redhat 6.5 mysql 升級5.5.48經mysql 5.6.32至mysql 5.7.16實施概略RedhatMySql