 |
|
Oracle Tips by Burleson |
Troubleshooting Problems with HTML DB Connections
If the screen
shown in Figure 2.1 is not displayed, the following information may
help with troubleshooting.
Service Temporarily
Unavailable
If you receive:
Service Temporarily
Unavailable
The server is
temporarily unable to service your request due to maintenance
downtime or capacity problems. Please try again later.
This error could be due to the
PlsqlDatabaseConnectString
parameter in the dads.conf file not being configured correctly to
connect to the database.
It can also be because the
tnsnames.ora file is
not setup correctly. When both the Oracle HTTP Server and the
database are installed on the same machine, there will be two
locations where the tnsnames.ora
file is located. They will each be located in their appropriate home
directories: ORACLE_HOME/network/admin/tnsnames.ora.
Verify these files are configured correctly. The connection can be
checked using SQL*Plus. SQL*Plus
will also exist in both homes in the
ORACLE_HOME/bin directory.
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
|
