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
Uninstall the database
 
1 

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

2 

Open a console window.

3 

Enter the following:

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

4 

Enter the following to stop and disable the auxiliary database services:

# ./auxdbAdmin.sh stopAndDisableServices ↵

5 

Enter the following to stop the auxiliary database:

# ./auxdbAdmin.sh stop ↵

The following prompt is displayed:

Please enter auxiliary database dba password [if you are doing initial setup for auxiliary database, press enter]:

6 

Enter the dba password.

Information like the following is displayed:

Database samdb stopped successfully

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

Note: If the inital stop does not succeed, force_stop is attempted automatically until the auxiliary database is stopped. If the database does not stop, do not proceed to the next step and contact Nokia support for further assistance.

7 

Enter the following:

# ./auxdbAdmin.sh uninstall ↵

The script displays the following message and prompt:

THIS ACTION WILL ERASE YOUR DATABASE

Please type 'YES' to continue

8 

Enter YES. You are prompted for the dba password.

9 

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

Uninstall the software
 
10 

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