Could not load DLL sqoracle.oci10.DLL error when running SM7.01 with Oracle 10g (1266 Views)
Reply
Frequent Advisor
Sethi
Posts: 45
Registered: ‎05-30-2008
Message 1 of 8 (1,266 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.
Honored Contributor
IrisGeist
Posts: 478
Registered: ‎04-06-2007
Message 2 of 8 (1,248 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.
Frequent Advisor
Sethi
Posts: 45
Registered: ‎05-30-2008
Message 3 of 8 (1,248 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
Occasional Advisor
AsmerM
Posts: 7
Registered: ‎03-12-2014
Message 4 of 8 (652 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.

 

HP Expert
lisajo
Posts: 480
Registered: ‎02-15-2010
Message 5 of 8 (648 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."
Occasional Advisor
AsmerM
Posts: 7
Registered: ‎03-12-2014
Message 6 of 8 (642 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....
Honored Contributor
Jas1
Posts: 434
Registered: ‎04-05-2010
Message 7 of 8 (630 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.

Occasional Advisor
AsmerM
Posts: 7
Registered: ‎03-12-2014
Message 8 of 8 (437 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.

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.