Opgradering fra 10.2.0.2 til 10.2.0.3

Skrevet af: Karsten Birch-Johansen i Oracle drift

Technorati Tags: Oracle upgrade 10.2.0.2 til 10.2.0.3

0 kommentarer : Blogs der linker : Tilføj til del.icio.us : Tilmeld dig feeds herfra : E-Mail posten

Undertegnede kom lige ud i en opgradering fra 10.2.0.2 til 10.2.0.3 og nedenstående er hvordan man får opgraderet nogenlunde smertefrit.

The 10.2.0.3 patch set includes an update to the Oracle time zone definitions. The 10.2.0.3 patch set updates the standard version of the Oracle 10.2 time zone definitions version-2 to version-3. This version of the time zone definitions includes the changes to daylight saving time in the USA in 2007, and many other updates.

A list of updated time zones in version-3 of these definitions are available from document 412160.1 on Oracle Metalink.

Perform the following actions to ensure that time zone data affected by the changes in these time zones are updated appropriately:

1. Download the patch 5601428 from Oracle Metalink.
2. Install the patch. The script utltzuv2.sql is installed into the $ORACLE_HOME/rdbms/admin directory.
3. Run utltzuv2.sql to check the data of datatype TIMESTAMP WITH TIME ZONE (TSTZ). The output of this script is a results table which highlights the affected columns.
4. Refer to the instructions in the utltzuv2.sql or Oracle Metalink note 396671.1: Usage of utltzuv2.sql before updating time zone files in Oracle 10, to evaluate results and if required save the existing TSTZ data. If no data was found, no further actions are needed.

Selve opgraderingen foregår så som følger:

Set dit Oracle environment til den database du ønsker at opgradere:

[maskinnavn:ORACLESID:path] sqlplus / as sysdba

SQL> shutdown immediate
SQL> startup restrict
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> shutdown
SQL> exit

[maskinnavn:ORACLESID:path] vi /var/opt/oracle/oratab
DBnavn:/opt/oracle/10.2.0.3.0:Y

[maskinnavn:ORACLESID:path] cd $ORACLE_HOME/dbs

[maskinnavn:ORACLESID:path] cp /opt/oracle/10.2.0.2.0/dbs/init$ORACLE_SID.ora .

Ret parameteren compatible til 10.2.0.3

[maskinnavn:ORACLESID:path] sqlplus / as sysdba

SQL> startup upgrade
SQL> spool patch.log
SQL> @$ORACLE_HOME/rdbms/admin/catupgrd.sql
SQL> shutdown
SQL> startup
SQL> @$ORACLE_HOME/rdbms/admin/utlrp.sql
SQL> spool off
SQL> exit

[maskinnavn:ORACLESID:path] grep -i "ora-" patch.log

Opdater herefter listener.ora filen til at afspejle ændringerne! Lav herefter en restart.

Er det første gang der opgraderes kan det være der skal ændres i