This error occurs while trying to print a report in a PDF format using Oracle Application Express 3.0. I'm not sure what this means and how to fix it. I'm running Oracle 10g on Windows Vista.
ORA-29273: HTTP request failed
ORA-06512: at "SYS.UTL_HTTP", line 1186
ORA-12570: TNS: packet reader failure
This is the first time I'm attempting to print to a PDF. I did follow configuration according to the Oracle documentation. I selected the Standard configuration that uses the built-in Apache FOP or another standard XSL-FO processing engine.
Machine details : UNIX machine Solaris 10 OS.I am not able to start the apache server using opmnctl startall command. i am getting the below error message
QUOTE Error --> Process (pid=823) failed to start a managed process after the maximum retry limit Log: /usr/local/oracle/OH_STANDOHS/opmn/logs/HTTP_Server~1
Even i tried killing the process id = 823 , i am getting the same error message with different process id.
I am hoping to test the behavior of a complex web application that is backended by an Oracle 9i database, against an upgrade to 11g database.
The current setup runs basically on 4 Solaris servers, The database, the Oracle Application Server (version 10 something) (2 instances running on the node/server with no OHS), an install of OAS/OHS as a load balancer box, and the non-OHS Apache2 web server front. Apache takes the request from the web and reverse-proxies it to the OHS load balancer, which sends it to one of the two instances on the single application server. This is a java application and uses an Oracle 9i database to feed it.
I have had enough server resources to clone the database, the app server and the web server, and upgrade the database to 11g. I am unable to setup an OHS load balancer box.
So my question is, how do I configure the Apache WS to communicate directly with the OC4J container(s). I can shut down an instance if that simplifies things. Or, if I had to I could look into standing up OHS in the OAS install, as that seems to be where all the info is focused on the technical info sites (Oracle and others), but since these are clones and I think it might be easier to just short circuit around the now missing load balancer box. Many configurations have already been done to be sure the 'clone' identifications are self-referencing, like the hosts file, etc. to point to resources in the Cloned environment.
We have an application, where we invoke a URL pointing to a folder on the Application Server, so that users can download files from the same.
There is user authentication provided for the URL.
Example :
Our application ABC (example) which is built with Oracle Forms 10g, hosted on Application server (itxxx123) inovkes a module GEN9999 which on pressing a button calls a URL which is open in the Internet Explorer browser.
If the URL has been called from the Forms or the Application (ABC), then it should be allowed.
If the URL is called standalone, by Opening IE Browser and invoking the URL, this should not be allowed.
However, there have been security concerns raised during Audit, saying that users can access the URL directly from the Browser instead of the Application. Also the URL is saved the Browser history, so even if the user is no longer working in the Application Team, and has moved out of the team, then the ex-user can still access the URL and view and download files.
Is there any way to restrict access to the URL such that is only accessible when it is called from the Application, and that access is restricted when directly called from the Browser.
I have seen that environment variables in httpd.conf may be usable for the above. However, not sure how to use them from Oracle Forms.
I tried my DBA hat today in an effort to set up the Apache FOP to allow users to download interactive reports as PDF. This was working previously - although I'm not sure how since there was no report printing infrastructure set up.We have APEX 4.1.1 using Apache on Windows server 2003.
It started because we saw one of two errors in the generated PDF ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified.or ORA-06502: PL/SQL: numeric or value error: character string buffer too smallAs much of the documentation indicates, the first suggests a problem with ACL. I had a little trouble finding documentation stating specifically which acl should be defined for IR PDF printing, but we did ensure the listings in the dba_network_acl* views were current with
[code]...
/I'm still unable to identify where the second error (ORA-06502) is coming up - which is apparently new. So I attempted to deploy the fop.war file using EM, adapting instructions from [URL]...though I think I may have missed a mark since these instructions differ from using the OC4J EM - but I guessed there was fair correlation.
From the EM home on our app server, I created a new OC4J instance called "APEX_Reports"I then went to deploy the fop.war file using "fop" as application name, and "/fop/" as the map to url.
Back in APEX instance management, I set up Print Server: External (Apache FOP)Protocal: http Print server address: dev.ouractualdomain.com.au print server port: 18100 Print server script: /fop/apex_fop.jsp>
I used the same port as that in the EM address. I've also tried variations usinglocalhost8888fop/fop/apex_fop.jsp
The reason for the /fop/fop/ attempt was because I located the jsp file in C:Ora10gFRShomej2eeAPEX_Reportsapplicationsfopfop (I've been trying everything)
Other port numbers attempted include those types (JMS,RMI,AJP) listed for the APEX_Reports component.Do we need to restart anything or re-login to APEX before testing modifications?
To rewrite this sql which is in ANSI 92 standard to ANSI 89 standard.
SELECT "PROJECT"."X_SAMPLED_DATE", SAMPLE"."SAMPLE_NUMBER" FROM "SHIRE_PRD"."LimsUser"."SAMPLE" "SAMPLE" INNER JOIN "SHIRE_PRD"."LimsUser"."PROJECT" "PROJECT" ON"SAMPLE"."PROJECT"="PROJECT"."NAME" WHERE ("SAMPLE"."SAMPLE_TYPE"='EM' OR "SAMPLE"."SAMPLE_TYPE"='WATER') AND "SAMPLE"."STATUS"<>'X' AND("PROJECT"."X_SAMPLED_DATE">={ts '2011-05-01 00:00:00'} AND "PROJECT"."X_SAMPLED_DATE"<{ts '2011-06-01 00:00:00'}) ORDER BY "SAMPLE"."PRODUCT"
I have been learning to create pdf report with Apex 4.2 and BI Publisher 10 which I have been successful with. Now I like to learn how to create pdf reports using FOP thinking of the customers who will not spend money on BI Publisher. I have gone through the documents and procedures described in Java 4 Less.[URL] and [URL]. Configured Apex instance setting accordingly.
For default layout a tabular pdf report is created. I have created an xsl-fo file named Formatted_report.fo on same query and xml file from report query with BI Desktop. But when I try to print a formatted output with Formatted_report.fo report layout it does not work(J4LFOPServer ). but same layout with .rtf template works fine (BI Publisher Print Server).
Im using pl sql to generate a web page using an apache server and the thing is that im trying to send cookies to the client but im also using an LDAP server for roles and user administration but the thing is that the cookie file does not appear in the client when sending by pl sql.
I have been learning to create pdf report with Apex 4.2 and BI Publisher 10 which I have been successful with. Now I like to learn how to create pdf reports using FOP thinking of the customers who will not spend money on BI Publisher. I have gone through the documents and procedures described in Java 4 Less. [URL] and [URL]. Configured Apex instance setting accordingly.
For default layout a tabular pdf report is created. I have created an xsl-fo file named Formatted_report.fo on same query and xml file from report query with BI Desktop. But when I try to print a formatted output with Formatted_report.fo report layout it does not work(J4LFOPServer ). but same layout with .rtf template works fine (BI Publisher Print Server).
I have one form in which there are master detail blocks. I am entering one record in master block and corresponding entry in detail block. If again I am entering a new record in master block, of course the corresponding entry is getting erased since the block is getting changed.
After entering the data in master block I want to pop a message as 'whether you want to duplicate the same entry in detail block '. If yes, then how can I copy the same details which i have entered for previous record? Can I use duplicate_record built in? If yes, How?
I have been testing out a form using 10.1.2.0.2 on a v10.2.0.1 db and in my local env. the form works correctly i.e. if I make a change and 'post' it and then exit and press NO (when asked to save changes) then it correctly leaves the value in the database as it originally was.
The process works by the user pressing a button in form A (read only form) and this opens form B (using open_mode,session,activate) and the user makes their change(s) in form B (a 'post' command is issued in a When New Rec Inst trigger on a db block when the user navigates to a new record within the same block if it is determined that the block status <> 'QUERY') before returning to form A and pressing 'NO' when prompted to save changes.
However, if I run the same process in the TEST env. using the same executable against the same database then it actually updates the database value.
I have tested this by adding a debug message at the end of form B to retrieve the db value back AFTER having issued a clear_form(no_commit) just for the sake of the test and it still returns me the 'new' i.e. amended value - which is obviously incorrect. From what I can see it would appear that the commit occurs straight after the 'post' has been issued and well before the user even exits the form.
Is this a known bug with the 'post' built-in or could it be that a parameter is set to act in this way (i.e. is there an 'autocommit' setting that is 'ON') within the application server?
Is there anyway to speed up the performance of the go_record built it or is there an alternative way to do it.
I have a table with nearly 30,000 rows and I would like to implement a text field that will allow the user to jump to a specified record. The only problem is if they try to jump too far away it will take a long time to load (beginning to end of 30,000 takes over a minute).
This problem doesn't arise if all the records, or up to the one they are jumping to, have been fetched already, but even if I fetch all records at the beginning it will still take a long time to initially load them.
I have a client who is facing the above error. Everything used to work perfectly but since a week, he gets this error message on a specific FORM. No updates have been made to the FORM.
The FMXs are stored on the database server(10G R3, Windows 2003 R2) and the Client terminals access them through a network drive.When executing the conflicting FORM on the server, no error.
I call the DBMS_ERROR_CODE routine from a FORM-LEVEL ON-ERROR trigger :
DECLARE ERR NUMBER; BEGIN IF DBMS_ERROR_CODE=-1 THEN MSG('Client existant',ERR,'E'); ELSE
[code]....
Code for procedure MSG :
PROCEDURE MSG(TXT_MSG IN VARCHAR2 , RET_REP OUT NUMBER , TYPE_MSG IN CHAR DEFAULT 'I' , LABEL_BUT1 IN VARCHAR2 DEFAULT 'OK' , LABEL_BUT2 IN VARCHAR2 DEFAULT NULL , LABEL_BUT3 IN VARCHAR2 DEFAULT NULL) IS VL_ALERT ALERT; BEGIN
I still have a legacy apps built using Forms 6i and Reports 6i running against Oracle 10g database on a Windows XP client and Windows 2008 server.It seems working well on Windows 7 client (32-bit only), but I think that it needs to test this apps.
Recently we have downgraded our database from enterprise to standard edition.....our sga size before downgrade was 11 gb and now it is 11gb and there is no as such problem in database..I have read somewhere that standard edition doesn't support sga size more than 2 gb .
I am checking out licenses. We all know that EE is much more expensive than SE. But many customers do have EE installed - unsure if they need all the features at all. After several years of production, a downgrade is considered 'risky' and we continue to pay the full EE.
How can we check and be sure that a downgrade to SE would not be any problem?
Some checks include: * partitioning used in user schemas? --> no downgrade to EE * bitmap indexes in user schemas? --> no downgrade to EE
How can we complete this list, or is there some script to make this easy?
I have been tasked with producing a list of all non standard characters that are not one of 0-9, a-z, A-Z from a parts table. The list should capture any non-English characters i.e. áóú etc as well as !"£$%^&* etc. These are a small example of the data.
Use ANSI standard JOIN syntax for example i have this code.
SELECT resv_num, unit_date FROM p_resv_unit ru, p_pm_unit_night pun WHERE pun.property_id = in_property_id AND pun.pm_unit_num = cvUnitNum AND pun.unit_date BETWEEN start_date AND end_date AND pun.resv_unit_id = ru.resv_unit_id;
[code]....
and is it a good idea to change it, because both ways it works?
