When you invoke the ra_admin utility with the -r option, the utility first validates the specified resource file, as described in “Validating a resource file”, except:
If the Replication Agent for Microsoft SQL Server
or Replication Agent for Oracle primary database user login does
not exist in the primary data server, the utility creates it, if
specified in the resource file (create_pds_username=yes).
If the user login does exist in the primary data server but does
not have all the required privileges, set create to yes, to
have the utility grant all required permissions.
If the Replication Agent for Microsoft SQL Server or Replication Agent for Oracle primary database user login does exist in the primary data server, has all the required privileges, and the resource file specifies that it should be created, the utility returns an error message and does not create the instance. (This error would be caught in the validation process described in “Validating a resource file”.)
If the resource file specifies that the new Replication
Agent instance should be initialized (initialize_instance=yes),
then:
The Replication Agent primary database
user login must either exist in the primary data server, or be created
by the ra_admin utility (create_pds_username=yes).
The resource file must specify that the Replication
Agent instance should be started (start_instance=yes).
Otherwise, the utility returns an error message and does not create the instance.
After validating the resource file successfully, the ra_admin utility does the following:
Creates and configures a Replication Agent instance, based on the contents of the specified resource file.
Creates or grants all required privileges for the instance user, if specified in the resource file.
Starts the new Replication Agent instance, if specified in the resource file.
Initializes the new Replication Agent instance, if specified in the resource file.
The utility also returns information about the instance created and the result.
If instance creation fails, the ra_admin utility returns an error message and information about the failure.
Sybase recommends that you validate a new resource file before you create
a Replication Agent instance using the new resource file. For more information,
see “Validating a resource file”.
To create a Replication Agent instance
Invoke the ra_admin utility, specifying the -r option and the name of the resource file:
ra_admin -r res_file
Here, res_file is the name of the resource file.
For example, if the resource file is named pubs2.rs, enter the following at the command prompt:
ra_admin -r pubs2.rs
Results are returned as either:
Response-file
processing completed.
or
Response-file processing completed
with errors.
If the instance creation is successful, you can begin using the new Replication Agent instance.
If the instance creation fails, you may have to:
Delete all files and subdirectories in the instance directory, and delete the instance directory from the Replication Agent installation directory.
Edit the resource file to correct the appropriate values.
If the instance creation fails, use the following recovery
procedure before you attempt to create the
instance again.
To recover from instance creation errors
If the resource file does not specify that the instance user login be created in the primary data server, skip this step and continue with step 2.
If the resource file specifies that the instance user login
be created in the primary data server (that is, create_pds_username=yes),
then:
Check the primary database to determine if the instance user was added.
Check that the pds_sa_username has sufficient privileges to create the instance login at the primary database.
Edit the resource file to specify that the instance
user login should not be created in the primary data server (create_pds_username=no).
If the Replication Agent primary database user login
is successfully created before the instance creation fails, you
must either:
Edit the resource file to set the value of the create_pds_username parameter to no, or
Log in to the primary data server and drop the instance login.
Check the Replication Agent base directory on the Replication Agent host to determine if a new instance directory was created. The Replication Agent base directory is:
%SYBASE%\RAX-15_1
Here, %SYBASE% is the Replication Agent installation directory.
If you do not find a new instance directory in the Replication Agent base directory, skip step 3 and continue with step 4.
If you find a new instance directory in the Replication Agent base directory, continue with step 3.
To delete the new instance directory, you have two options:
Use the ra_admin utility to delete the instance:
ra_admin -d inst_name
Here, inst_name is the name of the instance you want to delete, or
Use operating system commands to delete all of the files and subdirectories in the new instance directory, and then delete the new instance directory.
Review the error messages to find the cause of the instance creation failure, and if necessary, edit the resource file to correct the appropriate values.
After editing the resource file, use ra_admin to validate the resource file:
ra_admin -vr res_file
Here, res_file is the name of the resource file.
See “Validating a resource file” for more information.
After you complete the recovery procedure, you can retry creating the Replication Agent instance.
