Oracle9iiSQL * PLUS configuration process

The iSQL * PLUS structure is as follows: 1. Configure HTTPD $ cd $ ORACLE_HOMEApacheApacheconf $ vihttpd. conf1.1 sets the Servername or ServerIP address and port, and starts the HTTPD process with a non-root user. The port must be greater than 1024, for example, Listenhpserv01: 77771.2 sets DocumentRo.

The iSQL * PLUS structure is as follows: 1. Configure HTTPD $ cd $ ORACLE_HOME/Apache/conf $ vi httpd. conf 1.1 sets the Server name or Server IP address and port, and starts the HTTPD process with a non-root user. The port must be greater than 1024, for example, Listen = hpserv01: 7777 1.2 sets DocumentRo.

ISQL * PLUS
The configuration process is as follows:
1. Configure HTTPD
$ Cd $ ORACLE_HOME/Apache/conf
$ Vi httpd. conf
1.1 set the Server name or Server IP address and port and start the HTTPD process as a non-root user. The port must be greater than 1024,
For example, Listen = hpserv01: 7777
1.2 set DocumentRoot,
For example, DocumentRoot = "/home/htdocs"
1.3 if you also use web server as the document content server, you need to configure:
IndexOptions NameWidth = *
IndexOptions FoldersFirst
AddIcon/icons/text.gif. txt. log
1.4 check the oracle_apache.conf File
At the end of httpd. conf, the configuration file package of iSQL * PLUS is included in oracle_apache.conf.
1.5 a small BUG
Comment The Line "wrapper. env. copy = DISPLAY" in jserv. properties. Otherwise, the httpd process cannot be started.
$ Vi $ ORACLE_HOME/Apache/Jserv/etc/jserv. propertie
# Wrapper. env. copy = DISPLAY

2 configure TNS_NAMES
For example, tnsnames. ora
Orcl92 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC) (KEY = ORCL92)
) (CONNECT_DATA = (SID = ORCL92 ))
)

3. Start HTTPD
$ ORACLE_HOME/Apache/bin/apachectl [start | stop]

4. log on to iSQL * PLUS: 7777/isqlplus/

5 log on to iSQL * PLUS with SYSDBA or SYSOPER
: 7777/isqlplusdba
Create a DBA Password File
$ Cd $ ORACLE_HOME/sqlplus/admin
$ ORACLE_HOME/Apache/bin/htpasswd iplusdba. pw oracle
Automatically using MD5 format on Unix.
New password :*****
Re-type new password :*****
Adding password for user oracle

6 configure iSQL * PLUS
To change the settings 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
Details can be found in the SQL * Plus manual from the 9.2 documentation, available online

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

It is a new feature provided by Oracle9i Release2 (9.2). You can log in through a WEB browser. The results can be displayed in HTML tables with historical command tools. You can use the HTTPD password file to log on to iSQL * PLUS as SYSDBA or SYSOPER. In addition, it is easy to configure and uses standard CGI/Apache/Jserv without installing ORA9iAS.