Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g (1014 Views)
Reply
Frequent Advisor
Sethi
Posts: 45
Registered: ‎05-30-2008
Message 1 of 8 (1,014 Views)

Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

Hi,

I am getting the error "Could not load DLL sqoracle.oci10.DLL" while trying to connect SM7.01 with Oracle 10g.
The error from the sm.log file is below:

Could not load DLL sqoracle.oci10.DLL
Failed to load library 'sqoracle.oci10.DLL'
Error populating pointers to SQL functions
Failure opening 'dbdict' file, terminating.
Failed to initialize one or all of the core files( dbdict, code, format and link)
runServlet: inhook failed!


plz. help me in resolving this issue.
Thanks in advance.
Please use plain text.
Honored Contributor
IrisGeist
Posts: 478
Registered: ‎04-06-2007
Message 2 of 8 (1,003 Views)

Re: Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

Do you have the Oracle 10 client installed on the Service Manager server? The client is required for Service Manager to connect to the Oracle database.
Please use plain text.
Frequent Advisor
Sethi
Posts: 45
Registered: ‎05-30-2008
Message 3 of 8 (1,003 Views)

Re: Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

Hi,

Thanks for quick reply,

I had restarted the machine and was able to connect to SM with Oracle.
But still I am not sure why earlier the error was generated.

Thanks,
Gaurav
Please use plain text.
Occasional Advisor
AsmerM
Posts: 7
Registered: ‎03-12-2014
Message 4 of 8 (407 Views)

Re: Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

[ Edited ]

Hi, I have the same problem on SM9.30 with Oracle 11gR2. Error log:

 

Command line: C:\HP\Service Manager 9.30\Server\RUN\sm -sqlverifyconnection
Could not load DLL sqoracle.oci10.DLL
Error 193 in call LoadLibrary - [UNKNOWN]
Failed to load library 'sqoracle.oci10.DLL'
Failed to load SQL client shared libraries, terminating.
-Memory : S(52304) O(103756) MAX(160156) - MALLOC's Total(105)
Thread termination in progress
Unable to obtain lock in interm().
Total number of recorded stacks: 0
Process termination cleanup complete (exit code=1)

 

Restarting the server does not work.

 

Please use plain text.
HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 5 of 8 (403 Views)

Re: Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

HI

 

I found a KM article on this error

 

Service Manager Server is a 32-bit application and will run as a native 32-bit application on the supported OS. Service Manager connects to Oracle and DB2 databases via native clients and to SQLServer via ODBC driver. All database clients should be 32-bit version of the database client. The Service Manager server using the 32-bit client can connect to 32-bit or 64-bit database server

Workaround / Fix

Use the 32 bit client

"HP Support
If you find that this post or any post resolves your issue, please make sure to mark it as an accepted solution."
Please use plain text.
Occasional Advisor
AsmerM
Posts: 7
Registered: ‎03-12-2014
Message 6 of 8 (397 Views)

Re: Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

I have installed 32-bit Oracle client, and added its path to PATH environmnet variable. Same error....
Please use plain text.
Honored Contributor
Jas1
Posts: 400
Registered: ‎04-05-2010
Message 7 of 8 (385 Views)

Re: Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

If your Oracle server is not sharing the same box as SM, a 32bit oracle client is mandatory.

 

 

Check if you have these lines in your sm.ini

 

[oracle10]
sqldictionary:oracle10
sqllibrary:sqoracle.oci10.DLL

 

and that you have sqoracle.oci10.dll in your RUN folder.

Please use plain text.
Occasional Advisor
AsmerM
Posts: 7
Registered: ‎03-12-2014
Message 8 of 8 (192 Views)

Re: Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g

I installed Oracle 32-bit client, and connection information to oracle sever was wrong. After correcting values, everything worked without problems.

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation