Solved

ORacle Forms/Reports 9i Requirements: Web Enable.......

Posted on 2004-09-13
7
1,071 Views
Last Modified: 2012-08-14
Hello,

I need to run an Oracle Forms/Reports 6i application using an Oracle 8i Database to Oracle 9i Forms/Reports.
I already Installed Oracle 9i Database and imported the data from Oracle 8i to Oracle 9i.

I heard that I need to install Oracle 9i iAS (infrastructure) followed by Application Server.
I have read that installing Business INtelligence would allow me to run Oracle 9i Forms/Repports over the web.

What are the minimum components required to do this ?
(Internet Directory + Single Sign ON, Forms/Reports Services,.....)

I don't want to install components I will not use.

I will access my LAN through a dedicated VPN connection to my LAN. THe Oracle Forms/Reports Application will be executed locally in my LAN.

PT
0
Comment
Question by:ptreves
[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
  • 3
7 Comments
 
LVL 23

Expert Comment

by:seazodiac
ID: 12049157
ok, Hopefully I can get this across to you clearly by a few sentences here:

Oracle9iAS has two installation option:

OracleAS middle tier and Oracle9iAS infrastructure.

Oracle9iAS infrastructure supports OracleAS middle tier to run efficiently.

OracleAS middle tier has three installation types :

1. Oracle Http server and J2ee Web server.
2. Oracle Portal and wireless
3. Oracle intelligent business component.(support for FORM and REPORT on the internet)

except the first, OracleAS middle tier will need OracleAS infrastructure to be able to function normally.

so you need OID, Oracle repository database, Oracle SSO , but you don't need OCA (oracle certificate Authroity).
0
 

Expert Comment

by:taiping
ID: 12050514
seazodiac, can you help in here as well?
http://www.experts-exchange.com/Databases/Oracle/Q_21127170.html
0
 
LVL 23

Expert Comment

by:seazodiac
ID: 12050578
I tried. see in your thread...
0
Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

 

Author Comment

by:ptreves
ID: 12059200
Hello,

I successfully installed Forms/Reports Services 10g (9.0.4) on my Red Hat Enterprise 3 (ES) server.
HEre is the output:
-----
[root@Linux2005 OraHome_FormsReportsServices]# xhost +localhost
localhost being added to access control list
[root@Linux2005 OraHome_FormsReportsServices]# su - oracle
[oracle@Linux2005 oracle]$ pwd
/home/oracle
[oracle@Linux2005 oracle]$ /OraHome_FormsReportsServices/Disk1/runInstaller
 ***************************************************************
 Please Refer to Quick Installation Guide and/or Metalink Notes
 for Redhat 3.0 system setup.
 Install and Configuration issues are expected if system is not
 setup as per the guidelines before
 Oracle Application Server 10g (9.0.4) installs.
 Specifically, please ensure the following:
 * Availability of gcc-3.2.3, setarch-1.3, pdksh-5.2,
   openmotif21-2.1.30, sysstat-4.0.7, gnome-libs-1.4.1.2.90-34.1,
   libstdc++-3.2.3, etc.
 * Availability of Compat libraries:
   compat-libstdc++-devel-7.3-2.96.122,
   compat-glibc-7.x-2.2.4.32.5, etc.
 * Patch for libcwait.so (Patch no. 3006854)
 * Symbolic links for gcc/g++
                                                                                                                         
 Enter 'y' if the target system is configured as per the
 guidelines specified in the Quick Installation Guide
 Answer 'n' to exit runInstaller
 Please retry after completing system setup.
 ***************************************************************
 Is system configured correctly ? [y/n] (n)
y
 
 
 
Starting Oracle Universal Installer ...
 
Checking requirements...
 
Checking operating system version: must be redhat-2.1, UnitedLinux-1.0 or redhat-3                                      Passed
 
 
All requirements met.
 
Checking if CPU speed is above 450 MHz.
Actual 3192 MHz    Passed
Checking for Kernel version 2.4.21-4.EL     Passed
Checking for glibc version glibc-2.3.2-95.3     Passed
Checking operating system packages: gcc-3.2.3-20,compat-gcc-7.3-2.96.122,compat-gcc-c++-7.3-2.96.122,compat-libstdc++-7.3-2.96.122,compat-libstdc++-devel-7.3-2.96.122,openmotif21-2.1.30,setarch-1.3-1,pdksh-5.2.14,sysstat-4.0.7,gnome-libs-1.4.1.2.90-34.1,libstdc++-3.2.3,compat-libstdc++-devel-7.3-2.96.122,compat-glibc-7.x-2.2.4.32.5    Passed
Checking swap space: must be greater than 1536 MB.
Actual 1964MB    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2004-09-14_04-23-56PM. Please wait ...[oracle@Linux2005 oracle]$ Oracle Universal Installer, Version 2.3.0.10.0
Copyright (C) 1999, 2003, Oracle. All rights reserved.
 
Instantiating file index.html.en...
Instantiating file index.html.html...
opmnctl: opmn is already running
=====

I also have an Oracle 9i Database (9.2.0.4).

How can I run my Forms/Reports application 9i over the web ?

PT
 
0
 
LVL 23

Accepted Solution

by:
seazodiac earned 500 total points
ID: 12059256
ptreves:

glad to hear you are making headways.

Now that you are having OracleAS 10g set up, you can run your reports and forms.

but this will be another bump on the road, you have to learn the deployment of forms and reports in the internet.

search on internet for forms and reports deployment guide.

Unfortunately this is not an easy question to answer, it could be written in a BOOK about this..
0
 

Author Comment

by:ptreves
ID: 12068114
Hello,

Well, I tried to copy my *.fmx and *.rep files in the $ORACLE_HOME/forms90 folder and tried to invoke the forms/reports over the web like:

http://linux2005:7777/forms90/cadastre.fmx

but I keep getting: (Page cannot be displayed)

Any ideas, I am working on this ?
Where should i put my reports ?

PT
0
 

Author Comment

by:ptreves
ID: 12069404
Hello,

I made some modifications and copied my *.fmx files and *.rep files in the  .../forms90/f90servlet and the .../reports/rwservlet subfolders.

I tried to invoke the forms/reports as follows:

http://linux2005:7777/forms90/f90servlet/lot.fmx

and/or

http://linux2005:7778/reports/rwservlet/wkcatsum.rep

but I get a:

FRM-40010: Cannot read form test.fmx error message.

Any ideas How I can invoke my forms/reports over the web ?

PT
0

Featured Post

Industry Leaders: 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

Have you ever had to make fundamental changes to a table in Oracle, but haven't been able to get any downtime?  I'm talking things like: * Dropping columns * Shrinking allocated space * Removing chained blocks and restoring the PCTFREE * Re-or…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
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.

688 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