Sun Java System Application Server Enterprise Edition 8.1 2005Q2 Troubleshooting Guide

- Previous: Unable to Run configure-ha-cluster
- Next: Failure in configure-ha-cluster: Creating an HADB Instance Fails

# `hadbm set` Command Fails

## Description

`hadbm set` brings the database instance to a state that is hard to recover from.

Changing a database configuration variable with the `hadbm set` command fails. For example, setting `DataBufferPoolSize` to a larger size fails due to lack of shared memory on `node-0`. The `hadbm set` command leaves the database with `node-0` in a stopped state and `node-1` in a running state. Resetting the pool size back to the original value with the help of `hadbm set` fails with the message:

    22073: The operation requires restart of node 1. Its mirror node is
    currently not available. Use hadbm status --nodes to see the status of
    the nodes.

The `hadbm startnode 0` command is also of no use in this situation.

## Solution

Stop the database, then restore the old values using `hadbm set`, then restart the database.

- Previous: Unable to Run configure-ha-cluster
- Next: Failure in configure-ha-cluster: Creating an HADB Instance Fails

- © 2010, Oracle Corporation and/or its affiliates