HADR (Always-ON) Setup for SAP ASE Database Server...

sukhesh · ‎06-11-2020

Setting up HADR (Always-ON) for an already existing pair of SAP ASE servers

Since the HADR (High Availability Disaster Recovery) option of SAP ASE option was released, I was eager to set it up for the ASE servers in our production environment. The existing servers were having either log-shipping or SAN based replication or Sybase WarmStandby replication as a DR solution.

All of them have been tried and tested in multiple environments for many years. However, each had it's shortcomings, and never offered a fully automated High Availability Solution.

HADR or Always ON promised to be a game changer and possibly a lasting HA solution for any large DBMS system.

Our organization was looking for a DR (Disaster Recovery) solution that would guarantee quick recovery time objective (RTO) and a reliable recovery point objective (RPO). Our organization has a highly critical application that required a fail safe Disaster Recovery System.

I started studying the HADR installation manual sometime in August 2018. To be honest, the implementation of HADR was not as straight forward as it appeared initially. I had to struggle through multiple components and many small bugs that turned up every step of the way. I worked many hours with SAP engineers to identify and fix many new bugs which had come up when I was doing extensive testing along with our application teams.

Here, I am sharing the steps I followed in the installation of HADR for an existing set of ASE (non-BS) servers in our organization. I hope, some of you will find this useful and can use it for your own setup.

Disclaimer: The examples here has the server names and other component names that is fictional as I did not want to share our organization’s server names to the general public. Such names are displayed in Italics. Feel free to replace it with your given names. This blog does not explain HADR architecture or its components. The blog documents a comprehensive list of steps to install HADR in an existing ASE server setup.

Assumptions: There is already a pair of ASE Version 16.0 SP03 PL05 or above running on a Red Hat Linux OS or SUSE Linux OS.

Architecture:

Primary Host Name → nysybprim

Secondary Host Name → njsybsec

Primary DB Server Name → NYSYBPRIM

Secondary Host Name → NJSYBSEC

STEP 1 – Preparing Primary and DR servers at the OS level

Check Supported OS versions for HADR (Always ON) Installation
- Check for the latest HADR installation manual for the compatible OS versions for your environment.
- The existing OS versions will have to be upgraded if they are not the compatible version as listed in the manual.
- Go through the Prerequisites section of the HADR installation manual to understand certain pre-requisites that would be required for a HADR setup.
  - SAP Help Portal - HADR Installation Guide - Pre-requisites

Ask UNIX SA to check and install the following libraries in each host :
- For Red Hat Linux:

Check for the following Linux packages:

rpm -q openmotif
rpm -q libXp
rpm -q libXt
rpm -q libXtst #(both i686 and x86_64)
rpm -q libXi
rpm -q libXmu
rpm -q libXext #(both i686 and x86_64)
rpm -q libSM
rpm -q libICE
rpm -q libX11
rpm -q libXtst-devel
rpm -q libXi-devel
rpm -q openmotif-devel
rpm -q libXmu-devel
rpm -q libXt-devel
rpm -q libXext-devel
rpm -q libXp-devel
rpm -q libX11-devel
rpm -q libSM-devel
rpm -q libICE-devel
rpm -q gtk2 #(both i686 and x86_64)
rpm -q libgcc #(both i686 and x86_64)

Install any missing packages using yum (below are examples)

Run the following as root:

yum install gtk2.i686
yum install libgcc.i686
yum install glibc.i686
yum install libXext.i686
yum install libXtst.i686
yum install libpng12
yum install libXft
yum install libXp
yum install libXt
yum install libXtst
yum install libXmu

- For SUSE Linux

Run the following commands:

zypper install glibc
zypper install libgcc_s1

The HADR system requires two hosts. Installing Fault Manager requires a separate third host. I chose the third host from one of the application servers. FM doesn’t take much space and do not consume any CPU or memory.

For Linux, Fault Manager requires GLIBC version 2.7 or later. So, have that installed in the third host where the Fault Manager is going to be installed.

Add fully qualified hostnames to each hosts /etc/hosts file. For e.g.
- In nysybprim_host

172.99.99.999 nysybprim_host nysybprim_host.mycomp.com

- In njsybsec_host

172.99.99.999 njsybsec_host njsybsec_host.mycomp.com

The databases in both primary and DR servers that will be part of HADR should be identical in size and shape.

Ensure that all the configuration parameters are identical for both the servers.

IMP: Assign “replication_role” to the “sa” login on both the servers.

Run sp_configure "replication agent memory size", 5120000” on both the primary and DR servers.

STEP 2 – Get Unix SA to Install SAP Host Agent in each server

SAPHOSTAGENT software that comes with the software does not work properly.

* You will need to download SAP Host Agent Version 7.21or later for your OS from the following site:

SAP Software Center Download

SAPCAR is required to extract the saphostagent.sar file. This can also be downloaded from SAP download center. The downloaded SAPCAR file could be named like SAPCAR_1320-80000941.EXE. After the download, rename it to just SAPCAR.

Install the SAP Host Agent 7.21 (To be done by Unix SA)

Login as 'root'
- create temporary directory /tmp/hostagent
- Copy the Host Agent Software to the temporary directory

cp /sybsoftware/downloads/SAPHOSTAGENT721/SAPHOSTAGENT40_40-20009394.SAR /tmp/hostagent

Extract the SAP Host Agent software

/sybsoftware/downloads/SAPHOSTAGENT721/SAPCAR -xvf /tmp/hostagent/SAPHOSTAGENT40_40-20009394.SAR -manifest SIGNATURE.SMF

Install the SAP Host Agent software using below parameters ..

/tmp/hostagent/saphostexec -install -passwd

- When asked for the password give password like “Syb@se123” or anything else that you may want. Remember the password as it will be needed later.
- Check the status of SAP Host Agent

/usr/sap/hostctrl/exe/saphostexec -status

Give sudo permission for /usr/sap/hostctrl/exe/saphostexec to sapadm login.

Change group of all files under /usr/sap to the group “sapsys”

Remove the temporary directory with all its content

rm -r /tmp/hostagent

Create (touch) a file called “sapservices” under /usr/sap

For the file /usr/sap/hostctrl/exe/host_profile, give “read_only” permissions.

Add “/usr/sap/hostctrl/exe/saphostexec –stop” in the Unix shutdown script

Add “/usr/sap/hostctrl/exe/saphostexec –restart” in the Unix startup script

DBA should be able to login to the host as “sapadm” and run –

“sudo /usr/sap/hostctrl/exe/saphostexec –status”

STEP 3 – Install HADR using the Resource File

Firstly, ensure that you have installed version ASE 16.0 SP03 PL05 or above in both primary and DR hosts. If that is not the case, you will have to upgrade these servers to these versions first. HADR in previous ASE versions has lot of bugs and may not work properly.

Create the HADR database (3 alphanumeric characters that you prefer) in each server. As an example, I have given the name here as C99

create database C99 on datadevice1 = 100 log on logdevice1 = 25

sp_dboption C99 'trunc log on chkpt',true

Copy server entries of primary and DR servers into each other’s interfaces file

To install HADR using the resource file, sample resource file is available at the following location:

$SYBASE/$SYBASE_ASE/init/sample_resource_files/setup_hadr.rs

Copy this file to $SYBASE/$SYBASE_ASE/bin and modify it as follows:
- For the Primary server (nysybprim)

##########################################################################

# This will be the resource file entries for the “primary server” =~ site1 

##########################################################################

# ID that identifies this cluster

cluster_id=C99



# Which site being configured

setup_site=site1

is_secondary_site_setup=false

synchronization_mode=sync

ase_sa_password=*******



# Set installation_mode

# Valid values: true, false

# If set to true, installation_mode will be set to "BS"

# If set to false, installation_mode will be set to "nonBS"

setup_bs=false



# BACKUP server system administrator user/password

bs_admin_user=sa

bs_admin_password=



# ASE HADR maintenance user/password

hadr_maintenance_user=hadr_maint

hadr_maintenance_password=hadr_maint_ps



# Replication Management Agent administrator user/password

rma_admin_user=hadr_maint

rma_admin_password=hadr_maint_ps



# Databases that will participate in replication and "auto" materialize.



# cluster ID database

participating_database_1=C99

materialize_participating_database_1=true



# user database

participating_database_2=<dbname>

materialize_participating_database_2=true



#### <copy paste the above 3 lines for any number of databases that you 

may want to add to the HADR system> ###



##########################################################

# Entries for Site "site1" on host host1 with primary role

##########################################################

site1.ase_host_name=nysybprim



# Enter value that identifies this site, like a geographical location. Value must be unique.     

site1.site_name=NYPRIM



# Valid values: primary, companion

site1.site_role=primary



# directory where SAP ASE installed

site1.ase_release_directory=/sybsoftware/sybase/NYSYBPRIM



# Directory that stored SAP ASE user data files



# (interfaces, RUN_<server>, error log, etc. files).



site1.ase_user_data_directory=/sybsoftware/sybase/NYSYBPRIM

site1.ase_server_name=NYSYBPRIM

site1.ase_server_port=4100

site1.backup_server_name=NYSYBPRIM_back

site1.backup_server_port=4200



# Directory to store database dumps in materialization

site1.backup_server_dump_directory=/backups



# Port numbers for Replication Server and Replication Management Agent on host1



# See "rsge.bootstrap.tds.port.number" properties in



<$SYBASE>/DM/RMA-15_5/instances/AgentContainer/config/bootstrap.prop for value

site1.rma_tds_port=4909

site1.rma_rmi_port=7001



# Starting port number to use when setup Replication Server.



# Make sure next two ports (+1 and +2) are also available for use.

site1.srs_port=5005



# Device buffer for Replication Server on host1



# Recommend size = 128 * N

# where N is the number of databases to replicate,

# including the master and cluster ID databases.

site1.device_buffer_dir=/sybdata/RS_HADR_DeviceBuffer

site1.device_buffer_size=2048



# Persistent queue directory for Replication Server running on host1

site1.simple_persistent_queue_dir=/sybdata/RS_HADR_QueueDir

site1.simple_persistent_queue_size=4096



#############################################################

# Entries for Site "site2" on host host2 with companion role

#############################################################



# Host name where SAP ASE run

site2.ase_host_name=njsybsec



# Site name

site2.site_name=NJSEC



# Site role

site2.site_role=companion



# directory where SAP ASE installed

site2.ase_release_directory=/sybsoftware/sybase/NJSYBSEC



# Directory that stored SAP ASE user data files

# (interfaces, RUN_<server>, error log, etc. files).

site2.ase_user_data_directory=/sybsoftware/sybase/NJSYBSEC

site2.ase_server_name=NJSYBSEC

site2.ase_server_port=4100

site2.backup_server_name=NJSYBSEC_back

site2.backup_server_port=4200



# Directory to store database dumps in materialzation

# Backup server must able to access this directory

site2.backup_server_dump_directory=/backups/DB_BACKUP_DIR



# Port numbers for Replication Server and Replication Management Agent on host2

# See "rsge.bootstrap.tds.port.number" properties in

# <$SYBASE>/DM/RMA-15_5/instances/AgentContainer/config/bootstrap.prop for value

site2.rma_tds_port=4909

site2.rma_rmi_port=7001

# Starting port number to use when setup Replication Server.

# Make sure next two ports (+1 and +2) are also available for use.

site2.srs_port=5005



# Device buffer for Replication Server on host2

# Recommend size = 128 * N

# where N is the number of databases to replicate,

# including the master and cluster ID databases.

site2.device_buffer_dir=/sybdata/RS_HADR_DeviceBuffer

site2.device_buffer_size=2048



# Persistent queue directory for Replication Server running on host2

site2.simple_persistent_queue_dir=/sybdata/RS_HADR_QueueDir

site2.simple_persistent_queue_size=4096



*******************************************************************************************

Copy this same file to $SYBASE/$SYBASE_ASE/bin in the DR server and modify only the portions marked “red”. Rest everything will remain same.
- For secondary server (njsybsec)

##########################################################################
# This will be the resource file entries for the “secondary server” =~ site2
##########################################################################
# ID that identifies this cluster
cluster_id=C99# Which site being configured
setup_site=site2
is_secondary_site_setup=true
synchronization_mode=sync..

*** Everything else remains same as above ***

Run the setup using the resource file as follows :
- $SYBASE/$SYBASE_ASE/setuphadr <resource file name>

The setup logs will be created automatically in the following location:
- $SYBASE/$SYBASE_ASE/init/logs/setuphadr???.???
- Monitor the setup logs for the progress and keep an eye on any errors.

The setup in primary will not take much time, but if for some reason,the installation is unsuccessful, you can remove the entire HADR setup using the command “sap teardown” and re-run the setup after fixing the problem.
- SAP Teardown steps:

Login to primary server RMA using isql

- - isql –Uhadr_admin_user –S<primary_name>:4909 –Phadr_admin_ps
  - In the command prompt run “sap_teardown”
  - drop hadr_maint_user login from primary and companion servers
  - drop hadr_admin_user login from primary and companion servers
  - shutdown RMA server on both primary and companion
    - isql –Uhadr_admin_user –S<host_name>:4909 –Phadr_admin_ps
    - > shutdown
  - rename directories under the following path: (they get recreated upon reinstall)

$SYBASE/DM/RMA-16_0/instance/AgentContainer/configdb

$SYBASE/DM/RMA-16_0/instance/AgentContainer/logs

- - reinstall using

$SYBASE/$SYBASE_ASE/setuphadr <resource file name>

If HADR installation is successful, proceed to next step i.e. ASE Cockpit installation

STEP 4 – Installing ASE Cockpit for HADR Manually

Each ASE 16.0 server comes with an admin tool called ASE Cockpit. It is a useful tool to monitor, alert and manage the HADR system.

Note: ASE Cockpit works with Flash Plugin of the internet browser. As flash will no longer be supported by any browsers by end of Dec 2020, ASE Cockpit will also get deprecated. ASE Cockpit is not mandatory to run HADR, so you can disregard in case, the following do not work properly in your environment. Keep a lookout for a replacement of ASE Cockpit that SAP could rollout in future.

After the installation of HADR software as instructed above, you can configure the ASE Cockpit to manage HADR.

Shutdown the Cockpit server, if it is already started. Or start the cockpit server and shut it down once, which will then pick up all the HADR relevant parameters in its XML plugins.

- If you have the cockpit prompt - type: shutdown
- If it is running in the back ground - $SYBASE/COCKPIT-4/bin/cockpit.sh -stop

Go to the directory $SYBASE/COCKPIT-4/plugins.

Create a new directory. The name of the directory will be the name of the ASE server.
e.g: mkdir NYSYBPRIM

Copy the com.sybase.ase templates to the $SYBASE/COCKPIT-4/plugins/NYSYBPRIM directory to create the NYSYBPRIM plugin profile.

e.g: cp -R $SYBASE/COCKPIT-4/templates/com.sybase.ase/* $SYBASE/COCKPIT-4/plugins/NYSYBPRIM

Generate the encrypted password for ASE plugin profile. (Create encrypted passwords and copy & paste the encryption properly. Each time you run the tool, a new encryption code is generated)
- Run $SYBASE/COCKPIT-4/bin/passencrypt.
  - The password should be sa or an user with sa_role in ASE.
    e.g: $SYBASE/COCKPIT-4/bin/passencrypt
    Password: your password
    <crypted value>

Similarly, you will need to generate the encrypted password for hadr_admin_user and use it in the XML file.

Edit the $SYBASE/COCKPIT-4/plugins/NYSYBPRIM/agent-plugin.xml file and enter ASE plugin profile information. Change the items in shown in "blue" here.

<?xml version="1.0" encoding="ISO-8859-1"?>

<agent-plugin id="com.sybase.ase" version="16.0.0" name="ASE Agent Plugin" class="com.sybase.ua.plugins.ase.ASEAgentPlugg

in" provider-name="SAP AG or an SAP affiliate company" register-on-startup="true" mbean-type="Model MBean" mbean-descripp

tor="mbean-descriptor.xml" instance="1">



<dependencies />

<properties>

<set-property property="ase.heartbeat.timer" value="60" />

<set-property property="ase.heartbeat.update.time" value="2019-06-06 13:04:09 -0400" />

<set-property property="ase.home" value="/sybsoftware/sybase/NYSYBPRIM/ASE-16_0" />

<set-property property="ase.interfaces.pathspec" value="/sybsoftware/sybase/NYSYBPRIM/interfaces" />

<set-property property="ase.login.timeout" value="30" />

<set-property property="ase.maintain.connection" value="true" />

<set-property property="ase.password" value="Encrypted Pass As obtained by passencrypt" />

<set-property property="ase.port" value="4100" />

<set-property property="ase.query.timeout" value="60" />

<set-property property="ase.server.log" value="/sybsoftware/sybase/NYSYBPRIM/ASE-16_0/install/NYSYBPRIM.log" //>

<set-property property="ase.server.name" value="NYSYBPRIM" />

<set-property property="ase.start.command" value="/sybsoftware/sybase/NYSYBPRIM/ASE-16_0/install/RUN_NYSYBPRIM" />

<set-property property="ase.user" value="sa" />

<set-property property="com.sybase.home" value="/sybsoftware/sybase/NYSYBPRIM" />

<set-property property="rma.home" value="/sybsoftware/sybase/NYSYBPRIM/DM/RMA-16_0" />

<set-property property="rma.log.dir" value="/sybsoftware/sybase/NYSYBPRIM/DM/RMA-16_0/instances/AgentContainer/logs" />

<set-property property="rma.password" value=" Encrypted Pass As obtained by passencrypt" />

<set-property property="rma.port" value="4909" />

<set-property property="rma.start.command" value="/sybsoftware/sybase/NYSYBPRIM/DM/RMA-16_0/bin/RunContainer.sh"/>

<set-property property="rma.user" value="hadr_admin_user" />

<set-property property="rs.home" value="/sybsoftware/sybase/NYSYBPRIM/DM/REP-16_0" />

<set-property property="rs.interfaces.pathspec" value="/sybsoftware/sybase/NYSYBPRIM/DM/interfaces" />

<set-property property="rs.password" value=" Encrypted Pass As obtained by passencrypt" />

<set-property property="rs.port" value="5005" />

<set-property property="rs.server.log" value="/sybsoftware/sybase/NYSYBPRIM/DM/C99_REP_NYSYBPRIM/C99_REP_NYSYBPRIM.log" />

<set-property property="rs.server.name" value="C99_REP_NYSYBPRIM" />

<set-property property="rs.start.command" value="/sybsoftware/sybase/NYSYBPRIM/DM/C99_REP_NYSYBPRIM/RUN_C02_REP_NYSYBPRIM.sh" />

<set-property property="rs.sybase.home" value="/sybsoftware/sybase/NYSYBPRIM/DM" />

<set-property property="rs.user" value="sa" />

</properties>

</agent-plugin>

Start the Cockpit server

e.g: $SYBASE/COCKPIT-4/bin/cockpit.sh

Connect to ASE Cockpit through a browser that has flash plugin support. You should see the NYSYBPRIM server in the ASE Cockpit drop down menu for connection.

STEP 5 – Configuring ASE Cockpit for HADR

After successfully installing ASE Cockpit as mentioned above, you can login to the ASE Cockpit web-based GUI using the URL which will be given in the COCKPIT log.

It should be <hostname>:4283

You should login using “sa” and password that you have given when configuring the cockpit.

Once in the portal, you will see three tabs: MONITOR, EXPLORE and ALERT. Go to EXPLORE and select ASE Servers in the left panel.

On the right panel, when you select the servername, you will get a drop down list with various options. Select “Properties” option.

In the next screen, select “Agent” in the left panel and fill in the agent information i.e. user name (uafadmin)and password (uafadmin) and click on authenticate.

Again in the left panel, select “HADR” and fill in RMA details like Port Number (4909), User Name (hadr_admin_user) and Password and then click on authenticate

After the authentications are successful, you can now see the HADR details in the MONITOR tab as shown below.

STEP 6 – Configuring the FaultManager in the THIRD host

As I mentioned earlier, choose an application server as a third host or use any host that you have as a spare. This is a small software component so it would not take much CPU or memory.

After you extract the ASE binary, there should be a separate directory listed as FaultManager
- For e.g.: /sybsoftware/ASE16/ebf28996/FaultManager
- It should have the following files/sub-directories …

archives

sample_response.txt

setup.bin

The setup is a command line menu driven tool. All we need to do is run setup.bin and fill in the details … (For ease of use, gather all important values beforehand and keep it separately)

sybase@nysybprim: /sybsoftware/sybase/FaultManager ==> ./setup.bin

Preparing to install

Extracting the JRE from the installer archive...

Unpacking the JRE...

Extracting the installation resources from the installer archive...

Configuring the installer for this system's environment...

Launching installer...

Graphical installers are not supported by the VM. The console mode will be used instead...

====================================================================================================================

Fault Manager (created with InstallAnywhere)

--------------------------------------------------------------------------------------------------------------------

Preparing CONSOLE Mode Installation...

====================================================================================================================

Introduction

----------------

InstallAnywhere will guide you through the installation of Fault Manager 1.0 GA.



It is strongly recommended that you quit all programs before continuing with

this installation.Before you proceed, make sure that:

* SAP ASE, Replication Management Agent (RMA), Replication Server, and SAP

Host Agent are set up and running on the primary and companion sites.

* "sapadm" operating system user has a valid password on the primary and companion sites.



Respond to each prompt to proceed to the next step in the installation. If you want to change something on a previous step, type 'back'.

You may cancel this installation at any time by typing 'quit'.



PRESS <ENTER> TO CONTINUE:



======================================================================

End-user License Agreement

-------------------------------------

1) Americas and Asia Pacific

.

35) Any Other Locations



Please enter the number of the location you are installing. (1-35) (Default:

1): 1



LICENSE AGREEMENT

General (applies to all countries, except those for which a specific country/language version is posted)



IMPORTANT NOTICE: READ THIS LICENSE AGREEMENT CAREFULLY BEFORE USING THE ENCLOSED PROGRAM. YOU MAY USE THE PROGRAM ACQUIRED ONLY IN THE COUNTRY IN WHICH THIS LICENSE WAS ACCEPTED, AND ONLY IN ACCORDANCE WITH THE FOLLOWING TERMS AND CONDITIONS. IF YOU DO NOT AGREE TO BE BOUND BY THESE TERMS, YOU MAY NOT USE THE PROGRAM. BY DOWNLOADING, INSTALLING, OR USING THE PROGRAM IN ANY WAY, YOU ACKNOWLEDGE THAT YOU HAVE READ, UNDERSTAND AND AGREE TO THE TERMS OFTHIS AGREEMENT. IF YOU DO NOT AGREE WITH THESE TERMS, PRESENT YOUR RECEIPT OR OTHER PROOF OF PURCHASE, TOGETHER WITH THE PROGRAM MEDIA, DOCUMENTATION AND PACKAGING (IF ANY) TO THE ENTITY FROM WHICH YOU OBTAINED THIS PRODUCT WITHIN 30

DAYS TO REQUEST A REFUND. THIS IS A LICENSE AND NOT A SALE.



Press ENTER to read the text [Type 'back' and press ENTER to skip the text]

: back



I agree to the terms of the SAP license for the install location specified.

(Y/N): Y



======================================================================

Choose Install Folder

---------------------------

Where would you like to install?

Default Install Folder: /opt/sap



ENTER AN ABSOLUTE PATH, OR PRESS <ENTER> TO ACCEPT THE DEFAULT



INSTALL FOLDER IS: /sybsoftware/sybase/FaultManager

IS THIS CORRECT? (Y/N): Y

======================================================================

Pre-Installation Summary

---------------------------------



Please Review the Following Before Continuing:

Product Name:

Fault Manager



Install Folder:

/sybsoftware/sybase/FaultManager



Product Features:

Fault Manager



Disk Space Information (for Installation Target):

Required: 25,870,191 Bytes

Available: 34,533,335,040 Bytes



PRESS <ENTER> TO CONTINUE:

======================================================================

Ready To Install

---------------------



InstallAnywhere is now ready to install Fault Manager onto your system at the following location:



/sybsoftware/sybase/FaultManager



======================================================================

Installing...

-------------



[===============|================|==================|================]

[------------------|------------------|------------------|-----------------

======================================================================

Configure Fault Manager

--------------------------------



Installer has successfully unloaded Fault Manager to the disk. You need to

configure it for ASE HADR. If you choose not to configure Fault Manager now,

you can run "sybdbfm install" to configure it at later time.



Do you want to configure Fault Manager? (Y/N): Y

======================================================================

Cluster ID

-------------

Cluster ID (Default: 😞 C99

======================================================================

Failover

-----------



For ASE HADR synchronous replication, do you want automatic failover to

happen if primary SAP ASE is unreachable? (Y/N): Y

=====================================================================

SAP ASE on Primary

--------------------------



Site name (Default: 😞 NYPRIM

SAP ASE host name (Default: 😞 nysybprim.mycomp.com

SAP ASE Name (Default: 😞 NYSYBPRIM

SAP ASE port (Default: 😞 4100

SAP ASE installed directory (Default: /opt/sap): /sybsoftware/sybase/NYSYBPRIM

SAP ASE installed user (Default: sybase): sybase



======================================================================

SAP ASE on Companion

------------------------------



Site name (Default: 😞 NJSEC

SAP ASE host name (Default: 😞 njsybsec.mycomp.com

SAP ASE Name (Default: SYBWREUAT): NJSYBSEC

SAP ASE port (Default: 😞 4100

SAP ASE installed directory (Default: /opt/sap): /sybsoftware/sybase/NJSYBSEC

SAP ASE installed user (Default: sybase): sybase

======================================================================

Virtual IP for SAP ASE

----------------------------

Do want to enable virtual IP support for the SAP ASE? (Y/N): N

======================================================================

ASE Cockpit

----------------



Do you want to use ASE Cockpit to manage ASE HADR? (Y/N): Y

primary Cockpit TDS port (Default: 4998):

companion Cockpit TDS port (Default: 4998):



======================================================================

Replication Management Agent on Primary

-------------------------------------------------------

RMA TDS port (Default: 7001): 4909

======================================================================

Replication Management Agent on Companion

-----------------------------------------------------------



RMA TDS port (Default: 7001): 4909

======================================================================

Fault Manager Host and Ports

--------------------------------------



Fault Manager host (Default: nyapphost.mycomp.com): nyapphost.mycomp.com

Fault Manager heartbeat to heartbeat port (Default: 13797):

Primary Fault Manager heartbeat port (Default: 13777):

Companion Fault Manager heartbeat port (Default: 13787):

======================================================================

Secure Store Directory

-----------------------------

Secure Store directory (Default: /sybsoftware/sybase/FaultManager/FaultManager):

======================================================================

Enable SSL for the Fault Manager (Y/N): N

======================================================================

Users for ASE HADR

--------------------------



SAP ASE system administrator user (Default: sa):

SAP ASE system administrator password:

Confirm SAP ASE system administrator password:

RMA administrator user (Default: DR_admin):

RMA administrator password:

Confirm RMA administrator password:

SAP Host Agent user (Default: sapadm):

SAP Host Agent user password:

Confirm SAP Host Agent user password:

Cockpit administrator user (Default: sccadmin): uafadmin

Cockpit administrator password:

Confirm Cockpit administrator password:

======================================================================

Fault Manager Configuration Summary

--------------------------------------------------



The installer will now configure the Fault Manager with following values.



ASE HADR Cluster

Cluster ID C99

Failover in synchronous mode true

Primary

Primary Site name NYPRIM

Primary SAP ASE host name nysybprim.mycomp.com

Primary SAP ASE Name NYSYBPRIM

Primary SAP ASE port 4100

Primary SAP ASE installed directory /sybsoftware/sybase/NYSYBPRIM

Primary SAP ASE installed user sybase

Primary Cockpit TDS port 4998

Primary RMA TDS port 4909

Companion

Companion Site name NJSEC

Companion SAP ASE host name njsybsec.mycomp.com

Companion SAP ASE Name NJSYBSEC

Companion SAP ASE port 4100

Companion SAP ASE installed directory /sybsoftware/sybase/NJSYBSEC

Companion SAP ASE installed user sybase

Companion Cockpit TDS port 4998

Companion RMA TDS port 4909

Virtual IP for SAP ASE

Enable SAP ASE Virtual IP false

Virtual SAP ASE host name nysybprim.mycomp.com

Virtual SAP ASE port 4100

Network interface

Internet protocol version

Fault Manager Host and Ports

Fault Manager host nyapphost.mycomp.com

Fault Manager heartbeat to heartbeat port 13797

Primary Fault Manager heartbeat port 13777

Companion Fault Manager heartbeat port 13787

Secure Store

Secure Store directory /sybsoftware/sybase/FaultManager/Fault

SAP ASE system administrator user sa

SAP ASE system administrator password ***********

RMA administrator user hadr_admin_user

RMA administrator password ***********

SAP Host Agent user sapadm

SAP Host Agent user password ***********

Cockpit administrator user uafadmin

Cockpit administrator password ***********

1- No

->2- Yes



Do you want to proceed with the configuration?: 2



======================================================================

Installation Completed

-----------------------------



The installation was successful.

Please check regularly for updates at http://service.sap.com.



PRESS <ENTER> TO EXIT THE INSTALLER:

STEP 7 – Administration and Troubleshooting Tips

For administrative tasks, you may have to login to the various components individually and check its status.

- Following are the methods to login to the various components :
  - SAP ASE Primary or Companion Servers

$SYBASE/$SYBASE_OCS/bin/isql -U<login_name> -P<password> -S<server_name>

- - SAP Replication Primary or Companion Servers

isql -Uhadr_admin_user -SC99_REP_NYSYBPRIM -I/sybsoftware/sybase/NYSYBPRIM/DM/interfaces

or

isql -Uhadr_admin_user –S<hostname>:5005

- - SAP RMA Login in Primary or Companion Servers

isql -Uhadr_admin_user –S<hostname>:4909

- Logs for trouble shooting is located at the following places:
  - SAP ASE Primary or Companion Server

/sybsoftware/sybase/NYSYBPRIM/ASE-16_0/install/<servername>.log

- - SAP Replication or Companion Servers

/sybsoftware/sybase/NYSYBPRIM/DM/C99_REP_NYSYBPRIM/C99_REP_NYSYBPRIM.log

1. - SAP RMA errorlogs

/sybsoftware/sybase/NYSYBPRIM/DM/RMA-16_0/instances/AgentContainer/logs/RMA_<mmddyyyy>.log

- - ASE Cockpit errorlogs

/sybsoftware/sybase/NYSYBPRIM/COCKPIT-4/log/agent.log

- - FaultManager errorlog

/sybsoftware/sybase/FaultManager/dev_sybdbfm

- Starting & Stopping the various components

ASE Cockpit can be used to restart various components without having to login to the host. However, sometimes the ASE Cockpit may not function very well. So, we will have to depend on manual intervention.

- - Starting & Stopping SAP ASE servers

ASE servers can be started in the usual way from the $SYBASE/$SYBASE_ASE/install directory using the starteserver command.

To shut down the ASE server that is part of the HADR system, follow these steps …

- - First shutdown the FaultManager (steps given below)
  - Login to the companion server and shutdown that first using the “shutdown with wait/nowait” command.
  - Login to the primary server and shutdown using the command “shutdown with wait no_hadr”

* If you do not follow the above steps, then the Fault Manager will failover the primary server.

* To Re-start the servers, restart in the reverse order of the above.

- - Starting & Stopping the RMA
    - Start the RMA using the following command

/sybsoftware/sybase/NYSYBPRIM/DM/SYBASE.sh

/sybsoftware/sybase/NYSYBPRIM/DM/RMA-16_0/bin/RunContainer.sh AgentContainer&

- - Stop the RMA

isql -Uhadr_admin_user –S<hostname>:4909

shutdown

- - Starting & Stopping the Rep Server
    - Starting the Rep Server:

/sybsoftware/sybase/NYSYBPRIM/DM/SYBASE.sh

/sybsoftware/sybase/NYSYBPRIM/DM/C99_REP_NYSYBPRIM/RUN_C99_REP_NYSYBPRIM.sh

- - - Stopping the Rep Server:

isql -Uhadr_admin_user -SC99_REP_NYSYBPRIM

shutdown

- - Starting & Stopping the ASE Cockpit
    - To start the cockpit use this command

cd /sybsoftware/sybase/NYSYBPRIM/COCKPIT-4/bin

nohup ./cockpit.sh 2>&1 > cockpit-console.out &

disown

- - - To Stop the ASE Cockpit

/sybsoftware/sybase/NYSYBPRIM/COCKPIT-4/bin/cockpit.sh –stop

- - Starting & Stopping the FaultManager
    - To start the FaultManager

/sybsoftware/sybase/FaultManager/SYBASE.sh

/sybsoftware/sybase/FaultManager/sybdbfm_C03 &

- - - To stop the FaultManager

/sybsoftware/sybase/FaultManager/FaultManager/bin/sybdbfm stop