iSQL*PLUS
结构如下 配置过程如下
配置HTTPD
$ cd $ORACLE_HOME/Apache/Apache/conf
$ vi
设定Server name或者Server IP地址和端口使用非root用户启动HTTPD进程其端口必须大于
如 Listen=hpserv:
设定DocumentRoot
如DocumentRoot="/home/htdocs"
如果你也使用web server作为document content server那么需要配置
IndexOptions NameWidth=*
IndexOptions FoldersFirst
AddIcon /icons/textgif txt log
检查oracle_apacheconf文件
在的最后iSQL*PLUS的配置文件包含在oracle_apacheconf中
一个小BUG
注释jservproperties中"wrapperenvcopy=DISPLAY"行否则httpd进程不能启动
$ vi $ORACLE_HOME/Apache/Jserv/etc/jservpropertie
#wrapperenvcopy=DISPLAY
配置TNS_NAMES
如tnsnamesora
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = ORCL)
)(CONNECT_DATA = (SID = ORCL))
)
启动HTTPD
$ORACLE_HOME/Apache/Apache/bin/apachectl [start|stop]
登陆iSQL*PLUS http://hpserv:/isqlplus /
以SYSDBA或SYSOPER登陆iSQL*PLUS
http://hpserv:/isqlplusdba
创建DBA口令文件
$ cd $ORACLE_HOME/sqlplus/admin
$ORACLE_HOME/Apache/Apache/bin/htpasswd iplusdbapw oracle
Automatically using MD format on Unix
New password: *****
Retype new password: *****
Adding password for user oracle
配置iSQL*PLUS
To change the settings you must edit the isqlplusconf 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
idletimeout
Details can be found in the SQL*Plus manual from the documentation available online at
ORAiR SP
A patch is available as a download from Metalink the Oracle bug ID is
是Oraclei Release()提供的新功能通过WEB浏览器登陆可以以HTML表格形式显示结果具有历史命令工具可以通过HTTPD密码文件以 SYSDBA或SYSOPER身份登陆iSQL*PLUS另外它的配置十分简单使用标准的CGI/Apache/Jserv并且不需要安装 ORAiAS
