Non OHS Apache Front End Directly To OJ4C?
Jun 9, 2011
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.
View 6 Replies
ADVERTISEMENT
Sep 11, 2013
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.
View 1 Replies
View Related
Jul 1, 2010
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.
View 6 Replies
View Related
Dec 27, 2012
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.
View 1 Replies
View Related
Jan 8, 2013
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?
View 0 Replies
View Related
Mar 2, 2011
I am trying to login through front end application. I am getting the error login failed.
I tried to login from back end using same USERID and password. In the login page it's asking for EDUSERID and password. I tried to connect from backend to the database using same EDUSERID and password and it's working fine. But why from front end application I am unable to login.
View 2 Replies
View Related
Feb 18, 2013
Today we faced one strange issue Varchar doesnot print the zero front of number
eg
SQL> select agent_code from table_name where AGENT_CODE = 0061;
AGENT_CODE
----------
61
61
where in my database agent_code columns as value 0061 and 061 for both it shows same value.
View 9 Replies
View Related
Mar 16, 2011
I am new to oracle 10g. I have a strange problem which i never used to face it while using oracle 8i.
Out of around 120 forms , there is 2 forms in which all the data entry is being done. any changes made to the coding / text in these fmb is not getting effected when i run the form through front end.The front end is developer 2000 .
Where as changes made to the other fmb is working perfectly fine. Is there any deployment issues which needs to be taken care off in oracle 10g.
View 8 Replies
View Related
Mar 14, 2013
I am trying to write which will return cursors to front end program.The logic which I got stuck is while exiting the procedure.I am having some cursors in teh procedures which are read by the front end script.I have one condition which when satisfied I have to exit from the procedure.But the constraint I am facing is if I exit at that logic, oracle closes all the cursor and front end script is not able to read teh cursor and hence throws an error.Is there any way to exit the procedure without closing the REF cursors.
View 3 Replies
View Related
Mar 31, 2007
I am trying to generate a software that used VB as the front end and Oracle 10G as the back end. I have noticed that the date format is VB is : m/dd/yyyy whereas the date format in oracle is dd-mm-yyyy. Whenever i try to insert a tuple with either of the date formats, the program halts running and after a long time , i get a message saying a deadlock was encountered. I have never had any formal introduction to either of the two tools
View 1 Replies
View Related
Oct 28, 2013
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).
View 1 Replies
View Related
Sep 30, 2008
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.
this is the code im using
owa_util.mime_header('text/html',FALSE);
owa_cookie.send('CookieName','AnyString',TO_DATE(v_fecha,'DD/MM/YYYY'),'/',NULL,NULL);
owa_util.http_header_close;
View 2 Replies
View Related
Dec 15, 2012
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).
View 2 Replies
View Related
Dec 2, 2012
I am running Apex 4.2 on Oracle Express Edition (Linux). Sometimes my login page has the alignments of the Workspace/username/password login area below the Apex image as below: [URL] ........
This is with using Firefox. The font page renders ok with other browsers like IE or Chrome.
View 2 Replies
View Related
May 13, 2013
that are my biggest tables
Users use front end (called ESS Console) and when they try to open one of those tables they wait very long (really bad performance). Sometimes the GUI even hanging without displaying results.
Does Partitioned Tables feature works for better performance?
View 3 Replies
View Related
Jan 31, 2011
I'm developing now in 11g and i have some reports that i want to send directly to the printer. I been having some troubles and as i searched the web, i saw that for 9i and 10g, this was not possible without using orarrp. But i can't find any info about this for 11g. Is this true that i can only let user print direct using this tool? Plus, is this tool available for linux x64? Can i add the printer to the server and would it work now?
View 2 Replies
View Related
Oct 3, 2013
Given below a block of code, this code compiled successfully on one DB but returns error on other.DB version is same. I know sqlerrm can not be used directly but how it compiled successfully on one DB.
declare
l_procedure_name CONSTANT VARCHAR2(100) := 'copy_device_status_tables';
l_procedure_id CONSTANT INTEGER := 301;
[Code].....
Error report:
ORA-06550: line 12, column 75:
PL/SQL: ORA-00984: column not allowed here
ORA-06550: line 11, column 5:
PL/SQL: SQL Statement ignored
06550. 00000 - "line %s, column %s:\n%s"
*Cause: Usually a PL/SQL compilation error.
View 5 Replies
View Related
Jul 27, 2012
How to create directly pdf file in reports 6i and what type of parameter use and how to use?
View 3 Replies
View Related
Mar 19, 2012
i need to open the report directly into .pdf (adobe) format is there any option to do that.
View 6 Replies
View Related
May 29, 2013
I want to print a report to the printer directly. The main issue is that I don't want the user to save the report to prevent reprint of legal Order. Below is my code to produce 'PDF' format.
PROCEDURE
run_report_proc (rep_id report_master.REPORT_ID%type,pl_id ParamList ) IS
repid REPORT_OBJECT;
rep_name report_master.REPORT_NAME%type;
v_rep varchar2(1000);
rep_status varchar2(20);
rep_acc char(1);
[code]....
View 3 Replies
View Related
Jun 5, 2012
I want to delete a backupset and get the flowing prompt,i want to delete it directly and no prompt,how can i do?
Do you really want to delete the above objects (enter YES or NO)? YES
RMAN> delete backupset tag 'TAG20120306T211654';
using channel ORA_DISK_1
List of Backup Pieces
BP Key BS Key Pc# Cp# Status Device Type Piece Name
------- ------- --- --- ----------- ----------- ----------
111 101 1 1 UNAVAILABLE DISK /u01/app/oracle/duplicate/al_t777244616_s111_p1
Do you really want to delete the above objects (enter YES or NO)? YES deleted backup piece
backup piece handle=/u01/app/oracle/duplicate/al_t777244616_s111_p1 recid=111 stamp=777244617 Deleted 1 objects
View 4 Replies
View Related
Jan 29, 2008
I know that this topic in not new, but maybe my case is a bit different than common.My form has multi-record block (4 columns) in which i want to upload CSV file.
The form will have "Browse..." button to piont CSV file (on local users disc, not where Forms server resides) after pointing the CSV file, user will press UPLOAD button which will import CSV data into block. After that data is visible in block. But whole form must not be refreshed.
I'm studying about UTL_FILE package, but it seems it allows manipulating files on server not local user's machines. Do Forms have such "Browse... -> UPLOAD" possibility or I need to learn Java and create Java funcionality inside Forms?
Or it is impossible to load data directly into form? (I have to use SQLoader and load data into temp table then into block on form????)
View 7 Replies
View Related
May 31, 2011
I tried to import a dump in 11g that was taken in oracle 9i. The import started but it hangs after some time. Exactly say it check only the character set of the DB's then it hangs. let me know if there are any specific procedures to import a dump from 9i to 11g directly.
View 8 Replies
View Related
Jun 20, 2010
1) I put attention that TNS write events into its log in too big frequency: ~ 10 time in second. I see that it is for every connection, but I assume that this no too good to performance.Is there some way to tell to TNS not to write event for every connection but only for errors?
2) May I to remove alert.log of DB? Or DB will make me problems with this?
3) How can I tell to my client connect directly to my instance rather than during TNS?
I have Oracle RAC 11g running on Red Hat 4 64 bit.
View 4 Replies
View Related
Sep 30, 2013
While doing scanning of character set, error occurred in between.
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production With the Partitioning, OLAP, Data Mining and Real Application Testing options
Current database character set is AL32UTF8.
Enter new database character set name: > WE8MSWIN1252
Enter array fetch buffer size: 1024000 >
Enter number of scan processes to utilize(1..64): 1 >
Enumerating tables to scan...
. process 1 scanning REINS.RI_TD_EXECUTION_LOG[AAASwXAAAAABwkAAAA]
. process 1 scanning INS.SERVICE_TRANSACTION_LOG[AAAS5hAAAAADWiAAAA]
. process 1 scanning REINS.RI_TD_VOUCHER_DETAILS[AAASx+AAAAAC6KAAAA]
. process 1 scanning REINS.RI_TT_VOUCHER_DETAILS[AAAS0OAAAAAAMiAAAA]
. process 1 scanning CONFSYS.DML_AUDIT_LOG_FOR_DESIGNER[AAASnwAAAAAAsIAAAA]
. process 1 scanning REINS.RI_TD_TRANSACTION_LOG[AAASx0AAAAACsoAAAA]
[code]...
View 3 Replies
View Related
Jul 16, 2012
I am using jasper integration package ..from www.opal-consulting.de using apex 4 and i Am currently able to generate pdf invoice..using jasper and store in a database.. table.
I need to generate the pdf invoice in the background ..without displaying in my screen..Without downloading on my machine..And store directly into the database table..
Below is my existing part of code..
DECLARE
l_blob BLOB;
l_mime_type VARCHAR2 (100);
l_blob2 BLOB;
l_mime_type2 VARCHAR2 (100);
mport varchar2(200);
[code]....
View 9 Replies
View Related
Jun 12, 2012
Is there any way that dumpfile can be created directly on the target rather than on the source and copying that dumpfile to target using datapump. I want to do full database export.
View 8 Replies
View Related
Dec 16, 2012
(Oracle 11gR1 OEL 5)Is there any possibility to convert snapshot database (standby) directly to Primary. Instead of manual switchover I want to do this
I have checked that snapshot creates a guaranteed restoration point which reverts back changes in Standby.
View 3 Replies
View Related
Nov 7, 2011
When you create a backup in SQL Server, whether the backup is on disk or on tape, SQL Server writes the letters TAPE to the first four bytes of the backup. Does Oracle write any specify value to the front of every backup, and if so, what are the first four bytes?
View 2 Replies
View Related
Aug 11, 2011
base on performance it is better to retrieve data from view or mention the table names directly?
I have a select statement in from clause one of my table is view (which is having data collected from four tables) my question is whether performance of querry will be improved if i use directly all tables( four tables of a view) instead of a view
View 9 Replies
View Related
