Product Release Notes for Oracle Database update for Avaya ...



[pic]

Product Release Notes for Avaya Proactive Contact Database 3.0.3

Table of Contents

1. Pre-requisite 3

1.1. Software Dependencies 3

1.2. Obtaining files and patches 3

2. Installation 4

2.1. List of Patches provided by Third Party 4

2.2. Pre-installation Procedure 4

2.3. Installation Procedure 5

2.4. Post-Installation Procedure 8

2.5. Uninstallation Procedure 10

3. Enhancements 10

4. Fixes 10

5. Troubleshooting 10

5.1. Troubleshooting the installation 10

6. Known Issues 10

7. Contact Support 10

This document is the release notes for Avaya Proactive Contact Database 3.0.3. This document details the necessary steps to update an existing Oracle Database.

Pre-requisite

1 Software Dependencies

This procedure assumes that Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit, as delivered on the 12702-01 CD1 and CD2 are already installed and functioning. The software referenced in this document is for update purposes only. For Avaya Proactive Contact Database 3.0.3, the CDs are labeled as follows:

Avaya Proactive Contact Database 3.0.3 Disk1

Material ID: 700476070

Avaya Proactive Contact Database 3.0.3 Disk2

Material ID: 700476088

2 Obtaining files and patches

There are two ways to obtain this release. They are:

• Ordering the installation CDs labeled

o Avaya Proactive Contact Database 3.0.3 Disk1

Material ID: 700476070

o Avaya Proactive Contact Database 3.0.3 Disk2

Material ID: 700476088

• Downloading the ISO files from Avaya Support Web site and writing them on two CDs.

To download the ISO files:

1. Go to Avaya support site at

2. Navigate to Resource Library > Downloads > Proactive Contact -> 3.0.x.

3. Download the Avaya Proactive Contact Database 3.0.3 ISO images.

To write the ISO on a CD:

1. Insert a blank writable CD in the CD RW drive.

NOTE: You can use any available CD writing tool like Roxio

or Nero to write the ISO file on a CD.

2. Select the Image burning option from the CD writing software.

• For Roxio select Copy > Burn Image option.

• For Nero Express select Image, Project, and Copy > Disc Image or Saved Project option.

3. Browse and select the ISO image for burning.

4. Wait until the CD burning is completed.

5. Label the CD as Avaya Proactive Contact Database 3.0.3 Disk1, Material ID: 700476070

6. Perform Step1 to Step 4 for Disk2

7. Label the CD as Avaya Proactive Contact Database 3.0.3 Disk2, Material ID: 700476088

Installation

1 List of Patches provided by Third Party

This section provides a list of patches provided by Oracle.

|Work Item |Oracle Patch Set |Description |

|wi00295809 |P4505133_10105_HP64 |Oracle® Database 10g Release 1 (10.1.0.5) Patch Set |

.

2 Pre-installation Procedure

NOTE: HP-UX 11i Update for B2000/B2600/C8000 (Material ID: 700459290) should be installed before starting the installation.

The system should be in a “quiet” state, that is, the application should be shutdown and users logged off.

1. Login to the dialer as admin.

2. Run the following commands to shutdown all the PDS process:

stop_pds

stop_mts

stop_db

3. Run the following commands to verify all the PDS process are shutdown:

check_pds

check_mts

check_db

Take a backup of the database:

1. Login as root.

2. Insert a blank DDS tape into the tape drive.

3. Execute the following commands from the UNIX command prompt.

cd /opt/dbase

tar –cv0 *

4. Remove the DDS tape from the tape drive, label it with the release version and current date and store it in a safe place.

Alternatively take ignite backup of complete dialer using moimage

NOTE: Ensure the following:

● The /opt/dbase directory has at least 1.5 GB free space for successful installation of the database updates. Run the df –b command to find the amount of free space available.

● The swap space is more than 150 MB to start the installation. Run the

swapinfo -md command to find the amount of swap space.

3 Installation Procedure

This procedure will install the Avaya Proactive Contact Database 3.0.3:

1. Login to the dialer as root.

2. Run the “who” command and check that non root user is not logged into the dialer. If any non root user was listed in the command then logout all those users before proceeding for the installation.

3. Insert Disk1 in the CD ROM drive.

4. Mount Disk1 using the following command:

mount –F cdfs –o rr /dev/dsk/ /CDROM

NOTE: If you do not know which block device file is associated with your CD drive, run the “ioscan –fnd sdisk” command to find the device. Insert the proper name wherever you see in this procedure.

5. Copy the following files from Disk1 to any location on the dialer having at least 4 GB of free space with read/write access. For example, /DVD_OPS path.

• oracle.zipaa

• oraupdt

• postinst

• patch.sql

• readme.txt

6. Unmount Disk1 using the following command:

umount /CDROM

7. Insert Disk2 in the CD ROM drive.

8. Mount Disk2 using the following command:

mount –F cdfs –o rr /dev/dsk/ /CDROM

NOTE: If you do not know which block device file is associated with your CD drive, execute “ioscan –fnd sdisk” command to find the device. Insert the proper name wherever you see in this procedure.

9. Copy the oracle.zipab file from Disk2 to the dialer location where Disk1 files are copied.

NOTE:

i. oracle.zipab file must be copied to the dialer location where Disk1 files are copied.

ii. If you are downloading files using ftp, make sure that you have read/write access to that directory. Before downloading the file you need to set binary mode by running following command ftp> bin

iii. If directory by name “Disk1” already exists, rename it to “Disk1.old”.

mv /Disk1 /Disk1.old

Here the denotes a path where the installation files are copied.

a. Ensure the permissions of the copied files are as follows:

-rw-rw-r-- 1 root sys oracle.zipaa

-rw-rw-r-- 1 root sys oracle.zipab

-r-xr-xr-x 1 root sys patch.sql

-r-xr-xr-x 1 root sys postinst

-r-xr-xr-x 1 root sys oraupdt

If permissions are not as above then execute the following commands:

chmod 664 oracle.zipaa

chown root:sys oracle.zipaa

chmod 664 oracle.zipab

chown root:sys oracle.zipab

chmod 555 patch.sql

chown root:sys patch.sql

chmod 555 postinst

chown root:sys postinst

chmod 555 oraupdt

chown root:sys oraupdt

b. Run the following command to verify the oracle.zipaa file digest. It will take approximately 15 seconds to complete:

$ cksum oracle.zipaa

cksum size filename

2420577091 576716800 oracle.zipaa

c. Run the following command to verify the oracle.zipab file digest. It will take approximately 15 seconds to complete:

$ cksum oracle.zipab

cksum size filename

1212759742 536778103 oracle.zipab

d. Run the following command to verify the postinst file digest:

$ cksum postinst

cksum size filename

4230422730 2069 postinst

e. Run the following command to verify oraupdt file digest:

$ cksum oraupdt

cksum size filename

1576784792 6071 oraupdt

f. Run the following command to verify the patch.sql file digest:

$ cksum patch.sql

cksum size filename

3736142845 240 patch.sql

10. Go to , the location from where you copied the files from Disk1 and Disk2. Run the following command to install Avaya Proactive Contact Database 3.0.3.

./oraupdt

a. In the “Are you sure you want to run this script? [Y/N]” prompt, type “Y” and press Enter.

b. In the “Have you stopped all the Dialer, Midtier and Oracle processes? [Y/N]” prompt, type “Y” if Dialer, Midtier and Oracle processes are stopped. If any of these processes are still running, type “N” and stop the processes before proceeding.

c. In the “Please specify the path where the oracle.zipaa and oracle.zipab files are copied:” prompt, specify the path where the oracle.zipaa and oracle.zipab files were copied. It will create oracle.zip file at the specified location.

d. In the “Please specify the path where you want to unzip oracle.zip, minimum free space required is 1587200 Kilobytes (1.5GB)” prompt, specify the path where you would like to unzip the files. For example, /DVD_OPS path.

NOTE: The oracle user must have execute permissions on the folder where the files are unzipped.

Please wait for the installation to complete. This script takes approximately 25 minutes to complete.

e. After the installation is successful you will see the following message: “The installation of Oracle Database 10g Patchset 3 was successful”.

NOTE: When the above message is displayed, you must press the Enter key to exit. For more details refer to the logs created by the oracle installer at /opt/dbase/oraInventory/logs directory.

4 Post-Installation Procedure

After successful installation of the Avaya Proactive Contact Database 3.0.3 run the post installation script:

1. Login to the dialer as root.

2. Go to path where “postinst” script is copied and run the following command:

./postinst

3. At the "Has the oraupdt script executed successfully?[Y/N]:", type “Y” and press Enter if the oraupdt script executes successfully.

4. At the “Enter the full pathname of the local bin directory: [/usr/local/bin]:”, press Enter to select the default location.

5. In the “The file "dbhome" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:” prompt type “Y” and press Enter.

6. In the “The file "oraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:” prompt type “Y” and press Enter.

7. In the “The file "coraenv" already exists in /usr/local/bin. Overwrite it? (y/n) [n]:” prompt type “Y” and press Enter.

The following prompt will appear after approximately 4-5 minutes.

8. In the “Please specify the path where the patch.sql file is copied:” prompt, specify the correct location of the file.

NOTE: This script takes approximately 70 minutes to complete. The patch.sql script creates a log file at /opt/avaya/pds directory. The name of the log file is patch.log

At the end of the installation, the script will list the SERVER components in the database, along with their current patch set version and status. A sample of the list is provided below:

COMP_NAME STATUS VERSION

----------------------------------- ----------- ----------------------------------------------

Oracle Database Catalog Views VALID 10.1.0.5.0

Oracle Database Packages and Types VALID 10.1.0.5.0

JServer JAVA Virtual Machine VALID 10.1.0.5.0

Oracle XDK VALID 10.1.0.5.0

Oracle Database Java Packages VALID 10.1.0.5.0

Oracle XML Database VALID 10.1.0.5.0

Oracle Data Mining INVALID 10.1.0.5.0

Oracle interMedia INVALID 10.1.0.5.0

Oracle Text VALID 10.1.0.5.0

Oracle Ultra Search VALID 10.1.0.5.0

Oracle Expression Filter INVALID 10.1.0.5.0

Oracle Workspace Manager VALID 10.1.0.2.0

NOTE: The Oracle Data Mining, Oracle interMedia, and Oracle Expression Filter are not used in Avaya Proactive Contact Database, so their status is INVALID in the above sample list. Oracle Workspace Manager Version is not updated in 10.1.0.5.0 patch set.

9. Restart the dialer.

10. Once the dialer is up login as root.

11. Go to $ORACLE_HOME/network/admin. Verify the correct hostname is present in listener.ora. For example:

(ADDRESS =

(PROTOCOL = tcp)

(HOST = )

(PORT = 1521)

(QUEUESIZE = 20)

)

12. Login to the dialer as admin.

13. Run the following command to start the database:

start_db

Verify that the Oracle database version is 10.1.0.5.0.

14. Run the following command to verify that the database is running:

check_db

NOTE: After the installation is complete, delete the oracle.zip, oracle.zipaa and oracle.zipab files from .

5 Uninstallation Procedure

Not Supported.

Oracle Database Patch Set 10.1.0.5 can be uninstalled only if the Oracle base version is 10.1.0.3 or greater. Since the base version in our system is 10.1.0.2, uninstallation of 10.1.0.5 Patch Set is not supported. For more information, refer the Oracle Database Patch Set Notes located at /README.html.

NOTE: To view README.html, download it using ftp on to a windows system.

Enhancements

None

Fixes

None

Troubleshooting

1. Troubleshooting the installation

You can analyze the log files to resolve any installation related issues.

oraupdt and postinst script creates a log at the following location: /var/adm/sw/ PC30SP3-OracleUpdate-Install.log

Known Issues

Ora-29558 Error Message

The “ORA-29558:JAccelerator (NCOMP) not installed” error is displayed when you apply the patchset to a database where the Natively Compiled Java Libraries (NCOMP) files are not present.

Contact Support

Customers can contact Avaya Proactive Contact Technical Support through Internet, email, or telephone. For details visit:



[pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download