Recovering from Instance Creation Errors

You may need to recover from errors resulting from an instance creation.

1. 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:

   1. Check the primary database to determine if the instance user was added.
   2. Check that the pds_sa_username has sufficient privileges to create the instance login at the primary database.
   3. Edit the resource file to specify that the instance user login should not be created in the primary data server (create_pds_username=no).
   Note: 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.

2. 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_5

   where %SYBASE% is the Replication Agent installation directory.

   If you do not find a new instance directory in the Replication Agent base directory, skip to step 4.

   If you find a new instance directory in the Replication Agent base directory, continue with step 3.

3. To delete the new instance directory, you have two options:
   • Use ra_admin to delete the instance:

     ra_admin -d inst_name

     where 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.

4. 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, validate the resource file:

   ra_admin -vr res_file

   where res_file is the name of the resource file.