Hitachi

JP1 Version 12 JP1/Performance Management - Remote Monitor for Oracle Description, User's Guide and Reference


KAVL18302-W

An OCI call failed because of function function-name. (rc=return-code, errcode=error-number)

An OCI call resulted in an error during connection establishment with the Oracle Database.

(S)

Continues Remote Monitor Collector service processing.

(O)

Take one of the actions listed below on the basis of the Oracle error number:

  • errcode value is 942

    Check if you are attempting to collect a record that is not supported by the current configuration. Alternatively, make sure that the required system privileges have been granted to the Oracle account specified for oracle_user. When granting permissions as a role, grant the system privileges explicitly using GRANT privileges.

  • errcode value is 1017 or 1031

    An attempt to log in to the Oracle Database to be monitored failed because the user name or password was invalid. Check whether the user name and the password you specified during setup of the instance environment are correct. For details about how to check the instance environment, see 2.6.3 Updating an instance environment.

  • errcode value is 6550

    You need to execute the sp_rist.sql script for the Oracle Database subject to data collection. For details about how to execute the script, see 2.1.4(3) Set up an instance environment (for Windows), or 2.2.4(4) Set up an instance environment (in UNIX).

    Note that you must execute the sp_rist.sql script after connecting to the Oracle Database with the account that was specified for oracle_user during setup of the instance environment. Check the account that was used to execute the sp_rist.sql script.

  • errcode value is 1013

    Performance data collection may be canceled due to the cancellation facility. In this case, check whether the KAVL18636-I message has been output to the common log of the agent log. To prevent collection data from being canceled, change the timeout value.

  • errcode value is 12546

    If another user (OTHER user) lacks execution permissions for the files in the Oracle home directory (same value as the ORACLE_HOME environment variable), a connection to the Oracle Database may be unable to be established. For details about checking the instance environment, see 2.6.3 Updating an instance environment

  • When any other value is displayed for errcode

    See the Oracle manual and take appropriate action.