Re: error when running Oracle's HTTP server

Alison Holloway wrote:

> The Oracle HTTP Server may already be running as a service, and you are trying to start it
> using the command line option (from the Start menu). Try this SQL*Plus FAQ entry on OTN:
>
> http://otn.oracle.com/support/tech/sql_plus/htdocs/runtime.html#isql_mutex_error
>
> Norris wrote:
> > In Oracle9.2.0.1, when I try to run HTTP server powered by Apache, it gives
> > out
> > the syntax error in the file e:\oracle\sqlplus\admin\isqlplus.conf
> > Can someone tell me what is the syntax error of the following line and how
> > to fix it? I never touch the file before.
> >
> > FastCgiServer e:\oracle\bin\isqlplus -port 8228 -initial-env
> > iSQLPlusNumberOfThreads=20 -initial-env
> > iSQLPlusTimeOutInterval=30 -initial-env iSQLPlusLogLevel=off -initial-env
> > iSQLPlusAllowUserEntMap=none -idle-timeout 3600
>

<RANT>

One of things I have noticed about iSQL*Plus and other Oracle uses of the Apache server is that there are some very unintuitive aspects.

For example: Go into the control panel and start the Apache service. Then try to use the item on the START menu and you get an error? Why? The reverse is also true. And the error message lead to nowhere other than metalink.

The other thing is that the entire environment of the isqlplus.conf file is contrary to what is expected in an Oracle environment. The file is a parameter file and should logically be placed with other parameter files in $ORACLE_HOME/database or $ORACLE_HOME/dbs. Speaking of which why this totally unnecessary difference between Windows and UNIX environments. There should be a single architecture and one of these two subdirectories should just be dumped.

</RANT>

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)