Home > Ask the Oracle Experts > (Archive) Oracle Applications 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?


>
EXPERT RESPONSE
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
(Archive) Oracle Applications
Implementing Financials 11i on one box and adding another later
Determining which table was just modified
Identifying patch prerequisites
Assertion error when running Forms 6.0
Data points in Discoverer
Avoid changing size of ACS segments
Adding flexfield to standard form
Moving Oracle Apps 11.0 from Unix to another platform
Why there are fewer primary keys/foreign keys in Oracle Apps
Oracle Apps and SNMP data

Oracle E-Business Suite
Special report: Collaborate '08
Oracle forced migration fears a matter of education, OAUG says
Oracle password best practices
The E-Business Suite user's guide to Oracle OpenWorld 2007
Oracle OpenWorld 2007 Special Report
Oracle buys GRC firm LogicalApps
SunGard challenges Oracle in public sector
Millipore swaps out SAP for Oracle
Oracle and SAP passed over for IFS by water desalination firm
Why no integrity constraints in Oracle E-Business Suite?

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

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

TechTarget Corporate Web Site  |  Media Kits  |  Reprints  |  Site Map




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