Hitachi

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


KAVF12620-W

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

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

(S)

Continues Agent Collector processing.

(O)

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

  • errcode value is 942

    Make sure that collection is not being performed for records that cannot be collected under the current configuration. Alternatively, make sure that the required system privileges have been granted to the Oracle account specified for oracle_user. When granting privileges as a role, grant the system privileges explicitly using GRANT privileges.

  • errcode value is 6550

    The sp_inst.sql needs to be executed on the collection target Oracle Database. For details about how to execute this script, 2.1.4(3) Set up an instance environment (for Windows), or 3.1.4(4) Set up an instance environment (for UNIX).

    Note that you must execute the sp_inst.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_inst.sql script.

  • errcode value is 1013

    Performance data collection may be canceled due to the cancellation facility. In this case, check whether the KAVF12636-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. You can solve this problem by specifying Y for sqlnet when setting up an instance environment. For details about checking the instance environment, see 2.4.2 Updating an instance environment (for Windows), or 3.4.2 Updating an instance environment (for UNIX).

  • errcode value is another value

    For details about what to do, see the Oracle documentation.