Install ECDA Option for Oracle

NoteIf the ECDA Option for Oracle (also referred to as DCO) was already installed and a directory was created:

StepsTo install ECDA Option for Oracle in GUI mode

NoteIf you want to install using the console mode or a response file, refer to the Enterprise Connect Data Access Installation Guide for Linux and UNIX.

  1. Use one of the following methods to download the software:

  2. Launch the installation program by executing the Sun Solaris setup routine:

    ./setup
    
  3. If you see an error message saying that there is not enough temporary disk space, add this to your setup command:

    ./setup –is:tempdir someDirectory
    

    where someDirectory is a directory with at least 100MB of disk space that the installation program can use.

  4. On the Welcome window, click Next.

  5. Select a geographic location that displays the license agreement. Select I Agree and click Next.

  6. Enter the directory where you want to install ECDA:

  7. Select the Full setup and click Next.

  8. Verify the modules to install. At a minimum, ECDA Option for Oracle, Connectivity, and Language Modules should be listed. Click Next.

    You may receive a message:

    There are newer files already installed and do you want to replace them?
    

    Click No to All.

  9. When you receive a message that the installation was successful, click Next.

  10. The SySAM License Server window opens and displays this prompt:

    Will licenses be obtained from the License Server?
    
  11. The SySAM Notification window prompts you to configure your server for e-mail notification. When configuration is enabled, you receive information about license management events that require attention. Select Yes and either accept the default values that are supplied, or enter these values from your worksheet (from the installation guide):

    If you choose not to have e-mail alerts or severity messages logged, select No.

    Click Next.

  12. When you receive a message indicating that ECDA was successfully installed, click Finish.

For more information, see the Enterprise Connect Data Access Installation Guide.

StepsTo verify that you can connect to Oracle

  1. Open a command window in the $SYBASE directory of your ECDA installation.

  2. Change to the $SYBASE/DCO-15_0 directory.

  3. Set the environment variables by sourcing the $SYBASE/DCO_SYBASE.csh file.

  4. Use isql to log in to Oracle through the DirectConnect server:

    isql –Uvaliduser –Ppassword –SDCOServer
    

    where:

  5. Verify the connection to the standby Oracle database:

    select banner from v$version 
    go
    
    BANNER ----------------------------------------------- Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Prod PL/SQL Release 10.2.0.1.0 - Production CORE 10.2.0.1.0 Production TNS for Solaris Version 10.2.0.1.0 - Production NLSRTL Version 10.2.0.1.0 - Production
    
    
    (5 rows affected)
    
  6. Exit isql.