Solved

Oracle Reports deployment on Oracle Application Server 10g

Posted on 2007-04-09
3
1,645 Views
Last Modified: 2013-12-18
How to deploy and execute oracle reports 'rdf, and rep' on Oracle Applicatoin server 10g version 10.1.2 ?

Thanks
0
Comment
Question by:Oracle_DB
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 4

Expert Comment

by:ramumorla
ID: 18880004
You need Oracle 10g iAS to do this and the application server should be with "BI" option

 
0
 
LVL 48

Accepted Solution

by:
schwertner earned 300 total points
ID: 18882361
You have two options.

1. To install OAS 10.1.2 with Business Intelegence option. This is
very complex installation because it needs Infrastructure database.
If you have no option and the OAS is installed go to the environment variables and
add there the directory where your .rdf files reside. After that investigate the port on which the
Reports Servlet is listening and issue via a browser the URL like:

http://oracle-pc.bg.mcw.int:7778/reports/rwservlet?module=general.rdf+destype=cache+desformat=pdf+userid=lsuser/lsuser@bugf+p_from=01.09.2005_00:00:00+p_to=31.12.2005_23:59:59+p_type=INTERIM

oracle-pc.bg.mcw.int is the host of the OAS
7778 is the port of the reports servlet
module= is the name of the .rdf

others are parameters to the report (if any).

Another way is to run the Report on batch.
In this case you have to execute on the OAS server machine this:

D:\OASMiddTierHome\bin\rwrun module=e:\icw_reports\gen_othr.rdf userid=lsuser/lsuser@orcd desformat=delimiteddata destype=file p_from='01.09.2005_00:00:00' p_to='31.03.2006_23:59:59' p_type="QUARTER" p_wohin=e:\icw_reports\

2. The second option is not to use OAS. There is a standalone Forms/Reports server (see on the OTN).
It does the same job, but the installation is  lightweighted (do not need Infrastructure Database, no installation of the whole set of OAS tools like BI, Portal, J2EE stack etc.)
0
 
LVL 6

Assisted Solution

by:bpeterse
bpeterse earned 200 total points
ID: 18892706
There are volumes written by oracle that address your question.  And schwertner is correct in that it's a pretty complex undertaking.  That said, you can minimize the complexity by installing just the Forms & Reports Standalone, which includes HTTP server, Forms & Reports (i.e. business intelligence), OC4J and WebCache.  Once installed - and if you have experience in previous versions of OAS - you could deploy reports fairly easily.

Best advice I can offer > deploy on unix if at all possible, deploy only what you need, have a lot of patience, have your developers program J2EE compliant apps.... and you really should have an Oracle support contract or you're at the mercy of other busy applications dba's!  ;-p

A good starting point is http://www.oracle.com/technology/documentation/appserver101202.html
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There are numerous questions about how to setup an IBM HTTP Server to be administered from WebSphere Application Server administrative console. I do hope this article will wrap things up and become a reference for this task. You need three thingsā€¦
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
Via a live example, show how to take different types of Oracle backups using RMAN.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question