Oracle 9i HTTP server won't start

[Peter Hug]

I had Oracle 8.1.7 installed on my Windows XP Pro machine and upgraded to Oracle 9i. Somehow Oracle 8.1.7 was left installed so I removed it explicitly. In turn, this screwed up the newly installed 9i version so I reinstalled it. Orcale 9i works fine now with the exception of XDB and HTTP.

When I try to start the HTTP service using the SMC, the service stops immediately after starting and leaves the following message in the application event log:

The Apache service named OracleOraHome91HTTPServer reported the following error:
>>> [Wed Jan 12 13:08:19 2005] [error] Config file inaccessible thru env var WV_GATEWAY_CFG : [Not set] <<<
before the error.log file could be opened.
More information may be available in the error.log file.

I also have a problem with XDB and wonder if the two somehow interfer with one another. Whenever I try to do anything on XDB using the Enterprise Manager Console I get an error and then need to reconnect to my database to do anything.

I have uninstalled XDB and reinstalled Oracle 9i HTTP but I still experience the exact same behaviour.

What can I do?

[Indira Aramandla]

Hi Peter,

When you have one version of Oracle RDBMS software on the server also install another release in a different ORACLE_HOME.

In you case when you installed and Reinstalled this must had resulted in the WV_GATEWAY_CFG system variable to be set incorrectly leading to the error â Config file wdbsvr.app inaccessible thru env var WV_GATEWAY_CFGâ May be the WV_GATEWAY_CFG system variable is being appended to instead of overwritten and therefore it is set to an invalid value.
Command to manually start the Oracle Apache HTTP server:
c:\ORACLE_HOME\Apache\Apache\Apache.exe -k start -d

Metalink provides the follow these steps to update WV_GATEWAY_CFG:

1. Execute System program from Control Panel

2. Select the folder Environment and navigate to the System variable section

3. Select the variable WV_GATEWAY_CFG and update the value to be the correctdirectory path for file wdbsvr.app.

Example:
WV_GATEWAY_CFG = c:\ORACLE_HOME\apache\modplsql\cfg\wdbsvr.app

4. Reboot the machine for the change to take effect.

In

[Steven E. Protter]

The only acceptable way to uninstall Oracle products is with the appropriate version of the Universal Installer.

If you used any other method, you probably need to reinstall your chosen database version from scratch.

SEP

[T G Manikandan]

Set the variable WV_GATEWAY_CFG pointing to wdbsvr.app in your oracle installation path.

Revert

[Peter Hug]

Thanks everybody for your help. I added an environment variable as follows:

WV_GATEWAY_CFG=C:\oracle\ora91\Apache\modplsql\cfg\wdbsvr.app

(the path is correct for my system and wdbsvr.app exists)

This brought me a bit closer I guess but the HTTP server still doesn't start. I now find these two messages in the log (in chronological order):

The Apache service named OracleOraHome91HTTPServer reported the following error:
>>> fopen: No such file or directory <<<
before the error.log file could be opened.
More information may be available in the error.log file.

The Apache service named OracleOraHome91HTTPServer reported the following error:
>>> apache.exe: could not open document config file c:/oracle/ora91/oem_webstage/oem.conf <<<
before the error.log file could be opened.
More information may be available in the error.log file.

I'm not sure if the source of these problems is the line:

include "C:\oracle\ora91/oem_webstage/oem.conf"

in the file C:\oracle\ora91\Apache\Apache\conf\oracle_apache.conf. A fact is that I don't have that file and I wouldn't know what contents it was expected to have.

Any ideas?

[Peter Hug]

In the meantime I got it working. I found an oem.conf file on the web and fiddled with it until it looked like this:



ServerName Athena
DocumentRoot "D:\oracle\ora91/oem_webstage/"

Options Indexes FollowSymLinks
AllowOverride None
Order allow,deny
Allow from all


DirectoryIndex emwebsite.html
ScriptAlias /cgi-bin/ "D:\oracle\ora91/oem_webstage/cgi-bin/"
ScriptAlias /oem_webstage/cgi-bin/ "D:\oracle\ora91/oem_webstage/cgi-bin/"
Alias /oem_webstage/ "D:\oracle\ora91/oem_webstage/"


AllowOverride all
Allow from all

# ApjServGroupMount /em balance://group1/oemreporting




Then I still got another error which complained about this line:

# FastCgiServer C:\oracle\ora91\bin\isqlplus -port 8228 -initial-env iSQLPlusNumberOfThreads=20 -initial-env iSQLPlusTimeOutInterval=30 -initial-env iSQLPlusLogLevel=off -initial-env iSQLPlusAllowUserEntMap=none -idle-timeout 3600

in file C:\oracle\ora91\sqlplus\admin\isqlplus.conf. I simply commented it out an the HTTP server now works fine. I wonder what the cause of all these problems actually was?

[Indira Aramandla]

Hi Peter,

I think is this because of duplicate entry of include "c:\oracle\ora9i\sqlplus\admin\isqlplus.conf" in the oracle_apache.conf file. The problem seems to be the duplicate entries in the conf files affected
You may want to verify that the isqlplus.conf file is not being loaded twice. I think this file is included in the oracel_apache.conf file. Check your oracle_apache.conf file for duplicate lines include "E:\oracle\ora92\oem_webstage\oem.conf"

When you re-install iSQLPlus the installer adds another line to the oracle_apache.conf each time you re-install iSQLPlus.
The fix will be tp remove the duplicate entry.

Indira A