Configuring and starting the DirectConnect server

Before you begin to create and configure the DirectConnect server, make sure that:

• You have made a copy of the existing tnsnames.ora file, currently being used to connect to Oracle, and have placed it in a temporary file location.

• The Oracle connect string is available.

• The name for a valid Oracle account, which is used as the administrator for the DirectConnect server, is available.

• The number of the unused port to be used by the DirectConnect server is available.

1. Start the Create Server wizard navigate to the $SYBASE/DCO-15_0/DCWizard directory and execute DCWizard.sh script

   The Welcome Create Server Wizard window appears. Click Next.

2. Select ECDA Option for Oracle. Click Next.

3. Enter the server name for the new DirectConnect server and the port number that you want the server to listen on. Click Next.

4. Enter a valid Admin Account name. Click Next.

5. Enter the Oracle connection string as previously defined in the tnsnames.ora file, and the path (including the file name) to the previously defined temporary location of the tnsnames.ora file. Click Next.

6. Verify the DirectConnect server information. If correct, select Create Server otherwise, click Back to return to the previous window and provide the correct information.

7. Verify if the DirectConnect configuration is successful. If yes, click Next otherwise, click Back to return to the previous window, provide the correct information, and recreate the server.

8. In the Start DirectConnect Server window, click Start ecda_servername to start the newly configured DirectConnect server, where ecda_servername is the server name you indicated for the new DirectConnect server.

9. Verify that the DirectConnect server startup is successful and click Finish.

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 the isql utility to log in to Oracle through the DirectConnect server:

   isql –Uvaliduser –Ppassword –SDCOServer
   

   Here, validuser and password are any valid user and password, and DCOServer is the DirectConnect for Oracle server name.

5. Verify the connection to the replicate 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 the isql session with the quit command.