Solved

Oracle Reports deployment on Oracle Application Server 10g

Posted on 2007-04-09
3
1,629 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
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 47

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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
ORA-06504: PL/SQL: Return types of Result Set variables or query do not match 4 110
Oracle Public Synonyms and Privileges 2 65
clob to char in oracle 3 39
exp/imp 25 74
I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
How to Unravel a Tricky Query Introduction If you browse through the Oracle zones or any of the other database-related zones you'll come across some complicated solutions and sometimes you'll just have to wonder how anyone came up with them.  …
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…

773 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