Home > Ask the Oracle Database / Applications Experts > Oracle Application Server Questions & Answers > Problems with iAS while migrating to 9i/10g
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Problems with iAS while migrating to 9i/10g

John Garmany EXPERT RESPONSE FROM: John Garmany

Pose a Question
Other Oracle Categories
Meet all Oracle Experts
Become an Expert for this site


Oracle tips, scripts, and expert advice
Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google


>
QUESTION POSED ON: 07 September 2005
We are currently running client server applications using Dev 6i on a Windows platform and are planning for a switch to 9i or 10g but are a little reluctant to do so, as we are facing a lot of problems in the test environment, especially with iAS.

My question is I want to migrate on a LAN environment to 9i or 10g; how do I do it without going into the complications of configuring infrastructure?

The main issue faced by us is iAS configuration. The services will shut down without any specific reason. We applied the right patches but instead of improvement in the configuration we faced more problems. We really don't need the Web-based architecture at the moment but want to move to 9i or 10g. How do we do it?

The other issue moving to iAS is the resources required. We really cannot figure out the hardware requirements, because we noticed that the performance of the applications with just a few forms is dead slow with a configuration of around 2 GB of RAM. Another issue we came across is the report security with HTML reports. Users can move back and make their own changes on the browser and reprint a report, whereas in 6i users had no control on their reports. How do I handle a situation like this?

If we are moving to a Web-based environment how do we go about training our staff, who are new to Java or Web-based tools?

If possible please provide me with details as to what exactly is the hardware configuration required for iAS, if I have, say, an in-house developed financial application alongside other applications, with around 80 to 100 forms and a similar number of reports with 45 to 50 users.


>
Wow, that is a lot of questions. First, the move from 6i to 9i is the difficult move, while 9i to 10g is minor. Therefore, my recommendation is to go to AS10g as it is easier to install, manage and maintain. That said, the hardware issue is a tough one. I have installed the infrastructure, middle tier and backend database on one Windows server with 2 x 2.8 CPU and 4G RAM and it work very well for a rather small (70-100) company. However, if the server is overloaded, you have no choice but to add servers and offload some of the tasks. If you only have two servers, then normally you would move the backend database to a separate server. If you have three servers you can split the infrastructure and middle tier but you might get better performance by placing the web cache on its own server in front.

Bottom line, the application server is designed to be spread across multiple small servers and your application determines how well a set of servers handles the load you place on it. The real advantage of the application server is that you can easily add additional middle tiers and the AS will handle the load balancing and fail over.

As far as the minimum hardware configuration, that is explained in the docs, but the minimum hardly ever will handle the load.


Digg This!    StumbleUpon Toolbar StumbleUpon    Bookmark with Delicious Del.icio.us    Add to Google



RELATED CONTENT
Oracle Application Server
Database objects becoming invalid
How to solve ORA-04076 error?
Receiving ORA-12541 error trying to connect through Forms/Reports
Problems connecting to database after installing Forms
Button trigger raising exception
Cause of access violation while connecting from Forms
Migrating a database to 10g and a new server
Best OS for installing database and application server on same server
Accessing an application through the Internet
Testing the accessibility of an application from outside U.A.E.

Oracle database installation, upgrades and patches
Oracle's Java database continues push into embedded database market
How to use the Oracle Database Upgrade Assistant (DBUA)
Oracle delivers database fixes in Critical Patch Update
How to get the most out of Toad for Oracle 10
Coca-Cola Bottling swaps out Oracle for DB2
Oracle renews push into embedded open source software market
Oracle releases new database, says 11g upgrade will cut costs
Comparing servers for Oracle database 11g upgrades
Choosing the right server hardware is all about choosing the right software
The best of the Oracle 11g-ready servers

Oracle Application Server
Oracle to acquire application service management firm
Don't wait for clarity on Oracle's VM strategy, experts say
Oracle's 10 steps to get to Fusion rely on Oracle investments
Oracle Fusion Middleware: Top five headlines
Oracle-BEA deal gets the green light
Oracle adds Data Integration Suite to middleware family
Oracle-BEA deal means tough choices for middleware buyers
Oracle to buy BEA Systems
Oracle bids for BEA Systems
Oracle challenges IBM, Microsoft with application server platform
Oracle Application Server Research

RELATED GLOSSARY TERMS
Terms from Whatis.com − the technology online dictionary
10g  (SearchOracle.com)

RELATED RESOURCES
2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems
Search Bitpipe.com for the latest white papers and business webcasts
Whatis.com, the online computer dictionary



Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.
Browse our Expert Advice



Oracle White Papers: Fusion Middleware
HomeNewsTopicsTipsAsk the ExpertsMultimediaWhite PapersProductsBlogs
About Us  |  Contact Us  |  For Advertisers  |  For Business Partners  |  Site Index  |  RSS
SEARCH 
TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.

TechTarget Corporate Web Site  |  Media Kits  |  Site Map




All Rights Reserved, Copyright 2003 - 2009, TechTarget | Read our Privacy Policy
  TechTarget - The IT Media ROI Experts