配置过程如下:
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
阅读(1973) | 评论(0) | 转发(0) |