Sybase Replication

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

Replication Server

To verify that the Replication Server is installed successfully:

Create and start the sample Replication Server.

On Windows:

From the command prompt, go to the %SYBASE%\REP-15_0\install directory and enter:
```
rs_init -r ..\samp_repserver\SAMPLE_RS.res
```

On Solaris:

Go to the $SYBASE directory and enter:
```
source SYBASE.csh
```
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 line 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 Agents

To verify that Replication Agents are installed successfully:

Create a Replication Agent instance. The example below adds an instance for MS SQL Server.

On Windows:

From the command prompt, go to the %SYBASE%\RAX-12_6\bin directory and enter:
```
ra_admin -c repagent -p 10000 -t mssql
```
Use the dsedit utility to add the following entry into the sql.ini file in the %SYBASE%\ini directory. To invoke dsedit, select Start | Programs | Sybase | Connectivity | Open Client Directory Service Editor.
```
[repagent]
```
```
master=tcp, RepAgent_installed_HOST_name, 10000
```
```
query=tcp, RepAgent_installed_HOST_name, 10000
```

On Solaris:

Go to the $SYBASE directory and enter:
```
source SYBASE.csh
```
Go to the $SYBASE/RAX-12_6/bin directory and enter:
```
./ra_admin.sh -c repagent -p 10000 -t mssql
```
Use the dsedit utility to add the following entry into the interfaces file in the $SYBASE directory. To invoke dsedit, go to $SYBASE/OCS-15_0/bin/dsedit.
```
repagent
```
```
master tcp ether RepAgent_installed_host_name 10000
```
```
query tcp ether RepAgent_installed_host_name 10000
```

The command prompt displays that the Replication Agent instance has been successfully created.

Start the Replication Agent instance.

On Windows:

From the command prompt, go to the %SYBASE%\RAX-12_6\bin directory and enter:
```
ra -i repagent
```

On Solaris:

Go to the $SYBASE directory and enter:
```
source SYBASE.csh
```
Go to the $SYBASE/RAX-12_6/bin directory and enter:
```
./ra.sh -i repagent
```

If you installed Replication Agent into a different directory than Replication Server, add an entry for Replication Agent to the Replication Server sql.ini file (Windows) or interfaces file (Solaris).

isql -Usa -P -Sinst_name

where inst_name is the name of the Replication Agent instance.

If the installation is successful, you can connect to the Replication Agent.

DirectConnect

To verify that DirectConnect has installed successfully:

Create a DirectConnect server.

On Windows, from the command prompt:

Go to the %SYBASE%\DC-12_6 directory and enter the following to ensure that all the appropriate Sybase environment variables are set properly:
```
DC_SYBASE.bat
```
Go to the %SYBASE%\DC-12_6\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.
Open another command prompt and go to the %SYBASE%\DC-12_6 directory. Enter:
```
DC_SYBASE.bat
```

On Solaris:

Go to the $SYBASE/DC-12_6/bin directory and enter:
```
AddServer server_name port_number
```
where server_name is the name of the new server and port_number is the port on which the server listens . The AddServer utility creates the necessary entries in the interfaces file before starting the DirectConnect server.

The command prompt displays that the new server has been started and is ready for connections.
To set the environment variables, go to the $SYBASE/DC-12_6/bin directory and enter:
```
source DC_SYBASE.csh
```

Verify that the server is set up properly. On either of the platforms, 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 if DirectConnect for Oracle (DCO) is installed successfully, first use the DCOConfig utility in the DCO-12_6/install directory to configure and start the DCO. Then use isql to the configured and started DCO with a valid Oracle user ID and password. For details on how to configure and start a DCO, see the Sybase Enterprise Connect Data Access Option for Oracle 12.6 Server Administration and User’s Guide.