Thursday, December 17, 2009

The Oracle BAM Active Data Cache service failed to start - System.DllNotFoundException: Unable to load DLL (OraOps10.dll)

Issue :
##############
You start your DB and then try starting the BAM 10.1.3.x Services. Then, your BAM ADC Service fails to start with the following errors in the BAM ADC log::

2009-12-17 14:15:19,937 [2376] ERROR - ActiveDataCache The Oracle BAM Active Data Cache service failed to start. Oracle.BAM.ActiveDataCache.Common.Exceptions.CacheException: ADC Server exception in Startup(). ---> System.DllNotFoundException: Unable to load DLL (OraOps10.dll).
at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel, UInt32& StmtCacheSize)
at Oracle.DataAccess.Client.OraTrace.GetRegistryTraceInfo()
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleDataFactory.GetConnection()
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleStorageEngine.GetServerVersion()
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleStorageEngine.Startup(IDictionary oParameters)
at Oracle.BAM.ActiveDataCache.Kernel.Server.DataStoreServer.Startup()
--- End of inner exception stack trace ---
at Oracle.BAM.ActiveDataCache.Kernel.Server.DataStoreServer.Startup()
at Oracle.BAM.ActiveDataCache.Kernel.Server.Server.Startup()
at Oracle.BAM.ActiveDataCache.Service.DataServer.Run()
2009-12-17 14:16:29,843 [2088] INFO - ActiveDataCache The Oracle BAM Active Data Cache service is starting.
2009-12-17 14:16:29,859 [2088] INFO - Common Using an un-secured connection. Set the BAMSecureServerKey configuration setting to secure the connection.
2009-12-17 14:16:29,890 [2088] INFO - ActiveDataCache Starting up performance counters...
2009-12-17 14:16:29,906 [2088] INFO - ActiveDataCache Performance counters started up completely.
2009-12-17 14:16:30,015 [2088] ERROR - ActiveDataCache Unable to load DLL (OraOps10.dll).
2009-12-17 14:16:30,015 [2088] WARN - ActiveDataCache Exception occurred in method Startup

Stack trace:
at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel, UInt32& StmtCacheSize)
at Oracle.DataAccess.Client.OraTrace.GetRegistryTraceInfo()
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleDataFactory.GetConnection()
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleStorageEngine.GetServerVersion()
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleStorageEngine.Startup(IDictionary oParameters)
at Oracle.BAM.ActiveDataCache.Kernel.Server.DataStoreServer.Startup()

2009-12-17 14:16:30,015 [2088] ERROR - ActiveDataCache The Oracle BAM Active Data Cache service failed to start. Oracle.BAM.ActiveDataCache.Common.Exceptions.CacheException: ADC Server exception in Startup(). ---> System.DllNotFoundException: Unable to load DLL (OraOps10.dll).
at Oracle.DataAccess.Client.OpsTrace.GetRegTraceInfo(UInt32& TrcLevel, UInt32& StmtCacheSize)
at Oracle.DataAccess.Client.OraTrace.GetRegistryTraceInfo()
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Oracle.DataAccess.Client.OracleConnection..ctor(String connectionString)
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleDataFactory.GetConnection()
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleStorageEngine.GetServerVersion()
at Oracle.BAM.ActiveDataCache.Kernel.StorageEngine.Oracle.OracleStorageEngine.Startup(IDictionary oParameters)
at Oracle.BAM.ActiveDataCache.Kernel.Server.DataStoreServer.Startup()
--- End of inner exception stack trace ---
at Oracle.BAM.ActiveDataCache.Kernel.Server.DataStoreServer.Startup()
at Oracle.BAM.ActiveDataCache.Kernel.Server.Server.Startup()
at Oracle.BAM.ActiveDataCache.Service.DataServer.Run()
2009-12-17 14:16:50,687 [4980] INFO - ActiveDataCache The Oracle BAM Active Data Cache service is starting.
2009-12-17 14:16:50,703 [4980] INFO - Common Using an un-secured connection. Set the BAMSecureServerKey configuration setting to secure the connection.
2009-12-17 14:16:50,734 [4980] INFO - ActiveDataCache Starting up performance counters...
2009-12-17 14:16:50,750 [4980] INFO - ActiveDataCache Performance counters started up completely.
2009-12-17 14:16:50,828 [4980] ERROR - ActiveDataCache Unable to load DLL (OraOps10.dll).
2009-12-17 14:16:50,828 [4980] WARN - ActiveDataCache Exception occurred in method Startup







Solution :
####################
Go to your BAM installed home in your local folder. Copy the C:\OracleBAM\ClientForBAM\BIN location and then go to My Computer - > Advanced - Environment Variables - > Path - Edit - > Paste this location C:\OracleBAM\ClientForBAM\BIN as the first entry in the path. Click OK.
Now, try starting your BAM Services. All the services including your BAM ADC Service starts successfully with logs as below ::


2009-12-17 14:20:24,640 [2432] INFO - ActiveDataCache The Oracle BAM Active Data Cache service is starting.
2009-12-17 14:20:24,656 [2432] INFO - Common Using an un-secured connection. Set the BAMSecureServerKey configuration setting to secure the connection.
2009-12-17 14:20:24,671 [2432] INFO - ActiveDataCache Starting up performance counters...
2009-12-17 14:20:24,687 [2432] INFO - ActiveDataCache Performance counters started up completely.
2009-12-17 14:20:28,859 [2432] DEBUG - ActiveDataCache Data Storage Engine is Oracle
2009-12-17 14:20:32,750 [2432] DEBUG - ActiveDataCache ADC schema version is 1003.0
2009-12-17 14:20:36,296 [2432] INFO - ActiveDataCache Accepting requests on tcp:4033
2009-12-17 14:20:36,296 [2432] INFO - ActiveDataCache The Oracle BAM Active Data Cache service has started.
2009-12-17 14:20:37,453 [5272] DEBUG - ActiveDataCache Exists:SysIterUser
2009-12-17 14:20:37,546 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterUser:7afac3f8-17aa-4e14-89dc-e8e3467b47a5
2009-12-17 14:20:37,562 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 7afac3f8-17aa-4e14-89dc-e8e3467b47a5
2009-12-17 14:20:37,593 [5272] DEBUG - ActiveDataCache Exists:SysIterUser
2009-12-17 14:20:37,593 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterUser:86d705f0-8d27-4b34-b84a-ae7c0f01cefe
2009-12-17 14:20:37,593 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 86d705f0-8d27-4b34-b84a-ae7c0f01cefe
2009-12-17 14:20:37,609 [5272] DEBUG - ActiveDataCache Exists:SysIterRolePrivilegeMapping
2009-12-17 14:20:37,703 [5272] DEBUG - ActiveDataCache Exists:SysIterUser
2009-12-17 14:20:37,703 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterUser:839b2c8f-db8a-4c0f-b77d-6b4992f44690
2009-12-17 14:20:37,703 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 839b2c8f-db8a-4c0f-b77d-6b4992f44690
2009-12-17 14:20:37,703 [5272] DEBUG - ActiveDataCache Exists:SysIterMCProp
2009-12-17 14:20:37,734 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterMCProp:5598ea8e-a7b5-4bbd-a69e-1857309d9339
2009-12-17 14:20:37,734 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 5598ea8e-a7b5-4bbd-a69e-1857309d9339
2009-12-17 14:20:37,734 [5272] DEBUG - ActiveDataCache Exists:SysIterMCProp
2009-12-17 14:20:37,734 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterMCProp:1fb4f0fd-d9ea-4188-8aa0-9ecd9a3f8f5b
2009-12-17 14:20:37,734 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 1fb4f0fd-d9ea-4188-8aa0-9ecd9a3f8f5b
2009-12-17 14:20:37,953 [5272] DEBUG - ActiveDataCache Exists:SysIterMCProp
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterMCProp:542b423c-67ca-48c0-961d-02e76c978180
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 542b423c-67ca-48c0-961d-02e76c978180
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache Exists:SysIterMCProp
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterMCProp:cb67b151-d9ab-4cbf-a60b-34ae32fb8b3a
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: cb67b151-d9ab-4cbf-a60b-34ae32fb8b3a
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache Exists:SysIterMCProp
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterMCProp:a0c77d52-c331-4134-8615-28d256b23d8b
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: a0c77d52-c331-4134-8615-28d256b23d8b
2009-12-17 14:20:37,968 [5272] DEBUG - ActiveDataCache Exists:SysIterMCProp
2009-12-17 14:20:37,984 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterMCProp:ef7d8e46-206f-4765-9d25-d36d539c1b0b
2009-12-17 14:20:37,984 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: ef7d8e46-206f-4765-9d25-d36d539c1b0b
2009-12-17 14:20:38,000 [5272] DEBUG - ActiveDataCache Exists:SysIterUser
2009-12-17 14:20:38,015 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterUser:2b68b7b5-00ba-4f7a-bea7-d1d43c8e6510
2009-12-17 14:20:38,015 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 2b68b7b5-00ba-4f7a-bea7-d1d43c8e6510
2009-12-17 14:20:38,031 [5272] DEBUG - ActiveDataCache Exists:SysIterUser
2009-12-17 14:20:38,031 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterUser:8342b9b0-f4a9-4291-9474-01417e334b40
2009-12-17 14:20:38,031 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: 8342b9b0-f4a9-4291-9474-01417e334b40
2009-12-17 14:20:38,031 [5272] DEBUG - ActiveDataCache Exists:SysIterRule
2009-12-17 14:20:38,046 [5272] DEBUG - ActiveDataCache Exists:SysIterUser
2009-12-17 14:20:38,046 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterUser:c43efc38-6ca7-4ffd-857a-ddd9e1fb22af
2009-12-17 14:20:38,046 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: c43efc38-6ca7-4ffd-857a-ddd9e1fb22af
2009-12-17 14:20:38,046 [5272] DEBUG - ActiveDataCache Exists:SysIterUser
2009-12-17 14:20:38,062 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterUser:ab03cf32-2401-4469-8faf-7ff2f8938fc8
2009-12-17 14:20:38,062 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: ab03cf32-2401-4469-8faf-7ff2f8938fc8
2009-12-17 14:20:38,062 [5272] DEBUG - ActiveDataCache Exists:SysIterEscalation
2009-12-17 14:20:38,078 [5272] DEBUG - ActiveDataCache Exists:SysIterRule
2009-12-17 14:20:38,109 [5272] DEBUG - ActiveDataCache OpenViewset: SysIterRule:de488111-4227-43eb-9e56-7e645c1fbfad
2009-12-17 14:20:38,109 [5272] DEBUG - ActiveDataCache Insta-Close Viewset: de488111-4227-43eb-9e56-7e645c1fbfad
2009-12-17 14:20:38,109 [5272] DEBUG - ActiveDataCache Exists:SysIterUser

3 comments:

Anonymous said...

hello~nice to meet u..............................

Sanath Kumar Dattatreya said...

Hi Anirudh,

Thanks for the link. It helped me fix the issue.

Regards,
Sanath

Sanath Kumar Dattatreya said...

Hi Anirudh,

Thanks for the info. It helped.

Regards,
Sanath