Lucent Technologies Intuity CONVERSANT System Version 7.0 Guide

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 377
Figure 165. Database Access ID Table Window  
Database Access ID Table Window
The Database Access ID Table window displays currently recognized 
database IDs. Use the Database Access ID Table window to perform the 
following tasks:•
Add a local or remote database access ID
•
Remove a local or remote database access ID
Table 36 on page 378...

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 378
Database Access 
IDs
Each ID listed in the Database Access ID Table window represents an 
established local or remote connection to an ORACLE database. This 
connection is used by the voice system’s applications to access a customer’s 
database tables. The database ID, then, represents each local or remote 
database to the voice system.Table 36....

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 379
An application can access multiple database tables in a local database (that 
is, residing on the voice system’s hard disk). However, you can improve the 
access performance by adding multiple database access IDs to that local 
database to split the access evenly between the multiple database access 
IDs.
Add a Local Database Access ID
Use the...

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 380
4  
Select:
The system displays the Add a Local Database Access ID window 
(Figure 167 on page 380
).
Figure 167. Add a Local Database Access ID Window  5  
Enter the local database access ID in the 
Database Access ID:
 field, or 
press 
F2
 (Choices) to select from a menu. Valid values are DB2_local, 
DB3_local, DB4_local, and DB5_local....

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 381
8  
Stop and start the voice system. See Stop the Voice System
 on page 136
 
and Start the Voice System
 on page 139
 in Chapter 3, 
Vo i ce  Sy s t e m  
Administration
 , for more information.
The system establishes the local database connection(s).
Add a Remote Database Access ID Using SQL*NET V2
You must have the SQL*NET TCP/IP installed on...

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 382
See “Configuring the TNS Listener: LISTENER.ORA” and “Identifying the 
Servers: TNSNAMES.ORA” in the
 ORACLE Server Administrator’s Guide 
Release 7.3
, for more information on these configuration files.
Use the following procedure to add a remote database access ID using 
SQL*NET V2:
1  
Start at Database Access ID Table window (Figure 165 on page...

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 383
4  
Select:
The system displays the Add V2 Remote Database ID window (Figure 169 on page 383
). 
Figure 169. Add V2 Remote Database Access ID Window  5  
Complete the fields in this window using the information in Table 37 on page 384
.
> Add a SQL*Net V2 Remote Database Access ID 

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 384
Table 37. Field Descriptions for Add V2 Remote Database Access ID
Field Name Description Valid ValuesDatabase 
Access ID
This field specifies the name by which 
you want to refer to this connection. 
This name can be used in Script 
Builder when referring to tables in that 
database.—
Remote DB’s 
Connect 
Descriptor
This field specifies the...

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 385
Remote 
Server’s 
Network 
Name
This field specifies the network name 
or TCP/IP address of the remote 
database server. If the network name 
is entered, it must already exist in the 
local /etc/hosts file.Contact the network administrator for 
this name or TCP/IP address.
TCP/IP Port 
Number
This field contains the TCP/IP port 
number. This port...

6  
Database Administration  Voice System Database Administration
Intuity™ CONVERSANT® System Version 7.0 Administration 
585-313-501 Issue 3 January 2000 386
6  
Press 
F3
 (Save).
The system saves the information and redisplays the Database Access ID 
Window. 
7  
Press 
F6
 (Cancel) twice.
The system closes the Database Access ID Table.
8  
Stop and start the voice system. See Stop the Voice System
 on page 136
 
and Start the Voice System
 on page 139
 in Chapter 3, 
Vo i ce  Sy s t e m...