Amicuk Programming Answers

Oracle HTTP Server and mod_plsql

-0001-11-30   Views:22


Hi there, I have a problem using HTML DB on a small network. LAN consists of two computers with Windows XP Professional, Service Pack 1. Server has two NIC. One connected to the local internet provider (PPPoE) with TCP/IP set to "Obtain an IP address

Hi there,
I have a problem using HTML DB on a small network. LAN consists of two computers with Windows XP Professional, Service Pack 1. Server has two NIC. One connected to the local internet provider (PPPoE) with TCP/IP set to "Obtain an IP address automatically" and second network adapter (for the LAN) with TCP/IP address Second computer has NIC with IP The server is set with HTML DB 2.0. There is NO ANY problem if I work on it as stand alone computer - second network adapter disable!
The problem arises if I connect the second computer and then start HTML DB by http://localhost:7777/…"503 the service is temporary unavailable", emagent is down, DBconsole service is not active anymore, etc. Apache or Oracle HTTP Server is up.
I have found, after several days of troubleshooting, that the problem might be in httpd.config file. If somebody have experience in similar networks or Oracle HTTP Server settings please, give me advice or send httpd.conf file as an example.
Please help me!

The replay answer
If I disable the network adapters and restart the computer, then connect to the HTML DB or my application, everything is OK. Then enable connection and I can work from both computers!
This is listener.ora
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
This is tnsnames.ora
(ADDRESS = (PROTOCOL = TCP)(HOST = koncomp)(PORT = 1521))
(SID = PLSExtProc)
The dad.conf is empty because I am using marvel.conf. I just checked the rules to build such file. Listener uses as host name - computer name (in my case koncomp), but in all config files Oracle HTTP Server uses name localhost or That is the reason for SYSMAN to make too separate folders in Oracle home named LOCALHOST_instancename and hostname_instanceename.
One error from emagent.log
It goes down all the times when the problem arises.
2005-12-05 15:11:58 Thread-1996 ParseError: File=stream, Line=4, Msg=Missing value for ARG in RemoteOperationArgument (01006)
An error from sqlnet.log
Fatal NI connect error 12541, connecting to:
TNS for 32-bit Windows: Version - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version - Production
Time: 08-ДЕК. -2005 20:31:09
Tracing not turned on.
Tns error struct:
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0
Moreover in listener.log LISTENER is tried to connect to and to which is the second network adapter.
From Database Control, then Management Services and Repository, and Agent there are one agent and 4 targets. I found there several Metric erros.
Agent to Agent (Agent Process Statistics)
em_result=3696|0.00|14204|20384|1.94||751|12|14204|20384 Terminating on signal SIGTERM(15)
Agent to Database Instance (SQL Response Time, Streams Capture Queue Statistics, SGA Pool Wastage, etc.)
ORA-12505: TNS:listener does not currently know of SID given in connect descriptor,
ORA-12545: Connect failed because target host or object does not exist,
em_error=Could not connect to dbsnmp/(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost)(Port=1521))(CONNECT_DATA=(SID=Konsta10))) : ORA-12505: TNS:listener does not currently know of SID given in connect descriptor (DBD ERROR: OCIServerAttach),
ORA-12528: TNS:listener: all appropriate instances are blocking new connections
Agent to Listener (Response)
Terminating on signal SIGTERM(15)
Policy Violations found
Oracle recommends that you close all unnecessarily open ports, especially on internet-facing hosts

Go to See the other 10 answers

Need Oracle HTTP Server for mod_plsql and link to download software

Category:DefaultRelease time:2015-12-10Views:130

Hi all, I want to use mod_plsql to publish HTML from the database. Therefore, I need an Oracle HTTP Server with mod_plsql. I have installed the "Oracle HTTP Server with Apache 2.0", but there is no mod_plsql included! The welcome page r[More]

How to get standalone Oracle HTTP Server with mod_plsql?

Category:DefaultRelease time:2015-12-10Views:130

Hi, I do not know if it is just me but it seems to be a nightmare to get OHS with mod_plsql from the official OTN download site. I downoaded the companion CD for Windows - 3 disks, installed OHS - no mod_plsql. Then I tried to find any clue on OTN on[More]

What do I need for Oracle Http Server with mod_plsql on Linux 64bit?

Category:DefaultRelease time:-0001-11-30Views:130

I am trying to get the OHS onto a linux box but I am not quite sure I am installing the correct thing!! I currently have a windows box running the 10g Application server but everything seems to have changed since then and there seems to be several di[More]

Oracle HTTP Server and mod_plsql

Category:DefaultRelease time:-0001-11-30Views:130

Hi there, I have a problem using HTML DB on a small network. LAN consists of two computers with Windows XP Professional, Service Pack 1. Server has two NIC. One connected to the local internet provider (PPPoE) with TCP/IP set to "Obtain an IP address[More]

Web Service and Oracle HTTP Server

Category:DefaultRelease time:2015-12-10Views:130

I have a web environment with Oracle Database , oracle http server (using mod_plsql), Oracle pl/sql web toolkit. I need to create a web service that is accessed externally which will interact with the database (select, insert, delete). Is it[More]

APEX and Oracle HTTP server

Category:DefaultRelease time:2015-12-10Views:130

Scenario We are considering using APEX with Oracle 10g. However, we don't have Oracle application server.At the same time we do not want to use the Oracle HTTP server(OHS) on the database server. The propsed application intend to use by approx. 5000[More]

Oracle HTTP Server for APEX3.2

Category:DefaultRelease time:-0001-11-30Views:130

I am a DBA but new to APEX. On page 4-15 of APEX3.2 Installation Guide, it says Install from the Database and Configure Oracle HTTP Server This section describes how to configure Oracle HTTP Server with mod_plsql distributed with Oracle Database 11g[More]

Down Time for  Installing APEX 4.2.1 and oracle HTTP server?

Category:DefaultRelease time:-0001-11-30Views:130

Hi, all: I plan to install APEX 4.2.1 and oracle HTTP server on database. Is there any down time required during installation? I mean during installation, do I need to block users from accessing the database? Can they do their normal data en[More]

Oracle http Server (standalone)

Category:DefaultRelease time:-0001-11-30Views:130

I am going to install APEX 3.2 and as the pre-requisite, I need to install standalone Oracle HTTP server. In checking thru the Oracle web-site, it only appears under the integrated Oracle SOA Suite 10g. I have checked that some of the old version of[More]

Use oracle http server to configure mod_plsql

Category:DefaultRelease time:2015-12-10Views:130

Hi, I have a question. I have already installed HTTP server using the Oracle Database10g Companion CD on my Windows 2000 SP4. At the end of the installation, it refers to http://<computer_name>:7777 to open the HTTP server page. It seems work fine t[More]

Apex Listener vs. Oracle Application Server... advantages?

Category:DefaultRelease time:2015-10-11Views:130

Are there advantages to installing Apex Listener over using an existing Oracle Application Server instance to serve Apex applications? We have an existing application server instance in production. Would introducing Apex Listener and the extra overhe[More]

Cannot convert type class java.lang.String to class oracle.jbo.domain.ClobDomain. Using ADF Business Components I have a JSFF page fragment with an ADF form based on a table with has a column of type CLOB. The data is retrieved from the database and [More]
I can't access two application windows -- Mail and Spotlight. I sometimes use a external monitor so this may be related to that. When I switch to Mail, the Mail menu appears on top, but I do not see the window with my mailboxes in it. When I use Expo [More]
We have a RH8 project that has a custom, vertical layout that doesn't display the TOC, just some menu buttons and body content (WebHelp).  When we search, the TOC page open, however, the page is so truncated that only part of the first result display [More]
Using a Windows 7 64 bit Lenovo Laptop Have installed Adobe Captivate 7. During installation I was prompted to enter my Adobe ID and Product Serial Number. Now that installation is complete everytime I open the Adobe Captivate Application it prompts [More]
Hi, Now that the Internet Connect application has been removed from 10.5, I'm struggling to find the log file for VPN connections. Can anyone help?Now that the Internet Connect application has been removed from 10.5 It is not that is has been removed [More]
Friends, I am starting to work on new GL configuration on ECC 5.0. I would appreciate if you can give me some insight on questions I need to ask client before blueprinting. they r not planning to use PCA, only basic FI. Thanks, AHi, In New GL there a [More]
I'm having trouble getting my headphones paired to my iphonemy nokia a2dp headset like when turned on connect with my imac to connect or pair it with a new device I need to take measures to disconnect it from the computer beforehand you can also try [More]
Is it possible to open or "view inside" a sparsebundle file - and extract som files? I have a time machine backup that wont work in lion so I just want to extract some filesYes, files within sparsebundles are accessible. You can try these softwa [More]
I keep recieving an error saying codec overrun when installing latest qt. I tried both auto update and web site update. itcompletes its download an then it fails. help please current app qt 7.1.2fixed it by deleting itunes7 and quick time 7 apps. and [More]
Since upgrading to iTunes 5 from 4.9, most (but not all) of my play counts have been turned into a series of random numbers, such as -1088620803. Anyone else have this problem? I think I've been spared all the other bad stuff, although I really disli [More]