Troubleshooting common problems

Occasionally you may encounter problems when using the Oracle database agent.

The following table describes the most common problems and provides standard workarounds.

Table: Common problems when using Oracle database agent

Error

Description

The Oracle service starts, but does not start the database.

Make sure the Oracle database parameter startmode is set to auto.

Make sure the path of the initialization file is set correctly.

Verify access to the shared virtual disk.

Clients cannot connect to the virtual IP address set for the service group.

Make sure that the listener service is running. Verify that the listener is configured with virtual IP address in the host location.

Resource returns offline during detail monitoring.

This could occur because the database is offline or has not been mounted or opened properly. Check the error in the log file for further details.

Verify the configuration definition of the agent. Make sure that the correct file name is specified in the configuration. Verify access to sqlplus from the command prompt.

The sqlplus script cannot be run because sqlplus returns a process error.

If the script timed out, increase the timeout value set in the attribute SQLTimeOut. Otherwise, try recreating the Oracle service using the oradim utility.

The Oracle wizard could not locate PFILE or SPFILE for a database.

Make sure the initialization file settings are configured correctly.

Listener service does not start after configuring the virtual IP address.

Make sure the virtual IP address is configured correctly for the listeners.

Another possible cause is that the listener.ora file is corrupted.

Complete the following steps in the order given:

  • Stop the listener services on the node.

  • Rename the listener.ora file.

  • Recreate the listeners using the Net Configuration Assistant.

  • Bring up the virtual IP on the node.

  • Configure the virtual IP address for the newly created listeners using the Net Manager.

  • Restart the listener services.

  • Run lsnrctl status command for each listener to verify the virtual IP address.

Refer to the Oracle documentation for instructions on using the Net Configuration Assistant and the Net Manager.

More Information

Verifying the initialization file settings