Problem: Need to determine status or version of NFM-P database or Oracle proxy

Purpose

Perform the following procedure to determine the status of the NFM-P database or Oracle proxy, each of which starts automatically during NFM-P database station initialization.

Steps
 
1 

Log in as the Oracle management user on the database station.

2 

Open a console window.

3 

Navigate to the /opt/nsp/nfmp/db/install/config/db directory

4 

Enter the following command.

bash$ ./oracleproxy.sh option ↵

where option is one of the options in the table below.

Table 4-5: oracleproxy.* flag options

Flag option

Description

start

Starts the Oracle proxy

no option, or help

Lists the available options

proxy_version

Displays Oracle proxy version information

proxy_status

Displays Oracle proxy status information

db_version

Displays NFM-P database version information

db_status

Displays NFM-P database status information

5 

Review the command output.

The following sample shows the output of the proxy_status option.

Proxy is UP

The following sample shows the output of the db_version option.

NSP Version Release - Built on Wed Mar 27 03:14:15 EST 20XX
6 

Close the console window.

End of steps