Currently I am using Oracle 9i Database and 10g Developer when I connect via login/password successful login but not execute and shows the error
FRM: 10142 The HTTP listener is not running on <computer Name> at port 8889. start the listener and check your runtime preference.
I am still facing the following error even though i have started the OC4j instance,
"FRM-10142: The HTTP Listener is not running on <computernam> at port 8888.start the listener or check your runtime preferences."
we have RAC of two nodes and EM is not running on one instance and running on another instance. when i issue emctl start dbconsolecommand it trying to start for 50 minutes but at the end, it failsi have checked the log (emagent.log) which is as follows
2012-02-29 14:18:48,971 Thread-1 Starting Agent 10.2.0.4.2 from /u01/app/oracle/product/11.2.0/dbhome (00701)
2012-02-29 14:18:48,973 Thread-1 <Agent Startup> : Startup of HTTP LISTENER failure (00716)
2012-03-01 10:25:43,414 Thread-1 Starting Agent 10.2.0.4.2 from /u01/app/oracle/product/11.2.0/dbhome (00701)
2012-03-01 10:25:43,525 Thread-1 <Agent Startup> : Startup of HTTP LISTENER failure (00716)
[code]...
and output of tail -100 emagent.trc is
2012-02-29 09:24:39,821 Thread-1 ERROR http: nmehl_startHttpListener: failed to listen to HTTP(s) port for https://db1:2928/emd/main
2012-02-29 09:24:39,821 Thread-1 ERROR main: nmehl_startHttpListener failed starting http listener.
2012-02-29 09:43:29,057 Thread-1 ERROR http: snmehl_allocateListenerPort: failed to listen on all sockets for hostname
[code]....
I have installed Oracle 11g XE . After this , i have upgraded to Apex 4.2 All it's working fine, but..... by default XE installs and configure apex to use embebed pl/sql gateway.
In this scenario, the images are stored directly in the database within the oracle XML DB repository. This may be a problem because XE have a 11GB limit and my apex aplication is simple, but it may upload pictures for customers, etc, and in this schenma the pictures will consume space in the database instead consuming in the linux filesystem.Can i install HTTP server in a 11g XE and reconfigure apexr?, or can i change to apache+listener? or more easy....can i upload images outside the XML DB in my apex application easily?
I am having one table in which for currentdate column is having below values
10142
10143
10144
10145
10146
10147
10148
These values represents the date.
Ex 10146 = 146th day of 2010
10147= 147th day of 2010
I want to convert values in currentdate column in yyyymmdd format.
I have a problem running forms 11g OS is windows 7 (tried on both 32bit and 64 bit same error)..Forms and Reports were both working fine, i was able to run test form, and a form that i created, and both were running properly. suddenly, while testing a new form module, it didn't work, and its showing :
Failure of server APACHE bridge:
------------------------------------------------------------------------------
No backend server available for connection: timed out after 10 seconds or idempotent set to OFF.
I'd like to call an existing function/procedure from a resource template. For example, I have a procedure called 'rest' with an out parameter of 'p_out' - how do I use this within a resource template?
At the moment I have defined the template as type 'PL/SQL Block' and with the 'GET' defined as:
begin
myschema.rest(:p_out);
end;
APEX_PUBLIC_USER has been granted 'all' on the procedure. The p_out is populated with a piece of text.
When I call this resource, I get a '500 Internal Error' returned. I've tried adding p_out as an X-APEX-FORWARD parameter, but nothing seems to work.
Query-based templates seem to work OK.
Using Listener 1.1.3 with Tomcat6.
I am using oracle 11.2.0 in linux platform.i have created a listener for the asm database. and i am using non default port of 1525 whenever i go for lsnrctl>status always shows for the port 1521. i don't want the default port 1521 and i have changed the local listener as listener1 with port 1525 protool tcp in spfile and registered with the asm database.Is there any option to change the default listener as listener1.
also,everytime when i give lsnrctl>show current_listener it is showing "listener"
i have set the current-listener to listener1 and save_config listener1 and reloaded.After exit and enter lsnrctl>status it will show for port 1521 When i attempt to start listener1 every time. it will prompt listener1 is already running.
I'm planning to do a single-sing-on in one of my applications. To get to my application, the user has to log in to a portal-application befor. From this application i receive 2 headers, to verify this person has authenticated successfully. But how can I read these 2 headers? It doesn't work with the UTL_HTTP package, because i don't do an active request on an url.
View 8 Replies View RelatedIn one of our RAC envrionment, we have more than 15 databases in a server running in AIX Operating system.the Listener file I am able to find only one entry (SID). But while trying to execute lsnrctl status it displays all the 15 SIDs in the list hosted in the ser ver. Not sure how it works?
As we created another one new database in the database, where i need to add this SID in the listener.ora file to reload the listener.
I have a requirement to capture a large number character string which is an output from http request. I created a CLOB datatype to capture it. I see an issue of truncating of the characters after 1998 character's (Block 1, below). If i assign the same ouput put and assign to variable of CLOB type and displaying 3794 Character as required(Block 2) which i am expecting the same in Block 1 too to see entire string ....
For your reference pl copy below link and past in explorer to see th entire output put.
********
http://gissms-stg-05:8399/arcgis/rest/services/ESRI_Route_NA_SA_CF/NAServer/Service%20Area/solveServiceArea?facilities=-95.452487%2C2 9.789048&barriers=&polylineBarriers=&polygonBarriers=&defaultBreaks=1&travelDirection=esriNATravelDirectionFromFa cility&outputGeometryPrecision=&outputGeometryPrecisionUnits=esriDecimalDegrees&f=json
**************************************************************
BLOCK : 1
declare
l_text3 CLOB;
begin
[code]...
I have on a Laptop, Oracle database 10g, and some applications on Forms 6i, but having problem to run Forms. Error: "ORA-12224: TNS - No listener."
how setting up Forms6i to work with 10g database? Do I need some Patch? What special configuration to make? What about the many TNSNAMES.ORA and SQLNET.ORA files in the Forms 6i Folder, versus those on the 10g Database Folder?
i am trying to use Firefox to run 10g forms application. Firefox not detecting the initiator. Firefox each time says plugin missing and searching for it. giving option to download manually. each time i run the form in Firefox same thing. no plugin found and its downloading another copy from d10g folder.
View 2 Replies View RelatedI have developed my PAYROLL application in forms 9i, which is successfully runnig at internet explorer version 6 but it is not running at internet explorer version 8 or later.
View 1 Replies View RelatedWe installed new SSL certificate on Oracle HTTP server and getting an error in IE 6,7,8:
res://ieframe.dll/dnserror.htm#https://...
Examining http headers provide following error description:
ERROR_INTERNET_SECURITY_CHANNEL_ERROR.
How was it resolved?
How to check the open http connections in the database as I am getting.
ORA-29270: too many open HTTP requests
We have a requirement like, we will get bulk data (2 GB) data file with different languages(Russian, chinese, Japanese, German) etc. and we need to load these data into our databse also we have to translate the same.
We are using Oracle 11g.
We had used Oracle httpuritype - And the below mentioned procedure PROCEDURE TEST.PRC_TRANS_GERMAN will call the function - trans_jef
Input parameter for PRC_TRANS_GERMAN - > To_language and from Language. and this procedure will store the translated word in the seperate table. Input parameter for the function trans_jef - > Word to be translated , from languae, to_language. And this function will return the translated word.
The issue I am facing is when I am passing the table of around 10000 records, around 4000 rows are not getting translated. So when i try to capture the error in exception- the error is
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1819
ORA-29270: too many open HTTP requests
When I try to re execute the missed words, they were translated. But they are not getting translated in one go because of the too many http open request.
how to resolve this ORA-29270 errror.
Translator
/* Formatted on 07-09-2012 09:19:33 (QP5 v5.215.12089.38647) */
CREATE OR REPLACE FUNCTION trans_jef (v_RawText IN VARCHAR2,
v_SrcLang IN VARCHAR2,
[Code]...
i use netbean 7.2, oracle 10g, when i run a servlet with db connection program i got 404 or 405 error type. if it is not properly to db ? i download a odbc6.jar file and paste it in C:Program FilesJavajre1.6.0lib also add as jar file in library tab of netbean ide. then whats the problem in it?
View 1 Replies View RelatedI am using oracle forms 11g
when i am running a forms the web page is giving error 404-not found.
We are running forms 11g ( 11.1.1.3) in our production environment and we are having strange issue when we are deploying the new version of fmx on fusion middleware server ( Windows 2008). After copying/replacing the new fmx we are still running the OLDER version of form. It's happening randomly on different servers.
View 3 Replies View RelatedI want to run graphs through forms. Just wanted to ask you that, what changes in settings do I have to make in forms or install any new software so that I am able to run graphs through it?
View 2 Replies View Relatedwould like to check if anybody running Form/Report 6i on Windows 7 ? I meant not XP mode.
View 3 Replies View RelatedI newly installed the Forms 10.1.2.0.2 and my database version is 10.1.0.2.0.
I hope it successful installed. I done the following workings
1. Edit preferences done perfectly.
2. OC4J also started.
When i run my 1st sample form. On my 1st run it should ask for Jinititor installation. But my run is not asking the Jinitiator installation and form is not running.
Even tried with run a form on web option it is also not running
I am getting error while running oracle forms (oracle 10g) in internet explorer.
an unhandled win32 exception occurred in iexplorer.exe [7572]
I am facing a problem while calling a report from FORM.the system gets hang and RWRBE60.EXE is not started.I am using client/server environment and Form 6i.
View 2 Replies View RelatedI am using Http URL Connection class to post a data to a URL (which is a web service). The web service accepts data as text / XML.
Following is the code snippet i used:
URL url = new URL("http://xxx.xxx.xx.xx:8080/SampleWebService.svc");
HttpURLConnection conn =(HttpURLConnection) url.openConnection();
conn.setDoOutput(true);
conn.setRequestMethod("POST");
[code].....
But when i execute the code, I am getting following error at the line(InputStream in2 = conn.getInputStream()wink.gif
java.io.IOException: Server returned HTTP response 400 for URL
I have this code when i run this I get credentials error. How to give credentials .The authentication is set to windows in the https page. Means pop up will appear to get the credentials
declare
req UTL_HTTP.REQ;
resp UTL_HTTP.RESP;
value varchar2(1024);
p_url varchar2(4000);
OPT varchar2(1000);
BEGIN
dbms_output.put_line('');
[code]....
Apex 4.1.1 or 4.2 -
I do not see an option in web sheets to use HTTP Header values for authentication. Any workaround in order to use OAM for authentication to web sheets?
I was install windows 7 on my computer,oracle database10g and forms 10g installed successfully. I Cannot run forms on the browsers , how i can run my programs
View 9 Replies View RelatedMy requirement is:
I want to run multiple Reports Concurrently, being called from my Form.
Suppose I have 10 Reports Say Report1, Report2, ....Report10.
I am using "RUN_PRODUCT" to call these Reports from my Form. But it's taking too long time to run all the Reports one after another. Can I run all these Reports Concurrently at the Same time.