Home > Ask the Oracle Database / Applications Experts > Questions & Answers > Using a single box for Oracle Financials
Ask The Oracle Expert: Questions & Answers
EMAIL THIS

Using a single box for Oracle Financials

Carol Francum EXPERT RESPONSE FROM: Carol Francum

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


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


>
QUESTION POSED ON: 03 June 2004
I am implementing Oracle Financials 11i and I am concerned about some of the things we are doing. Can we have just one box and, after the implementation, get another box for test? To my understanding, patching is a continual process and we will need at least two environments during the implementation phase. Another thing, we only have two volumes to spread the data, indexes, redo logs, etc. I am a DBA and thought I had to have data, indexes, redolog and mirror redo logs on separate disks.

Can we get by with only one box for the 11i Financials implementation and get a test box after the implementation is done? What is the disk layout for Oracle Financial 11i?


>
Having a single box is not a good idea. The installation guide is available on-line, the generic guide is Oracle Applications, Installing Oracle Applications Part B102451, with revisions for whichever release level you go to.

For instance, I remember discussing patching and configuration management issues with a consultant after a disaster. They were two weeks before cutover (to the new system) and someone decided to implement a patch without doing a full backup first. The project manager felt they were "too busy" to do the backup. Sometimes patches have unpredictable results -- and in this case, it did. It was an AR patch which failed, in a really freaky way, wiped out the accounting structure and set the project back weeks.

Patching is not the only issue in whether you have one, two, three or more instances. If you have any custom development work, you will want to test it before adding it to what will be your production instance.

If you are starting a new implementation, at some point you will want to start training your users. You will not want to train them on the same instance that you are building for production.

Also, you will probably want a separate box for the Oracle Application Server (which performs the browser interface).

If you use Rapid_install, the install will create your structure for you.

From the applications manual:

Table A–4 Production database size requirements
Mount Point            Files                            Size
DATA_TOP (sys)         Control file 1 (cntrl01.dbf) 9.04 GB
                       Rollback data file (rbs01.dbf)
                       System data files (systemnn.dbf)
                       Temp data file (temp01.dbf)
                       Web package data file (owa01.dbf)

DATA_TOP (logs)     Control file 2 (cntrl02.dbf)    .04 GB
            Group A log files (lognna.dbf)
            Group B log files (lognnb.dbf)

DATA_TOP (data)     Control file 3 (cntrl03.dbf)    5.80 GB
            interMedia server data file (ctxd01.dbf)
            Applications product data tablespace files (dnn.dbf
            Portal data file (portal01.dbf)

DATA_TOP (index)    Applications product index  6.00 GB
            tablespace files (xnn.dbf


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



RELATED CONTENT
Oracle E-Business Suite
Part 3: The final ERP transition: Crossing the finish line successfully
Part 2: Maintaining your place in the race -- ERP project management
Revving your engines: Tuning up your ERP project plan
Ventana's Mark Smith on Hyperion and Oracle BI
Oracle delivers database fixes in Critical Patch Update
Oracle CRM On Demand data integration raises big issues
Oracle applications learning guide
SMART weighs Oracle vs. SAP, picks E-Business Suite 12 for IFRS compliance
Oracle's E-Business Suite consolidates HBO's financial operations
Ellison sees new opportunities for Oracle with Java on mobile devices

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