How to Verify That the Oracle Database Is Running

This procedure describes how use the Oracle Database Plug-In to verify that a single instance of the Oracle database is currently running..

Steps

1. In the Common Tasks section of the N1 SPS browser interface, select the appropriate Oracle Database entry.

2. On the Oracle Database Common Tasks page, click Verify.

3. On the Plans Details page, click Run.

4. On the Plan Details Run page, provide plan variables information.

   1. Set the version settings by clicking on the appropriate link in the Plan Parameters table.

   2. Set the variable settings by clicking on the appropriate link in the Plan Parameters table.

   3. Select the target host on which you want to verify that the database is running.

   4. In the Plan Variables section, set the install path of the single instance component.

   5. In the Plan Variables section, set the name of the Oracle service that you want to stop on the target host.

5. Click Run Plan (includes preflight).

6. Verify that the Oracle database is running by clicking the stdout link.

   The status of the database is displayed in the stdout window.

   • If the database is running, a message that is similar to the following is displayed.

     Total System Global Area 320308312 bytes Fixed Size 730200 bytes Variable Size 285212672 bytes Database Buffers 33554432 bytes Redo Buffers 811008 bytes

   • If the database is not running, a message that is similar to the following is displayed.

     ORA-01034: ORACLE not available

Troubleshooting

If the Oracle database is not running, restart the database. For more information, see How to Start the Oracle Database.