CORAcleanup completes without registering any CI

Document ID : KB000029488
Last Modified Date : 14/02/2018
Show Technical Document Details

Symptoms: 

Running coracleanup utility on MDB installed on Oracle returned the following output:

 Result: Assets Read = 240094, Registration Successful = 0, Registration Failed = 0

 All Done.

 

Environment: 

 

This document applies to Service Desk Manager r12.x and 14.1.
 

Resolution:

  • The first point to check is how tnsnames.ora is defined.

The SERVICE_NAME and the SID must be the same:

"name" =

(DESCRIPTION =

  (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = "server")(PORT = 1521))

  )

(CONNECT_DATA =

  (SERVICE_NAME = "name")

    (SERVER = DEDICATED)

  )

If you don't have it set this way, setting them to the same should resolve the issue.

  • The second point to check is the environment variable TNS_ADMIN. In a Service Desk Manager installation with Oracle, it is a pre-requisite to have both 32 and 64 bit Oracle Clients installed. If the first step described doesn't resolve the problem, variable TNS_ADMIN must point to the Oracle Client 64 bit installation.

 

With both the above correctly set - tnsnames.ora and TNS_ADMIN - coracleanup will register the CIs.