Configuring the service group using the command-line

The Veritas Cluster Server Agent for Oracle comes with a sample configuration file that can be used as reference to directly modify your present configuration file. When you use this method, you must stop and restart VCS to implement the configuration.

See "About the sample configurations for Oracle enterprise agent" on page 89.

To configure the service group using the sample configuration file

  1. Log in to sysa as superuser.
  2. Ensure that all changes to the existing configuration have been saved and that further changes are prevented while you modify main.cf:

    # haconf -dump -makero

  3. To ensure that VCS is not running while you edit main.cf, issue the following command to stop the VCS engine on all systems and leave the resources available:

    # hastop -all -force

  4. Make a backup copy of the main.cf file:

    # cd /etc/VRTSvcs/conf/config

    # cp main.cf main.cf.orig

  5. Edit the main.cf file.

    You can use the file /etc/VRTSagents/ha/conf/Oracle/sample_main.cf for reference.

  6. Save and close the file.
  7. Verify the syntax of the file /etc/VRTSvcs/conf/config/main.cf:

    # cd /etc/VRTSvcs/conf/config/

    # hacf -verify .

  8. Start the VCS engine:

    # hastart

  9. Verify that all Oracle service group resources are brought online:

    # hagrp -state

  10. Take the service group offline and verify that all resources are stopped:

    # hagrp -offline service_group -sys system_name

    # hagrp -state

  11. Bring the service group online again and verify that all resources are available:

    # hagrp -online service_group -sys system_name

    # hagrp -state

  12. Start the VCS engine on sysb:

    # hastart

  13. Switch the Oracle service group to sysb:

    # hagrp -switch service_group -to sysb

  14. Verify that all Oracle service group resources are brought online on sysb:

    # hagrp -state

  15. On all the nodes, look at the following log files for any errors or status:

    /var/VRTSvcs/log/engine_A.log

    /var/VRTSvcs/log/Oracle_A.log

    /var/VRTSvcs/log/Netlsnr_A.log

Encrypting passwords

VCS provides a utility to encrypt database user passwords and listener passwords. You must encrypt the Pword attribute in the Oracle agent and the LsnrPwd attribute in the Netlsnr agent before configuring these attributes.

Oracle provides the option of storing the listener password in the listener.ora file, in both clear text and encrypted formats. Irrespective of the format in which the password is stored in Oracle, you must encrypt the password using the vcsencrypt utility before configuring the LsnrPwd attribute. This password, when decrypted should be of the same format as stored in the listener.ora file.

Note   You need not encrypt passwords when using the configuration wizard or the VCS Cluster Manager (Java Console) to configure attributes. The user passwords that are used for detail monitoring of the Oracle database are encrypted. The listener password that is considered for querying the status of the listener and stopping the listener is also encrypted.

To encrypt passwords

  1. From the path $VCS_HOME/bin/, run the vcsencrypt utility.
  2. Review as the utility encrypts the password and displays the encrypted password.
  3. Enter this encrypted password as the value for the attribute.
  4. Copy the encrypted password for future reference.