Při vlastním upgredu databáze jsem spustil pre-upgrade tool (utlu112i.sql) a zobrazilo se varovné hlášení:**********************************************************************Miscellaneous Warnings**********************************************************************WARNING: –> Database is using a timezone file older than version 11….. After the release migration, it is recommended that DBMS_DST package…. be used to upgrade the 11.1.0.6.0 database timezone version…. to the latest version which comes with the new release.Upgrade byl bez problémů, ale pro jistotu a také ze cviku jsem tedy naaplikoval verzi DST, která je součástí databáze 11.2.0.1. Poslední verze DST je zatím 14 a danou databází přichází verze 11.Veškeré dostupné updaty jsou v adresáři $ORACLE_HOME/oracore/zoneinfo.[oracle@vserver1 ~]$ cd $ORACLE_HOMERead More [oracle@vserver1 dbhome_1]$ cd oracore/zoneinfo/[oracle@vserver1 zoneinfo]$ lsbig timezlrg_2.dat timezlrg_9.dat timezone_5.datlittle timezlrg_3.dat timezone_10.dat timezone_6.datreadme.txt timezlrg_4.dat timezone_11.dat timezone_7.dattimezdif.csv timezlrg_5.dat timezone_1.dat timezone_8.dattimezlrg_10.dat timezlrg_6.dat timezone_2.dat timezone_9.dattimezlrg_11.dat timezlrg_7.dat timezone_3.dattimezlrg_1.dat timezlrg_8.dat timezone_4.datSoučasný stavDobře, podívejme se tedy na jaké jsme aktuálně verzi. Jak je vidět z výpisu, jedná se o verzi 4.SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) valueFROM DATABASE_PROPERTIESWHERE PROPERTY_NAME LIKE ‚DST_%’ORDER BY PROPERTY_NAME;PROPERTY_NAME VALUE————————————DST_PRIMARY_TT_VERSION 4DST_SECONDARY_TT_VERSION 0DST_UPGRADE_STATE NONESQL> SELECT version FROM v$timezone_file;VERSION———-4PostupPostup, který je uveden níže, je založen na note z metalinku.Updating the RDBMS DST version in 11gR2 (11.2.0.1 and up) using DBMS_DST [ID 977512.1]SQL> EXEC DBMS_DST.BEGIN_PREPARE(11);PL/SQL procedure successfully completed.SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) valueFROM DATABASE_PROPERTIESWHERE PROPERTY_NAME LIKE ‚DST_%’ORDER BY PROPERTY_NAME;PROPERTY_NAME VALUE————————————–DST_PRIMARY_TT_VERSION 4DST_SECONDARY_TT_VERSION 11DST_UPGRADE_STATE PREPARESQL> EXEC DBMS_DST.CREATE_AFFECTED_TABLE(‚my_affected_tables‘);PL/SQL procedure successfully completed.SQL> EXEC DBMS_DST.CREATE_ERROR_TABLE(‚my_error_table‘);PL/SQL procedure successfully completed.SQL> SELECT * FROM sys.dst$affected_tables;no rows selectedSQL> SELECT * FROM sys.dst$error_table;no rows selectedSQL> EXEC DBMS_DST.END_PREPARE;PL/SQL procedure successfully completed.SQL> shutdown immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startup upgradeORACLE instance started.Total System Global Area 828608512 bytesFixed Size 1339684 bytesVariable Size 557846236 bytesDatabase Buffers 264241152 bytesRedo Buffers 5181440 bytesDatabase mounted.Database opened.SQL> EXEC DBMS_DST.BEGIN_UPGRADE(11);PL/SQL procedure successfully completed.SQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) valueFROM DATABASE_PROPERTIESWHERE PROPERTY_NAME LIKE ‚DST_%’ORDER BY PROPERTY_NAME;PROPERTY_NAME VALUE————————————–DST_PRIMARY_TT_VERSION 11DST_SECONDARY_TT_VERSION 4DST_UPGRADE_STATE UPGRADESQL> shutdown immediateDatabase closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 828608512 bytesFixed Size 1339684 bytesVariable Size 557846236 bytesDatabase Buffers 264241152 bytesRedo Buffers 5181440 bytesDatabase mounted.Database opened.SQL> set serveroutput onVAR numfail numberBEGINDBMS_DST.UPGRADE_DATABASE(:numfail,parallel => TRUE,log_errors => TRUE,log_errors_table => ‚SYS.DST$ERROR_TABLE‘,log_triggers_table => ‚SYS.DST$TRIGGER_TABLE‘,error_on_overlap_time => TRUE,error_on_nonexisting_time => TRUE);DBMS_OUTPUT.PUT_LINE(‚Failures:’|| :numfail);END;/SQL>Table list: SYSMAN.MGMT_CONFIG_ACTIVITIESNumber of failures: 0Table list: SYSMAN.MGMT_PROV_SUITE_INST_MEMBERSNumber of failures: 0Table list: SYSMAN.MGMT_PROV_STAGING_DIRSNumber of failures: 0Table list: SYSMAN.MGMT_PROV_RPM_REPNumber of failures: 0Table list: SYSMAN.MGMT_PROV_OPERATIONNumber of failures: 0Table list: SYSMAN.MGMT_PROV_NET_CONFIGNumber of failures: 0Table list: SYSMAN.MGMT_PROV_IP_RANGENumber of failures: 0Table list: SYSMAN.MGMT_PROV_DEFAULT_IMAGENumber of failures: 0Table list: SYSMAN.MGMT_PROV_CLUSTER_NODESNumber of failures: 0Table list: SYSMAN.MGMT_PROV_BOOTSERVERNumber of failures: 0Table list: SYSMAN.MGMT_PROV_ASSIGNMENTNumber of failures: 0Table list: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_SNumber of failures: 0Table list: SYSMAN.AQ$_MGMT_NOTIFY_QTABLE_LNumber of failures: 0Table list: SYSMAN.AQ$_MGMT_LOADER_QTABLE_SNumber of failures: 0Table list: SYSMAN.AQ$_MGMT_LOADER_QTABLE_LNumber of failures: 0Table list: IX.AQ$_STREAMS_QUEUE_TABLE_SNumber of failures: 0Table list: IX.AQ$_STREAMS_QUEUE_TABLE_LNumber of failures: 0Table list: IX.AQ$_ORDERS_QUEUETABLE_SNumber of failures: 0Table list: IX.AQ$_ORDERS_QUEUETABLE_LNumber of failures: 0Failures:0PL/SQL procedure successfully completed.SQL>SQL> VAR fail numberBEGINDBMS_DST.END_UPGRADE(:fail);DBMS_OUTPUT.PUT_LINE(‚Failures:’|| :fail);END;/SQL>An upgrade window has been successfully ended.Failures:0PL/SQL procedure successfully completed.KontrolaSQL> SELECT PROPERTY_NAME, SUBSTR(property_value, 1, 30) valueFROM DATABASE_PROPERTIESWHERE PROPERTY_NAME LIKE ‚DST_%’ORDER BY PROPERTY_NAME;PROPERTY_NAME VALUE————————————DST_PRIMARY_TT_VERSION 11DST_SECONDARY_TT_VERSION 0DST_UPGRADE_STATE NONESQL> SELECT * FROM v$timezone_file;FILENAME VERSION——————– ———-timezlrg_11.dat 11



Komentáře