Sybase Replication

Perform the following tasks to check if the Sybase Replication component is successfully installed.

Replication Server

To verify that the Replication Server is installed successfully:

Create and start the sample Replication Server.

From the command prompt, go to the %SYBASE%\REP-15_0\install directory and enter:
```
rs_init -r ..\samp_repserver\SAMPLE_RS.res
```
The sample Replication Server starts.
Log in to Replication Server from the command prompt using isql commands with the sa user name. If the installation is successful, you can connect to the Replication Server using isql.
```
isql -Usa -P -SSAMPLE_RS
```
```
1>admin who
```
```
2>go
```
admin who displays the newly created connection.

Logging in to Replication Server is an easy way to find out if Replication Server is running. If you can successfully log in to Replication Server and find it running, then the installation is successful.

Replication Agent

To verify that Replication Agent is installed successfully:

Go to the %SYBASE% directory and check if the following directories and files exist:
- _jvmrax
- installed
- RAX-15_0
  - ASA-9_0
  - bin
  - classes
  - config
  - JRE-1_4_2
  - lib
  - scripts
  - sysam
  - ThirdPartyLegal
- SYSAM-2_0
  - bin
  - licenses
  - log
- uninstall
  - RAX-15_0
- log.txt
- SYBASE.bat
- SYBASE.env
Go to the %SYBASE% directory and set the environment variables by executing SYBASE.bat.
Go to the %SYBASE%\RAX-15_0\bin directory and enter:
```
ra.bat -v
```

Replication Agent is successfully installed, if executing the ra.bat file displays the version number and the Sybase copyright information, and all the above listed directories and files exist.

DirectConnect

To verify that DirectConnect is installed successfully:

Create a DirectConnect server.
1. Go to the %SYBASE%\DC-15_0 directory and enter the following to ensure that all the appropriate Sybase environment variables are set properly:
```
DC_SYBASE.bat
```
2. Go to the %SYBASE%\DC-15_0\bin directory and enter:
```
AddServer server_name port_number
```
  where server_name is the name of the new DirectConnect server and port_number is the port on which the server listens. The AddServer utility creates the necessary entries in the sql.ini file before starting the DirectConnect server.
  
  The command prompt displays that the new server has been started and is ready for connections.
Verify that the server is set up properly.
1. Set the environment variables. Open another command prompt and go to the %SYBASE%\DC-15_0 directory. Enter:
```
DC_SYBASE.bat
```
2. Using isql, enter:
```
isql -Sserver_name -Usa -P
```
```
1>exec adm_version
2>go
```
If DirectConnect is successfully installed, this command displays the product name, version, platform, and release date, along with other information.

To verify that DirectConnect for Oracle (DCO) is installed successfully

To check for a valid installation of DCO, create and configure a DirectConnect instance. Before you do that, make sure:

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

The Oracle connect string is available.

The name for a valid Oracle account, which will be the administrator for DCO, is available.

The number of the unused port to be used by DirectConnect for Oracle is available.

To create and configure a DirectConnect instance:

Start the Create Server wizard.

Navigate to the %SYBASE%\DCO-15_0\DCWizard directory and execute the DCWizard.bat file.

The Welcome Create Server Wizard window appears. Click Next.
Select the ECDA Option for Oracle option. Click Next.
Enter the server name for the new DirectConnect server and the port number that you want the server to listen on. Click Next.
Enter a valid Admin Account name. Click Next.
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.
Verify the ECDA Server information. If correct, select Create Server otherwise, click Back to return to the previous window and provide the correct information.
Verify if the ECDA configuration is successful. If yes, click Next otherwise, click Back to return to the previous window, provide the correct information, and recreate the server.
In the Start DirectConnect Server window, click Start ecda_servername to start the newly configured ECDA server.
Verify if the ECDA server startup is successful and click Finish.
Verify if the ECDA Option for Oracle server is properly configured to Oracle.
1. Set the environment variables. Go to the %SYBASE%\DCO-15_0 directory and enter:
```
DCO_SYBASE.bat
```
2. Using isql enter:
```
isql -Sserver_name -U<valid_oracle_userid> -P
1>select @@oracle_version	
2>go
```
  If the DCO server is installed and configured properly, this command displays the version of the target Oracle database.