Providing and verifying connectivity to the APS database

To create tables and write data to your new CEaps database, the install.sh script needs to establish a native connection to the database server. That is, when you log on to UNIX with the user name crystal to perform the installation, the default shell environment must include the appropriate database environment variables and/or initialization files. Only then can the installation script access the CEaps database using your database client software.

The environment variables and/or files required by the install.sh script depend upon the type of database server you are running:

• If you choose to connect to Oracle through a native connection, the installation searches the current shell for the ORACLE_HOME environment variable. This standard Oracle environment variable must be set in order for the install.sh script to utilize the Oracle client software.
• If you choose to connect to DB2 through a native connection, the installation searches the current shell for the DB2DIR environment variable. This standard DB2 environment variable must be set in order for the install.sh script to utilize the DB2 client software.

Additional database environment variables must be set in order for the installation script to use the database client software properly. Before running the installation script, test the shell environment of the new crystal user to verify database connectivity and privileges. See the procedure that corresponds to your database.

Note:    Consult your database documentation and/or your database administrator if the crystal user's shell environment has not yet been set up for your database client software, or if you are unable to connect successfully to the database.

To verify Oracle native connectivity through the System ID

1. Log on to the UNIX server under the new crystal user account.
2. Echo the following environment variables and ensure that their values correspond to your database client software installation.

   Variable	Value
   ORACLE_SID	This variable contains your Oracle System ID.
   ORACLE_HOME	This variable contains the path to the root directory of your Oracle client installation (one level above the Oracle bin and lib directories).
   library path	The library search path (LD_LIBRARY_PATH on Solaris, LIBPATH on AIX, and so on) must include the lib directory of your Oracle client installation.
   PATH	The search path must include the bin directory of your Oracle client installation.

   This example checks the required variables and shows sample output values.

   $ echo $ORACLE_SID
   

   ORCL
   

   $ echo $ORACLE_HOME
   

   /opt/oracle/817
   

   $ echo $LD_LIBRARY_PATH
   

   /opt/oracle/817/lib
   

   $ echo $PATH
   

   /usr/bin:/usr/ucb:/etc:.:/opt/oracle/817/bin
   

3. Issue the following command to run the Oracle SQL tool:

   sqlplus

   If the shell environment has been configured correctly, you are prompted for an Oracle user name.

4. Type crystal and, when prompted, provide the user's password.

   Tip:    If you cannot connect in this manner, you may need to connect to Oracle through a service name. See To verify Oracle native connectivity through a service name.

5. Issue the following command to ensure that the crystal user account has permission to create tables:

   create table sampletable (field1 char(10));

6. Issue the following command to ensure that the crystal user account has permission to delete tables:

   drop table sampletable;

7. Type exit

To verify Oracle native connectivity through a service name

1. Log on to the UNIX server under the new crystal user account.
2. Echo the following environment variables and ensure that their values correspond to your database client software installation.

   Variable	Value
   ORACLE_HOME	This variable contains the path to the root directory of your Oracle client installation (one level above the Oracle bin and lib directories).
   library path	The library search path (LD_LIBRARY_PATH on Solaris, LIBPATH on AIX, and so on) must include the lib directory of your Oracle client installation.
   PATH	The search path must include the bin directory of your Oracle client installation.

   This example checks the required variables and shows sample output values.

   $ echo $ORACLE_HOME
   

   /opt/oracle/817
   

   $ echo $LD_LIBRARY_PATH
   

   /opt/oracle/817/lib
   

   $ echo $PATH
   

   /usr/bin:/usr/ucb:/etc:.:/opt/oracle/817/bin
   

3. Issue the following command to run the Oracle SQL tool and connect to the appropriate service name:

   sqlplus crystal/password@servicename

   Replace password and servicename with the appropriate values. If the shell environment has been configured correctly, you are connected to Oracle.

4. Issue the following command to ensure that the crystal user account has permission to create tables:

   create table sampletable (field1 char(10));

5. Issue the following command to ensure that the crystal user account has permission to delete tables:

   drop table sampletable;

6. Type exit

To verify DB2 native connectivity through a database alias

1. Log on to the UNIX server under the new crystal user account.
2. Echo the following environment variables and ensure that their values correspond to your database client software installation.

   Variable	Value
   DB2INSTANCE	This variable defines the current DB2 database instance.
   DB2DIR	This variable contains the path to the root directory of your DB2 installation (one level above the DB2 bin and lib directories).
   library path	The library search path (LD_LIBRARY_PATH on Solaris, LIBPATH on AIX, and so on) must include the lib directory of your DB2 client installation.
   PATH	The search path must include the bin directory of your DB2 client installation.

   This example checks the required variables and shows sample output values.

   $ echo $DB2INSTANCE
   

   db2inst1
   

   $ echo $DB2DIR
   

   /opt/IBMdb2/V7.1
   

   $ echo $LD_LIBRARY_PATH
   

   /export/home/db2inst1/sqllib/lib
   

   $ echo $PATH
   

   /usr/bin:/usr/ucb:/etc:.:/export/home/db2inst1/sqllib/adm:/export/home/db2inst1/sqllib/misc
   

3. Issue the following command to run the DB2 SQL tool:

   db2

4. Issue the following command to connect to the desired database alias:

   connect to db_alias user crystal using password

   Replace db_alias and password with the appropriate values. If the shell environment has been configured correctly, you are connected to DB2.

5. Issue the following command to ensure that the crystal user account has permission to create tables:

   create table sampletable (col_fld char(10) not null)

6. Issue the following command to ensure that the crystal user account has permission to delete tables:

   drop table sampletable

7. Type terminate