Oracle Audio Technologies 8.1 manual Upgrading an Older Oracle 9i Database for CCA

Page 15

Configuring the Database ■ Configuring an Oracle 9i Database for CCA


--	&4 - PathTableSpace	Path for the		TAW Table Space
--	&5 - TableSpaceSize	500M Initial		size of the Table Space
--	&6 - TWTableSpaceTemp	TAW Temporary Table Space
--	&7 - PathTableSpaceTemp	Path for the		TAW Temporary Table Space
--	&8 - TableSpaceTempSize	50M	Initial size of the Temporary Table Space
--	&9 - TableSpaceTempGrowthSize	10M	Temporary Table Space Growtrh Size
-- &10 - TWRole		TWRole

--&11 - ADMINCC81 (Admin Username) ADMINCC81

--&12 - ADMINCC81 (Admin Password) ADMINCC81


-- &13 - CC81				(User		Username)	CC81
-- &14 - CC81				(User		Password)	CC81
-- &15 - Database Service Name							Use by the JDBC		Connection
--	&16	-	Database		Hostname		db	Hostname -->	Use by the	JDBC Connection
--	&17	-	Database		Port Number		db	port number --> Use by the JDBC Connection

@CreateDatabase.sql 'syspassword' 'oracle' 'TWTableSpacecc81' 'c:\oracle\oradata\oracle\twcc81.ora' '500M' 'TWTableSpacecc81Tmp' 'c:\oracle\oradata\oracle\twcc81tmp.ora' '50M' '10M' 'TWRolecc81' 'ADMINCC81' 'admincc81' 'cc81' 'cc81' 'oracle' 'support-db' 1521

3Open the command line window. Navigate to directory that contains the UseMe.sql file by cd command.

4Open the Sql Plus console by typing: sqlplus /nolog

5From the Sql Plus command prompt, type: @UseMe.sql to run the script file.

6After the script file completes running, check all log files created to verify that no error is reported during database creation process.

Upgrading an Older Oracle 9i Database for CCA

Complete these steps to upgrade an older Oracle 9i database for CCA:

To upgrade an Oracle 9i database for CCA

1Copy the Patch folder for Oracle 9i Database Server from the installation package to the host used to run database scripts. For example, we put it in C:\CCA\database\Oracle\Patch.

2Edit the UseMe_upgrade.sql file in Patch folder to reflect the correct information that is necessary to upgrade the database by using the following guidelines:

NOTE: Retain the quotation marks (‘’) surrounding the parameters’ values.

■Replace &1 with the username of the administrator who owns all the objects (tables, views, indexes, and so on) in the database to be upgraded.

■Replace &2 with the password of the administrator used in previous parameter.

Contact Center Anywhere Installation Guide Version 8.1

13

Image 15

Contents Contact Center Anywhere Installation Guide Copyright 2005, 2007, Oracle. All rights reserved Contents Index Topic Description What’s New in This ReleasePage CCA Architecture Overview CCA Overview RequirementsCA Architecture Overview Tier ZeroTier Two Tier OneTier Three Software RequirementsRequirement CCA Installation Overview Creating a New Oracle 9i Database Configuring the DatabaseDatabase Configuration Options Configuring an Oracle 9i Database forTo create a new Oracle 9i database Upgrading an Older Oracle 9i Database for CCA To upgrade an Oracle 9i database for CCAConfiguring a MS SQL Server 2000 Database Creating a New Database on MS SQL ServerTo create a MS SQL database Contact Center Anywhere Installation Guide Version Upgrading Database on MS SQL Server To upgrade an older MS SQL Server databaseContact Center Anywhere Installation Guide Version Contact Center Anywhere Installation Guide Version Creating Database Connection to the Application Server Installing CCA Server ComponentsCreating an Odbc Data Source for Oracle 9i Database To create an Odbc data source for Oracle 9i Database ServerField Description Comments To create an Odbc data source for SQL Server Creating an Odbc Data Source for Ms SQL Server DBTo install CCA application server files Installing CCA Application FilesTo install the TCPIPBus on Ms Windows Installing the TCPIPBusTo install the TCPIPBus on Solaris/Linux Configuring CCA Resources Using the Network Manager to Manage CCA ResourcesTo use Network Manager To add a host manager Adding Shared and Dedicated Server ResourcesInstalling CCA Server Components Configuring CCA Resources To add a resource in Network Manager Configuring Resources Using Network ManagerConfiguring the Call Center Resource To configure the Call Center resourceField Comments Sample Figure To configure Redirect Server Configuring the Redirect Server ResourceTo configure an MP3 server Configuring the MP3 Server ResourceConfiguring the MCU Server Resource Configuring the CTI Server ResourceTo configure an MCU server To start and stop resources To configure the CTI serverStarting and stopping TCPIPBus Starting and Stopping CCA ResourcesConfiguring the Web Server Creating Jdbc Connection Pool on OAS 10g To create a Jdbc Connection poolField Name Value Creating Jdbc Data Source on OAS 10g Deploying CCA Web Applications on OAS 10gTo create a Jdbc Data Source Deploying the TAW Application To deploy TAWContext Parameter Name Parameter Value Updating the System Configuration Key Deploying the CCA ApplicationDeploying Integration application Deploying CCA Web Applications on WebLogic 8.1 SP5 To update the system configuration keyTo create a new WebLogic server domain Creating a New Server DomainInstalling WebLogic as a Windows Service To install WebLogic as a serviceDeploying CCA web applications on WebLogic To configure the Jdbc connection pool Configuring the Jdbc Connection PoolTo configure the Jdbc data source Configuring the Jdbc Data SourceTo deploy CCA To deploy the Integration Application Deploying the Integration ApplicationGetting Started With CCA Logging in Administration Manager AMTo login to AM To login the Integrated ClientMaking interactions Enabling the Partition FeatureTo enable the Partition feature Making interactionsGetting Started With CCA Making interactions Page Index SymbolsIndex M