Progress
DataServer
for ORACLE Guide


Starting the Local DataServer

Starting the Progress client starts the local DataServer. You include information about the ORACLE database, user ID, and password in the startup command.

  1. Set ORACLE_HOME and ORACLE_SID and start an instance for the supporting ORACLE database.
  2. Set the environment variables in the shell from which you are starting the DataServer. Table 4–1 describes how to set them.
  3. Table 4–1: Environment Variables for the Local DataServer 
    Variable
    How to Set It
    DSLOGDIR
    The pathname to the log file that Progress will use to keep track of DataServer processes and error messages.
    ORACLE_HOME
    The pathname of the directory where you installed ORACLE.
    ORACLE_SID
    The identifier for the ORACLE instance you are accessing.
    LD_LIBRARY_PATH
    (Sun Solaris)
    or
    LIBPATH (AIX)
    or
    SHLIB_PATH (HP-UX)
    The identifier of the shared ORACLE libraries. On your UNIX system, if the SETUID bit is on, make sure there is a soft link from /usr/lib pointing to the ORACLE shared libraries.
    Note that ORACLE does not support shared objects on all UNIX platforms. See your ORACLE documentation for more information.
    You must set this environment variable to include $ORACLE_HOME/lib when you run executables that you built with PROBUILD to access ORACLE7 or ORACLE8.

    NOTE: If you change the values of any environment variables, such as ORACLE_SID or ORACLE_HOME, you must shut down the DataServer processes and restart them.

  4. Enter one of the following commands:
Local DataServer — UNIX

pro schema-holder-name -db fill-char -dt ORACLE
  -ld oracle-logical-db-name -U userid -P password 

Local DataServer — NT or Windows

prowin32 schema-holder-name -db fill-char -dt ORACLE
  -ld oracle-logical-db-name -U userid -P password 

For example, the following command starts Progress with the DataServer on a UNIX machine, connects a local schema holder oholder in single-user mode, and connects an ORACLE database orademo with a user scott and the password tiger:

pro oholder -db oradb -dt ORACLE -ld orademo -U scott -P tiger 

For SQL*Net or Net 8 startup information, see the "Connecting Through SQL*Net or Net 8" section.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095