To uninstall an NSP auxiliary database

Description
CAUTION 

CAUTION

Data Loss

Performing this procedure permanently erases all auxiliary database data.

Before you perform this procedure, ensure that you have a backup of the auxiliary database, if the data is of value.

The following steps describe how to delete an NSP auxiliary database and remove the auxiliary database software from all auxiliary database stations.

Note: You require the following user privileges on each auxiliary database station:

  • root

  • dba user

Note: A leading # character in a command line represents the root user prompt, and is not to be included in a typed command.

Steps
Stop and disable auxiliary database proxies
 
1 

Perform the following to stop and disable the auxiliary database proxy services in the auxiliary database cluster that you are uninstalling.

  1. Log in as the root user on each auxiliary database station in the cluster.

  2. Perform one of the following:

    1. If Release 23.11 or later is installed, enter the following:

      # systemctl stop nspos-auxdbproxy.service ↵

      # systemctl disable nspos-auxdbproxy.service ↵

    2. If Release 23.8 or earlier is installed, enter the following:

      # systemctl stop nfmp-auxdbproxy.service ↵

      # systemctl disable nfmp-auxdbproxy.service ↵

Uninstall the database
 
2 

Log in as the root user on a station in the auxiliary database cluster that you are uninstalling.

3 

Open a console window.

4 

Enter the following:

# cd /opt/nsp/nfmp/auxdb/install/bin ↵

5 

Enter the following to block external access to the auxiliary database ports:

# ./auxdbAdmin.sh shieldsUp ↵

6 

Enter the following to stop the auxiliary database:

# ./auxdbAdmin.sh stop ↵

7 

Enter the following to display the auxiliary database status:

# ./auxdbAdmin.sh status ↵

Information like the following is displayed:

Database status

 Node       | Host          | State | Version | DB

------------+---------------+-------+---------+-------

 node_1     | internal_IP_1 | STATE | version | db_name

 node_2     | internal_IP_2 | STATE | version | db_name

.

.

.

 node_n     | internal_IP_n | STATE | version | db_name

      Output captured in log_file

The cluster is stopped when each STATE entry reads DOWN.

Note: If the cluster is not stopped, enter the following to force the auxiliary database to stop.

# ./auxdbAdmin.sh force_stop ↵

8 

Repeat Step 7 periodically until the cluster is stopped.

Note: You must not proceed to the next step until the cluster is stopped.

9 

Enter the following:

# /opt/nsp/nfmp/auxdb/install/bin/auxdbAdmin.sh uninstall ↵

The script displays the following message and prompt:

THIS ACTION WILL ERASE YOUR DATABASE

Please type 'YES' to continue

10 

Enter YES. You are prompted for the dba password.

11 

Enter the password.

The following messages are displayed as the database is stopped and the database objects are removed from each station:

Dropping auxiliary database ...

Removing data and catalog directories from all nodes

12 

Enter the following:

# ./auxdbAdmin.sh shieldsDown ↵

Uninstall the software
 
13 

Perform the following steps on each auxiliary database station.

  1. Log in to the station as the root or NSP admin user.

  2. Open a console window.

  3. Enter the following to remove the auxiliary database packages:

    # dnf erase nspos-auxdb nspos-jre vertica ↵

    The dnf utility resolves any package dependencies and displays the following prompt:

    Remove 3 Package(s)

    Installed size: nnn M

    Is this ok [y/N]:

  4. Enter y. The packages are removed.

  5. When all packages are removed, enter the following to back up the contents of the /opt/vertica/log directory:

    # tar czf /opt/nsp/nfmp/auxdb/install/log/opt_vertica_log_$(date +%Y%m%d_%H%M%S).tgz /opt/vertica/log ↵

  6. Enter the following to remove the /opt/vertica directory and contents:

    # cd /opt ↵

    # rm -rf vertica ↵

  7. Enter the following to reboot the station:

    # systemctl reboot ↵

    The station reboots.

End of steps