Home
>
Lucent Technologies
>
Communications System
>
Lucent Technologies Intuity CONVERSANT System Version 7.0 Guide
Lucent Technologies Intuity CONVERSANT System Version 7.0 Guide
Have a look at the manual Lucent Technologies Intuity CONVERSANT System Version 7.0 Guide online for free. It’s possible to download the document as PDF or print. UserManuals.tech offer 413 Lucent Technologies manuals and user’s guides for free. Share the user manual or guide on Facebook, Twitter or Google+.
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 describes each field in the Database Access ID Table window.
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. Field Description for Database Access ID Table Window Field Name DescriptionDatabase Access ID List of database access IDs, each representing an established ORACLE database connection to the system. See Database Access IDs on page 378 for more information. Remote Machine * * If these fields are blank, the connection is to a local ORACLE database. If these fields are populated, connection is to an ORACLE database on the sys- tem machine or to an ORACLE database on the machine specified in the Re- mote Machine field. Remote machine name. DB SID * Database instance, ORACLE_SID or database name (dbname) on ORACLE systems. There could be multiple instances on a remote machine.
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 following procedure to add a local database access ID:1 Start at Database Access ID Table window (Figure 165 on page 377 ). 2 Press F8 (Chg–Keys). The system displays the alternate function keys. 3 Press F1 (Add). The system displays the Add A Database Access ID menu (Figure 166 on page 379 ). Figure 166. Add A Database Access ID Menu
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. DB1_local is the standard connection to a local ORACLE database. The CHOICES menu lists only those local database access IDs that have not yet been added. 6 Press F3 (Save) to save the database access ID and exits the window. The Add a Database Access ID menu remains active, allowing you to add other database access IDs, if desired. 7 If you are finished adding database access IDs, press F6 (Cancel) twice to return to the Configuration Management menu. > Add a Local Database Access ID
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 your system to use SQL*NET V2 for remote database access. See “Installing the Oracle SQL*NET TCP/IP Package,” in Chapter 7, “Installing the Optional Feature Software,” in the maintenance book for your platform for information on installing the SQL*NET V2 software. Before you establish an SQL*NET V2 connection, verify that the following are true:• The SQL*Net V2 listener for TCP/IP is running on the remote database server. • The $ORACLE_HOME/network/admin/tnsnames.ora configuration file on the Intuity CONVERSANT system has been updated to provide system information for the server. The Intuity CONVERSANT software automatically attempts to update the existing tnsnames.ora file (or create a new file if none exists), but manual alterations are sometimes necessary. For assistance with this requirement, see the database administrator for the server.
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 377 ). 2 Press F8 (Chg–Keys). The system displays the alternate function keys. 3 Press F1 (Add). The system displays the Add a Database Access ID menu (Figure 168 on page 382 ). Figure 168. Add a Database Access ID Menu
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 database instance on the remote database server to which you want to connect. This connect descriptor is put into the /oracle/network/admin/tnsnames.ora file if it is not already in that file.— Remote Server’s DB Instance This field specifies the name of the ORACLE database instance on the remote database server. This field is also known as the ORACLE SID. This name must match the corresponding ORACLE SID on the server system. Contact the server’s database administrator for this name. 1 of 2
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 number must match the one on the remote database server. Contact the server’s database administrator for this port number. Will this CONVERSANT be a DB server? This field indicates whether this is a database server. Note:It is strongly recommended that the local system not be used as a database server due to performance considerations. Yes or No If No, the system can only be a client to a remote database server. If Yes, the system can be both a client and a database server. Also, if Yes, the system sets up a listener process and a connect descriptor entry is created in the tnsnames.ora file for this system. Table 37. Field Descriptions for Add V2 Remote Database Access ID Field Name Description Valid Values 2 of 2
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 Administration , for more information. Completing ORACLE Environment Setup if Server is Not an Intuity CONVERSANT Server If the database server is a UNIX based system running ORACLE V7 but not an Intuity CONVERSANT system, you must perform the following procedures to complete the ORACLE environment setup: Note:This procedure assumes the following: ~ The network is a TCP/IP local area network and consists of a single server and any number of clients (Intuity CONVERSANT systems). ~ The server runs a single listener process to permit access to the server’s database. ~ The ora7sql package is installed on all the clients