Meeting the Adapter Run-Time Requirements

In this section: Providing Access for End Users Supplying the Oracle User ID and Password Testing the Adapter Connection

The adapter now resides on your system. Before you invoke the adapter from CMS, you must satisfy the following run time requirements:

• Allow adapter users access to Oracle tables and views. You or your Oracle database administrator must authorize users by issuing the native SQL GRANT command described in Before You Begin.
• Provide adapter users read access to the FOCUS production disk and the Oracle USER disk.
• Invoke FOCUS to test the adapter connection.

Providing Access for End Users

How to: Access FOCUS Production and Oracle USER Disks Example: Sample Initialization EXEC

In order for users to invoke the adapter, they must be linked to the FOCUS production disk and the Oracle USER disk. There are several ways to satisfy these requirements and they are explained in the following subsections. A sample initialization EXEC is also provided.

Procedure: How to Access FOCUS Production and Oracle USER Disks

Choose one of the following methods to link adapter users to both the FOCUS production and Oracle USER disks:

• Include the CMS LINK and ACCESS commands in each user's PROFILE EXEC.
• Include the CMS LINK and ACCESS commands in the FOCUS EXEC procedure residing on the FOCUS production disk.
• Let each user execute the CMS LINK and ACCESS commands at the CMS command prompt before invoking FOCUS.
• Let each user execute a CMS EXEC that includes the CMS LINK and ACCESS commands before invoking FOCUS.

The link to the Oracle USER disk should allow read only privileges; the disk can be accessed as any available filemode. For an example illustrating the CMS LINK and ACCESS commands, see Sample Initialization EXEC. The link to the FOCUS production disk is also discussed in the CMS Installation Guide.

Example: Sample Initialization EXEC

The following is an EXEC that includes the LINK and ACCESS commands so that they are issued automatically. Make any appropriate changes for your site's standards.

CP LINK F6579203 191 491 RR
ACCESS 491 F
CP LINK V8ORALNK195 495 RR
ACCESS 495 P
EXEC FOCUS

Notes:

• The first set of LINK and ACCESS commands provide read-only access to the FOCUS production disk.
• The second set of LINK and ACCESS commands provide read-only access to the Oracle USER disk, which is usually labeled V8ORALNK.
• The EXEC FOCUS command executes FOCUS.

Supplying the Oracle User ID and Password

The SET CONNECTION_ATTRIBUTES command allows users to declare a connection to one Oracle database server and to supply authentication attributes necessary to connect to the server.

This command can be stored in any FOCUS-supported profile. It can also be issued in a FOCEXEC or at the FOCUS command prompt. For example:

SQL SQLORA SET CONNECTION_ATTRIBUTES TNSNAMEA/USERA,PWDA

Note: SET USER is a synonym for SET CONNECTION_ATTRIBUTES, supported for compatibility with earlier releases of the adapter. However, note that the symbol used for separating the connection attribute from the authentication information and the symbol used for separating the user ID from the password changed in FOCUS 7.2.

See the Relational Data Adapter User's Manual for more information about supplying Oracle connection attributes.

Testing the Adapter Connection

After linking to the production disks, test the adapter connection to Oracle with the adapter SQLORA ? query command. Invoke FOCUS and issue the following command from the FOCUS command prompt:

SQL SQLORA ?

If there is a connection, a list of adapter defaults and current settings displays.

If there is a problem, the following adapter message is displayed:

(FOC1488) SQL INTERFACE IS NOT INSTALLED:

If you get an error message, please check your installation with this guide or call Information Builders for assistance.