We are attempting to install the "Thoth Gateway: PL/SQL Gateway Module for Microsoft IIS" using the instructions from http://code.google.com/p/thoth-gateway/.
We are running APEX 4.2, IIS 6 and Oracle 11g. When we attempt to execute http://<server>/ThothGateway/pls/Default.aspx we receive the following error. Is the Thoth Gateway compatible with our environment? If it is compatible then how can we troubleshoot the problem?
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.
[NullReferenceException: Object reference not set to an instance of an object.] PLSQLGatewayModule.DadConfiguration.getVal(String name, String defaultValue) +12 PLSQLGatewayModule.DadConfiguration.get_NLSLanguageString() +17 PLSQLGatewayModule.DadConfiguration..ctor(String dadName) +95 PLSQLGatewayModule.GatewayRequest.ParseRequest(String requestMethod, String thePath, String rawUrl, String soapAction) +232 PLSQLGatewayModule.GatewayRequest..ctor(String serverName, String requestMethod, String requestPath, String rawUrl, String soapAction) +203 PLSQLGatewayModule.PLSQLHttpModule.HandleRequest(Object o, EventArgs a) +554 System.Web.SyncEventExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +68 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +75
I'm Morten, developer of the Thoth Gateway. The gateway should run fine in your environment.
However, the URL you use to access it should be of the form http://servername/pls/dadname where "dadname" maps to a DAD (Database Access Descriptor) that you have defined in the web.config file (as explained in the installation docs).
When you try to access "/pls/default.aspx", the gateway looks for a DAD called "default.aspx", which does not exist and gives you the error.
Try with a valid DAD definition and let me know how it works out.
<signature link removed by moderator >
We have the Thoth Gateway installed but are getting the following error in the Event log. Are you familiar with the error?
Event code: 3005
Event message: An unhandled exception has occurred.
Event time: 10/28/2013 9:45:50 AM
Event time (UTC): 10/28/2013 2:45:50 PM
Event ID: 6b5975b9cda84cad9e4d0935b80d14d2
Event sequence: 2
Event occurrence: 1
Event detail code: 0
Application domain: /LM/W3SVC/232667915/Root/pls-1-130274451498533565
Trust level: Full
Application Virtual Path: /pls
Application Path: D:\Inetpub\wwwroot\thoth\pls\
Machine name: BTCFPRASP003P
Process ID: 392
Process name: w3wp.exe
Account name: NT AUTHORITY\NETWORK SERVICE
Exception type: OracleException
Exception message: The provider is not compatible with the version of Oracle client
Request URL: http://btcfprasp003p.bok.com/pls/apex/apex
Request path: /pls/apex/apex
User host address: 10.10.7.53
Is authenticated: False
Thread account name: NT AUTHORITY\NETWORK SERVICE
Thread ID: 1
Thread account name: NT AUTHORITY\NETWORK SERVICE
Is impersonating: False
Stack trace: at Oracle.DataAccess.Client.OracleInit.Initialize()
Custom event details:
the error message is "The provider is not compatible with the version of Oracle client ", and it is most likely caused by you having multiple, incompatible versions of the Oracle Client on the same machine.
See this thread for more info:
And see this article about how to set up a separate set of client files just for your web application:
<signature link removed by moderator -- it goes into the BIO section of your profile, not into your posts >
Thanks for your replay. I have verified that I only have one version of the Oracle client installed (126.96.36.199.0). I have verified the I have the correct version of ODP.net (188.8.131.52). I have also tried the non-intrusive install. I continue to receive the above error in the Event Viewer. In addition, I am receiving the following error in the PLSQLGatewayModule.log. I should mention that the LOGON_USER is correct. It almost appears that the PLSQLGatewayModule.dll is not loading. Is that possible? Do you have any other suggestions?
2013-10-31 08:52:58,804  DEBUG PLSQLGatewayModule.PLSQLHttpModule Cookies: ORA_EPMWS_AccessibilityMode=false; ORA_EPMWS_ThemeSelection=BpmTadpole; LWSSO_COOKIE_KEY=4DU18_7zS7QND9mc4Qm8x5PT8gDfOtLmsjVjyzfQsUbtvKSHwCH4qCk-CeS-dykLhVUDc512wfHMfXCxQ2KS3AamIe33akHx1DRzaMohor5xBkUuL46sQMjwo7iIEBHDuh5jem4_TrnR2x8cN-Faz9BQIlZZ8K_1r3F6yKBTt0gItQjfhw-qWRFJa7FnEVXrMA4huh99RCynCMC7I8YDpA..
2013-10-31 08:52:58,804  DEBUG PLSQLGatewayModule.PLSQLHttpModule Current Windows user name (LOGON_USER) = NTPROD\abc123
2013-10-31 08:52:58,820  DEBUG PLSQLGatewayModule.PLSQLHttpModule Connecting with user apex_public_user to //btcfindbp011p.bok.com:1521/apexprod...
"I continue to receive the above error in the Event Viewer."
Then I suggest you do a reinstall of ODP.NET. First remove all traces of old installations by deleting the files, remove the appropriate Registry keys, and remove any references to the ODP.NET folders from the PATH environment variable. Do a search for "oci.dll" in all folders on the server to make sure you have got rid of all instances.
Then reboot the server, to make sure that DLLs already loaded are not kept by any processes such as IIS.
Finally, run the installation bat file included with ODP.NET to install it using default options.
"In addition, I am receiving the following error in the PLSQLGatewayModule.log."
I don't see any errors in the excerpt you provided, I just see some DEBUG statements... ?
"It almost appears that the PLSQLGatewayModule.dll is not loading. Is that possible?"
If it wasn't loading, then you would not see any lines in the gateway log file.