Sitemap

Amicuk Programming Answers

Oracle HTTP Server and mod_plsql

-0001-11-30   Views:21

Advertisement

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 192.168.0.2. Second computer has NIC with IP 192.168.0.3. 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!
Konstantin

The replay answer
Advertisement
Hi,
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
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\product\10.2.0\db_1)
(PROGRAM = extproc)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = KONCOMP)(PORT = 1521))
This is tnsnames.ora
KONSTA10 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = koncomp)(PORT = 1521))
(CONNECT_DATA =
(SERVICE_NAME = KONSTA10)
EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
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 127.0.0.1. 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:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=koncomp)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=KONSTA10)(CID=(PROGRAM=C:\oracle\product\10.2.0\db_1\jdk\jre\bin\java.exe)(HOST=KONCOMP)(USER=Konsta))))
VERSION INFORMATION:
TNS for 32-bit Windows: Version 10.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 10.2.0.1.0 - 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 127.0.0.1 and to 192.168.1.2 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 10.1.3.1", 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 10.2.0.3 , 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 10.2.0.4 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]

Hot
@How do you prevent the organizer from mixing the order of pictures when down loading off the memory card?This sounds like you are using Photoshop Elements, and the Photoshop Elements forum would be best at answering that. Photoshop Elements GeneRead [More]
Hi, We are in ECC 6.0. We have a requirement to automatically  create delivery for a product based on PO. Here is the scenario: We have a sub contracting scenario where in material MAT1is made by breaking up MAT2. 1CAR of MAT1 is made from 2 CAR of M [More]
Hi, I'm working with two classes Car and Customer. The Car class has a Vector of Customers and the Customer class has a Vector of Car. Both are related by a many to many mapping. I have noticed that I have to set one of the vector to read only to avo [More]
When I download movies from iTunes to my NAS drive, I don't get the cover art. It shows up while its downloading, but when it's finish it disappears. If it has an iTunes extra the cover art is there. I tried get info and add the cover art, it never s [More]
I bought a mac game from www.gamehouse.com. Downloaded it and now trying to install to play. But everytime I go to install, a message keeps popping up telling me "Your account doesn't have sufficient access privileges. You will need to run this game [More]
I remember when the 8.1 update was announced to come out in September and October for the Lumia 521 but still nothing. It's the only reason my family got 521's. Does anybody have any information when it's actually coming out?Actually the Lumia Cyan u [More]
How do I get pulseaudio to see my USB dac? It keeps playing sound through the sound card only. I've added "load-module module-udev-detect" to default.pa, and changed my ~/.asoundrc to include: pcm.pulse { type pulse ctl.pulse { type pulse pcm.!d [More]
Hi, I have created index for INC_ID coloumn but when I use it in queries, it is not working. Verified the index it is on valid stat only, eventhough its not using in queries. can you please suggest why it is not using. what I have to do for this. I a [More]
I am on a 2008r2 domain.  I spoke to a security engineer from Microsoft a few years ago.  He mentioned some known issues that can occur from using some of the built-in security groups like Account Operators, Backup Operators, Server Operators, etc. I [More]
Hi All, Could somebody please help me with the following. I'm using the xmldom to create my xml files based on queries from the database. (using a PL/SQL package) The problem is that the processing instruction is never added to the top of the xml fil [More]