Configuration process for oracle9i Isql*plus

Isql*plus
Structure as follows: The configuration process is as follows:
1 Configuration httpd
$ cd $ORACLE _home/apache/apache/conf
$ VI httpd.conf
1.1 Set the server name or server IP address and port, start the httpd process with a non-root user, the port must be greater than 1024,
such as: listen=hpserv01:7777
1.2 Set DocumentRoot,
such as documentroot= "/home/htdocs"
1.3 If you also use Web server as document content server, you need to configure:
Indexoptions namewidth=*
Indexoptions Foldersfirst
Addicon/icons/text.gif. txt. log
1.4 Check oracle_apache.conf file
At the end of httpd.conf, the Isql*plus configuration file is included in the oracle_apache.conf.
1.5 A small bug
Note the "Wrapper.env.copy=display" line in Jserv.properties, or the httpd process will not start.
$ VI $ORACLE _home/apache/jserv/etc/jserv.propertie
#wrapper. Env.copy=display

2 Configuration Tns_names
such as: Tnsnames.ora
Orcl92 =
(DESCRIPTION =
(Address_list =
(address = (PROTOCOL = IPC) (KEY = ORCL92)
) (Connect_data = (SID = ORCL92))
)

3 Start httpd
$ORACLE _home/apache/apache/bin/apachectl [Start|stop]

4 Landing Isql*plus Http://hpserv01:7777/isqlplus/

5 Landing isql*plus with SYSDBA or sysoper
Http://hpserv01:7777/isqlplusdba
Creating a DBA Password file
$ cd $ORACLE _home/sqlplus/admin
$ORACLE _home/apache/apache/bin/htpasswd IPLUSDBA.PW ORACLE
Automatically using MD5 format on Unix.
New Password: * * *
Re-type New Password: * * *
Adding password for user Oracle

6 Configuration Isql*plus
To change the settings for you must edit the isqlplus.conf configuration file then stop and start the HTTP daemons.
The configuration file lives in $ORACLE _home/sqlplus/admin.
Currently, the following server parameter settings can be adjusted:isqlplusnumberofthreads
Isqlplusloglevel
Isqlplustimeoutinterval
Isqlplushashtablesize
Isqlplusconnectidlist
-idle-timeout
The Details can is found in the Sql*plus manual to the 9.2 documentation, available online at http://tahiti.oracle.com.

7 Ora9ir2 SP
A patch is available as a download from metalink-the Oracle bug ID is 2581911

Oracle9i Release2 (9.2) is a new feature provided by the Web browser login. You can display the result as an HTML table with a History command tool. You can login to Isql*plus by SYSDBA or sysoper identity via httpd password file. In addition, its configuration is very simple, using standard cgi/apache/jserv, and does not need to install Ora9ias.