Amicuk Programming Answers

Oracle HTTP Server and mod_plsql

-0001-11-30   Views:14


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]

I'm getting the free Lion download for new Macs from the Mac App Store, but am not ready to install it yet. It appears that apps (including Lion?) from the App Store automatically install themselves. Is there any way to save an App Store download (.d [More]
Hi SAP SD Gurus, I am Prasad, I am new to SAP and have an isuue with my client . i will be greatful to all for helping me in resolving this issue. 1 scenario my client takes advance payment greater than or equal to the order quantity. The customer li [More]
Experts, How do I go about adding a tab in a PM notification? I have a requirement of adding a 'causes' tab for capturing of the object part, damage etc. and also for entering user defined codes for capturing an RCA in SAP. see screen belowHi Mutale, [More]
Help please: iDVD is not burning DVDs for me. it goes through the whole process seemingly fine, then at the end shows the error message: "problem during multiplexing/burning". I have a G4 emac. 800 Mhz 10.3.9 external Lacie dvd burner (that burn [More]
I bought a Def Leppard CD yesterday knowing that they are not available on the iTunes store. I burned the discs to my Mac with the intention of putting them on my iPhone 4s. After trying to drag and drop for about an hour and iTunes refusing to even [More]
Can anyone tell me the standard fields available in SAP among the following  and where can I can locate them?  1. <Overpacks Accepted>  -  This is for case pack only customers, N=no overpacks, Y=will accept overpacks 2. <Label Cartons with Pallet [More]
hi fellas I've got quite a stressing problem with my applets. When I load them in the appletviewer there is no problem, idem in Netscape 7. But when I try with IE I only obtain a grey rectangle. I thought I had written something wrong and I downloade [More]
I imported footage from my iphone (MOV files).  On Premiere Pro, the footage is cropped all around.  How do I fix this?  Oh, I have no idea about settings, where to find them or what any of the configurations mean.  thank you, LianaThanks, I've been [More]
Dear All, I have prime infrastructure 2.0 from 12 day ago i have logg on NCS (1. Message: CPU: 85 crossed down threshold: 90) and when see host memory from prime infrastructure VM i see that Host memory consumed so i make down time and increase the m [More]
We purchased a new Windows 8 laptop. I used Windows Easy Transfer to transfer data from the old laptop to the new laptop. Now, my wife's bookmarks, saved passwords, and other personalized settings do not appear on the new laptop. I am not sure if Win [More]