linux下Oracle9i启动iSQLPLUS

配置过程如下：

1 配置HTTPD

$ cd $ORACLE_HOME/Apache/Apache/conf
$ vi httpd.conf

1.1 设定Server name或者Server IP地址和端口，使用非root用户启动HTTPD进程，其端口必须大于1024， 如： Listen=hpserv01:7777

1.2 设定DocumentRoot， 如DocumentRoot="/home/htdocs"

1.3 如果你也使用web server作为document content server，那么需要配置： IndexOptions NameWidth=* IndexOptions FoldersFirst AddIcon /icons/text.gif .txt .log


1.4 检查oracle_apache.conf文件 在httpd.conf的最后，iSQL*PLUS的配置文件包含在oracle_apache.conf中。


1.5 一个小BUG 注释jserv.properties中"wrapper.env.copy=DISPLAY"行，否则httpd进程不能启动。 $ vi $ORACLE_HOME/Apache/Jserv/etc/jserv.propertie #wrapper.env.copy=DISPLAY



2 配置TNS_NAMES 如：tnsnames.ora orcl92 = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = ORCL92) )(CONNECT_DATA = (SID = ORCL92)) )

3 启动HTTPD $ORACLE_HOME/Apache/Apache/bin/apachectl [start|stop]


4 登陆iSQL*PLUS /


5 以SYSDBA或SYSOPER登陆iSQL*PLUS dba 创建DBA口令文件 $ 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 配置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 at

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