Oracle Audio Technologies 8.1 ユーザーズマニュアル

Contact Center Anywhere Installation Guide Version 8.1

■

 Configuring a MS SQL Server 2000 Database

■

Replace &3 with the name of the database user that the current CCA system uses to access 
the database. 

■

Replace &4 with the password of the user used in parameter &3.

■

Replace &5 with the database TNS name of the database server. 

■

Replace &6 with the host name of the database server.

■

Replace &7 with the database service name (SID). 

■

Replace &8 with the listening port of the database server. By default, Oracle 9i database 
server listens on port 1521.

After the script file is edited, it will return to the following:

@upgrade.sql 'admincc81' 'admincc81' 'cc81' 'cc81' 'oracle' 'support-db' 'cc81' 1521

Open a command line window. Use the cd command to navigate to the Patch folder.

At the command line, type sqlplus /nolog to open Sql Plus console.

At the Sql Plus console, type: @UseMe_upgrade.sql

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

Complete these steps to create a new Ms SQL Server database for use with CCA:

Copy the Automated directory for SQL Server from the installation package to the host used to 
run database scripts. For example, we put it in C:\CCA\database\Sql Server\Automated.

-- &1 - Admin User Username

-- &2 - Admin User Password 

-- &3 - CCA db User Username 

-- &4 - CCA db User Password

-- &5 - database TNS Name

-- &6 - database hostname

-- &7 - Database Service Name

-- &8 - Database Port Number