Storage Foundation for Sybase ASE CE 7.4.1 Configuration and Upgrade Guide - Linux

Last Published:
Product(s): InfoScale & Storage Foundation (7.4.1)
Platform: Linux
  1. Section I. Configuring SF Sybase ASE CE
    1. Preparing to configure SF Sybase CE
      1.  
        About this document
      2.  
        Supported Sybase ASE CE releases
      3.  
        Supported SF Sybase CE configurations
      4.  
        Coordinator disk requirements for I/O fencing
      5.  
        Supported replication technologies for global clusters
      6. About planning to configure I/O fencing
        1.  
          Typical SF Sybase CE cluster configuration with disk-based I/O fencing
      7.  
        Planning for cluster management
    2. Configuring SF Sybase CE
      1.  
        About configuring SF Sybase CE
      2. Configuring the SF Sybase CE components using the script-based installer
        1. Configuring the SF Sybase CE cluster
          1.  
            Configuring the cluster name
          2.  
            Configuring private heartbeat links
          3.  
            Configuring the virtual IP of the cluster
          4. Configuring SF Sybase CE in secure mode
            1.  
              Setting up trust relationships for your SF Sybase CE cluster
          5. Configuring a secure cluster node by node
            1.  
              Configuring the first node
            2.  
              Configuring the remaining nodes
            3.  
              Completing the secure cluster configuration
          6.  
            Adding VCS users
          7.  
            Configuring SMTP email notification
          8.  
            Configuring SNMP trap notification
          9.  
            Configuring global clusters
    3. Configuring SF Sybase CE clusters for data integrity
      1. Setting up disk-based I/O fencing using installer
        1.  
          Initializing disks as VxVM disks
        2.  
          Identifying disks to use as coordinator disks
        3.  
          Refreshing keys or registrations on the existing coordination points for disk-based fencing using the installer
        4. Checking shared disks for I/O fencing
          1.  
            Verifying Array Support Library (ASL)
          2.  
            Verifying that the nodes have access to the same disk
          3.  
            Testing the disks using vxfentsthdw utility
        5.  
          Configuring disk-based I/O fencing using installer
    4. Performing an automated SF Sybase CE configuration
      1.  
        Configuring SF Sybase CE using response files
      2.  
        Response file variables to configure SF Sybase CE
      3.  
        Sample response files for configuring SF Sybase CE
    5. Performing an automated I/O fencing configuration using response files
      1.  
        Configuring I/O fencing using response files
      2.  
        Response file variables to configure disk-based I/O fencing
      3.  
        Sample response file for configuring disk-based I/O fencing
    6. Configuring a cluster under VCS control using a response file
      1.  
        Configuring a Sybase cluster under VCS control with a response file
      2.  
        Response file variables to configure SF Sybase CE in VCS
  2. Section II. Post-installation and configuration tasks
    1. Verifying the installation
      1.  
        Upgrading the disk group version
      2.  
        Performing a postcheck on a node
      3.  
        Verifying SF Sybase CE installation using VCS configuration file
      4. Verifying LLT, GAB, and cluster operation
        1.  
          Verifying LLT
        2.  
          Verifying GAB
        3.  
          Verifying the cluster
        4.  
          Verifying the cluster nodes
    2. Performing additional post-installation and configuration tasks
      1. About enabling LDAP authentication for clusters that run in secure mode
        1.  
          Enabling LDAP authentication for clusters that run in secure mode
      2.  
        Configuring Volume Replicator
      3.  
        Running SORT Data Collector to collect configuration information
  3. Section III. Upgrade of SF Sybase CE
    1. Planning to upgrade SF Sybase CE
      1.  
        About the upgrade
      2.  
        Supported upgrade paths
      3.  
        Using Install Bundles to simultaneously install or upgrade full releases (base, maintenance, rolling patch), and individual patches
    2. Performing a full upgrade of SF Sybase CE using the product installer
      1.  
        About full upgrades
      2.  
        Preparing to perform a full upgrade to SF Sybase CE 7.4.1
      3. Upgrading to SF Sybase CE 7.4.1
        1.  
          Upgrading SF Sybase CE using the Veritas installation program
    3. Performing an automated full upgrade of SF Sybase CE using response files
      1.  
        Upgrading SF Sybase CE using a response file
      2.  
        Response file variables to upgrade SF Sybase CE
      3.  
        Sample response file for upgrading SF Sybase CE
    4. Performing a phased upgrade of SF Sybase CE
      1.  
        About phased upgrade
      2. Performing a phased upgrade of SF Sybase CE from version 6.2.1 and later release
        1.  
          Step 1: Performing pre-upgrade tasks on the first half of the cluster
        2.  
          Step 2: Upgrading the first half of the cluster
        3.  
          Step 3: Performing pre-upgrade tasks on the second half of the cluster
        4.  
          Step 4: Performing post-upgrade tasks on the first half of the cluster
        5.  
          Step 5: Upgrading the second half of the cluster
        6.  
          Step 6: Performing post-upgrade tasks on the second half of the cluster
    5. Performing a rolling upgrade of SF Sybase CE
      1.  
        About rolling upgrade
      2.  
        Supported rolling upgrade paths
      3.  
        Preparing to perform a rolling upgrade to SF Sybase CE 7.4.1
    6. Performing post-upgrade tasks
      1.  
        Re-joining the backup boot disk group into the current disk group
      2.  
        Reverting to the backup boot disk group after an unsuccessful upgrade
      3.  
        Setting or changing the product license level
      4.  
        Upgrading disk layout versions
      5.  
        Upgrading CVM protocol version and VxVM disk group version
  4. Section IV. Installation and upgrade of Sybase ASE CE
    1. Installing, configuring, and upgrading Sybase ASE CE
      1.  
        Before installing Sybase ASE CE
      2.  
        Preparing for local mount point on VxFS for Sybase ASE CE binary installation
      3.  
        Preparing for shared mount point on CFS for Sybase ASE CE binary installation
      4.  
        Installing Sybase ASE CE software
      5.  
        Preparing to create a Sybase ASE CE cluster
      6.  
        Creating the Sybase ASE CE cluster
      7. Preparing to configure the Sybase instances under VCS control
        1.  
          Language settings for the Sybase agent
        2.  
          Configuring Sybase for detail monitoring
        3.  
          Encrypting passwords for Sybase
        4. About setting up detail monitoring for the agent for Sybase
          1.  
            Enabling detail monitoring for the agent for Sybase
          2.  
            Disabling detail monitoring for the agent for Sybase
      8.  
        Configuring a Sybase ASE CE cluster under VCS control using the SF Sybase CE installer
      9.  
        Upgrading Sybase ASE CE
  5. Section V. Adding and removing nodes
    1. Adding a node to SF Sybase CE clusters
      1.  
        About adding a node to a cluster
      2.  
        Before adding a node to a cluster
      3. Adding the node to a cluster manually
        1.  
          Starting Veritas Volume Manager (VxVM) on the new node
        2.  
          Configuring cluster processes on the new node
        3. Setting up the node to run in secure mode
          1.  
            Configuring the authentication broker on node sys5
        4.  
          Starting fencing on the new node
        5.  
          Configuring Cluster Volume Manager (CVM) and Cluster File System (CFS) on the new node
        6.  
          After adding the new node
        7.  
          Configuring the ClusterService group for the new node
      4.  
        Adding a node to a cluster using the Veritas InfoScale installer
      5. Adding the new instance to the Sybase ASE CE cluster
        1.  
          Creating Sybase user and groups
        2.  
          Preparing the mount point for Sybase resources on the new node
        3.  
          Adding a new Sybase ASE CE instance to the Sybase ASE CE cluster
        4.  
          Bringing the new Sybase ASE CE instance under VCS control
    2. Removing a node from SF Sybase CE clusters
      1.  
        About removing a node from a cluster
      2.  
        Removing a node from a cluster
      3.  
        Modifying the VCS configuration files on existing nodes
      4.  
        Modifying the Cluster Volume Manager (CVM) configuration on the existing nodes to remove references to the deleted node
      5.  
        Removing security credentials from the leaving node
  6. Section VI. Configuration of disaster recovery environments
    1. Configuring disaster recovery environments
      1.  
        Disaster recovery options for SF Sybase CE
      2.  
        About setting up a global cluster environment for SF Sybase CE
      3.  
        About configuring a parallel global cluster using Volume Replicator (VVR) for replication
  7. Section VII. Installation reference
    1. Appendix A. Installation scripts
      1.  
        Installation script options
      2.  
        About using the postcheck option
    2. Appendix B. Sample installation and configuration values
      1.  
        SF Sybase CE installation and configuration information
      2.  
        SF Sybase CE worksheet
    3. Appendix C. Tunable files for installation
      1.  
        About setting tunable parameters using the installer or a response file
      2.  
        Setting tunables for an installation, configuration, or upgrade
      3.  
        Setting tunables with no other installer-related operations
      4.  
        Setting tunables with an un-integrated response file
      5.  
        Preparing the tunables file
      6.  
        Setting parameters for the tunables file
      7.  
        Tunables value parameter definitions
    4. Appendix D. Configuration files
      1.  
        About sample main.cf files
      2. Sample main.cf files for Sybase ASE CE configurations
        1.  
          Sample main.cf for a basic Sybase ASE CE cluster configuration under VCS control with shared mount point on CFS for Sybase binary installation
        2.  
          Sample main.cf for a basic Sybase ASE CE cluster configuration with local mount point on VxFS for Sybase binary installation
        3.  
          Sample main.cf for a primary CVM VVR site
        4.  
          Sample main.cf for a secondary CVM VVR site
    5. Appendix E. Configuring the secure shell or the remote shell for communications
      1. About configuring secure shell or remote shell communication modes before installing products
        1.  
          Manually configuring passwordless ssh
        2.  
          Setting up ssh and rsh connection using the installer -comsetup command
        3.  
          Setting up ssh and rsh connection using the pwdutil.pl utility
        4.  
          Restarting the ssh session
        5.  
          Enabling rsh for Linux
    6. Appendix F. High availability agent information
      1. About agents
        1.  
          VCS agents included within SF Sybase CE
        2.  
          VCS agent for Sybase included within SF Sybase CE
      2. CVMCluster agent
        1.  
          Entry points for CVMCluster agent
        2.  
          Attribute definition for CVMCluster agent
        3.  
          CVMCluster agent type definition
        4.  
          CVMCluster agent sample configuration
      3. CVMVxconfigd agent
        1.  
          Entry points for CVMVxconfigd agent
        2.  
          Attribute definition for CVMVxconfigd agent
        3.  
          CVMVxconfigd agent type definition
        4.  
          CVMVxconfigd agent sample configuration
      4. CVMVolDg agent
        1.  
          Entry points for CVMVolDg agent
        2.  
          Attribute definition for CVMVolDg agent
        3.  
          CVMVolDg agent type definition
        4.  
          CVMVolDg agent sample configuration
      5. CFSMount agent
        1.  
          Entry points for CFSMount agent
        2.  
          Attribute definition for CFSMount agent
        3.  
          CFSMount agent type definition
        4.  
          CFSMount agent sample configuration
      6. Process agent
        1.  
          Agent functions
        2.  
          State definitions
        3.  
          Attributes
        4.  
          Resource type definition
        5.  
          Sample configurations
      7.  
        Monitoring options for the Sybase agent
      8. Sybase resource type
        1.  
          Type definition for the Sybase agent
        2.  
          Attribute definitions for the Sybase agent

Configuring a Sybase ASE CE cluster under VCS control using the SF Sybase CE installer

A VCS service group is a collection of resources working together to provide application services to clients. A VCS service group typically includes multiple resources that are both hardware and software based. For example, a resource maybe a physical component such as a disk or network interface card, or a software component such as Sybase or a Web server, or a configuration component such as an IP address or mounted file system.

For an example configuration file:

See Sample main.cf for a basic Sybase ASE CE cluster configuration under VCS control with shared mount point on CFS for Sybase binary installation.

The SF Sybase CE installer enables you to configure VCS service groups for putting a basic Sybase ASE CE cluster under VCS control. For examples of the VCS service group dependencies for SF Sybase CE see the following diagrams.

Figure: Service group dependencies for an SF Sybase CE configuration on local disk group with VxFS displays the service group dependencies for an SF Sybase CE configuration on local disk group with VxFS.

Figure: Service group dependencies for an SF Sybase CE configuration on local disk group with VxFS

Service group dependencies for an SF Sybase CE configuration on local disk group with VxFS

Figure: Service group dependencies for an SF Sybase CE configuration on shared disk group with CFS displays the service group dependencies for an SF Sybase CE configuration on shared disk group with CFS.

Figure: Service group dependencies for an SF Sybase CE configuration on shared disk group with CFS

Service group dependencies for an SF Sybase CE configuration on shared disk group with CFS

Requirements for configuring the SF Sybase CE cluster under VCS control:

  • Install Veritas InfoScale Enterprise.

  • Configure SF Sybase CE.

  • Configure I/O fencing in Sybase mode.

  • Create Sybase user and group.

    See Sybase documentation.

  • Create a local or shared disk group, volume, and mount point for Sybase binary installation.

  • Install the Sybase ASE CE software

  • Create a shared disk group, volume and mount point for the Sybase ASE CE quorum device

  • Create a shared disk group, volume and mount point for the Sybase ASE CE datafiles

  • Create the Sybase ASE CE cluster

To put the Sybase ASE CE cluster and its resources under VCS control, the installer's configuration process will add the required resources to appropriate VCS service groups.

Table: Required resources for configuring Sybase ASE CE under VCS control lists the required resources for configuring Sybase ASE CE under VCS control.

Table: Required resources for configuring Sybase ASE CE under VCS control

Required resources

Example values

Resources for the Sybase ASE CE binary installation:

Example values for shared mount point:

Example values for local mount point:

  • Disk group

  • Mount point

  • Volume

  • sybbin_dg

  • /sybase

  • sybbin_vol

  • sybbin_dg_voldg

  • /sybase

  • sybbin_dg_vol

Resources for the Sybase ASE CE quorum device:

Example values for shared mount point:

  • Disk group

  • Mount point

  • Volume

  • quorum_dg

  • /quorum

  • quorum_vol

Resources for the Sybase ASE CE datafiles:

Example values for shared mount point:

  • Disk group

  • Mount point

  • Volume

  • dbdata_dg

  • /sybdata

  • sybvol

Any other CFS disk group, mount point, and volume used for Sybase ASE CE resources that are required by the Sybase ASE CE cluster

As needed

The quorum device name

/quorum/quorum.dat

Warning:

You will not be able to proceed using the installer to configure the Sybase ASE CE cluster under VCS control without the items listed in Table: Required resources for configuring Sybase ASE CE under VCS control

To configure VCS service groups for Sybase ASE CE

  1. Log in to the installer if you are not currently logged in.

    See Configuring the SF Sybase CE components using the script-based installer.

  2. When prompted to select an option from the main menu, choose the option: Configure Sybase ASE CE Instance in VCS.

    The installer will not be able to proceed any further unless you have the required resources available.

    See Table: Required resources for configuring Sybase ASE CE under VCS control.

  3. To select the type of file system where Sybase ASE CE binaries reside, choose one of the options.

    Veritas recommends CFS.

  4. Configure the Sybase ASE CE binary installation resources under VCS control. These are the resources which were created while preparing to install Sybase ASE CE.

    See Preparing for shared mount point on CFS for Sybase ASE CE binary installation. for shared mount point.

    See Preparing for local mount point on VxFS for Sybase ASE CE binary installation . for local mount point.

    To configure the Sybase resources under VCS control:

    • To select a disk group used for Sybase ASE CE installation, choose one of the options.

      Note:

      If you use Sybase ASE CE installation binaries on the local VxFS mount, you must specify the disk group for each node.

    • To select the volume used for Sybase ASE CE installation, choose one of the options.

    • Enter the mount point for the selected volume.

  5. The quorum device resources must be added into the resource group if it is under a different CFS than the Sybase database installation. These resources were created while preparing for a Sybase ASE CE cluster.

    See Preparing to create a Sybase ASE CE cluster.

    To configure the quorum device under VCS control:

    • Enter y if the quorum device is under a different CFS than the Sybase database resources you have configured in the previous step, otherwise enter n.

    • If you entered y, select a disk group for the quorum device.

    • Select a volume for the qourum device.

    • Enter y if there is a CFS on the volume you selected, otherwise enter n. The quorum device can use either a volume which you have selected directly or a file under CFS created on the selected volume.

    • Enter the mount point for the volume.

  6. If there are any other disk groups, volumes, or mount points used for the Sybase ASE CE cluster, such as other database files, for instance master, system, etc., which are using a different CFS, they must also be put under VCS control.

    To add other disk groups, volumes, and mount points to the resource group, enter y when prompted, otherwise enter n.

  7. Verify the disk groups, volumes and mount points information when prompted.
  8. To configure the Sybase ASE CE resources:

    • Enter the Sybase instance on ASE1 and ASE2 when prompted.

    • Enter the Sybase UNIX user name.

    • Enter Sybase home directory, where the Sybase binaries reside.

    • Enter Sybase version.

    • If required, enter the username and password for the Admin user. The default username is 'sa', password is''.

    • Enter the Sybase quorum device information.

      During configuration of Sybase instance under VCS control, if the quorum device is on CFS and is not mounted, the following warning message appears on the installer screen:

      Error: CPI WARNING V-9-0-0 The quorum file /quorum/quorum.dat 
cannot be accessed now. 
This may be due to a file system not being mounted.

      This message may be safely ignored. The resource will be onlined and available when the service is completed.

    • Verify the Sybase configuration information by entering y, otherwise enter n. For example:

      Sybase configuration information verification:

        Sybase Server on sys1: ASE1
        Sybase Server on sys2: ASE2
        Sybase UNIX user name: sybase
        Sybase home directory where sybase binaries reside: /sybase
        Sybase version: 15
        Sybase sa: sa
        Passwords are not displayed
        Sybase quorum: /quorum/quorum.dat

      Once you confirm the information is correct, the installer configures and onlines the VCS service groups for Sybase ASE CE. This completes the configuration of Sybase ASE CE under VCS control.

    • Note the location of the configuration log files for future reference.

  9. To verify the service groups have been created and are available online, enter:
    # hagrp -state
    hagrp -state
#Group                 Attribute        System       Value
cvm                     State           system1     |ONLINE|
cvm                     State           system2     |ONLINE|
quorum_voldgmnts        State           system1     |ONLINE|
quorum_voldgmnts        State           system2     |ONLINE|
sybasece                State           system1     |ONLINE|
sybasece                State           system2     |ONLINE|
sybbin_voldgmnts        State           system1     |ONLINE|
sybbin_voldgmnts        State           system2     |ONLINE|