Table Of Contents

Updating CTM Daylight Saving Time for New Zealand

Updating CTM Daylight Saving Time for New Zealand

---

This appendix describes how to make the CTM server compliant with the New Zealand Daylight Saving Time (DST) settings update.

---

Step 1 Download Oracle patch number 6113507, required to support the DST changes. To download the additional required Oracle patch, complete the following substeps:

a. Go to http://metalink.oracle.com and click Login to MetaLink. Enter your Oracle MetaLink username and password.

b. Choose Patch from the menu and search for the 6113507 patch.

c. Choose Solaris Operating System (SPARC 64-bit) from the Platform or Language list box.

d. Click Go.

e. Click Download to download the p6113507_10203_SOLARIS64.zip file to your local workstation.

f. Enter the following command to log into the database workstation as the oracle user:

su - oracle

g. Save the patch to the $ORACLE_HOME directory.

Step 2 As the root UNIX user, enter the following command to shut down the CTM server:

ctms-stop

Step 3 As the oracle user, enter the following commands to stop the CTM database:

su - oracle

lsnrctl stop

sqlplus /nolog

connect / as sysdba

shutdown immediate

quit

Step 4 Install the additional required Oracle patch. Complete the following substeps:

a. Enter the following commands to unzip p6113507_10203_SOLARIS64.zip to your Oracle home directory:

cd $ORACLE_HOME

unzip p6113507_10203_SOLARIS64.zip

A new 6113507 folder is created.

b. Enter the following command to change to the 6113507 folder:

cd 6113507

c. Enter the following command to apply the patch:

../OPatch/opatch apply

d. Enter the following command to determine whether the 6113507 patch is installed:

../OPatch/opatch lsinventory | grep 6113507

The output should show the 6113507 patch number.

Step 5 As the oracle user, enter the following commands to start the CTM database:

su - oracle

sqlplus /nolog

connect / as sysdba

startup

quit

lsnrctl start

Step 6 As the root UNIX user, enter the following command to verify that the Oracle processes are running:

ps -ef | grep ora

Step 7 Enter the following command to start the CTM server:

ctms-start

---