apache / http services in 9i and 10g

[rommel]

Hi,

I have both 9i and 10g DB installed in our AIX server.
Each has each own http service:
for 9i> apachectl start
for 10g> opmnctl startproc ias-component=HTTP_Server

If I have installed HTMLDB on both DB, do i have to use/startup one
http service, of both?

Thanks

[adewri]

Originally posted by rommel
Hi,

I have both 9i and 10g DB installed in our AIX server.
Each has each own http service:
for 9i> apachectl start
for 10g> opmnctl startproc ias-component=HTTP_Server

If I have installed HTMLDB on both DB, do i have to use/startup one
http service, of both?

Thanks

If HTMLDB on Oracle9i HTTP Server is configured to use the HTMLDB metadata on Oracle9i and The HTMLDB on Oracle10g HTTP Server is configured to use the HTMLDB metadata on Oracle10g and you plan to do development on both then you need to start both http servers to access respective HTMLDB metadata. Else one is enough.

Check the dads.conf file to see where the respective HTMLDBs are connecting to.

<HTTP_ORACLE_HOME>\Apache\modplsql\conf\dads.conf (Windows) or <HTTP_ORACLE_HOME>/Apache/modplsql/conf/dads.conf (Linux) file:

Alias /i/ "<http_oracle_home>/Apache/Apache/images/"
<Location /pls/htmldb>
	 SetHandler pls_handler
	 Order deny,allow
	 Allow from all
	 AllowOverride None
	 PlsqlDatabaseUsername      HTMLDB_PUBLIC_USER
	 PlsqlDatabasePassword      oracle
	 PlsqlDatabaseConnectString <dbhostname>:1521:<dbsid>
	 PlsqlDefaultPage           htmldb
	 PlsqlDocumentTablename     wwv_flow_file_objects$
	 PlsqlDocumentPath          docs
	 PlsqlDocumentProcedure     wwv_flow_file_manager.process_download
	 PlsqlAuthenticationMode    Basic
	 PlsqlNLSLanguage           AMERICAN_AMERICA.UTF8
</Location>

Note:
<dbhostname> refers to the name of the host where your database is resides.
<dbsid> refers to the connect string to your database

[rommel]

thanks,

I have Installed the http server using the companion cd shipped with the 10.1.0.2 db on oracle_home2, while the database is on oracle_home1.
Todate, I downloaded patch 10.1.0.3 and installed the patch on
oracle_home1. Do i need to patch the http srver (oracle_home2) too?
or http servers have separate patches developed?

[adewri]

Which ever http you want to use, patch it and change the dads.conf to point to the correct DB.

If you have the HTMLDB metadata on ORA_HOME1 database then use ORA_HOME1 http .