Prerequisites for Using CES Database Manager

The prerequisites before using the CES Database Manager are provided in this topic.

This task explains how to work with the CES Database Manager:
  1. Install JRE 1.5 on your system. You can download it from one of these locations:

  • Solaris and Windows: http://java.sun.com/products/archive/

  • HP: http://www.hp.com/products1/unix/java/

  • AIX: http://www6.software.ibm.com/dl/dka/dkw-p

  1. Specify the JRE 1.5 path in the PATH environment variable.

    For example,

  • On UNIX: setenv PATH /jre1.5/bin:$PATH

  • On Windows: SET PATH=D\jre1.5\bin:%PATH%

  1. Make sure that the EDS_HOME environment variable is pointing to the directory where CES Database Server is installed.

    For example,

  • On UNIX: setenv EDS_HOME /ds/R17/<aix_a>/resources/sdm/exploreDB/oracle

  • On Windows: SET EDS_HOME=D:\ds\R17/<intel_a>\resources\sdm\exploreDB\oracle

  1. If you are running the CES Database Manager on UNIX, make sure that you have included the awk utility in your path.

  2. Make sure that the com/jars, config directories under $EDS_HOME/edm and the log directory under EDS_HOME have write permissions to all.

  3. On Windows, if you want to use the Create an empty Database, Install Text Search Option and administration functions like Startup Database and Shutdown Database options, you must:

  • Belong to the ORA_DBA group.

  • The sqlnet.ora file in <ORACLE_HOME>\network\admin should have the following entry. If this parameter is commented out with a #, remove the #.

    • SQLNET.AUTHENTICATION_SERVICES = (NTS)

If you are logged as a domain user, and do not have a network connection, you will not be able to connect to the database because the authentication will try to reach the domain users database on the domain controller.

 

  • To use the preceding EDM options when no network is present you can log on as a Windows local user, belonging to ORA_DBA group.

  • To use other options in EDM, when no network is present and when connected as a domain user, you can temporarily disable NTS in sqlnet.ora by setting the following parameter:

SQLNET.AUTHENTICATION_SERVICES=(NONE)