Step 3. Verify the ECDA installation

StepsTo verify that you can connect to Oracle

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

  2. Change to the $SYBASE/DCO-12_6 directory.

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

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

    isql –Uvaliduser –Ppassword –SDCOServer
    

    where:

  5. To verify the connection to the standby Oracle database, enter the following:

    select banner from v$version 
    go
    

    The string returned from DCO should look similar to the following:

    BANNER ----------------------------------------------- Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE   9.2.0.1.0       Production TNS for Solaris: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production
    
  6. Exit isql.