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.