Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » How to set-up OHS to connect to the DB(mod_plsql) (Oracle 11g)
How to set-up OHS to connect to the DB(mod_plsql) [message #581687] Tue, 09 April 2013 23:29 Go to next message
senthilkumar35raju
Messages: 7
Registered: April 2013
Location: Las Vegas
Junior Member
I've installed Oracle 11g on my laptop(windows 8). I've also installed OHS for 11g and had configured the dads.conf. But when I try accessing the DB, I'm unable to do so from the browser(Page not found 404). Can somebody provide inputs on the mod_plsql configuration and help me the config files, if any. Please let me know if you need more inputs.

[EDITED by LF: disabled smilies]

[Updated on: Wed, 10 April 2013 01:21] by Moderator

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581708 is a reply to message #581687] Wed, 10 April 2013 01:27 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm afraid that I can't assist with what you are looking for, sorry.

However, just being curious: which Windows 8 edition is it? Note that Oracle won't work on any Windows Home edition (so, if you use it, that might be the root cause of your problems).

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581809 is a reply to message #581708] Wed, 10 April 2013 19:43 Go to previous messageGo to next message
senthilkumar35raju
Messages: 7
Registered: April 2013
Location: Las Vegas
Junior Member
I've installed Oracle DB and I'm using it on my laptop.

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581813 is a reply to message #581809] Thu, 11 April 2013 00:16 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
That much I figured out from your first message. But noone (except you) knows which operating system edition you use. Anyway, it appears that you are happy with Oracle and the way it works, which - in turn - makes me happy as well. As of OHS, I'm as stupid as yesterday so ... /forum/fa/3314/0/ I'm useless, as usual.

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581825 is a reply to message #581687] Thu, 11 April 2013 02:43 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
OK, I'll have a go.
First, can you post the lines from your httpd.conf file that enable the mod_plsql module? Is it actually there?
Second, post your dads.conf file.
Third, post the lines from the access_log that show what happens when you hit the OHS with a request that should go to the DAD.

I need some idea of how you have configured it, and what happens when you try to use it.

(Don't worry about running Oracle on home Windows, I've been doing that for years, no problems)

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581827 is a reply to message #581825] Thu, 11 April 2013 03:30 Go to previous messageGo to next message
senthilkumar35raju
Messages: 7
Registered: April 2013
Location: Las Vegas
Junior Member
1. What part of httpd.conf should I check for the enablement of mod_plsql module? Please let me know, so I can post that information here. The httpd.conf file is huge(is it the Loadmodule that you were expecting?) I've attached the httpd.congif file. Please review.

2. I was able to connect to the Oracle DB using the below connect string using sqlplus, which is provided in my dads config.

sqlplus SYSTEM/VHN78USA@Vertisystem

<Location /DEV/Verti>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername SYSTEM
PlsqlDatabasePassword VHN78USA
PlsqlDatabaseConnectString Vertisystem
PlsqlNLSLanguage American_America.AL32UTF8
PlsqlDocumentTablename documents
PlsqlDocumentProcedure document_api.download
PlsqlErrorStyle ApacheStyle
</Location>

3. Access_log - picked under the c:\\Middleware\Oracle_WT2\instances\instance1\diagnostics\logs\OHS\ohs1\access_log.1365552000 directory
::1 - - [09/Apr/2013:16:56:03 -0700] "GET /pls/Senthil/Verti/HelloWorld HTTP/1.1" 404 211
::1 - - [09/Apr/2013:16:56:10 -0700] "GET /pls/Dev/Verti/HelloWorld HTTP/1.1" 404 207
::1 - - [09/Apr/2013:16:56:13 -0700] "GET /pls/Dev/Verti/HelloWorld HTTP/1.1" 404 207
::1 - - [09/Apr/2013:16:56:17 -0700] "HEAD /index.html HTTP/1.1" 200 -
::1 - - [09/Apr/2013:16:56:17 -0700] "GET /pls/Dev/Verti/HelloWorld HTTP/1.1" 404 207
::1 - - [09/Apr/2013:16:56:37 -0700] "HEAD /index.html HTTP/1.1" 200 -

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581829 is a reply to message #581827] Thu, 11 April 2013 03:41 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Two immediate issues:
First, URLs are supposed to be case sensitive (except for the host name) so your virtual path should be /pls/DEV/Verti as in the DAD, but the access log shows that you are trying /pls/Dev/Verti. I think smoe platforms will do case conversion, but you can't rely on that.
Second, have you created a procedure HelloWorld in the SYSTEM schema? (That name if I rememebr correctly need not be case sensitive)

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581842 is a reply to message #581829] Thu, 11 April 2013 04:36 Go to previous messageGo to next message
senthilkumar35raju
Messages: 7
Registered: April 2013
Location: Las Vegas
Junior Member
I just tried the below URL with localhost:7777/pls/DEV/Verti/HelloWorld

but I got the same error "Page not found 404"

Access_log details below
::1 - - [11/Apr/2013:02:00:28 -0700] "HEAD /index.html HTTP/1.1" 200 -
::1 - - [11/Apr/2013:02:00:48 -0700] "HEAD /index.html HTTP/1.1" 200 -
::1 - - [11/Apr/2013:02:00:53 -0700] "GET /pls/DEV/Verti/HelloWorld HTTP/1.1" 404 207
::1 - - [11/Apr/2013:02:01:08 -0700] "HEAD /index.html HTTP/1.1" 200 -
::1 - - [11/Apr/2013:02:01:28 -0700] "HEAD /index.html HTTP/1.1" 200 -

I've the HelloWorld procedure created when I login as user 'SYSTEM'

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581847 is a reply to message #581842] Thu, 11 April 2013 04:41 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Quote:
I've the HelloWorld procedure created when I login as user 'SYSTEM'
You'll need to prove this. And you might want to check the case sensitivty.

And you might want to say "thank you for your time".

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581851 is a reply to message #581847] Thu, 11 April 2013 04:51 Go to previous messageGo to next message
senthilkumar35raju
Messages: 7
Registered: April 2013
Location: Las Vegas
Junior Member
Definitely Watson, thanks a lot for your time and help!

I've executed the procedure after logging into the DB using SYSTEM as user

C:\Users\senthil>sqlplus SYSTEM/********@Vertisystem

SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 11 02:49:12 2013

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 11g Express Edition Release 11.2.0.2.0 - Production

SQL> execute HelloWorld
BEGIN HelloWorld; END;

*
ERROR at line 1:
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 356
ORA-06512: at "SYS.HTP", line 1368
ORA-06512: at "SYS.HTP", line 1443
ORA-06512: at "SYS.HTP", line 1735
ORA-06512: at "SYS.HTP", line 101
ORA-06512: at "SYSTEM.HELLOWORLD", line 3
ORA-06512: at line 1


SQL>

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581852 is a reply to message #581851] Thu, 11 April 2013 04:54 Go to previous messageGo to next message
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Could you share that procedure's code? Before you do that, please, spend 10 seconds of your time and have a look at How to use [code] tags and make your code easier to read?

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581853 is a reply to message #581852] Thu, 11 April 2013 04:59 Go to previous messageGo to next message
senthilkumar35raju
Messages: 7
Registered: April 2013
Location: Las Vegas
Junior Member
 
CREATE OR REPLACE PROCEDURE HelloWorld AS
BEGIN
	htp.htitle('My first dynamic Web page');
	htp.print('Hello world');
	htp.line;
END HelloWorld;
/

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581854 is a reply to message #581853] Thu, 11 April 2013 05:03 Go to previous messageGo to next message
John Watson
Messages: 8960
Registered: January 2010
Location: Global Village
Senior Member
Well, it all looks OK to me. If the module is actually loading. You haven't provided any information on that.
I think it would normally be loaded by a LoadModule directive. You had better post the relevant files, you may need to follow a track of include directives starting with httpd.conf to find it.

Report message to a moderator

Re: How to set-up OHS to connect to the DB(mod_plsql) [message #581867 is a reply to message #581854] Thu, 11 April 2013 05:27 Go to previous message
senthilkumar35raju
Messages: 7
Registered: April 2013
Location: Las Vegas
Junior Member
Watson - I've attached the httpd.conf file for you to take a look at it. As far as I looked the LoadModule, I was not able to find anything explicit for "mod_plsql" when I searched in the httpd.conf file.

LoadModule file_cache_module "${ORACLE_HOME}/ohs/modules/mod_file_cache.so"
LoadModule vhost_alias_module "${ORACLE_HOME}/ohs/modules/mod_vhost_alias.so"
LoadModule env_module "${ORACLE_HOME}/ohs/modules/mod_env.so"
LoadModule log_config_module "${ORACLE_HOME}/ohs/modules/mod_log_config.so"
LoadModule mime_magic_module "${ORACLE_HOME}/ohs/modules/mod_mime_magic.so"
LoadModule mime_module "${ORACLE_HOME}/ohs/modules/mod_mime.so"
LoadModule negotiation_module "${ORACLE_HOME}/ohs/modules/mod_negotiation.so"
LoadModule status_module "${ORACLE_HOME}/ohs/modules/mod_status.so"
LoadModule info_module "${ORACLE_HOME}/ohs/modules/mod_info.so"
LoadModule include_module "${ORACLE_HOME}/ohs/modules/mod_include.so"
LoadModule autoindex_module "${ORACLE_HOME}/ohs/modules/mod_autoindex.so"
LoadModule dir_module "${ORACLE_HOME}/ohs/modules/mod_dir.so"
LoadModule cgi_module "${ORACLE_HOME}/ohs/modules/mod_cgi.so"
#LoadModule cgid_module "${ORACLE_HOME}/ohs/modules/mod_cgid.so"
LoadModule asis_module "${ORACLE_HOME}/ohs/modules/mod_asis.so"
LoadModule imagemap_module "${ORACLE_HOME}/ohs/modules/mod_imagemap.so"
LoadModule actions_module "${ORACLE_HOME}/ohs/modules/mod_actions.so"
LoadModule speling_module "${ORACLE_HOME}/ohs/modules/mod_speling.so"
LoadModule userdir_module "${ORACLE_HOME}/ohs/modules/mod_userdir.so"
LoadModule alias_module "${ORACLE_HOME}/ohs/modules/mod_alias.so"
LoadModule authz_host_module "${ORACLE_HOME}/ohs/modules/mod_authz_host.so"
LoadModule auth_basic_module "${ORACLE_HOME}/ohs/modules/mod_auth_basic.so"
LoadModule authz_user_module "${ORACLE_HOME}/ohs/modules/mod_authz_user.so"
LoadModule authn_file_module "${ORACLE_HOME}/ohs/modules/mod_authn_file.so"
LoadModule authn_anon_module "${ORACLE_HOME}/ohs/modules/mod_authn_anon.so"
LoadModule authn_dbm_module "${ORACLE_HOME}/ohs/modules/mod_authn_dbm.so"
LoadModule proxy_module "${ORACLE_HOME}/ohs/modules/mod_proxy.so"
LoadModule proxy_http_module "${ORACLE_HOME}/ohs/modules/mod_proxy_http.so"
LoadModule proxy_ftp_module "${ORACLE_HOME}/ohs/modules/mod_proxy_ftp.so"
LoadModule proxy_connect_module "${ORACLE_HOME}/ohs/modules/mod_proxy_connect.so"
LoadModule proxy_balancer_module "${ORACLE_HOME}/ohs/modules/mod_proxy_balancer.so"
LoadModule cern_meta_module "${ORACLE_HOME}/ohs/modules/mod_cern_meta.so"
LoadModule expires_module "${ORACLE_HOME}/ohs/modules/mod_expires.so"
LoadModule headers_module "${ORACLE_HOME}/ohs/modules/mod_headers.so"
LoadModule usertrack_module "${ORACLE_HOME}/ohs/modules/mod_usertrack.so"
LoadModule unique_id_module "${ORACLE_HOME}/ohs/modules/mod_unique_id.so"
LoadModule setenvif_module "${ORACLE_HOME}/ohs/modules/mod_setenvif.so"
LoadModule context_module "${ORACLE_HOME}/ohs/modules/mod_context.so"
LoadModule rewrite_module "${ORACLE_HOME}/ohs/modules/mod_rewrite.so"
  • Attachment: sample.txt
    (Size: 37.83KB, Downloaded 2829 times)

Report message to a moderator

Previous Topic: Display report based on the value picked from select list
Next Topic: Update Statement
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Dec 04 12:50:46 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.