SecretServer Oracle Account Heartbeat Fails - IBM

Problem

Objective: To Manage and monitor heartbeats of Oracle Accounts with SecretServer. (Just manage and monitor the credential status in the database). After adding an account to test, the heartbeat failed with the following message: "Secret 'Oracle_TEST' (Id = 33) returned (UnknownError). Exception: The Oracle.DataAccess.dll was not found in the paths [C:\inetpub\wwwroot\SecretServer\bin,C:\Windows\Microsoft.NET\Framework64\v4.0.30319\Temporary ASP.NET Files\secretserver\eb35b00a\BackgroundWorkerServerRole\assembly\dl3\0797d6f2\2e9b61d6_faf6d501]." "Secret 'Oracle_TESTE' (Id = 33) returned (UnknownError). Exception: Failure while using Oracle.DataAccess.Client to build a connection string, System.Exception: Failure while using Oracle.DataAccess.Client to build a connection string ---> System.IO.FileLoadException: Could not load file or assembly 'Oracle.DataAccess, Version=4.122.19.1, Culture=neutral, PublicKeyToken=89b483f429c47342' or one of its dependencies. The located assembly's manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMarkHandle stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName, ObjectHandleOnStack type) at System.RuntimeTypeHandle.GetTypeByName(String name, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark, IntPtr pPrivHostBinder, Boolean loadTypeFromPartialName) at System.RuntimeType.GetType(String typeName, Boolean throwOnError, Boolean ignoreCase, Boolean reflectionOnly, StackCrawlMark& stackMark) at System.Type.GetType(String typeName) at System.Data.Common.DbProviderFactories.GetFactory(DataRow providerRow) at Thycotic.PasswordChangers.Oracle.OracleStringBuilder.BuildString(Boolean asSys) --- End of inner exception stack trace --- at Thycotic.PasswordChangers.Oracle.OracleStringBuilder.BuildString(Boolean asSys) at Thycotic.PasswordChangers.Oracle.OracleStringBuilder.GetConnectionString(String dataSource, String username, String password, Boolean asSys, String host, String customSetting, String customPort, String database, Boolean integrated, Boolean forceTranslateValuesToDataSource, String explicitConnectionStringFormat) at Thycotic.PasswordChangers.Oracle.OracleCredentialsVerifier.VerifyCredentials(OracleVerifyInfo info)"

Resolving The Problem

Troubleshooting: Followed the steps of the article to configure Oracle Database Access Components (ODAC). https://www.ibm.com/support/pages/node/6151983 Followed all steps, reboot after configured the .dll, iisreset, the heartbeat still fails. The problem is that the Oracle service is running on a IP address, and the host is configured with another IP address. To see the IP address of the Oracle service, issue an lsnrctl status command and check the address reported (in this case is 127.0.0.1, the localhost): (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Document Location

Worldwide

[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSWHLP","label":"IBM Security Secret Server"},"ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"All Version(s)","Line of Business":{"code":"LOB24","label":"Security Software"}}]