BC remote Oracle DBA - Call (800) 766-1884  
Oracle Consulting Oracle Training Development

Remote DBA

Remote DBA Plans  

Remote DBA Service

Remote DBA RAC

   
Remote DBA Oracle Home
Remote DBA Oracle Training
Remote DBA SQL Tuning Consulting
Remote DBA Oracle Tuning Consulting
Remote DBA Data Warehouse Consulting
Remote DBA Oracle Project Management
Remote DBA Oracle Security Assessment
Remote DBA Unix Consulting
Burleson Books
Burleson Articles
Burleson Web Courses
Burleson Qualifications
Oracle Links
Remote DBA Oracle Monitoring
Remote DBA Support Benefits
Remote DBA Plans & Prices
Our Automation Strategy
What We Monitor
Oracle Apps Support
Print Our Brochure
Contact Us (e-mail)
Oracle Job Opportunities
Oracle Consulting Prices





   

 

 

 

Remote DBA services

Remote DBA Support

Remote DBA RAC

Remote DBA Reasons

Remote Oracle Tuning

Remote DBA Links

Oracle DBA Support

Oracle DBA Forum

Oracle Disaster

Oracle Training

Oracle Tuning

Oracle Training

 Remote DBA SQL Server

Remote MSSQL Consulting

Oracle DBA Hosting

Oracle License Negotiation

 

 


 

 

 

 

 

  Oracle Tips by Burleson

Stopping and Restarting the Oracle HTTP Server

The next chapter will walk through installing the HTML DB into an existing database and doing some configuration.  After the configuration, it will become necessary to restart the HTTP Server so it can pick up the new setting in the configuration.

For Linux/UNIX, it can be beneficial to create a shell script to restart the HTTP Server.  The following is a good example:

export ORACLE_HOME=/u01/app/oracle/product/10.2.0/ohs

$ORACLE_HOME/opmn/bin/opmnctl restart ias-component=HTTP_Server

On Windows, there is a program group created during installation in Start ą Programs ą Oracle Application Server - OHS_HOME ą Oracle HTTP Server.  In this group, there will be two shortcuts to Stop and Start the HTTP Server managed process.  I like to create three extra shortcuts that will handle some of the other common Stop/Start tasks that are often performed when making configuration changes.  Figure 1.4 shows what the program group will look like after adding the shortcuts.

The shortcuts do the following:

  • Start HTTP Server (created by installation):  This starts the HTTP Server managed process.  For this to succeed, the OPMN service must already be started.
     

  • Stop HTTP Server (created by installation):  This stops the HTTP Server managed process and leaves the OPMN service running.
     

  • Restart HTTP Server:  This stops and restarts the HTTP Server managed process.  This one will have to be created manually, but it comes in handy when making changes to the configuration files.  It will also come in handy in the next chapter.
     

  • OPMN StopAll:  This stops all managed processes, such as HTTP Server, and also stops the OPMN service.  Although it is not necessary to use this in most circumstances, it does become necessary when changing configuration files such as ORACLE_HOME\opmn\conf\httpd.xml.
     

  • OPMN StartAll:  This starts the OPMN service and all managed processes, such as HTTP Server.

The procedure for setting up the additional shortcut items in the Oracle HTTP Server program group is as follows:

1.       Create a copy of any of the shortcuts that currently exist.

2.       Rename the shortcut to the text shown in the table below.

3.       Open the shortcut properties and change the text in the Target field as shown in the table below.

Those following along should replace the underlined portion of the text with the ORACLE_HOME location used during the installation.

That completes the installation of Oracle HTTP Server.  The next chapter will cover installing HTML DB into an existing database and performing some configuration.  At that point, the configuration files required for Oracle HTTP Server to communicate with HTML DB will be explained.  After the configuration, it will be necessary to restart the Oracle HTTP Server so it can pick up the new settings in the configuration.


The above book excerpt is from:

Easy HTML-DB Oracle Application Express

Create Dynamic Web Pages with OAE

ISBN 0-9761573-1-4   

Michael Cunningham & Kent Crotty

http://www.rampant-books.com/book_2005_2_html_db.htm

Remote DBA Service
 

Oracle Tuning Book

 

Advance SQL Tuning Book 

BC Oracle support

Oracle books by Rampant

Oracle monitoring software

 

 

 

 

 

 

BC Remote Oracle Support

Remote DBA

Remote DBA Services

Copyright © 1996 -  2013 by Burleson. All rights reserved.

Oracle® is the registered trademark of Oracle Corporation.