| Description |
User Name/Password Issues:
- If the default user name is password-protected, the create UI does not detect this until after all validation is complete
When creating the SAP ASE resource, you are prompted to enter the user name. The help to front displays a message that if no user is specified, the default of ‘sa’ will be used. However, no password validation is done for the default account at this time. When LifeKeeper attempts to create the SAP ASE resource, the resource creation fails because the password has not been validated or entered. The password validation occurs on the user/password dialog, but only when a valid user is actually entered on the user prompt. Even if using the default user name, it must be specified during the create action.
- Password prompt skipped if no user name specified
User/password dialog skips the password prompt if you do not enter a user name. When updating the user/password via the UI option, if you do not enter the SAP ASE user name, the default of ‘sa’ will be used and no password validation is done for the account. This causes the monitoring of the database to fail with invalid credential errors. Even if using the default user name, it must be specified during the update action. To fix this failure, perform the following steps:
- Verify that the required SAP ASE data files are currently accessible from the intended server. In most instances, this will be the backup server due to the monitoring and local recovery failure on the primary.
- Start the SAP ASE database instance from the command line on this server (see the SAP ASE product documentation for information on starting the database manually).
- From the command line, change directory (cd) to the LKROOT/bin directory (/opt/LifeKeeper/bin).
- Once in the bin directory, execute the following:
./ins_setstate –t <SYBASE_TAG> -S ISP
where <SYBASE_TAG> is the tag name of the SAP ASE resource
- When the command completes, immediately execute the Update User/Password Wizard from the UI and enter a valid user name, even if planning to use the SAP ASE default of ‘sa’. Note: The Update User/Password Wizard can be accessed by right-clicking on the SAP ASE resource instance and selecting Change Username/Password.
- When the hierarchy has been updated on the local server, verify that the resource can be brought in service on all nodes.
- Protecting backup server fails when SAP ASE local user name >= eight characters
The SAP ASE user name must consist of less than eight characters. If the SAP ASE local user name is greater than eight characters, the process and user identification checks used for resource creation and monitoring will fail. This will also prevent the protection of a valid SAP ASE Backup Server instance from being selected for protection. This problem is caused by the operating system translation of user names that are >= eight characters from the name to the UID in various commands (for example, ps). You must use a user name that is less than eight characters long.
|
Resource Create Issue:
- Default SAP ASE install prompt is based on ASE 16.0 SP02 (/opt/sybase). During the LifeKeeper resource creation, the default prompt for the location of the SAP ASE installation shows up relative to SAP ASE Version 16.0 SP02 (/opt/sybase). You must manually enter or browse to the correct SAP ASE install location during the resource create prompt.
|
Extend Issues:
- The SAP ASE tag prompt on extend is editable but should not be changed. The SAP ASE tag can be changed during extend, but this is not recommended. Using different tags on each server can lead to issues with remote administration via the command line.
|
Properties Page Issues:
- Image appears missing for the Properties pane update user/password. Instead of the proper image, a small square appears on the toolbar. Selecting this square will launch the User/Password Update Wizard.
|
| SAP ASE Monitor server is not supported in 15.7 or later with LifeKeeper. If the SAP ASE Monitor server process is configured in ASP ASE 15.7 or later, you must use a Generic Application (gen/app) resource to protect this server process. |
Cannot create a resource using the Recovery Kit for SAP ASE OR experiencing issues on a LifeKeeper upgrade when using SLES 15
Symptoms:
When setting up SLES 15 (this includes SLES 15 SP1 or SP2), the Recovery Kit for SAP ASE may not work on an upgrade or on a fresh install of LifeKeeper.
During a fresh install of LifeKeeper you won’t be able to create the SAP ASE resource, or during a LifeKeeper upgrade there could be issues in controlling the resource from LifeKeeper. The underlying error is “An error occurred when attempting to allocate localization-related structures”.
Resolution:
There are 2 possible solutions:
- Add a line in the [Linux] section of the file /sybase/<SID>/locales/locales.dat
locale = POSIX, us_english, utf8
OR
- Add this line to the SAP ASE profile for the syb<SID> user profile.
This profile is typically located in /sybase//SYBASE.sh
export LANG=en_US.UTF-8
<SID> is the 3 letter system ID.
These changes force the correct language to be used and is appropriate for US English locale. If another locale is used for Japan or China, please consult the local country and the system locale.
You can also su to the syb<SID> user and run the command echo $LANG. The cshell parameter will point to the correct language for the appropriate locale.
Which change is appropriate to make? It depends on the comfort level of the SAP ASE database administrator. One is changing the shell script, the other will add the POSIX support to the locales.
|
Unable to detect that Recovery Kit for SAP ASE is running
Symptom: Unable to detect that Recovery Kit for SAP ASE is running.
Cause: The Recovery Kit for SAP ASE uses the default sql interface tool (isql). On some 64 bit systems, the isql tool is installed as isql64 and not isql.
Solution: The isql64 tool can be copied, in the same path, to isql. Or a link can be created between the isql64 executable and isql.
|
Post your comment on this topic.