New Oracle HTTP server install unable to host remote HTMLDB.

December 10 269
Advertisement
Hi all.
I installed the Oracle HTTP Server from the Oracle 10G Release 1 companion CD on a Mac Powerbook running the Tiger OS. I have a CentOS Linux server on my network with Oracle 10G R2 database running that I've installed HTMLDB 2.0 on. I can not seem to get the HTTP server to serve up a front end to my HTMLDB. I can connect and log into the Oracle Database from the MAC using SQLPlus using the HTMLDB_PUBLIC_USER account and password.
Here is my dads.conf file:
Alias /i/ "/oracle/product/10.1.0/db_1/Apache/Apache/images/"
<Location /pls/htmldb>
SetHandler pls_handler
Order deny,allow
Allow from all
AllowOverride None
PlsqlDatabaseUsername HTMLDB_PUBLIC_USER
PlsqlDatabasePassword HTMLDB
PlsqlDatabaseConnectString CentOSServ3:1521:htmldb ServiceNameFormat
PlsqlDefaultPage htmldb
PlsqlDocumentTablename wwv_flow_file_objects$
PlsqlDocumentPath docs
PlsqlDocumentProcedure wwv_flow_file_manager.process_download
PlsqlAuthenticationMode Basic
PlsqlNLSLanguage AMERICAN_AMERICA.WE8MSWIN1252
</Location>
AddType text/xml xbl
AddType text/x-component htc
Here is the errors I'm seeing on the error log:
[Wed Jan 10 12:58:47 2007] [notice] FastCGI: process manager initialized (pid 246)
[Wed Jan 10 12:58:48 2007] [emerg] mod_onsint can't initialize ons runtime.
[Wed Jan 10 12:58:48 2007] [notice] Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server configured -- resuming normal operations
[Wed Jan 10 12:58:48 2007] [notice] Accept mutex: flock (Default: flock)
[Wed Jan 10 12:58:58 2007] [error] [client 127.0.0.1] [ecid: 1168451937:192.168.2.121:249:0:12,0] mod_plsql: /pls/htmldb/htmldb HTTP-503 ORA-12514
It keeps giving me the error for the Language, but I've changed the PlsqlNLSLanguage serveral times to other posted values I've found and other postings and I still get that error.
Has anyone else worked through this or may have an idea how I can get this working?
Thanks,
Mike
Advertisement
Also, here is the error I get when browsing to : http://localhost:7780/pls/htmldb/htmldb from the HTTP server.
Service Temporarily Unavailable
The server is temporarily unable to service your request due to maintenance downtime or capacity problems. Please try again later.
Oracle-Application-Server-10g/10.1.2.0.0 Oracle-HTTP-Server Server at 192.168.3.1 Port 7780
Thanks,
Mike