CORAcleanup completes without registering any CI

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


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

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

 All Done.




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


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

The SERVICE_NAME and the SID must be the same:

"name" =



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



  (SERVICE_NAME = "name")



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.