oracle10g http server HTMLDB

最新推荐文章于 2023-03-19 14:05:31 发布
最新推荐文章于 2023-03-19 14:05:31 发布
阅读量3k 收藏
点赞数 1
分类专栏： Oracle 文章标签： server oracle10g list null oracle download
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/mzwang123/article/details/7581373
版权

环境：redhat 5.4 + oracle 10.2.0.1.0 

一、HTMLDB 与HTTP server

注：如果机器上已经安装了oracle db，在选择路径时一定要创建一个新的路径，否则无法安装。

oracle 10R2的companion中HTMDB的版本是1.6， HTTP server 的版本是10.2。

如果选择先安装了oracle database 10g companion products 10.2.0.1.0 ----> HTTP SERVER，再手动安装HTMLDB2.0的话，需要手动的创建   Apache/modplsql/conf/marvel.conf文件。文件的格式如下：

Alias /i/ /u01/app/oracle/product/10.2.0/HTMLDB/htmldb/images/

<Location /pls/htmldb>
    Order deny,allow
    PlsqlDocumentPath docs
    AllowOverride None
    PlsqlDocumentProcedure wwv_flow_file_manager.process_download
    PlsqlDatabaseConnectString localhost.localdomain:1521:zzlhy ServiceNameFormat
    PlsqlNLSLanguage AMERICAN_AMERICA.ZHS16GBK
    PlsqlAuthenticationMode Basic
    SetHandler pls_handler
    PlsqlDocumentTablename wwv_flow_file_objects$
    PlsqlDatabaseUsername HTMLDB_PUBLIC_USER
    PlsqlDefaultPage htmldb
    PlsqlDatabasePassword @BfsSgUiCUa0nzndZ+v4iHS8=
    Allow from all
</Location>


问题一：在安装oracle companion 时会有三种类型选择：

在选择第一个和第三个时都会在打开 oracle http server 时出现以下错误：

opmnctl: starting opmn and all managed processes... opmnctl: opmn start failed

Command = /u01/app/oracle/product/10.2.0/companion/opmn/bin/opmnctl has failed

INFO: Configuration assistant "Starting HTTP Server" failed

解决方法：

查看/usr/lib文件夹下是否存在

libgdm.so.2.0.0 和 libdb.so.2

如果只有前者，没有后者，在root用户下执行：

ln -s /usr/lib/libgdbm.so.2.0.0 /usr/lib/libdb.so.2。

然后 在失败的界面点击 retry。

问题二、在安装过程中选择了上图中的第一项：oracle HTML DB 10.2.0.1.0(htmldb的版本是1.6),在安装结束后。可以打开http://localhost:7782主页面，却无法打开http://localhost:7782/pls/htmldb 页面。（注：7782是在文件 %Apache_Home/Apache/conf/httpd.conf).

# Port: The port to which the standalone server listens. For
# ports < 1024, you will need httpd to be run as root initially.
#
# This port is used when starting without SSL
Port 7782
Listen 7782
页面出现以下错误

Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later. 

同时在$Apache_Home/Apache/log/error*   日志中出现了以下错误。

[Wed May 23 03:46:46 2012] [error] [client 192.168.1.145] [ecid: 1337716006:127.0.0.1:3813:0:1,0] mod_plsql: DAD '/pls/htmldb' is disabled because of misconfiguration. Please refer to the log entries during server startup for more information.

于是打开modplsql日志功能，需要对 $Apache_Home/Apache/modplsql/conf/plsql.conf文件进行配置

PlsqlLogEnable Off    #如果需要查看日志将Off 改成 On

PlsqlLogDirectory /u01/app/oracle/product/10.2.0/OHS/Apache/modplsql/logs  #此为日志的路径
再次访问该页面，在$Apache_Home/modplsql/logs/_pls_htmldb/中产生两个日志文件 2707.log       cid1_2707.log，其中2727.log文件内容如下： 
<313794 ms>[ReqStartTime: 23/May/2012:17:05:06]
<313794 ms>Request ID ReqID:2707_1337763906
<313794 ms>(wpx.c,393) Initialized successfully 1
<313794 ms>(wpx.c,690) Shutdown has been called
<313794 ms>Maximum memory allocated by the request is 6721 bytes
<313794 ms>[ReqEndtime: 23/May/2012:17:05:06]
<313794 ms>[ReqExecTime: 0 ms]

<313814 ms>[ReqStartTime: 23/May/2012:17:05:06]
<313814 ms>Request ID ReqID:2707_1337763906
<313814 ms>(wpdenv.c,677) script_name='/pls/htmldb' path_info='/htmldb'script_prefix='/pls' dad_name='htmldb'
<313814 ms>(wpdenv.c,790) User-Agent is Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0;  Embedded Web Browser from: http://bsalsa.com/; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ( Embedded Web Browser from: http://bsalsa.com/); User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ( EmbeddedWB http://bsalsa.com/); .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
<313814 ms>(wpdenv.c,1410) dadname = 'htmldb', path_info = 'htmldb'
<313814 ms>(wpdenv.c,1449) Service will NOT use dynamic auth
<313814 ms>(wpx.c,393) Initialized successfully 0
<313814 ms>(wpx.c,315) SetRemoteUser : Remote User set to HTMLDB_PUBLIC_USER for this request.
<313814 ms>(wpx.c,482) Auth info from .APP file is being used
<313814 ms>(wpd.c,1728) Attempting to logon with '(unknown)'
<314104 ms>(wpd.c,1734) Database LogoN olog failed 604
<314104 ms>(wpd.c,1761) Failed connect as (unknown)
<314104 ms>/pls/htmldb/htmldb HTTP-503 ORA-604
<314104 ms>(wpx.c,595) Going to select...
<314104 ms>(wpx.c,690) Shutdown has been called
<314104 ms>Maximum memory allocated by the request is 12070 bytes
<314104 ms>[ReqEndtime: 23/May/2012:17:05:07]
<314104 ms>[ReqExecTime: 290 ms]

cid1_2707.log文件如下：

<313824 ms>[ReqStartTime: 23/May/2012:17:05:06]
<313824 ms>Request ID ReqID:2707_1337763906
<313824 ms>Connecting to database with connect string : "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=zzlhy)))"
<314094 ms>ORA-604 LogOn ORA-00604: error occurred at recursive SQL level 1
ORA-01756: quoted string not properly terminated
<314104 ms>Stale Connection due to Oracle error 604
<314104 ms>Logoff: Closing connection due to stale connection
<314104 ms>[ReqEndtime: 23/May/2012:17:05:07]
<314104 ms>[ReqExecTime: 280 ms]
实际也出现过以下内容： 

<5597054 ms>[ReqStartTime: 23/May/2012:04:08:19]
<5597054 ms>Request ID ReqID:4687_1337717299
<5597054 ms>Connecting to database with connect string : "zzlhy"
<5597054 ms>ORA-12154 LogOn ORA-12154: TNS:could not resolve the connect identifier specified
<5597054 ms>Stale Connection due to Oracle error 12154
<5597054 ms>Logoff: Closing connection due to stale connection
<5597054 ms>[ReqEndtime: 23/May/2012:04:08:19]
<5597054 ms>[ReqExecTime: 0 ms]
在$Apache_Home/Apache/logs/error_log 文件中日志如下： 

[Wed May 23 17:04:14 2012] [notice] FastCGI: process manager initialized (pid 2702)
[Wed May 23 17:04:15 2012] [notice] Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server configured -- resuming normal operations
[Wed May 23 17:04:15 2012] [notice] Accept mutex: fcntl (Default: sysvsem)
[Wed May 23 17:05:07 2012] [notice] [client 192.168.1.145] [ecid: 1337763906:127.0.0.1:2707:0:3,0] mod_plsql: ORA-604 LogOn ORA-00604: error occurred at recursive SQL level 1\nORA-01756: quoted string not properly terminated
[Wed May 23 17:05:07 2012] [error] [client 192.168.1.145] [ecid: 1337763906:127.0.0.1:2707:0:3,0] mod_plsql: /pls/htmldb/htmldb HTTP-503 ORA-604
[Wed May 23 17:05:07 2012] [error] [client 192.168.1.145] [ecid: 1337763907:127.0.0.1:2718:0:1,0] File does not exist: /u01/app/oracle/product/10.2.0/HTMLDB/Apache/Apache/htdocs/favicon.ico
[Wed May 23 17:05:07 2012] [error] [client 192.168.1.145] [ecid: 1337763907:127.0.0.1:2708:0:1,0] File does not exist: /u01/app/oracle/product/10.2.0/HTMLDB/Apache/Apache/htdocs/favicon.ico
按照OTN上的解决方法

unset LANG

在执行之前，先看一下 $echo $LANG，显示为 en_US.UTF-8。系统为英文操作系统，执行后该变量为空。

$Apache_Home/opmn/bin/opmnctl startall

然后再次访问 http://localhost:7782/pls/htmldb，正常显示。


同时在$Apache_Home/modplsql/logs/_pls_htmldb/cid1_2934.log日志如下：

<2188114 ms>[ReqStartTime: 23/May/2012:17:36:38]
<2188124 ms>Request ID ReqID:2934_1337765798
<2188124 ms>Connecting to database with connect string : "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=zzlhy)))"
<2188254 ms>Doing alter session set nls_language= "AMERICAN" nls_territory= "AMERICA"
<2188254 ms>OpenCursor
<2188264 ms>Altered session to nls_language=AMERICAN nls_territory=AMERICA
<2188264 ms>DeinitCursor
<2188264 ms>OpenCursor
<2188434 ms>Status 1 (rc=0)
<2188434 ms>DeinitCursor
<2188434 ms>OpenCursor
<2188574 ms>DBCharSet is AMERICAN_AMERICA.ZHS16GBK, OWAVersion 10.1.2.0.0, 1001020000 (rc=0)
<2188574 ms>DeinitCursor
<2188574 ms>OpenCursor
<2188574 ms>(wpd.c,1761) Logged in as (unknown)
<2188574 ms>(wpx.c,595) Going to select...
<2188574 ms>(wpx.c,649) Have been asked to execute a request
<2188574 ms>(wppa.c,332) Building Arglist based on Parsed Content from WRB
<2188574 ms>(wppa.c,1012) Enter ParseUrlData
<2188574 ms>GET
<2188574 ms>(wppa.c,1061) Getting Values from QUERY_STRING
<2188574 ms>[headers begin]
<2188574 ms>[headers end]
<2188574 ms>(wppa.c,427) Arglist built, 0 unique entries
<2188574 ms>(wpx.c,656) Going to wpprodb_OciDoBlock...
<2188574 ms>(wpd.c,2746) Cache enabled. Gathering cache information.
<2188574 ms>(wpd.c,2764) Language for this request is en-US,zh-cn;q=0.5
<2188574 ms>(wpd.c,2815) Using user HTMLDB_PUBLIC_USER for caching.
<2188574 ms>cache: Checking for user level hit
<2188574 ms>cache: Cache MISS user - /u01/app/oracle/product/10.2.0/HTMLDB/Apache/modplsql/cache/plsql/411/1650
<2188574 ms>cache: Checking for system level hit
<2188574 ms>cache: Cache MISS system - /u01/app/oracle/product/10.2.0/HTMLDB/Apache/modplsql/cache/plsql/sys/400/1451
<2188574 ms>(wppr.c,459) start working with htmldb
<2188574 ms>(wppr.c,1163) The CALL block: len=908, bind_count=8
declare
 rc__ number;
 start_time__ binary_integer;
 simple_list__ owa_util.vc_arr;
 complex_list__ owa_util.vc_arr;
begin
 start_time__ := dbms_utility.get_time;
 owa.init_cgi_env(:n__,:nm__,:v__);
 htp.HTBUF_LEN := 63;
 null;
 null;
 simple_list__(1) := 'sys.%';
 simple_list__(2) := 'dbms\_%';
 simple_list__(3) := 'utl\_%';
 simple_list__(4) := 'owa\_%';
 simple_list__(5) := 'owa.%';
 simple_list__(6) := 'htp.%';
 simple_list__(7) := 'htf.%';
 if ((owa_match.match_pattern('htmldb', simple_list__, complex_list__, true))) then
  rc__ := 2;
 else
  null;
  null;
  htmldb;
  if (wpg_docload.is_file_download) then
   rc__ := 1;
   wpg_docload.get_download_file(:doc_info);
   null;
   null;
   null;
   commit;
  else
   rc__ := 0;
   null;
   null;
   null;
   commit;
   owa.get_page(:data__,:ndata__);
  end if;
 end if;
 :rc__ := rc__;
 :db_proc_time__ := dbms_utility.get_time - start_time__;
end;
<2188574 ms>(wppr.c,519) Pl/sql block parsed...
<2188574 ms>(wpdenv.c,1526) CGI Environment has 27 vars. Max name len 128, Max Value Len 512
<2188574 ms> PLSQL_GATEWAY(14)=(6)WebDb
<2188574 ms> GATEWAY_IVERSION(17)=(2)2
<2188574 ms> SERVER_SOFTWARE(16)=(60)Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server
<2188574 ms> GATEWAY_INTERFACE(18)=(8)CGI/1.1
<2188574 ms> SERVER_PORT(12)=(5)7782
<2188574 ms> SERVER_NAME(12)=(22)localhost.localdomain
<2188574 ms> REQUEST_METHOD(15)=(4)GET
<2188574 ms> PATH_INFO(10)=(8)/htmldb
<2188574 ms> SCRIPT_NAME(12)=(12)/pls/htmldb
<2188574 ms> REMOTE_ADDR(12)=(14)192.168.1.145
<2188574 ms> SERVER_PROTOCOL(16)=(9)HTTP/1.1
<2188574 ms> REQUEST_PROTOCOL(17)=(5)HTTP
<2188574 ms> REMOTE_USER(12)=(19)HTMLDB_PUBLIC_USER
<2188574 ms> HTTP_USER_AGENT(16)=(478)Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0;  Embedded Web Browser from: http://bsalsa.com/; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ( Embedded Web Browser from: http://bsalsa.com/); User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ( EmbeddedWB http://bsalsa.com/); .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
<2188574 ms> HTTP_HOST(10)=(19)192.168.1.179:7782
<2188574 ms> HTTP_ACCEPT(12)=(268)image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */*
<2188574 ms> HTTP_ACCEPT_ENCODING(21)=(14)gzip, deflate
<2188574 ms> HTTP_ACCEPT_LANGUAGE(21)=(18)en-US,zh-cn;q=0.5
<2188574 ms> HTTP_ORACLE_ECID(17)=(32)1337765798:127.0.0.1:2934:0:4,0
<2188574 ms> WEB_AUTHENT_PREFIX(19)=(1)
<2188574 ms> DAD_NAME(9)=(7)htmldb
<2188574 ms> DOC_ACCESS_PATH(16)=(5)docs
<2188574 ms> DOCUMENT_TABLE(15)=(23)wwv_flow_file_objects$
<2188574 ms> PATH_ALIAS(11)=(1)
<2188574 ms> REQUEST_CHARSET(16)=(9)AL32UTF8
<2188574 ms> REQUEST_IANA_CHARSET(21)=(6)UTF-8
<2188574 ms> SCRIPT_PREFIX(14)=(5)/pls
<2188574 ms>StrArrPosBind pos 2 Charset Id : 873
<2188574 ms>StrArrPosBind pos 3 Charset Id : 873
<2188574 ms>StrArrPosBind pos 5 Charset Id : 873
<2190104 ms>(wpd.c,1958) Begin header parsing...
<2190104 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2190104 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2190104 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2190104 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2190104 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2190104 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2190104 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2190104 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2190104 ms>(wpd.c,2007) Got a line (81 bytes): Location: f?p=4550:1:6827067964513493848
<2190104 ms>(wpd.c,2129) Parsed header - Location:f?p=4550:1:6827067964513493848
<2190104 ms>(wpd.c,2007) Got a line (35 bytes): Content-length: 0
<2190104 ms>(wpd.c,2080) Parsed header - Content-Length:0
<2190104 ms>(wpd.c,2007) Got a line (1 bytes): 
<2190104 ms>(wpd.c,2014) End of headers detected
<2190114 ms>(wpcs.c, 76) Executed 'begin dbms_session.reset_package; end;' (rc=0)
<2190114 ms>(wpd.c,1816) Going to close cursor
<2190114 ms>DeinitCursor
<2190114 ms>(wpx.c,662) Normal completion
<2190114 ms>(wpx.c,690) Shutdown has been called
<2190114 ms>(wpx.c,702) Going to logoff
<2190114 ms>Logoff: Pooling this connection
<2190114 ms>[ReqEndtime: 23/May/2012:17:36:40]
<2190114 ms>[ReqExecTime: 1990 ms]

<2190114 ms>[ReqStartTime: 23/May/2012:17:36:40]
<2190114 ms>Request ID ReqID:2934_1337765800
<2190114 ms>Connecting to database with connect string : "(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=zzlhy)))"
<2190114 ms>OpenCursor
<2190114 ms>(wpd.c,1761) Logged in as (unknown)
<2190114 ms>(wpx.c,595) Going to select...
<2190114 ms>(wpx.c,649) Have been asked to execute a request
<2190114 ms>(wppa.c,332) Building Arglist based on Parsed Content from WRB
<2190114 ms>(wppa.c,1012) Enter ParseUrlData
<2190114 ms>GET
<2190114 ms>(wppa.c,1061) Getting Values from QUERY_STRING
<2190114 ms>[headers begin]
<2190114 ms>[headers end]
<2190114 ms>p=4550:1:6827067964513493848
<2190114 ms>(wppa.c,1506) indx = 1, entryCnt = 1
<2190114 ms>(wppa.c,1827) Listing distinct actual names: 
<2190114 ms>(wppa.c,1829)    p
<2190114 ms>(wppa.c,1831) Listing actuals of array with large entries: 
<2190114 ms>(wppa.c,1836) Listing distinct actual names and values: 
<2190114 ms>(wppa.c,1868)  p, type = 0, value (27) = 4550:1:6827067964513493848
<2190114 ms>(wppa.c,427) Arglist built, 1 unique entries
<2190114 ms>(wpx.c,656) Going to wpprodb_OciDoBlock...
<2190114 ms>(wpd.c,2746) Cache enabled. Gathering cache information.
<2190114 ms>(wpd.c,2764) Language for this request is en-US,zh-cn;q=0.5
<2190114 ms>(wpd.c,2815) Using user HTMLDB_PUBLIC_USER for caching.
<2190114 ms>cache: Checking for user level hit
<2190114 ms>cache: Cache MISS user - /u01/app/oracle/product/10.2.0/HTMLDB/Apache/modplsql/cache/plsql/776/7520
<2190114 ms>cache: Checking for system level hit
<2190114 ms>cache: Cache MISS system - /u01/app/oracle/product/10.2.0/HTMLDB/Apache/modplsql/cache/plsql/sys/058/0713
<2190114 ms>(wppr.c,459) start working with f
<2190114 ms>(wppr.c,1163) The CALL block: len=905, bind_count=9
declare
 rc__ number;
 start_time__ binary_integer;
 simple_list__ owa_util.vc_arr;
 complex_list__ owa_util.vc_arr;
begin
 start_time__ := dbms_utility.get_time;
 owa.init_cgi_env(:n__,:nm__,:v__);
 htp.HTBUF_LEN := 63;
 null;
 null;
 simple_list__(1) := 'sys.%';
 simple_list__(2) := 'dbms\_%';
 simple_list__(3) := 'utl\_%';
 simple_list__(4) := 'owa\_%';
 simple_list__(5) := 'owa.%';
 simple_list__(6) := 'htp.%';
 simple_list__(7) := 'htf.%';
 if ((owa_match.match_pattern('f', simple_list__, complex_list__, true))) then
  rc__ := 2;
 else
  null;
  null;
  f(p=>:p);
  if (wpg_docload.is_file_download) then
   rc__ := 1;
   wpg_docload.get_download_file(:doc_info);
   null;
   null;
   null;
   commit;
  else
   rc__ := 0;
   null;
   null;
   null;
   commit;
   owa.get_page(:data__,:ndata__);
  end if;
 end if;
 :rc__ := rc__;
 :db_proc_time__ := dbms_utility.get_time - start_time__;
end;
<2190114 ms>(wppr.c,519) Pl/sql block parsed...
<2190114 ms>(wpdenv.c,1526) CGI Environment has 28 vars. Max name len 128, Max Value Len 512
<2190114 ms> PLSQL_GATEWAY(14)=(6)WebDb
<2190114 ms> GATEWAY_IVERSION(17)=(2)3
<2190114 ms> SERVER_SOFTWARE(16)=(60)Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server
<2190114 ms> GATEWAY_INTERFACE(18)=(8)CGI/1.1
<2190114 ms> SERVER_PORT(12)=(5)7782
<2190114 ms> SERVER_NAME(12)=(22)localhost.localdomain
<2190114 ms> REQUEST_METHOD(15)=(4)GET
<2190114 ms> QUERY_STRING(13)=(29)p=4550:1:6827067964513493848
<2190114 ms> PATH_INFO(10)=(3)/f
<2190114 ms> SCRIPT_NAME(12)=(12)/pls/htmldb
<2190114 ms> REMOTE_ADDR(12)=(14)192.168.1.145
<2190114 ms> SERVER_PROTOCOL(16)=(9)HTTP/1.1
<2190114 ms> REQUEST_PROTOCOL(17)=(5)HTTP
<2190114 ms> REMOTE_USER(12)=(19)HTMLDB_PUBLIC_USER
<2190114 ms> HTTP_USER_AGENT(16)=(478)Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 5.1; Trident/4.0;  Embedded Web Browser from: http://bsalsa.com/; User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ( Embedded Web Browser from: http://bsalsa.com/); User-agent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; http://bsalsa.com) ( EmbeddedWB http://bsalsa.com/); .NET CLR 2.0.50727; .NET CLR 3.0.04506.648; .NET CLR 3.5.21022; .NET CLR 3.0.4506.2152; .NET CLR 3.5.30729)
<2190114 ms> HTTP_HOST(10)=(19)192.168.1.179:7782
<2190114 ms> HTTP_ACCEPT(12)=(268)image/gif, image/jpeg, image/pjpeg, image/pjpeg, application/x-shockwave-flash, application/vnd.ms-excel, application/vnd.ms-powerpoint, application/msword, application/x-ms-application, application/x-ms-xbap, application/vnd.ms-xpsdocument, application/xaml+xml, */*
<2190114 ms> HTTP_ACCEPT_ENCODING(21)=(14)gzip, deflate
<2190114 ms> HTTP_ACCEPT_LANGUAGE(21)=(18)en-US,zh-cn;q=0.5
<2190114 ms> HTTP_ORACLE_ECID(17)=(32)1337765800:127.0.0.1:2934:0:5,0
<2190114 ms> WEB_AUTHENT_PREFIX(19)=(1)
<2190114 ms> DAD_NAME(9)=(7)htmldb
<2190114 ms> DOC_ACCESS_PATH(16)=(5)docs
<2190114 ms> DOCUMENT_TABLE(15)=(23)wwv_flow_file_objects$
<2190114 ms> PATH_ALIAS(11)=(1)
<2190114 ms> REQUEST_CHARSET(16)=(9)AL32UTF8
<2190114 ms> REQUEST_IANA_CHARSET(21)=(6)UTF-8
<2190114 ms> SCRIPT_PREFIX(14)=(5)/pls
<2190114 ms>StrArrPosBind pos 2 Charset Id : 873
<2190114 ms>StrArrPosBind pos 3 Charset Id : 873
<2190114 ms>StrArrPosBind pos 6 Charset Id : 873
<2191384 ms>(wpd.c,1958) Begin header parsing...
<2191384 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2191384 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2191384 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2191384 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2191384 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2191384 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2191384 ms>(wpd.c,2007) Got a line (47 bytes): X-ORACLE-IGNORE: IGNORE
<2191384 ms>(wpd.c,2025) X-ORACLE-IGNORE parsed
<2191384 ms>(wpd.c,2007) Got a line (77 bytes): Content-type: text/html; charset=UTF-8
<2191384 ms>(wpd.c,2106) Parsed header - Content-Type:text/html; charset=UTF-8
<2191384 ms>(wpd.c,2007) Got a line (41 bytes): Content-length: 6769
<2191384 ms>(wpd.c,2080) Parsed header - Content-Length:6769
<2191384 ms>(wpd.c,2007) Got a line (1 bytes): 
<2191384 ms>(wpd.c,2014) End of headers detected
<2191394 ms>(wpcs.c, 76) Executed 'begin dbms_session.reset_package; end;' (rc=0)
<2191394 ms>(wpd.c,1816) Going to close cursor
<2191394 ms>DeinitCursor
<2191394 ms>(wpx.c,662) Normal completion
<2191394 ms>(wpx.c,690) Shutdown has been called
<2191394 ms>(wpx.c,702) Going to logoff
<2191394 ms>Logoff: Pooling this connection
<2191394 ms>[ReqEndtime: 23/May/2012:17:36:41]
<2191394 ms>[ReqExecTime: 1280 ms]

问题三、$Apache_Home/modplsql/conf/文件夹中 marvel.conf和 dads.conf

在htmldb1.6版本中，marvel.conf文件不是必须的，只要dads.conf文件配置正确就行,格式如下：

Alias /i/ /u01/app/oracle/product/10.2.0/HTMLDB/htmldb/images/

<Location /pls/htmldb>
    Order deny,allow
    PlsqlDocumentPath docs
    AllowOverride None
    PlsqlDocumentProcedure wwv_flow_file_manager.process_download
    PlsqlDatabaseConnectString localhost.localdomain:1521:zzlhy ServiceNameFormat
    PlsqlNLSLanguage AMERICAN_AMERICA.AL32UTF8
    PlsqlAuthenticationMode Basic
    SetHandler pls_handler
    PlsqlDocumentTablename wwv_flow_file_objects$
    PlsqlDatabaseUsername HTMLDB_PUBLIC_USER
    PlsqlDefaultPage htmldb
    PlsqlDatabasePassword wangmz
    Allow from all
</Location>
如果修改以下项时，无法打开 http://localhost:7782/pls/htmldb页面，错误和问题二相同。 
PlsqlDatabaseConnectString localhost.localdomain:1521:zzlhy ServiceNameFormat
在$Apache_Home/modplsql/logs/_pls_htmldb/中的日志内容如下： 

<4310984 ms>[ReqStartTime: 23/May/2012:18:12:19]
<4310984 ms>Request ID ReqID:3277_1337767939
<4310984 ms>Connecting to database with connect string : "zzlhy"
<4311074 ms>ORA-12154 LogOn ORA-12154: TNS:could not resolve the connect identifier specified
<4311074 ms>Stale Connection due to Oracle error 12154
<4311074 ms>Logoff: Closing connection due to stale connection
<4311074 ms>[ReqEndtime: 23/May/2012:18:12:19]
<4311074 ms>[ReqExecTime: 90 ms]
打开 http://localhost:7782/pls/htmldb/htmldb_admin，用户名必须是admin,密码则是dads.conf中 PlsqlDatabasePassword 的值。



参考：

https://forums.oracle.com/forums/thread.jspa?threadID=552966

mzwang123
关注
  • 1
    点赞
  • 踩
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
nginx动静分离（保姆级教程）
qq_55646631的博客
04-21 2676
nginx动静分离的优势以及如何配置
oracle 10g 的http服务该如何停止，请各位指教？ 紧急……
soft_codd的专栏
06-07 692
oracle database 10g的安装类型,Oracle Database 10g for Windows安装
weixin_42397220的博客
04-05 238
一、操作系统lWindows Server 2003lWindows 2000 SP1lWindows XP ProfessionallWindows NT Server4.0 二、下载软件论坛ftp上面也有 三、安装 1．运行setup.exe出现图1所示的“Oracle Database 10g安装”画面。 图 1 Oracle Database 10g安装画面中网格背...
ORACLE 10.2.0.1.0安装部署
weixin_42955647的博客
10-25 2354
@TOOracle 10.2.0.1.0安装部署C 10.2.01 oracle 软件安装文档 root 用户操作 先添加硬盘 service NetworkManager stop service iptables stop service ip6tables stop chkconfig NetworkManager off chkconfig iptables off chkc...
Android进阶-第三方框架使用汇总
热门推荐
王涛的博客
11-22 1万+
image loading 框架： 1.1 Glide 1.1Glide:一、Glide-Getting StartedGlide:Glide就像Picasso，能从许多资源上加载和显示图片，也照顾了缓存和做图片操作的时候保持一个低的内存影响，它已经被官方谷歌应用程序(如Google I / O的应用程序2015)和Picasso一样受欢迎，在本系列中,我们将探索Glide在Picas
oracle10g官方离线手册03
02-05
10. **应用服务器**：Oracle Application Server 10g提供了Web服务、portlet、身份管理和工作流等功能，为构建企业级应用提供了一体化平台。 手册中的B14117文件可能包含了这些主题的详细章节，包括安装与配置指南...
Oracle 10g客户端的安装配置操作详解.doc
最新发布
09-05
1. 访问Oracle官方网站获取Oracle 10g客户端的下载链接，例如：http://www.oracle.com/technology/software/tech/oci/instantclient/index.html。注册一个Oracle用户（如果尚未拥有）并下载适合的客户端版本。 2. 解...
oracle10g与db2的透明网关设置
12-22
据网络资料:Oracle 8i gateways为收费插件 oracle10g的10.1.0版本的gateWay也为收费插件 本例使用的是10g的10.2.0.1版本 下载地址: http://www.oracle.com/technetwork/database/10201winsoft-095341.html
Oracle.10G.数据库系统教程
11-08
现有的应用 (基于 .NET, Microsoft® Excel®, Microsoft® Access®) 可以非常方便地直接享用Oracle数据库带来的性能、可靠性、伸缩性方面的提升，也可以通过Oracle HTML DB 快速方便地集成到Oracle数据库 ...
node-red-contrib-oracledb-mod
05-07
节点-RED Oracle数据库节点 ... $[sudo] npm install -g node-red-contrib-oracledb-mod 如果您已经安装了.zip或从github克隆了自己的Node-RED副本，则可以将其作为普通的npm软件包安装在Node-RED项目目录中： <p
oracle10G Instant Client for Microsoft Windows
01-04
oracle10G 连接提示缺少oci.dll Instant Client for Microsoft Windows
htmldb.pdf
06-03
You can use the HTMLDB_ITEM package to render select lists in a report or tabular form by making direct calls to HTMLDB_ITEM.SELECT_LIST or by applying certain display types to report columns. Note that this type of sele cannot exceed 32K characters. Also note that selecting too many options ma result in the select list not rendering correctly.
基于http+公网ip的Frp内网穿透教程(win server)
guigenyi的专栏
03-19 4392
本文主要介绍公网ip的frp内网穿透配置教程。写本文主要是做一个记录，以便以后需要再次配置内网穿透时有所参考。如对您有所帮助不甚荣幸。本文主要涉及的硬件为：服务端：阿里云服务器 + win server + 公网ip；客户端：win11 + 台式电脑。
linux（ccentos7.6）apache服务配置详解（httpd的安装，虚拟主机，访问控制详解）
li_minjian的博客
03-19 3194
1.apache服务简介 作用：搭建web服务软件 软件名：httpd 端口号：tcp80 2.apache工作过程： 第一步：连接过程：客户端通过浏览器输入的url采用http协议与服务器之间通过tcp三次握手建立连接。 第二步：请求过程：向服务器请求的网站的主页资源，通常默认主页为index.htnl、index.php、index.jsp等文件名。 第三步：应答过程：服务器将主页文件传送给...
安卓手机自动化测试_app安装卸载
weixin_45649503的博客
05-12 243
目的：实现安卓手机app安装卸载，并且兼容性测试 #父类 #注意点：类初始化、is_app_installed、remove_app、insall_app、is_enable、智能等待 from appium.webdriver.webdriver import WebDriver import time from selenium import webdriver from selenium.webdriver.support.wait import WebDriverWait class YD
磊科路由虚拟服务器设置,如何设置磊科无线路由器端口映射
weixin_39969143的博客
07-31 816
磊科无线路由器配置简单，不过对于没有网络基础的用户来说，完成路由器的安装和端口映射的设置，仍然有一定的困难，本文学习啦小编主要介绍磊科无线路由器端口映射的设置方法!磊科无线路由器端口映射的设置方法内网中有一台WEB服务器(端口80)，IP地址是192.168.1.100;还有一台FTP服务器(端口21)，IP地址192.168.1.200，现在需要实现互联网上的用户能够正常访问到内网中的WEB服务...
oracle发送http请求。
乘桴游海的专栏
08-04 1万+
使用oracle发送http请求，实现的思路是：在某张表上配置触发器，该触发器调用存储过程，使用存储过程执行http请求的发送。 需要注意的几点是： 1、http post请求，在发送的时候，跟数据库的字符集有关，在处理不当的时候，会出现乱码问题。 2、oracle访问网络服务的时候，需要配置acl权限。 创建触发器：CREATE OR REPLACE TRIGGER "T_POS
【10.31】nginx 访问控制
张森纳的博客
10-31 596
nginx 访问控制
华为安装及基础操作
看清所以看轻
10-19 1580
认识华为 华为于1987 年成立于中国深圳。在30年的时间里，华为全体员工付出艰苦卓绝的努力，以开放的姿态参与到全球化的经济竞争中，逐步发展成一家业务遍及全球170 多个国家和地区的全球化公司。华为约有18万名员工，服务全世界三分之一以上的人口，是世界500强业。 华为是全球领先的信息与通信技(Information and Communications Technology, ICT)解决方案供...
Oracle10G系统简介.ppt
11-13
"Oracle10G系统简介.ppt" Oracle 10G系统是Oracle公司推出的一个重要的数据库管理系统版本，它在数据库技术上有着显著的改进和优化，特别强调了分布式数据库系统的特性和性能。以下是对Oracle 10G系统关键知识点的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值